JSON Array to CSV Rows
Paste a JSON array of objects to create escaped CSV with a column for every key.
Each object becomes a row; columns are the union of object keys. Values are CSV-escaped. Cells whose first non-whitespace character is =, +, - or @ receive a leading apostrophe in the output copy before CSV quoting. This does not guarantee safety in every spreadsheet.
A QUICK WALKTHROUGH
How to use this tool
- Paste an array of objects, up to 5,000 rows.
- Convert the JSON locally.
- Copy the CSV output.
Union of keys
The header contains every key found in input order; missing values are empty.
CSV escaping
Values containing commas, quotes, or line breaks are quoted and internal quotes are doubled.
Local processing
JSON stays in this browser and is not uploaded or saved. Values use JavaScript String conversion: nested structures are not flattened, null is empty, and native JSON numeric precision limits apply.
GOOD TO KNOW
Common questions
What input is accepted?
A top-level array containing JSON objects, up to 5,000 rows.
How are missing keys handled?
The column is present and that row receives an empty value.
Are values safely escaped?
Cells whose first non-whitespace character is =, +, - or @ receive a leading apostrophe in the output copy before CSV quoting. This does not guarantee safety in every spreadsheet.