JSON Formatter
Validate, prettify, minify or sort JSON keys with clear syntax errors.
Developer toolsDeveloper tools
JSON to CSV
Convert an array of JSON objects into escaped CSV with spreadsheet-safe string cells.
Your result
A little input. A useful result.
Adjust the example inputs, then select Convert to CSV.
About this tool
Create a CSV table from a JSON array of objects. Columns are the union of all object keys, and nested objects are serialized inside their cells. Spreadsheet protection prefixes formula-like string values with an apostrophe by default.
How to use it
- 1
Paste a JSON array of objects.
- 2
Choose a delimiter and keep spreadsheet protection enabled for spreadsheet imports.
- 3
Convert the data, then copy the CSV output.
Questions, answered
What happens when some fields are missing?
The column still appears, with an empty cell in records where it is missing. JSON null also becomes an empty cell, so this conversion is not perfectly reversible.
Why might a string start with an apostrophe?
The optional spreadsheet protection adds it to formula-like strings such as “=SUM(A1:A2)”. It changes the literal value to reduce spreadsheet formula execution risks. Disable it only when the receiving system expects raw, trusted data.