Menu
PDF Tools
Image Tools
Converters & Utilities
Seller & Print Tools
Accounting & Business
Calculators
Text & Writing Tools
Developer & Web Tools
Creator & Social Tools
Browser Utilities & Games
Document & Design Makers
Text & Developer Tools
Exam & Form Tools

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.

How to use JSON to CSV online

  1. Paste the JSON. Paste an array of objects, or an array of arrays.
  2. Choose the separator. Use a comma, or a semicolon, tab or pipe if your program expects it.
  3. 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.
  4. 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?
An array of objects, an array of arrays, or a single object. Other shapes are refused with a message.
How are the columns ordered?
In the order the keys first appear in the data.
What happens to nested objects?
They are written into the cell as JSON text.
Why would I use the formula guard?
To stop a spreadsheet from running text that starts with = + - or @ as a formula when the data comes from other people.
Can I use a semicolon instead of a comma?
Yes. Pick the separator your program expects.
Is my JSON uploaded?
No. It is converted in your browser and nothing is stored.

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.

More tools in Text & Developer Tools →

Search tools