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
| # | id | name | 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.
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.
.json file..csv file.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.
data or results.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.
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.
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.
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.
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.
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.
Public JSON endpoints reachable over HTTPS up to 5 MB. Auth-walled, local, and private network addresses are blocked by the proxy.