JSON to CSV

array of objects → CSV · flatten nested · pick delimiter

Convert a JSON array of objects to CSV. For nested objects pick a flatten strategy (dot, bracket, or drop nested). Configurable delimiter (comma / semicolon / tab) and RFC 4180 quoting. The reverse direction lives at CSV → JSON. Runs in your browser.

Flatten nested Delimiter

Input JSON (array of objects)

CSV output

Paste a JSON array.

How to convert JSON to CSV

Paste your JSON array.
The column picker shows every detected key — toggle which to include and reorder them.
For nested objects, pick a Flatten strategy: Dot-notation (user.address.city), Bracket (user[address][city]), or Drop nested.
Pick Delimiter (comma / semicolon / tab) and Quote style.
Output appears below. Download as .csv.

Common targets

Excel / Sheets: use comma; if your locale uses comma as decimal, use semicolon.
Postgres COPY: tab or comma, with --csv mode for quoted fields.
BigQuery / Snowflake: comma, with explicit quoting; flatten nested with dot.
Pandas: pd.read_csv defaults to comma — match it.

FAQ

What happens with arrays inside objects?

They're serialized as a JSON string inside the cell. If you need each array element as its own row, see NDJSON for line-mode conversion, or pre-flatten with json-flatten.

Does the CSV escape correctly?

Yes — RFC 4180. Fields containing the delimiter, double quotes, or newlines are wrapped in "..." with embedded quotes doubled. Other CSV consumers may not handle multi-line cells correctly though.

Will it work offline?

Yes — pure JavaScript in the browser.