About this tool
Convert a JSON array to CSV format.
The JSON to CSV converter takes a JSON array of objects and produces a CSV file ready for import into Excel, Google Sheets, or any data pipeline. The keys of the first object become the CSV header row. All values are serialised to strings. Nested objects are serialised as JSON strings by default, or flattened into dot-notation columns with the flattening option.
Example
Input: [{"name":"Alice","score":95}]
Output: name,score\nAlice,95
How to use
- Paste a JSON array of objects in the input.
- Click Convert.
- CSV output appears with a header row.
- Copy or download as a .csv file.
Features
- JSON array → CSV with header row
- Comma and semicolon delimiter options
- Nested object flattening
- Download as .csv file
- Missing keys handled gracefully
Frequently Asked Questions
What JSON format is required?+
An array of objects: [{...}, {...}, ...]. All objects should share the same keys for a well-formed CSV.
How are nested objects handled?+
Nested objects are serialised as JSON strings in the CSV cell by default. Enable "flatten" to expand them into dot-notation columns (e.g. address.city).
Can I use a semicolon delimiter?+
Yes. Choose semicolon for European spreadsheets where comma is used as the decimal separator.
How do I open the CSV in Excel?+
Click Download to save as .csv, then open in Excel. Or paste into Notepad, save as .csv and import.
What happens to nested objects?+
Nested objects are serialised as JSON strings in the CSV cell. Flatten the JSON first if you need separate columns for nested properties.
Does it preserve column order?+
Yes. Column order matches the key order of the first object in the array.