API responses and app exports come as JSON, but the people who need to read them live in spreadsheets. ConvertCove flattens your JSON into tidy columns and writes a CSV that Excel, Numbers and Google Sheets open without an import wizard.
How to convert JSON to CSV
- Click Select JSON files or drag them onto the box above. You can add as many as you like.
- Check that the target says CSV. Click the slider icon next to a file to change its options.
- Press Convert. Each file shows its own progress, and the work happens on your device.
- Download files one by one, or use Download all (ZIP). Press Convert more to start a new batch.
German, French and other European versions of Excel expect semicolons. Pick “Semicolon” in the options if the columns appear merged.
JSON vs CSV
What is JSON?
JSON can nest objects inside arrays inside objects to any depth. That flexibility is what makes turning it into a flat table non-trivial. More about the JSON format.
What is CSV?
CSV is the lowest common denominator of tabular data: every spreadsheet, database and BI tool can import it. More about the CSV format.
| JSON | CSV | |
|---|---|---|
| Full name | JavaScript Object Notation | Comma-Separated Values |
| Extensions | .json | .csv, .tsv, .txt |
| MIME type | application/json | text/csv |
When to convert JSON to CSV
- You exported orders, users or analytics events from an API and need to analyse them in a spreadsheet.
- A non-technical colleague needs to review data from a web app.
- You are importing records into a CRM or email tool that only takes CSV.
- You want to diff two datasets in a spreadsheet.
Quality and settings
ConvertCove finds the main array of records automatically, even when it is wrapped in an object such as {"data": {"items": [...]}}. Nested objects become dotted column names (address.city), arrays of plain values are joined with “; ”, and arrays of objects get indexed columns (items[0].sku). Columns are the union of all keys, in the order first seen, so records with missing fields still line up. By default the file starts with a UTF-8 byte-order mark so Excel shows accented characters correctly; you can also choose semicolon, tab or pipe delimiters.