JSON to CSV Converter
Convert any JSON array (of objects or arrays) — or even a single object — into clean CSV. Tick the Flatten option to expand nested objects into dot-notation columns (e.g. <code>address.city</code>).
More options
How to use JSON to CSV
- Paste JSON.
- Pick delimiter; optionally enable flattening.
- Click Convert.
What is JSON to CSV?
Columns are derived from the union of all keys across all objects, so heterogeneous arrays still produce a complete CSV. Choose delimiter (comma, semicolon, tab, pipe) and whether to include a header row.
FAQ
- What about nested arrays?
- Nested arrays are JSON-stringified into a single cell. For full normalization, flatten manually or use a tool like jq first.
- What if objects in the array have different keys?
- The tool collects every unique key across all objects and uses them as the CSV header. Missing values in any row are left empty.
- How large can my JSON file be?
- Since conversion runs entirely in your browser, the practical limit depends on your device's RAM. Most machines handle files up to several hundred megabytes without issues.
Related tools
People also use
- CSV ↔ JSON🗄️ Developer Tools
CSV ↔ JSON — Convert tabular data between CSV and JSON. Header row detection, custom delimiter, quoted-field-with-comma support.
- XLSX to JSON💼 Office Tools
XLSX to JSON — Convert any Excel sheet to JSON — array of objects keyed by header row, or array of arrays with no header.
- CSV to SQL📊 CSV Tools
Convert a CSV to SQL INSERT statements for MySQL, PostgreSQL, SQLite or MS SQL. Optional CREATE TABLE, multi-value INSERT mode.
Last updated: