JSON array to CSV for Excel or Sheets, nested objects as address.city columns; comma, semicolon, tab or pipe; a table preview
Turn an array of JSON objects into a CSV you can open in Excel or Google Sheets. Nested fields become dotted columns.
How to use it
Paste a JSON array of objects, or open a .json file. Pick the delimiter: comma for most tools, semicolon for Excel in many European locales, or tab. Under Options: Arrays as rows gives one row per record in a nested list (the other fields repeated); Dates writes ISO dates as 2024-03-05, 03/05/2024 or 05/03/2024; leave out the header row, quote every cell, or end lines with CRLF for Windows and Excel. Download the .csv or copy it straight into a spreadsheet.
Example
Nested objects become columns
Input
[{"id": 1, "user": {"name": "Ada", "city": "London"}}, {"id": 2, "user": {"name": "Grace"}}]Result
id,user.name,user.city 1,Ada,London 2,Grace,
Columns are the union of all keys; missing values are left empty.
How the columns are built
Questions
- What JSON shapes can be converted?
An array of objects (the usual API list response), a single object (one row), or an array of arrays (written as rows directly). Also JSON Lines, one object a line, and an object whose one array of records holds the rows, as in {"data": [...], "total": 2}; the status bar says which it read. - Can it read a file that isn’t UTF-8?
Yes for UTF-16 and UTF-32 files that start with a byte-order mark, as Windows tools often save them, and for Windows-1252 and ISO-8859-1 text. Other single-byte encodings, such as Windows-1251, are read as Windows-1252 and show the wrong letters, and the rest as a file that could not be read; save those as UTF-8 first. - Why does Excel put everything in one column?
Excel uses your system’s list separator. In many European locales that is a semicolon: choose "Semicolon" and open the file again. - Why does it say some cells start like a formula?
A cell that starts with =, +, -, @, a tab or a carriage return may run as a formula when a spreadsheet opens the file. The CSV keeps your values as they are; turn on "Make safe for spreadsheets" to start those cells with an apostrophe, so Excel, Google Sheets and LibreOffice show them as text. - Is my data uploaded?
No. Everything runs in your browser, so your data stays on your device. Nothing you paste is uploaded unless you share a result, which is locked with your password first. That matters for exports with customer or user data.