Convert a JSON array of objects into CSV rows with a header row of field names.
Try an example
Load a ready-made sample into this tool and run it. Every result you see is calculated live by the tool itself — nothing here is a pre-written answer.
Sample: input: [{"name":"apples","qty":4},{"name":"bread","qty...
How to Use
- Paste a JSON array of objects.
- Click Run.
- Copy or download the CSV result.
What this JSON to CSV converter does
This JSON to CSV converter turns a JSON array of objects into comma-separated rows that a spreadsheet can open. The field names from your objects form the header row, and each object becomes one row beneath it. Paste the array, run the converter, and copy or download the CSV for Excel, Sheets or any tool that imports tabular data. You do not need a spreadsheet open to produce the file.
When to use it
Use it when an API hands you JSON but you need to sort, filter or share the data as a table. It is designed for flat records: names, dates, amounts and statuses of the same shape. If your objects carry different fields, expect some columns to sit empty for the rows that lack them.
Good to know
The input must be a JSON array of flat objects. A value that is itself an object or an array cannot occupy a cell, so it is written into its cell as JSON text instead. If your data is deeply nested, flatten it first or the spreadsheet columns will not line up.
Frequently asked questions
What shape of JSON does it accept?
A single array whose items are objects, like a list of customers or orders. A lone object, or an array of plain numbers, does not fit the table model. Wrap a single record in square brackets to convert it.
How are nested objects handled?
They are written into their cell as JSON text, braces and all, because a spreadsheet cell holds one value. The data is not lost, but it is not split into columns either. Flatten nested fields beforehand if you need them as columns.
Can I open the result in Excel?
Yes. Download the CSV and open it, or use the import option in your spreadsheet program and choose comma as the separator. Field names become the header row, so your columns arrive already labelled and ready to filter.
How to use JSON to CSV Converter
- Paste a JSON array of objects.
- Click Run.
- Copy or download the CSV result.
Limitations
Input must be a JSON array of flat objects; nested objects and arrays are written as JSON text in their cell.