Does my JSON leave the browser?

Pasted JSON and uploaded files are parsed entirely in your browser. The Extract from URL tab is the only path that touches the server, and only to proxy the URL you supply so CORS does not block direct fetches. Nothing is stored.

How are nested objects handled?

Enable Flatten nested objects to turn { user: { name } } into a user.name column. Disable it to leave nested values as JSON strings inside a single cell.

What happens to arrays inside records?

Expand arrays creates one CSV row per array item, copying the parent fields. Disable it to keep arrays joined with commas inside a single cell.

When do I need the BOM checkbox?

Microsoft Excel needs a UTF-8 BOM to render non-ASCII characters correctly. Turn it on if your CSV will be opened in Excel and contains accented characters, CJK, or emoji. Most other tools do not need it.

Which delimiter should I pick?

Comma is the universal default. Use semicolon for German/French exports where decimals use commas, tab for shell pipelines, and pipe for legacy systems that allow commas inside values without quoting.

Why do some cells have quotes around them?

Minimal quoting wraps a value only when it contains the delimiter, a newline, or a double quote. Always wraps every cell. Never skips quoting and is unsafe when values can contain those characters — only use Never when the source is guaranteed clean.

What URLs work in Extract from URL?

Public JSON endpoints reachable over HTTPS up to 5 MB. Auth-walled, local, and private network addresses are blocked by the proxy.

appkiro.com

Data

JSON 转 CSV

Data

在浏览器里把 JSON 数据转成 CSV,适合调 API、改 fixture、迁移数据时换格式,缩进、引号、转义都可配。

Input JSON

Example JSON loaded.

3 rows · 6 columnsPreviewing first 3 rows

Output CSV

1id,name,email,role,signup_date,active21,Alice Johnson,[email protected],Admin,2024-01-15,true32,Bob Smith,[email protected],Editor,2024-01-16,true43,Carol Williams,[email protected],Viewer,2024-01-17,false

Table preview

3 of 3 rows shown

#	id	name	email	role	signup_date	active
1	1	Alice Johnson	[email protected]	Admin	2024-01-15	true
2	2	Bob Smith	[email protected]	Editor	2024-01-16	true
3	3	Carol Williams	[email protected]	Viewer	2024-01-17	false

JSON to CSV converts API responses, exported documents, and pasted JSON into a flat CSV file inside your browser. Nested objects, arrays, and mixed records flatten into proper columns; delimiter, quoting, and line endings are configurable for any downstream system.

Why this tool exists

JSON is the dominant API and config format. Spreadsheets, BI tools, ETL pipelines, and legacy back-office systems still want CSV. Hand-mapping nested fields, escaping quotes, and remembering whether a target tool needs a BOM costs hours per week. This tool collapses that work into one page — paste a payload, pick a delimiter, copy or download.

Workflow at a glance

Bring data in: paste raw JSON, fetch a public URL, or upload a .json file.
Confirm the table preview shows the expected columns and rows.
Tune Parse Settings for nested objects, arrays, and headers.
Tune CSV Format for delimiter, quoting, line endings, and BOM.
Copy the CSV or download a .csv file.

What each part of the interface does

Input JSON card hosts three input tabs: Paste content for direct text, Extract from URL for public JSON endpoints (server-proxied to bypass CORS), and Upload JSON for local .json/.txt files up to 5 MB.

Output CSV card renders the result in a compact line-numbered viewer with Copy and Download actions. Output updates live as you change Parse and CSV options.

Table preview shows the first 100 parsed rows so you can verify column shape before exporting.

Parse Settings control structural decisions: root selector, nested-object flattening, array expansion, type preservation, and whether to emit a header row.

CSV Format controls textual output: delimiter, line ending, quoting strategy, and UTF-8 BOM for Excel compatibility.

When to flip each option

Flatten nested objects — on for tabular consumers; off when nested objects must remain JSON inside a single column.
Expand arrays — on when you want one row per child item (e.g. order line items); off to keep arrays comma-joined inside a cell.
Preserve types — on for downstream tools that infer types; off when you need every value as a string.
Delimiter — comma is standard; semicolon for European exports; tab for shell pipelines; pipe when commas appear inside values.
Quote strategy — minimal is the safe default; always for strict importers; never only when source values are guaranteed clean.
UTF-8 BOM — on for files opened in Microsoft Excel containing accented characters, CJK, or emoji.

Tips that save real time

For Microsoft Excel exports, enable BOM and pick comma — Excel auto-recognizes the delimiter when the BOM is present.
For German/French Excel, set delimiter to semicolon to match locale defaults.
Order line items, audit logs, and event payloads usually want Expand arrays on for one-row-per-event output.
Disable Preserve types when feeding tools that choke on JSON booleans/numbers in CSV.
Use Auto detect array for typical API responses where the data sits inside a wrapper key like data or results.

1id,name,email,role,signup_date,active21,Alice Johnson,[email protected],Admin,2024-01-15,true32,Bob Smith,[email protected],Editor,2024-01-16,true43,Carol Williams,[email protected],Viewer,2024-01-17,false

name

role

signup_date

active

Alice Johnson

[email protected]

Admin

2024-01-15

true

Bob Smith

[email protected]

Editor

2024-01-16

true

Carol Williams

[email protected]

Viewer

2024-01-17

false