JSON to CSV Converter
JSON to CSV Converter convert JSON array to CSV JSON objects spreadsheet rows export JSON records as CSVFlatten one level of record objects
Paste a JSON array whose items are objects, select comma, semicolon, or tab, then choose Convert to CSV. Columns are collected from keys across all records, preserving first-seen order.
How columns are selected
The converter scans records from beginning to end and adds each newly encountered property as a column. Missing properties create empty fields. Values remain in record order. Strings containing delimiters, quotes, or line breaks are quoted, and internal quotes are doubled so the resulting text follows common CSV import behavior.
Worked example
An array containing {"name":"Rosa","score":8} and {"name":"Lee","active":true} creates columns name, score, and active. Rosa's active field is empty and Lee's score field is empty. Booleans appear as their textual JSON values.
Nested values
Objects and arrays stored inside a property are serialized as compact JSON within one CSV field. This preserves their textual structure but does not create several spreadsheet columns. If downstream analysis needs nested fields separated, reshape the records deliberately before conversion so column names and array behavior match that workflow.
Choosing a delimiter
Comma is common in English-language exports. Semicolon may work better where commas represent decimal punctuation. Tab-delimited output pastes conveniently into many spreadsheets. A receiving program's import settings must match the chosen delimiter and character encoding; a filename extension alone cannot communicate every choice.
Privacy and limitations
Conversion runs locally and does not upload records. The input must be a JSON array of ordinary objects, not a single object, array of scalars, JSON Lines stream, or arbitrary nested document. The tool does not generate an Excel workbook, infer formulas, choose data types, preserve comments, or enforce a schema. Spreadsheet programs may interpret cells automatically, so review identifiers, dates, and formula-like text after import.
JSON to CSV FAQ
What happens when records have different keys?
The union of keys becomes columns and missing values become empty fields.
Can nested objects become separate columns?
No. They are stored as compact JSON inside one field.
Does this create an XLSX file?
No. Output is plain delimited text suitable for CSV import.