JSON to CSV Converter
Turn a JSON array into CSV for spreadsheets. Nested objects can be flattened into columns, and the delimiter is your choice.
How to convert JSON to CSV
Paste your JSON array
Paste or type it into the box, or press Try an example. It should be a list of objects.
Choose the delimiter
Comma, semicolon, tab or pipe.
Flatten and quote
Flatten nested objects into columns, include the header row, or quote every field.
Copy or download
Open the CSV in a spreadsheet, or save it as a .csv file.
Worked example
This is what JSON to CSV Converter gives for its own sample values. Open the tool above and change anything to try your own.
JSON
[
{ "id": 1, "name": "Ada Lovelace", "email": "ada@example.com", "active": true, "score": 9.5 },
{ "id": 2, "name": "Linus Torvalds", "email": "linus@example.com", "active": false, "score": 7 },
{ "id": 3, "name": "Grace Hopper", "email": "grace@example.com", "active": true, "score": 10 }
]- Delimiter
- Comma ( , )
- Flatten nested objects into columns
- Yes
- Include the header row
- Yes
- Quote every field
- No
CSV
id,name,email,active,score 1,Ada Lovelace,ada@example.com,true,9.5 2,Linus Torvalds,linus@example.com,false,7 3,Grace Hopper,grace@example.com,true,10
About JSON to CSV Converter
Turn a JSON array into CSV you can open in a spreadsheet. The columns are every key found across all items, nested objects can be flattened into columns such as address.city, and fields are quoted when they need to be.
FAQs
What shape of JSON works best?
A list of objects. A list of lists, or a single object, also works.
What happens to nested data?
With flattening on, nested objects become dotted columns. Otherwise they are written as JSON text.
Can I convert CSV back?
Use CSV to JSON Converter.