JSON to CSV FREE
Flatten an array of JSON objects into a CSV table. Nested values are either flattened into dotted columns or reported, never silently dropped.
Drop a file here, or choose one
CSV, TSV, JSON, YAML, XML, Markdown, HTML, plain text, Excel workbooks, and audio and video. The format is read from the file itself, not from its name.
Your files
Convert to
Columns
Uncheck a column to leave it out, type over a name to rename it, and use the arrows to reorder. The preview below follows.
What was read
How this conversion works
A CSV is a rectangle and JSON is a tree, so the interesting question is what happens to the branches. This converter gives you two honest answers: flatten nested objects and arrays into dotted columns (user.name, user.tags.0), or stop and name the paths that will not fit.
What it never does is the third thing most converters do, which is to stringify a whole nested branch into one cell of unreadable JSON, or drop it in silence. Either way you would find out later, from the spreadsheet.
An array of objects converts directly. A document with a single wrapper key holding the array - the shape almost every API returns - is unwrapped automatically. A document that is one object with no list in it has nothing to put in rows, and says so.
Build a better web, faster.
We build custom software and solutions tailored to your needs.



