How This Tool Converts JSON to CSV
- Accepts a JSON array of objects or a single object; each array element becomes one CSV row.
- Column headers are collected from all unique keys across every object — if objects have different keys, missing cells are left empty.
- Nested objects are flattened automatically using dot notation:
address.cityandaddress.countryeach become their own column. - Array values inside objects (e.g.
"roles": ["admin","editor"]) are joined with|into a single cell value.
When to Use JSON to CSV
- When you need to open API response data in Excel or Google Sheets for review or sharing.
- When preparing data for bulk import into a database, CRM, or data warehouse that expects CSV format.
- When building a report and your data source is a JSON API response array.
- When handing structured data to a non-technical stakeholder who prefers a spreadsheet view.
Frequently Asked Questions
What JSON format does this tool accept?
This tool accepts a JSON array of objects or a single JSON object. Each array item becomes one CSV row. Nested objects are flattened automatically using dot notation.
Can I convert nested JSON?
Yes. Nested objects are flattened automatically using dot notation — address.city, address.country, etc. Array values inside objects are joined with | .
Why is my CSV missing fields?
CSV rows are built from object keys. If some objects have different keys, missing values will appear as empty cells.
What delimiter does the CSV output use?
The output uses commas as the delimiter (standard CSV). Any values that contain a comma are automatically wrapped in double quotes so they are parsed correctly by Excel, Google Sheets, and other tools.
What happens to null or missing values?
JSON null values become empty cells in the CSV. If an object is missing a key that other objects in the array have, that cell is also left empty.