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.

Processed on your device. Files are not uploaded

How to convert JSON to CSV

  1. Paste your JSON array

    Paste or type it into the box, or press Try an example. It should be a list of objects.

  2. Choose the delimiter

    Comma, semicolon, tab or pipe.

  3. Flatten and quote

    Flatten nested objects into columns, include the header row, or quote every field.

  4. 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.

Related tools