Home › Dev & Data › JSON → CSV
Dev & Data
JSON → CSV
Convert a JSON array of objects into CSV — the column headers are the union of all keys. Great for loading API data into a spreadsheet.
Try it now
Worked example
a,b
1,x
2,y
Frequently asked
What input does it expect?
A JSON array of flat objects.
How are missing values handled?
Absent keys and nulls become empty cells.
What happens to nested objects and arrays?
There is no flat spreadsheet form for them, so the whole nested value is written verbatim into one cell rather than dropped. Flatten your JSON first if you want it in columns.
Are quotes and commas in values safe?
Yes — values are escaped to RFC 4180, so commas, quotes and line breaks stay inside their own cell. A value starting with = + or @ is prefixed with an apostrophe so your spreadsheet treats it as text instead of running it as a formula.