JSON to CSV
Export an array of flat JSON records as a comma- or semicolon-separated table.
How to use JSON to CSV
Paste an array of flat objects or open a UTF-8 JSON file. The tool builds columns from property names across all the records, including keys that first appear in later rows. Missing and null values become empty cells. Use the separator expected by the program where you will import the table.
Worked example
[
{"id":"0042","name":"Patel, Ria","city":"Surat"},
{"id":"0043","name":"Sam","city":"Pune"}
]id,name,city 0042,"Patel, Ria",Surat 0043,Sam,Pune
Review fields before import
Flatten nested objects and arrays before conversion. Store long numeric identifiers as JSON strings to preserve their precision. When importing the CSV into a spreadsheet, choose Text for columns such as postal codes or IDs with leading zeros.
Keep spreadsheet formulas as text
With formula protection on, text cells and column names that look like spreadsheet formulas receive a leading apostrophe. This changes those field values in the exported file. Use the original JSON to retain an exact copy of the inputs.