JSON to CSV

How to use

1. Paste a JSON array of objects, or a single object for one row.
2. Choose a delimiter — semicolon if your spreadsheet expects it, tab for pasting straight into one.
3. Leave flattening on to turn nested objects into dotted columns rather than JSON inside a cell.
4. Copy or download the result.

Features

• Columns taken from every record, so a key that appears only in the tenth row still gets a column.
• Nested objects flattened to dotted paths, with arrays left as JSON since they have no columns.
• Proper escaping: commas, quotes, newlines and surrounding spaces all survive.
• Optional CRLF line endings for Excel.
• Runs in your browser — an export never leaves the device.

Frequently asked questions

What happens when records have different keys?

Every key seen anywhere becomes a column, in the order it first appears, and records missing one get an empty cell. Converters that take the columns from the first record only will silently drop every field that appears later — which is the failure worth avoiding, because the file still looks correct.

How are nested objects handled?

Flattened to dotted columns: {"user": {"name": "An"}} becomes a user.name column. Turn flattening off and the object is written as JSON inside a single cell, which is valid but hard to read in a spreadsheet. Arrays are always written as JSON, because an array has no columns to spread across.

Is an empty cell the same as null?

In CSV there is no way to tell them apart — null, an empty string and a missing key all come out as an empty cell. That is a limitation of the format, not of this tool. If the distinction matters, keep the JSON.

Will Excel open it correctly?

Usually. Turn on CRLF line endings, and pick semicolon if your locale expects it — Excel in much of Europe treats comma as a decimal separator and will put every row in one column otherwise.

Related tools