Free · runs in your browser · no upload · no quota
JSON to CSV Converter
Turn a JSON array of objects into a CSV table you can open in Excel, Google Sheets or LibreOffice. Nested objects become dotted column names, and every key that appears in any row gets its own column.
How to Convert JSON to CSV
- Add your JSON
Paste it into the left box, drop a file onto it, or click Open file and pick a .json file. - Choose the delimiter
Comma is the default. Pick semicolon if your Excel expects one (common with European regional settings), and tick Add BOM so accented letters open correctly. - Copy or download the CSV
Copy the table from the right box, or click Download to save a .csv file for Excel, Google Sheets or LibreOffice.
Example
[
{"name": "Ana", "address": {"city": "Novi Sad"}},
{"name": "Marko", "email": "[email protected]"}
]name,address.city,email Ana,Novi Sad, Marko,,[email protected]
Frequently Asked Questions
-
What JSON shapes can be converted?An array of objects gives one row per object. A single object gives one row. An object whose value is an array of objects, like
{"items": [...]}, is converted from that array. -
How are nested objects handled?They are flattened:
{"address": {"city": "Novi Sad"}}becomes a column namedaddress.city. Arrays of plain values are joined with a semicolon; anything more complex is written as JSON text inside the cell. -
Will the CSV open correctly in Excel?Yes. Values containing the delimiter, quotes or line breaks are quoted. If Excel puts everything in one column, choose the semicolon delimiter; tick Add BOM so Excel reads accented letters correctly.
-
Is my data uploaded?No. The conversion runs in your browser and nothing is sent to a server.
More browser tools
Working with files rather than text? Our file converters handle CSV to XLSX and 400+ other formats.