Flatten JSON into spreadsheet columns using dot paths, then copy it or download the file.
Nested objects become dot columns such as user.name, and arrays of scalars are joined into one cell.
An array of objects is the usual shape, straight from an API response or a database export. A single object works too and produces one row.
Comma is standard. Choose semicolon if the file is destined for Excel in a locale that uses the comma as a decimal separator, which avoids columns merging.
Copy the CSV straight to the clipboard, or download it as a file ready to open in a spreadsheet. Values containing quotes or delimiters are escaped for you.
They are flattened into dot paths, so a user object with a name field becomes a user.name column. This keeps the structure readable rather than dumping raw JSON into a cell.
An array of simple values is joined into one cell separated by semicolons. An array of objects is expanded into indexed columns, so the detail is not lost.
Every key seen across every row becomes a column, and rows missing that key get an empty cell. Nothing is silently dropped.
Usually yes. If columns run together, switch the delimiter to semicolon, which is what Excel expects in locales where the comma is the decimal separator.
No. The conversion runs in your browser, so API payloads and exported records stay on your machine.
Any value containing the delimiter, a double quote, a newline or leading and trailing spaces is wrapped in quotes, and inner quotes are doubled, following the usual CSV rules.
Yes, with the CSV to JSON tool, which is linked below. It handles the same quoting rules in the other direction.
Yes, completely free with no sign-up and no limits.
Turn a spreadsheet export into JSON, with quoted fields, custom delimiters and automatic type detection.
Open ToolFree online JSON formatter and validator. Format, minify and validate JSON with syntax highlighting and instant error detection.
Open ToolBuild realistic fake test data from the fields you choose, as JSON, CSV or SQL inserts.
Open Tool