Developer

JSON to CSV

Convert arrays of JSON objects into CSV text for spreadsheets.

All tools

JSON

Output

name,type
"TULAKITO","toolbox"
"JSON","developer"

Frequently asked questions

How are nested objects handled when converting JSON to CSV?
CSV is a flat tabular format, so nested objects and arrays need to be flattened with dotted keys or serialized into a single cell as a JSON string. Decide which makes more sense for your consumer before exporting.
Why do my CSV cells get split across columns?
Values that contain commas, quotes, or newlines must be wrapped in double quotes, with any internal quotes doubled. Without that escaping a spreadsheet will treat embedded commas as new columns.
Does the CSV need a header row?
Headers are not required by RFC 4180, but most spreadsheet apps and import scripts assume the first row is column names. Including headers makes the file self-describing and far easier to reuse.