JSON to CSV

Turn an array of objects into a spreadsheet-ready CSV, with nested objects flattened into dotted columns and quoting handled by the rules.

Separator
json
CSVcsv
The result appears here

Questions

How are nested objects handled?+

They become dotted columns: an address object with a city key gives you an address.city column. It is the only honest way a flat table can carry a tree.

What about arrays inside a record?+

They keep their JSON in the cell. A list has no faithful flat form, and splitting it across columns would break the moment one record has more items than another.

Which columns end up in the file?+

The union of every key seen, in the order they first appear. A key that only some records carry still gets a column, empty where the record had nothing.

Excel shows my accented characters as nonsense. How do I fix it?+

Excel assumes the local code page unless a UTF-8 file starts with a byte order mark. Save the download with a BOM, or open it through Data, From Text rather than by double-clicking. Nothing is wrong with the file itself.

Related tools

The tools are free. So is most of the library.

1935 blocks and 989 pieces for shadcn/ui and Tailwind, built on the same tokens these tools write. Install one with a command and the code is yours.

No signup for the tools. MIT for free blocks, commercial licence for Pro.

Markdown version