JSON to CSV
Convert JSON arrays to CSV. Free, no signup, runs in your browser.
How It Works
Paste a JSON array of objects. Click Convert and the keys become CSV headers, with each object as a row. Values containing commas or quotes are properly escaped.
Why Convert JSON to CSV?
CSV is the universal format for spreadsheets and data tools like Excel, Google Sheets, and database import utilities. Converting JSON API responses or data exports to CSV makes them easy to analyze, sort, and filter in familiar tools.
How the Conversion Maps Fields
The keys of the first object define the column order, so each object should share the same keys for clean, aligned rows. Given this JSON:
| JSON input | CSV output |
|---|---|
| [{"name":"Alice","age":30}, | name,age |
| {"name":"Bob","age":25}] | Alice,30 Bob,25 |
Values containing a comma, quote, or line break are automatically quoted and escaped so columns stay intact when the file is opened in a spreadsheet.
Frequently Asked Questions
How do I convert JSON to CSV?
Paste a JSON array of objects into the input box and click Convert. The keys of the first object become the CSV header row, and every object becomes a data row. Click Copy CSV to copy the result, then paste it into a spreadsheet or save it as a .csv file.
What JSON format does the converter need?
It expects a non-empty JSON array of objects, for example [{"name":"Alice","age":30},{"name":"Bob","age":25}]. A single object, a plain value, or an empty array will not convert, and you will see an error asking for a non-empty array of objects.
How are commas and quotes handled in CSV output?
Any value that contains a comma, a double quote, or a line break is wrapped in double quotes, and embedded double quotes are doubled. This follows standard CSV escaping so the file opens correctly in Excel, Google Sheets, and other tools without breaking columns.
Can I open the CSV in Excel or Google Sheets?
Yes. Copy the CSV output, paste it into a spreadsheet, or save it in a text file with a .csv extension and open that. The comma-separated format is read natively by Excel, Google Sheets, Numbers, and database import tools.
Is my JSON data uploaded anywhere?
No. The conversion runs entirely in your browser with JavaScript. Your JSON is never sent to a server, so you can safely convert private or sensitive data.