JSON to CSV
Turn a JSON array into a CSV file you can open in Excel, Google Sheets or Numbers. Nested objects become dotted columns.
JSON
CSV
Converted in this browser tab. Nothing is uploaded.
How to use the JSON to CSV
- Paste a JSON array, or open a .json file.
- Choose a delimiter and whether to flatten nested objects.
- Preview the table, then copy the CSV or download it.
Example
Input
[{"id":1,"name":"Ada","address":{"city":"London"}},{"id":2,"name":"Linus","address":{"city":"Helsinki"},"admin":true}]Result
id,name,address.city,admin
1,Ada,London,
2,Linus,Helsinki,trueWhat it does
- Handles real-world JSON
- Items with different keys are merged into one set of columns. A wrapper object such as { "data": [...] } is unwrapped automatically.
- Correct quoting
- Values with commas, quotes or line breaks are quoted according to RFC 4180, so spreadsheets read them correctly.
- Table preview
- Check the columns before you download.
- Choose a delimiter
- Comma, semicolon (common in Europe), tab or pipe.
Frequently asked questions
How are nested objects handled?
With Flatten on, { "address": { "city": "London" } } becomes a column named address.city. Arrays are written as JSON text in a single cell.
Why does Excel show my CSV in one column?
Excel uses your regional list separator. If it expects semicolons, choose the semicolon delimiter, or use Data > From Text/CSV to import.
Is my data sent to a server?
No. The conversion runs in your browser, and nothing you paste is uploaded, logged or stored.