All tools (39)
JSON to CSV
Turn an array of JSON objects into a spreadsheet-ready CSV.
address.city becomes its own column.
Paste a JSON array of objects. A single object becomes one row.
JSON to CSV
Paste an array of objects and get a CSV you can open in Excel, Numbers or Google Sheets. Column names come from the keys, and every row is scanned - so a field that only appears on some records still gets a column, instead of being silently dropped because it was missing from the first one.
Nested objects
A spreadsheet cell holds one value, and JSON routinely nests. Withflatten nested objects on,{"address":{"city":"London"}} becomes a column calledaddress.city. Off, the whole nested object is written into one cell as JSON. Arrays of simple values are joined into a single cell either way, since one column per array index is rarely what anyone wants.
Delimiters and Excel
Excel in several European locales expects semicolons rather than commas, and will put an entire comma-separated row into column A if it gets the wrong one. Switch the delimiter here if that happens. ChooseTab and the download is named .tsv, which Excel opens without an import dialog at all.
Fields containing the delimiter, a quote or a newline are quoted and escaped per RFC 4180, so addresses and free-text notes survive intact.
Related tools
- CSV to JSON - the other direction.
- JSON Formatter - check the JSON is valid first.
- Markdown Table Generator - the same data as a Markdown table.