Skip to the tool
Filekits
FreeNo sign-upNo watermarkNo file-size games

JSON to CSV

Give it an array of objects and it works out the columns from every key it finds, so a record missing a field still lines up.

Runs
On your device. The file is never uploaded.
Takes
JSON
Gives
CSV
json-to-csvLocal

How it works

  1. 01Paste an array of JSON objects
  2. 02Check the columns it found
  3. 03Download the CSV

Questions

What happens to nested objects?
They are flattened into dotted column names, so {"user":{"name":"Ada"}} becomes a column called user.name.
What about arrays inside a record?
They are written back as JSON in a single cell, which is lossless and survives a round trip.
Will it open in Excel?
Yes. Commas are the separator, quotes are doubled, and the file is UTF-8 with a byte order mark so Excel reads accents correctly.