JSON to CSV

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. Enable BOM if Excel on Windows shows one column or mojibake.. 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.
• Excel-safe mode is for stopping formula execution, not for making Excel a database.

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?

Yes. Choose Semicolon in the delimiter control. That is the usual Excel list separator in comma-decimal locales. Comma remains the default.

Are empty arrays allowed?

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

What does Excel-safe do?

It prefixes cells that look like formulas (=, +, @, |, and non-numeric leading -) with an apostrophe so Excel treats them as text. Plain numbers such as -3 are not prefixed. This is not a malware scanner.

Can I transpose the table?

Yes. Transpose swaps rows and columns before writing CSV. The first row of the result is the original first column.