JSON to CSV

Turn a JSON array of objects into a spreadsheet-ready CSV, with optional flattening of nested data.

JSON file (optional - or paste below)

JSON input

Delimiter

Nested objects

Header row

CSV output

How it works

Accepts an array of objects, an array of arrays, or a single object (treated as one row).
With flattening on, nested objects become columns like address.city; nested arrays are JSON-encoded into a single cell.
Values containing the delimiter, quotes or line breaks are quoted and escaped per RFC 4180, so Excel and Sheets open the file cleanly.
The column order follows the keys in the order they first appear.