JSON to CSV
JSON to CSV turns a JSON array of objects or arrays into CSV text with a header row, and lets you copy it or save a .csv file. It runs in your browser.
- Free, no sign-up
- Nothing is sent to a server
- Worldwide
How to use JSON to CSV online
- Paste the JSON. Paste an array of objects, or an array of arrays.
- Choose the separator. Use a comma, or a semicolon, tab or pipe if your program expects it.
- Switch on the guard if needed. Tick the formula guard when the file will be opened in a spreadsheet and the data is not yours.
- Copy or download. Copy the CSV or save it as data.csv.
Why use this free JSON to CSV
- Array of objects or arrays
- Header row from the keys
- Correct quoting
- Comma, semicolon, tab or pipe
- Formula guard option
- Nothing sent, nothing stored
From JSON to a table
Web services and databases often return JSON, but people and spreadsheets like tables. This tool lays an array out as rows and columns. When the array holds objects, each key becomes a column. When it holds arrays, each inner array becomes a row and no header is added.
How columns are chosen
The tool reads every object and collects the keys in the order they first appear. Objects do not need to have the same keys. An object that lacks a key gets an empty cell in that column. A single object, not in an array, is treated as one row.
Quoting
A value that contains the separator, a double quote or a line break is wrapped in double quotes, and any quote inside it is doubled. For example, the value x,y is written as "x,y" so it stays one cell. Without quoting, it would split into two cells and shift every value after it.
Nested data
CSV has no way to hold a list inside a cell. Nested objects and lists are therefore written as JSON text in the cell, and you can convert that column again later. A null value becomes an empty cell.
Spreadsheet formulas
A spreadsheet may treat a cell that starts with an equals sign, a plus, a minus or an at sign as a formula. If you are exporting data that came from other people, tick the guard and the tool adds an apostrophe in front of such text so it stays text. Plain numbers, such as -5, are not changed. The guard changes your data, so it is off by default.
JSON to CSV: frequently asked questions
What JSON can I paste?
How are the columns ordered?
What happens to nested objects?
Why would I use the formula guard?
Can I use a semicolon instead of a comma?
Is my JSON uploaded?
Related searches for JSON to CSV
- JSON to CSV online
- free JSON to CSV
- JSON to CSV online free
- JSON to CSV for mobile
- JSON to CSV without sign up
- convert json to csv
- json to csv converter
- JSON to CSV – Text & Developer Tools
JSON to CSV is a free online tool on MAITBOX, in the Text & Developer Tools group. It runs in your browser, so what you type is not sent to a server. It works on Android and iPhone, and on Windows, Mac and Linux, with no download and no account.