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.

Runs in your browser

JSON

CSV

Converted in this browser tab. Nothing is uploaded.

How to use the JSON to CSV

  1. Paste a JSON array, or open a .json file.
  2. Choose a delimiter and whether to flatten nested objects.
  3. Preview the table, then copy the CSV or download it.

Example

Nested JSON to CSV
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,true

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