Convert JSON to CSV Online
Transform JSON data to CSV format for spreadsheets and data analysis.
JSON Input
CSV Output
Other conversions
What is JSON to CSV conversion?
JSON stores data hierarchically, while CSV is flat and tabular. Converting JSON to CSV is essential when you need to analyze API data in Excel, import into databases, or share with non-technical users.
How to convert JSON to CSV?
- Paste your JSON array of objects in the input panel
- Conversion is automatic - CSV appears with headers based on JSON keys
- Download as .csv file to open in Excel or Google Sheets
Converter features
- Auto headers: Column names are extracted from JSON object keys
- Nested flattening: Nested objects become columns with dot notation (address.city)
- Excel compatible: Proper escaping of commas, quotes, and newlines
- Works with arrays: Each array element becomes a CSV row
Frequently Asked Questions
What JSON structure works best?
An array of objects with consistent keys works best:
[{"name": "John", "age": 30}, {"name": "Jane", "age": 25}]. Each object becomes a row, and keys become column headers.How are nested objects handled?
Nested objects are flattened using dot notation. For example,
{"address": {"city": "NYC"}} becomes a column named "address.city".What happens with arrays inside objects?
Arrays within objects are joined with semicolons (;) in a single cell, or can be flattened into numbered columns depending on the structure.
Is the CSV compatible with Excel?
Yes, the generated CSV follows RFC 4180 standards and opens correctly in Excel, Google Sheets, LibreOffice Calc, and most spreadsheet applications.