JSON to CSV
Paste an array of JSON objects and get a CSV file ready to download: the header row is built automatically by merging the keys of every object.
How mismatched keys and nested values are handled
Real-world JSON arrays rarely have perfectly uniform objects. This converter builds the CSV header from the union of every key it finds, in the order each key first appears: when an object is missing a key, the matching cell is simply left blank. Nested values — objects or arrays stored inside a field — are serialized as JSON text inside the cell, so no information is lost along the way.
Opening the CSV in Excel without garbled characters
The downloaded file includes a UTF-8 BOM, the small marker that tells Excel to read the file as Unicode: accented letters, currency symbols, and emoji will display correctly. If you use Excel or Google Sheets with US settings, the classic comma delimiter is the right choice; in locales where the comma is the decimal separator (much of Europe), pick the semicolon instead. Double quotes inside values are escaped by doubling them, following the RFC 4180 standard, so the file stays readable by any spreadsheet or import script.