JSON to CSV

Your files never leave your device.

Choose a format
Choose a format

Every key becomes a column. Nested objects and lists are written into their cell as JSON text.

Questions about JSON to CSV

How does JSON to CSV work?

JSON to CSV flattens your data into a table. For an array of objects, every key found becomes a column, in the order it first appears, and each object becomes a row. Nested objects and arrays are written into their cell as JSON text, and null or missing values become empty cells.

Which JSON shapes can I convert?

An array of objects, an array of arrays (each inner array is a row), or an object whose values are all arrays. In that last case each key is treated as its own table, so you get one CSV per key, such as file-orders.csv and file-customers.csv.

What if my objects don't all have the same keys?

That's fine. The columns are every key that appears in any object, in the order first seen, and an object that lacks a key gets an empty cell in that column.

How are numbers and true/false written?

As plain text: true and false are written as those words and numbers as their digits. CSV has no types, so the app that opens the file decides how to read them.