Convert JSON data to CSV format with nested flattening, array expansion, and custom delimiters
Zero Dependencies · Works Offline📥 JSON Input
⚙️ Conversion Options
📤 CSV Output
What Can the JSON to CSV Converter Do?
The JSON to CSV Converter is a free online data format conversion tool that quickly transforms JSON array data into CSV table format. Supports automatic nested object flattening (e.g., user.address.city), multiple array field handling options, custom delimiters, and column sorting. The resulting CSV can be directly imported into Excel, Google Sheets, and other tools. All processing runs locally in your browser—no data is ever uploaded.
Core Features
- Nested Flattening: Automatically expand deep nested objects into dot-separated columns (e.g., address.city)
- Array Handling: Three modes—semicolon join, JSON stringify, or skip
- Multiple Delimiters: Comma, Tab, Semicolon, and Pipe delimiters
- Auto Detection: Automatically identifies JSON arrays or objects with data/results/items fields
- Error Location: Precise JSON syntax error position reporting
How to Use
1. Paste JSON data in the input box, or click "Load Example" to see it in action.
2. Select CSV delimiter, nested object and array handling options.
3. Click "Convert to CSV" or press Ctrl+Enter.
4. Copy the result or download as a .csv file.
Use Cases
Data Analysis
Data analysts convert API JSON responses to CSV for import into Excel or Pandas for statistical analysis.
Database Migration
Developers convert MongoDB JSON exports to CSV format for import into MySQL and other relational databases.
Report Generation
Ops teams convert monitoring system JSON responses to CSV for more readable reports.
Technical Background
CSV (Comma-Separated Values) is the most universal tabular data exchange format, supported by virtually all data processing tools. The core challenge of JSON to CSV conversion is handling nested structures and arrays: nested objects need flattening to dot-notation paths, and arrays require decisions on joining, expanding, or skipping. RFC 4180 defines the CSV standard, requiring fields containing commas, newlines, or double quotes to be wrapped in double quotes, with internal double quotes escaped as two double quotes. TSV (Tab-Separated Values) is a CSV variant using tab delimiters, common in bioinformatics and log analysis.
❓ FAQ
How to convert JSON to CSV?
Each JSON array object becomes a CSV row, keys become headers, values become cells. Nested objects use dot notation, arrays can be joined or expanded.
How are nested objects handled?
Automatically flattened with dot-joined keys (e.g., address.city). Deep nesting is recursively expanded.
How are array fields converted?
Three options: join with semicolons, convert to JSON string, or skip array fields.
What delimiters are supported?
Comma, Tab, Semicolon, and Pipe delimiters.
Is data uploaded?
No. All conversion runs locally in your browser.