JSON to CSV and CSV to JSON converter
Convert a JSON array of objects into CSV for a spreadsheet, or turn CSV back into JSON. Quoted fields, embedded commas and newlines are handled properly in both directions.
Runs entirely in your browser — nothing is uploaded.
How to use
- Pick a direction. JSON → CSV, or CSV → JSON.
- Paste your data. For JSON → CSV, an array of objects works best; a single object becomes one row.
- Set the delimiter. Comma by default. Semicolon is common in European exports, where the comma is the decimal separator.
- Check the row and column count. Shown under the options as a quick confirmation the parse went as expected.
Questions
What happens to nested objects?
CSV is flat, so nested values are serialised back to JSON text inside the cell rather than being silently dropped or flattened into invented column names. You keep the data and can decide what to do with it.
What if rows have different keys?
The header is the union of every key across all rows, in first-seen order. Rows missing a key get an empty cell.
Are numbers detected when converting CSV to JSON?
Yes, but conservatively. A value only becomes a number when the round trip is exact, so "007", "1e999" and phone numbers stay strings rather than being silently corrupted. You can switch detection off entirely.
Does it handle commas inside quoted fields?
Yes. The parser implements RFC 4180 properly, including doubled quotes as an escape and newlines inside quoted fields — all three break a naive split on commas.