Convert JSON to CSV
Need to open API data in Excel or Google Sheets? This converter takes an array of JSON objects, uses the keys as the header row, and writes each object as a comma-separated line, escaping any values that contain commas or quotes.
Example · JSON → CSV
JSON input
[
{ "id": 1, "name": "Ada", "role": "engineer" },
{ "id": 2, "name": "Linus", "role": "maintainer" }
]CSV output
id,name,role 1,Ada,engineer 2,Linus,maintainer
Try it with your own data
Output
Output will appear here…Frequently Asked Questions
What format should my CSV be in?
The first line of your CSV must be a header row containing column names. Subsequent lines should contain the data separated by commas.
Is my data safe?
Yes, all conversion happens directly in your browser. We don't store or transmit any of your data to our servers.
How to convert JSON to CSV
- Paste a JSON array of objects.
- The keys of the first object become the CSV header.
- Each object is written as a row; values with commas are quoted automatically.
Frequently asked questions
What if objects have different keys?
The header is taken from the first object. For predictable output, make sure every object shares the same set of keys.
Are commas inside values handled?
Yes. Any value containing a comma, quote, or newline is wrapped in quotes and internal quotes are doubled, per the CSV convention.
Related converters