MegaTools.live

JSON to CSV

Export an array of flat JSON records as a comma- or semicolon-separated table.

Up to 5 MB. Read on this device.

Options

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

Input
[
  {"id":"0042","name":"Patel, Ria","city":"Surat"},
  {"id":"0043","name":"Sam","city":"Pune"}
]
Output
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.