The JSON to CSV Converter turns JSON data into CSV (for spreadsheets like Excel or Google Sheets) and converts CSV back into JSON. Paste your data, pick the direction, and the converted result appears instantly alongside a table preview so you can check it looks right.
For JSON to CSV, it expects an array of objects and builds columns from all the keys; nested objects and arrays are written as JSON text in the cell. For CSV to JSON, it uses the header row for the keys and can automatically parse numbers and booleans. Quoted fields, commas, and line breaks inside cells are handled correctly. Everything runs in your browser.
How to convert between JSON and CSV
- Choose the direction: JSON → CSV or CSV → JSON.
- Paste your data into the input box (or use Paste).
- Pick the delimiter (comma, semicolon, or tab) and, for CSV → JSON, whether the first row is a header and whether to parse numbers and booleans.
- Copy the converted output, or check the table preview below.
What it handles
- JSON arrays of objects → CSV columns from the union of all keys.
- Nested objects and arrays → written as JSON text within a cell.
- CSV fields containing commas, quotes, or line breaks → correctly quoted and escaped.
- Custom delimiters — comma, semicolon, or tab.
- Optional type inference so "42" becomes a number and "true" becomes a boolean.
Frequently Asked Questions
How do I convert JSON to CSV?
Paste a JSON array of objects, keep the direction on JSON → CSV, and the CSV appears instantly with columns built from your keys. You can then copy it into Excel or Google Sheets.
How do I convert CSV to JSON?
Switch to CSV → JSON and paste your CSV. The first row is used as the keys, and each following row becomes a JSON object. You can turn on number and boolean parsing for cleaner data.
Does it handle commas and quotes inside values?
Yes. The converter follows CSV quoting rules, so fields containing commas, double quotes, or line breaks are escaped and parsed correctly in both directions.
What happens to nested JSON objects?
When converting JSON to CSV, nested objects and arrays are written as JSON text inside the cell, since CSV is a flat format. You can flatten your JSON first if you want separate columns.
Is my data private?
Yes. All conversion happens locally in your browser with JavaScript. Your data is never uploaded or stored.