How to convert JSON to CSV
APIs, database exports and many apps hand you data as JSON. To review it in a spreadsheet, share it with someone who does not code or import it into another tool, CSV is far more practical.
This converter takes JSON containing an array of objects and builds a CSV with one column per field and one row per object.
Step by step
- Make sure your JSON is an array of objects, for example [{"name": "Ana", "age": 31}, …].
- Click Select file and choose the .json file (up to 50 MB).
- Check that Convert to shows CSV and click Convert to CSV.
- Download the CSV and open it in your spreadsheet app.
Which JSON structure is supported
The JSON must be an array of objects with simple values: strings, numbers, true/false or null. If an object contains another array or a nested object, the conversion stops, because a flat table cannot represent those levels. A single bare object will not work either: wrap it in square brackets.
The columns are the union of every key, in the order each first appears. If an object is missing a key, its cell is left empty.
Details of the generated CSV
The CSV uses a comma as delimiter and UTF-8 encoding. The values true and false are written as True and False, and null becomes an empty cell.
For safety, strings that start with =, +, - or @ are saved with an apostrophe in front. That stops a spreadsheet from treating them as formulas when the file is opened, a problem known as CSV or formula injection.
Frequently asked questions
- Why does it say my data is nested?
- An object contains an array or another object. Flatten those fields into simple columns before converting.
- What if the objects have different keys?
- A column is created for every key found, and missing values are left empty.
- Why do some values start with an apostrophe?
- They began with =, +, - or @, and are protected so the spreadsheet does not run them as formulas.
- Can I convert JSON straight to Excel?
- Yes, choose XLSX as the target in the converter; the same structure rules apply.