JSON ↔ CSV Converter
Convert between JSON and CSV formats instantly
JSON Input
CSV Output
Convert JSON arrays to CSV, or CSV spreadsheets to JSON — instantly, in your browser. Handles nested objects, escapes special characters, and gives you a download-ready result.
JSON ↔ CSV conversion rules
| JSON shape | CSV result |
|---|---|
| [{ "name": "A", "age": 1 }, ...] | Columns: name, age. One row per object. |
| [{ "user": { "name": "A" } }] | Nested keys flattened: user.name becomes a column. |
| [{ "tags": ["a", "b"] }] | Arrays joined with commas or serialised as JSON string. |
| Plain object (not array) | Single-row CSV. |
CSV special characters
Values containing commas, quotes, or newlines are automatically wrapped in double quotes and escaped — so your CSV is safe to open in Excel or Google Sheets.
Frequently asked questions
What JSON shape works for CSV conversion?
An array of objects with consistent keys. Nested objects are flattened using dot notation (e.g. address.city).
Can I open the CSV in Excel?
Yes — download the CSV and open directly in Excel, Google Sheets, Numbers, or any spreadsheet app.
How are arrays inside objects handled?
They are joined as a semicolon-separated string or serialised as a JSON literal, depending on your setting.
What about unicode and emoji?
Fully supported — output is UTF-8 encoded.