JSON to CSV Converter

Which JSON shapes work

CSV is a table, so the converter looks for a list of records. An array of objects is the usual case: each object becomes a row. If the top level is an object with a single property holding an array of objects, as in a typical API response like {"data": [...], "page": 2}, that array is used and the footer says so. Any other object becomes a single row, and an array of plain values becomes one column called value.

The columns are every key found in any record, in the order they first appear. Records do not need the same keys: a missing key just leaves an empty cell, and a note above the output tells you how many rows had gaps. That is often the quickest way to spot inconsistent records in an export.

Nested objects and arrays

With Flatten nested objects on, each nested field gets its own column named by its path, so {"address": {"city": "Pune"}} becomes a column address.city. Turn it off to keep each nested object as JSON text in a single cell, which keeps the column count down for deeply nested data.

Arrays have three options. a; b joins simple lists like tags into one readable cell. Columns gives each item its own column, tags.0, tags.1 and so on, which suits short fixed-length lists such as coordinates. JSON writes the array as JSON text. Arrays of objects cannot be joined, so they use columns, or JSON if you choose it.

Opening the file in Excel

Excel guesses the file's encoding, and without a hint it often shows Müller instead of Müller. Tick Excel-friendly download to add a UTF-8 byte order mark that tells Excel which encoding to use. In countries where Excel uses a comma as the decimal separator, such as Germany, France or Brazil, it also expects semicolons between columns, so choose the semicolon delimiter. Google Sheets and Numbers read either.

Quoting and formula safety

Cells are quoted following RFC 4180: any value that contains the delimiter, a double quote or a line break is wrapped in double quotes, and quotes inside it are doubled. If the data came from users, tick Escape formulas. Cells starting with =, +, - or @ are then prefixed so spreadsheet apps show them as text instead of running them as formulas, which protects against CSV injection.

The table preview shows the first 100 rows. Copy and Download always include every row. To go the other way, use CSV to JSON.