Skip to main content

JSON to CSV

Convert JSON arrays to CSV format, ready to open in Excel.

convertcsvexport
Read the guide
Shortcuts:⌘ KSearch
Rows: 0Columns: 0

Frequently Asked Questions

Why does it say my input must be a JSON array?

Because this converter treats each array item as a CSV row. A single object is not accepted unless you wrap it in an array yourself.

How are nested objects handled?

With Flatten nested objects on, nested keys become dot-path headers like user.name. If you turn flattening off, objects and arrays are written into one cell as JSON strings.

Can I export semicolon- or tab-delimited CSV for Excel?

Yes. The delimiter dropdown supports comma, semicolon, tab, and pipe, and Download saves the result as converted.csv.

Why are some cells blank?

The tool builds one header set from all row keys, then fills missing values with empty strings. Null and undefined-like gaps therefore become blank cells.

Does it quote every field?

Headers are always quoted, and data cells are quoted when the Quote strings option is on. Even with that off, cells are still quoted automatically if they contain the delimiter, quotes, or line breaks.

Related Tools