JSON to CSV

Convert an array of JSON objects into a downloadable CSV table.

Your input is processed in this browser and is not uploaded.

JSON to CSV

Convert a nonempty array of objects into a comma-separated table. The union of object keys becomes its header, allowing records with missing properties to share the same columns.

How to use it

  1. Paste an array whose elements are JSON objects.
  2. Select Run tool and review the header and quoted fields.
  3. Select Download result to save a .csv file, or Copy result to paste it into a CSV-aware application.

Worked example

[{"name":"Ada","score":10},{"name":"Lin"}]

produces:

"name","score"
"Ada","10"
"Lin",""

Limits and troubleshooting

Missing and null values become empty cells, so conversion is not fully reversible. Nested objects and arrays become JSON strings inside a cell. Formula-like text beginning with optional whitespace and =, +, - or @ receives an apostrophe to reduce spreadsheet formula execution. JavaScript numeric precision applies. The same apostrophe rule affects negative numbers, so review their imported type in your spreadsheet. Limit: 200,000 input characters.

Frequently asked questions

Why did a value gain an apostrophe?

Some spreadsheet imports execute formula-like cells. The prefix reduces that risk; check how your destination imports the resulting text.

Can nested properties become separate columns?

No. Flatten records beforehand if individual nested properties must become columns. Use CSV Viewer to inspect the output's row and field boundaries.