How are nested objects handled?

Keys are flattened with dot notation (for example user.name). Arrays are JSON-encoded into a single cell by default, or you can join them with a separator, expand them into tags[0], tags[1]… columns, keep only the first item, or output the count.

Why does Excel show everything in one column or garble accents?

Enable the Excel-friendly option: it adds a UTF-8 byte-order mark so Excel detects the encoding and uses CRLF line endings. If your locale uses semicolons as list separators, choose the semicolon delimiter too.

What delimiter is used?

Comma by default. Values containing the delimiter, quotes or newlines are quoted per RFC 4180.

JSON to CSV

Convert an array of JSON objects (or an object that contains one, such as an API response with a data or items field) to CSV. Column headers are inferred from object keys, nested values are flattened with dot notation, and arrays can be JSON-encoded, joined, expanded to columns, counted or reduced to their first item. Preview the table, toggle, reorder and rename columns, choose the null representation and enable the Excel-friendly BOM + CRLF output.

Runs locally in your browser

For large datasets, open fullscreen for a wider view

JSON input

0 chars · 1 line

CSV output

Output will appear here…

Delimiter

Arrays

Null as

Header rowFlatten nested objects (a.b.c)Quote every fieldExcel-friendly (UTF-8 BOM + CRLF)

Fields containing the delimiter, quotes or newlines are quoted per RFC 4180. Enable the Excel option when Excel shows accented characters wrong or puts everything in one column.

CSV to JSON

Parse CSV into JSON objects, arrays, columns or NDJSON with a table preview and type inference that keeps IDs intact.

JSON Formatter

Beautify, minify, sort, query and repair JSON with a tree view and copy-as code export.

JSON to YAML

Convert JSON into clean YAML with control over quoting, wrapping, anchors and multi-document output.

How to use JSON to CSV

1Paste a JSON array, or an object containing one. If the tool finds several arrays it lets you pick which one becomes the rows.
2Switch to Table preview to check the first 100 rows.
3Use the Columns panel to hide, reorder or rename columns.
4Pick delimiter, array handling, null text and the Excel option, then copy or download the CSV.

About JSON to CSV

JSON to CSV is part of FizzKit — a collection of focused developer and ad-tech tools. Because everything runs locally, it works offline once loaded and never exposes your data to a remote server.

Frequently asked questions

An array of objects, where each object becomes one row. If you paste an object instead, the tool looks for arrays inside it (up to four levels deep) and lets you choose one, so raw API responses work without editing.

Related tools