About JSON → CSV
Detect columns, preserve missing values, serialize nested data explicitly, preview the table, and choose an output delimiter.
JSON to CSV accepts an array of objects, discovers the combined column set, and delegates quoting and escaping to a CSV serializer. Nested objects are preserved explicitly as JSON text inside a cell.
How to use it
- Enter or select your source data.
- Adjust the available options and run the tool.
- Review, copy, or download the result.
Common use cases
- Export API fixture data for spreadsheet users.
- Create a simple report from a JSON array.
- Translate test records into comma, semicolon, tab, or pipe-delimited output.
Worked example
Convert an array of product objects into CSV for a spreadsheet.
Limitations and responsible use
- The top-level value must be an array of objects.
- Deeply nested structures are stringified into cells rather than expanded into multiple columns.
- Spreadsheet applications may interpret formulas or dates when opening CSV; review untrusted values before distribution.
Frequently asked questions
How are missing properties handled?
The combined set of object keys becomes the columns, and absent values produce empty cells.
Will commas and quotes be escaped?
Yes. The CSV serializer quotes and doubles characters as required by the selected delimiter.