Input Format:
Your JSON must be an array of objects. Each object becomes a row, and object keys become column headers.
Features:
- Handles nested objects (converts to JSON string)
- Properly escapes quotes and special characters
- Merges all unique keys from all objects
Privacy: All conversion happens in your browser. Your data never leaves your device.
About JSON to CSV Converter
Convert JSON arrays to CSV format for opening in Excel or Google Sheets. Object keys become column headers, values become rows. Download as .csv file or copy to clipboard.
APIs return JSON but spreadsheets want CSV. This converter transforms JSON arrays into clean CSV files that open perfectly in any spreadsheet application. Handles nested objects by converting them to JSON strings.
How to use JSON to CSV Converter
Paste your JSON array into the input.
Click Convert to generate CSV.
Review the output preview.
Download as .csv or copy to clipboard.
Open in Excel, Google Sheets, or any spreadsheet.
Examples
Basic conversion
JSON array becomes CSV table:
JSON Input:
[
{"name": "Alice", "age": 30},
{"name": "Bob", "age": 25}
]
CSV Output:
name,age
Alice,30
Bob,25Handling missing keys
Objects don't need to have all keys:
JSON:
[
{"name": "Alice", "age": 30, "city": "NYC"},
{"name": "Bob", "age": 25}
]
CSV:
name,age,city
Alice,30,NYC
Bob,25, ← empty cell for missing cityNested objects
Nested objects become JSON strings in cells:
JSON:
[{"name": "Alice", "address": {"city": "NYC"}}]
CSV:
name,address
Alice,"{""city"":""NYC""}"
Open in Excel, then parse the JSON column as neededFeatures
When to use this
- •Exporting API data to spreadsheets
- •Creating reports from JSON responses
- •Data analysis in Excel
- •Importing into legacy systems
- •Sharing data with non-technical users
- •Database exports to CSV