JSON to CSV Converter — Export JSON to Excel Online
Convert a JSON array of objects to CSV format. Keys become headers, each object becomes a row. Download the result for Excel or Google Sheets.
Frequently Asked Questions
What JSON format works for CSV conversion?
An array of objects where each object has the same keys. Keys become column headers and each object becomes a row. Example: [{"name":"Alice","age":30},{"name":"Bob","age":25}]
Are nested objects supported?
Nested objects are serialised as strings in the CSV cell. For complex nested data, flatten your JSON first before converting.
Can I open the CSV in Excel or Google Sheets?
Yes. Click Download to save the .csv file, then open it directly in Excel or Google Sheets.
People Also Ask
How do I convert a JSON array to CSV for Excel?
Paste your JSON array into the converter above and click Download — the tool generates a standard .csv file that opens directly in Excel or Google Sheets, with each object's keys as column headers.
What happens if my JSON objects have different keys?
The CSV output includes a column for every key found across all objects. Objects missing a given key get an empty cell in that column, so no data is silently dropped.
Can I convert deeply nested JSON to CSV?
This converter handles flat arrays of objects directly. For nested objects and arrays, flatten the structure first — see the dedicated guide on flattening nested JSON to CSV, which covers dot-notation columns and array handling.
How do I convert JSON to CSV in Python or JavaScript?
In Python, the csv and json modules combined with DictWriter handle it in a few lines. In Node.js, libraries like json2csv or papaparse do the same. Use this tool for a one-off conversion without writing any code.
Does converting JSON to CSV lose any data?
Scalar values (strings, numbers, booleans) map cleanly to CSV cells. Nested objects and arrays are serialised as text within a cell rather than expanded into multiple columns, so highly nested data should be flattened first for a clean spreadsheet.