JSON to CSV
Convert JSON arrays to CSV instantly. Handles nested objects with dot-notation flattening, custom delimiters, and large files via Web Worker. No data uploaded.
What is JSON to CSV conversion?
CSV (Comma-Separated Values) is the universal format for spreadsheets, data analysis tools, and database imports. Converting a JSON array to CSV lets you open API data in Excel, import it into Google Sheets, load it into pandas, or feed it to any data pipeline that expects tabular data.
How to convert JSON to CSV
- Paste a JSON array of objects into the input. Each object becomes one CSV row.
- Choose your delimiter — comma for Excel/Sheets, semicolon for European locales, tab for TSV.
- Toggle Flatten nested objects to expand
{"user": {"name": "Alice"}}into auser.namecolumn. - Copy the CSV or download it. Need to go the other way? Use our CSV to JSON converter.
How are nested objects handled?
When Flatten is enabled, nested objects are expanded using dot notation. For example:
// Input JSON
[{"user": {"name": "Alice", "city": "London"}, "score": 99}]
// Output CSV (flattened)
user.name,user.city,score
Alice,London,99Arrays inside objects are converted to a JSON string representation in the cell, since CSV has no native array syntax.
Why this is safer for sensitive data
API exports, CRM data, and analytics JSON often contain personal information. This tool runs entirely in your browser — your data is converted locally and never uploaded to any server. The downloaded CSV goes directly from your browser to your filesystem.
Frequently Asked Questions
How do I convert JSON to CSV online?
Paste your JSON array into the input, click Convert, and download the CSV. Nested objects are flattened using dot notation (e.g. address.city).
What happens with nested JSON objects?
Nested objects are flattened: {"user":{"name":"Alice"}} becomes a column named user.name with value Alice.
Can I change the delimiter?
Yes. Choose comma, semicolon, tab, or pipe as the delimiter to match your target application.
What if my JSON has inconsistent keys?
The converter performs a full pass to collect all unique keys and uses them as headers, leaving empty cells for missing values.