JSON to CSV Converter
Paste a JSON array and convert it to CSV format. Download as a .csv file or copy to clipboard. Handles nested objects with flattening options.
Why use a JSON to CSV Converter?
JSON is the standard format for APIs and databases, but business stakeholders, data analysts, and reporting tools typically work in spreadsheets. Converting JSON arrays to CSV makes your data immediately importable into Excel, Google Sheets, Tableau, and any BI tool. This converter also flattens nested objects using dot notation so even complex structures produce clean CSV columns. See also the CSV to JSON converter and CSV viewer in the data tools category.
Spreadsheet-ready
Output CSV is immediately importable into Excel, Google Sheets, or any BI tool without additional transformation.
Nested object flattening
Nested JSON objects are flattened to dot-notation column names (e.g. address.city) so all data maps to clean CSV columns.
Download support
Download the CSV file directly or copy the output to clipboard for pasting into your spreadsheet or data pipeline.
Nested JSON flattening strategies
This tool uses dot-notation flattening. Here's how different nesting levels are handled in the CSV output.
| JSON input | CSV column name | Notes |
|---|---|---|
| {"name": "Alice"} | name | Top-level key — mapped directly |
| {"address": {"city": "London"}} | address.city | Nested object — flattened with dot notation |
| {"a": {"b": {"c": 1}}} | a.b.c | Deep nesting — fully flattened recursively |
| {"tags": ["a", "b"]} | tags | Arrays — serialised as JSON string in the CSV cell |