JSON to CSV

What this tool does

The converter expects a JSON array. Each object becomes a row. Nested objects and arrays are stored as JSON text inside a quoted CSV field, which is the only honest way to keep structure in a two-dimensional table.

How to use it

1. Paste a JSON array of objects.
2. Download the CSV or copy it into a spreadsheet.
3. If you need JSON again, use CSV to JSON and inspect nested cells.

Privacy

This tool processes files and text locally in your browser. Your content is not uploaded or stored by this site.

ConvertPass does not include your input in analytics, URLs, or error reports. Encoding: UTF-8 without a BOM. Excel on Windows may need a BOM; add one in your spreadsheet tool if columns misalign.. Limit: 2 MB (2.00 MB).

Limitations

• A JSON object that is not an array cannot become CSV without choosing keys to flatten. Flattening is not guessed.
• Column order follows the first row's keys, then extra keys from later rows.

Example

[{"name":"Ada","city":"London, UK"},{"name":"Alan","city":"Manchester"}]

"name","city"
"Ada","London, UK"
"Alan","Manchester"

Troubleshooting

Excel merged everything into one column

Use Data > From Text and set the delimiter to comma. ConvertPass quotes fields, but Excel's auto-detect can still fail on some locales that expect semicolons.

FAQ

How are commas inside values handled?

Fields are quoted. A city named London, UK stays one cell. That is the core RFC 4180 behaviour this tool is built around.

What happens to nested JSON?

It is stringified into the cell. You will see {"lat":51.5} rather than extra columns. Automatic flattening creates silent data loss, so ConvertPass refuses to invent columns.

Can I use a semicolon delimiter?

Not in this version. Comma is the default. A delimiter option can be added later without changing the converter core.

Are empty arrays allowed?

Yes. The output is an empty CSV with no rows. A header cannot be inferred from empty data.