JSON to CSV Converter
Convert JSON data to CSV format online. Paste JSON array and download as CSV file. Free developer tool.
About this calculator
Paste a JSON array of objects, pick a delimiter and get CSV you can copy or download. Keys become column headers.
A quick way to move API data into Excel or Google Sheets.
How to use it
- Paste a JSON array.
- Choose the Delimiter.
- Press Convert to CSV, then Download or Copy.
Mapping
CSV is rows of values separated by a delimiter (usually a comma). A value containing the delimiter, a quote or a line break is wrapped in double quotes, and quotes inside are doubled ("") per RFC 4180. In JSON-to-CSV, the first row is a header made from the keys of the objects; nested objects can be flattened to dotted keys such as address.city. In CSV-to-JSON, the first row supplies the keys and every other row becomes one object.
Worked example
[{"name":"Asha","age":30},{"name":"Ravi","age":28}]
| CSV | name,age / Asha,30 / Ravi,28 |
Tips and common mistakes
- Check the delimiter. Many European exports use semicolons.
- Make sure the first row is the header.
- Values with commas must be quoted.
- Nested arrays do not fit neatly in CSV; flatten or stringify them.
- Open the CSV in a spreadsheet to confirm columns line up.
Frequently asked questions
How do I convert JSON to CSV?
Paste a JSON array of objects and press Convert.
How are nested objects handled?
They can be flattened with dotted column names.
What delimiter should I use?
Comma is standard, semicolon is common in Europe.
What if keys differ between objects?
The header is the union of all keys.
How do I convert CSV to JSON?
Paste the CSV with a header row and press Convert.
Is my data uploaded?
No.