Related Tools
How to Use
- 1Paste a JSON array of objects into the input field.
- 2Or click 'Load Example' to see a sample conversion.
- 3Click 'Convert to CSV' to generate the output with proper escaping.
- 4Preview the first rows in the table below to verify column mapping.
- 5Copy to clipboard or download as a .csv file.
About JSON to CSV Converter
The JSON to CSV Converter transforms any JSON array of objects into a valid CSV file with proper escaping. Nested objects are automatically flattened using dot notation (e.g., 'address.city'), so complex API responses convert cleanly to spreadsheet rows.
Preview the converted data in a table before downloading to verify that columns map correctly. The tool handles commas, quotes, and line breaks inside field values according to the CSV standard.
Data analysts and developers use this to export API responses into Excel or Google Sheets, transform database exports into tabular format, and prepare JSON data for BI tools. All processing runs in your browser — no data is sent to any server.
Frequently Asked Questions
What JSON format is accepted?
The input must be a JSON array of objects: [{...}, {...}]. Each object becomes a row, and all unique keys across objects become column headers.
How are nested objects handled?
Nested objects are flattened using dot notation. For example, {"address": {"city": "NY"}} produces a column named 'address.city' with value 'NY'.
Can I open the CSV in Excel or Google Sheets?
Yes. The downloaded .csv file is compatible with Excel, Google Sheets, LibreOffice Calc, and any other spreadsheet application.
Is my data sent to a server?
No. All conversion happens locally in your browser using JavaScript. Your JSON data never leaves your device.
What happens if objects have different keys?
The converter collects all unique keys across every object to create the full set of columns. Objects missing a key will have an empty cell for that column.