JSON to CSV
Turn an array of JSON objects into CSV with correct RFC 4180 quoting. Nested objects flatten into dotted columns, missing keys become empty cells, and the tool tells you how anything it could not represent was handled.
Converter ToolsHow to use JSON to CSV
- Paste an array of objects into the input panel.
- The CSV appears immediately, with the row and column counts above it.
- Choose the delimiter — comma, semicolon or tab — and the line ending.
- Leave flattening on to expand nested objects into dotted columns.
- Copy the CSV, or download it as data.csv and open it in a spreadsheet.
Examples
Flat records
The straightforward case: one object per row.
[{"id":1,"name":"Alpha"},{"id":2,"name":"Beta"}]
id,name
1,Alpha
2,BetaValues that need quoting
A comma, a quote and a line break in the data are all escaped properly.
note,quote "Alpha, Inc.","He said ""hi"""
Nested objects flattened
address becomes two columns rather than one unreadable cell.
{"id":1,"address":{"city":"Berlin","zip":"10115"}}
id,address.city,address.zip
1,Berlin,10115Features
- RFC 4180 quoting: values with the delimiter, quotes or line breaks are quoted correctly
- Columns are the union of every row's keys, so missing keys become empty cells
- Nested objects flatten into dotted columns such as address.city
- Arrays are written as JSON and the tool discloses that it did so
- Comma, semicolon or tab delimiter for European and tab-separated workflows
- LF or CRLF line endings, the latter for Excel
- Refuses input that has no row structure rather than emitting broken CSV
- Copy to clipboard or download data.csv
Frequently asked questions
- What shape does my JSON need to be?
- An array of objects, which is what most API list endpoints return. A single object is accepted too and produces one data row. A bare string, number or array of primitives has no row structure, so the tool explains that instead of guessing.
- What happens to nested objects?
- With flattening on — the default — they become dotted columns: address.city, address.zip. With it off, the whole object is written into one cell as JSON.
- What happens to arrays inside a record?
- Arrays have no column form, so the cell contains the array as JSON and a note tells you that. Silently flattening them would lose information.
- Will it handle commas and quotes in my data?
- Yes. Any value containing the delimiter, a double quote, a line break or leading or trailing whitespace is wrapped in quotes with internal quotes doubled, exactly as RFC 4180 specifies.
- Which line ending should I pick for Excel?
- CRLF. Excel on Windows is happiest with it; most other tools accept either. The choice is yours because the right answer depends on where the file is going.
- What if rows have different keys?
- The header is the union of every key seen, in first-appearance order, and rows missing a key get an empty cell. Columns never shift.
Related tools
About JSON to CSV
JSON to CSV is part of Converter Tools on ToolHive, a growing collection of small, focused utilities for developers, designers and students. Convert between encodings, cases and data formats in a single click. Everything runs client-side, so your data never leaves the browser tab — which makes these tools safe to use with work-in-progress code and private content.