JSON to CSV Converter

Nested objects become dotted columns

JSON nests; CSV does not. With flattening on, which is the default, a structure like user.address.city becomes a column of exactly that name. Every level is preserved in the column header, so nothing is lost and you can see where each value came from. Turn flattening off only when your JSON is already flat and you want the keys untouched.

Array handling is the setting that matters

This is where most converters quietly make the choice for you, and it is the one that decides whether the CSV is useful.

Stringify puts the whole array into a single cell as text. A record with three tags becomes one cell containing all three. That keeps the row count matching the record count, which is right when the array is incidental — a list of labels you just want to see.

Expand produces one row per array item instead, repeating the rest of the record on each. Three tags become three rows. That is what you want whenever you intend to count, filter or pivot by the thing inside the array — which, for most analysis, is the whole reason you exported it. Bear in mind it multiplies your row count, so a large file with long arrays gets much larger.

If you are not sure: stringify to eyeball the data, expand to analyse it.

Records with different fields

Real API output is rarely uniform — some records carry optional fields, others do not. The header row is built from every key found across all records, not just the first one, so a field that appears in only some records still gets a column, with blanks where it is absent. Converters that read only the first record silently drop everything the others added, which is a bad way to lose data.

Delimiters and headers

Comma is the default. Choose semicolon if the CSV will be opened in Excel on a European locale, where a comma-separated file otherwise arrives as one mangled column, and tab for import tools that expect it. The header row can be turned off for systems that want raw data with no column names.

Nothing is uploaded

The file is read and converted in the page. API exports tend to contain customer records, order histories and internal identifiers, so keeping them on your own machine is the sensible default rather than a nicety.

Related tools

CSV to JSON Converter goes back the other way. CSV to Excel Converter turns the result into a formatted workbook, and Excel to CSV Converter handles the reverse trip when your data starts in a spreadsheet.