JSON to CSV Converter
Convert JSON arrays to CSV (comma-separated values) and CSV back to JSON instantly in your browser. Handles nested objects, custom delimiters and file downloads. No data is uploaded to a server — everything runs locally for complete privacy.
How to Convert JSON to CSV
Paste your JSON array into the JSON Input box. Each object in the array becomes one row in the CSV file. The keys of the first object are used as column headers. Choose a delimiter (comma, semicolon or tab), then click Convert to CSV. The formatted CSV appears in the output box, ready to copy or download as a .csv file you can open in Excel or Google Sheets.
Understanding JSON Array Format
This tool works with a JSON array of objects — the most common format returned by REST APIs and databases. It looks like this:
[
{ "id": 1, "product": "Widget", "price": 9.99, "in_stock": true },
{ "id": 2, "product": "Gadget", "price": 24.99, "in_stock": false }
]
Each object must be at the top level of the array. Deeply nested structures (objects inside objects) are serialised as JSON strings in the CSV cell rather than expanded into multiple columns.
CSV Delimiters and When to Use Each
| Delimiter | Extension | Best Used When |
|---|---|---|
| Comma ( , ) | .csv | Default for most spreadsheet software and data imports |
| Semicolon ( ; ) | .csv | Regions where commas are used as decimal separators (e.g. European locales) |
| Tab | .tsv | Values contain commas (addresses, descriptions, notes) |
Converting CSV Back to JSON
Switch to the CSV → JSON tab, paste your CSV, select the correct delimiter and click Convert to JSON. The first row is treated as the header row, and each subsequent row becomes a JSON object. Values that look like numbers are automatically parsed as numbers, and true/false strings become booleans.
Frequently Asked Questions
What JSON format works for CSV conversion?
The converter expects a JSON array of objects, where each object is one row. Keys of the first object become the CSV column headers. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}].
Can it handle nested JSON objects?
Yes. If a value is a nested object or array, it is serialised as a JSON string inside the CSV cell and wrapped in quotes so the CSV stays valid. Flatten your data first if you need separate columns for nested fields.
How do I download the CSV file?
After clicking Convert to CSV, click the Download CSV button. The file saves as data.csv and can be opened in Excel, Google Sheets, LibreOffice Calc or any spreadsheet application.
What is the difference between CSV and TSV?
CSV uses a comma as the column separator; TSV uses a tab character. TSV is handy when values contain commas (addresses, free-text notes). Both formats are plain text and supported by all major spreadsheet tools.