What is JSON to CSV conversion?
JSON to CSV conversion flattens structured JSON data into a tabular format suitable for spreadsheets and databases. This tool handles nested objects, arrays of objects, and custom delimiter selection. The conversion runs entirely in your browser and produces a downloadable .csv file.
From nested JSON to flat rows
CSV is a flat, tabular format: one header row of column names followed by rows of values. JSON, by contrast, is hierarchical. Converting JSON to CSV means taking an array of objects and turning each object into a row, with the object keys becoming the column headers. This is exactly what you need to open API data in a spreadsheet or import it into a database.
When objects contain nested fields, they are flattened into columns so that every value has a place in the table, and keys that appear in some objects but not others become columns that are simply left blank where absent.
Delimiters, quoting, and escaping
A correct CSV quotes any value that contains a comma, a quote, or a line break, and doubles internal quotes so a spreadsheet reads the row correctly. The converter handles this automatically, so a product name like "Widget, large" ends up in a single cell rather than spilling across two columns.
Handling inconsistent objects
Real data is rarely uniform: some objects have fields others lack. The converter collects every key that appears across the array into the header row, so each record still lines up under the right columns and missing values become empty cells rather than shifting the data out of alignment.
How to convert JSON to CSV
- 1Paste a JSON array. Paste an array of objects — for example an API response listing records.
- 2Click Convert. Each object becomes a row and the keys become the header columns.
- 3Download or copy. Use Download to save a .csv file, or copy the result into a spreadsheet.
Examples
Array of objects to CSV
Input
[{"name":"Ada","role":"Engineer"},{"name":"Alan","role":"Analyst"}]Output
name,role Ada,Engineer Alan,Analyst
Values needing quotes
Commas inside a value are quoted.
Input
[{"item":"Widget, large","qty":3}]Output
item,qty "Widget, large",3
JSON to CSV mapping
How structures translate.
| JSON | Becomes |
|---|---|
| Array of objects | Rows of the table |
| Object keys | Column headers |
| Missing key | Empty cell |
| Value with comma | Quoted cell |
| Nested object | Flattened columns |
Frequently asked questions
What JSON shape does the converter expect?+
An array of objects works best, because each object becomes a row and its keys become columns. A single object is treated as one row.
How are commas inside values handled?+
Any value containing a comma, quote, or newline is wrapped in double quotes, and internal quotes are doubled, so spreadsheets parse each row correctly.
What happens to nested objects and arrays?+
Nested fields are flattened into additional columns so every value appears in the table rather than being lost.
Can I open the result in Excel or Google Sheets?+
Yes. Download the .csv and open it directly, or paste the output into a spreadsheet.
Is my data uploaded?+
No. Conversion runs entirely in your browser, so your JSON never leaves your device.
Is it free?+
Yes — free with no limits.
Can I convert CSV back to JSON?+
This tool converts JSON to CSV. To go the other way, import the CSV into a spreadsheet or use a dedicated CSV-to-JSON converter.