How to use the JSON to CSV Converter
Convert JSON to CSV in four steps:
1
Paste a JSON array
The converter works with JSON arrays of objects — each object becomes a row. Paste your array into the input panel.
2
Preview the table
A table preview shows how your data will map to CSV columns. Column names come from the JSON object keys.
3
Choose delimiter
Select comma (,), semicolon (;), or tab as the delimiter. Semicolon is standard in European locales where Excel uses it by default.
4
Download the CSV
Click Download CSV to save the file. Open it directly in Excel, Google Sheets, or any spreadsheet application.
When to use this tool
JSON to CSV conversion bridges the gap between developer APIs and business tools. Use it when:
- →Exporting API data into Excel or Google Sheets for analysis, reporting, or sharing
- →Preparing data for import into CRM systems, email platforms, or databases that accept CSV
- →Sharing structured JSON data with non-technical stakeholders who use spreadsheets
- →Converting a JSON data export from one tool for import into another
- →Building quick data visualizations using spreadsheet charting tools
Frequently asked questions
Q:What JSON structure works with this converter?
The converter is designed for JSON arrays of flat or shallow objects: [{"name": "Alice", "age": 30}, {"name": "Bob", "age": 25}]. Each object maps to a row and keys become column headers. Deeply nested objects are flattened using dot notation (e.g. address.city).
Q:How are nested objects handled?
Nested objects are flattened into dot-notation column names. For example, {"user": {"name": "Alice", "city": "NY"}} becomes two columns: user.name and user.city. Arrays inside objects are converted to a semicolon-separated string in a single cell.
Q:What if my values contain commas?
Values containing commas are automatically wrapped in double quotes per the CSV standard (RFC 4180). Values that contain double quotes are escaped as two double quotes (""") — ensuring the CSV opens correctly in Excel and Google Sheets.
Q:Can I convert CSV back to JSON?
Yes — use our CSV to JSON Converter tool. It reads the header row as JSON keys and each subsequent row as an object.