Free Online JSON to CSV Converter

Paste a JSON array into the left editor, pick a delimiter and click Convert to CSV. Each object becomes a row and each key a column. Check the preview on the right, then click Download .csv or Copy CSV.

The top level must be an array, usually of objects like [{"name":"Ana","age":30}]. Each object becomes one row. Plain values such as numbers go into a single column called value. A single object, or an array wrapped in an object, is rejected. Nested arrays as rows give columns named 0, 1 and so on.

With Flatten nested objects on, each nested field becomes its own column, such as address.city, at any depth. With it off, the whole nested object is written as JSON text in one cell. Arrays always stay as JSON text in one cell and are never split into rows.

The converter collects every key from every object, in the order it first sees them, and makes one column for each. When a row doesn't have a key, that cell is left empty, so records with mixed fields still line up.

Use comma for most apps. Pick semicolon if your Excel uses a comma for decimals, as in much of Europe. Tab is handy for pasting into a sheet, and pipe suits text full of commas. Cells holding the delimiter get quotes either way.

Download data.csv. In Google Sheets, use File, then Import. In Excel, use Data, then From Text/CSV, and pick UTF-8 if accents look wrong, since the file has no byte-order mark. Choose the same delimiter you converted with.

Not with this tool. It only converts JSON to CSV, and there is no reverse mode. If you need another text format for the same data, the JSON to YAML converter works in both directions between JSON and YAML.

Your JSON starts with { instead of [. Many APIs wrap their list, as in {"data":[...]}. Copy only the part from [ to ], or put a single object inside square brackets so it becomes a one-row array, then click Convert again.

JSON numbers are read as JavaScript numbers, which hold about 15 to 17 digits. A 20-digit ID such as 12345678901234567890 comes out as 12345678901234567000. Ask the source to send IDs as strings in quotes; strings, including ones with leading zeros like "02134", pass through unchanged.

Yes, it can. The converter writes text exactly as it is, so a value like =SUM(A1:A3) or +1 may run as a formula when a spreadsheet opens the file. If your JSON comes from people you don't know, check for cells starting with =, +, - or @.

The conversion runs on your device, and the JSON and CSV are not sent to us. Analytics record clicks like Convert and Download and the time a run took. If conversion fails, the error text goes to analytics too, and in rare cases it quotes a few characters from near the mistake.