What the JSON to CSV converter does
A live two-pane converter: paste a JSON array of objects on the left and a clean CSV table appears on the right, ready to drop into Excel, Google Sheets, or Numbers. It reads the keys from your objects, builds the header row, and lines up every record underneath, updating as you type with no Convert button anywhere. If your data has uneven fields, it gathers every key it finds so no column gets dropped. Invalid input is caught inline, with an error message pointing at the syntax problem instead of silently failing. A Load example button fills in sample JSON, Clear wipes both panes, and the output has Copy and Download buttons. Handy for developers exporting API responses, analysts turning a data dump into a sheet, or anyone who got handed a JSON file and just wants rows and columns.
How to use it
- Paste or type your JSON into the input pane on the left, or press Load example to drop in sample data. It accepts an array like
[{"name":"Ada","age":36}], or a single object, which becomes one row. - The CSV appears instantly in the output pane on the right as you type. There is no button to press.
- If the JSON has a syntax error, an “Invalid JSON” message shows the position or line of the problem. Fix that spot and the CSV comes right back.
- Click Copy to grab the result, or Download to save it as a
.csvfile. Clear empties both panes when you want to start over.
How it handles tricky data
Values that contain commas, quotes, or line breaks are automatically wrapped in quotes and escaped the proper CSV way, so nothing breaks when you open the file. Nested objects and arrays are kept as JSON text inside the cell rather than being silently lost. The column order follows the keys as they first appear in your data.
Why convert here
It runs entirely in your browser. Your JSON never gets uploaded, which matters when the data is from a private API or contains anything sensitive. It is free, needs no sign-up, and works the moment the page loads on phone, tablet, or desktop. Because the conversion happens on your machine, there is no waiting on a server round trip.
Tip: if your objects share the same shape, you get the tidiest CSV. For converting a folder full of JSON files in one go, the BulkPro desktop app from the same team handles batch jobs. This page is built for a quick paste and copy.
Frequently asked questions
- How do I convert a JSON array to CSV?
- Paste your JSON array of objects into the input box on the left, for example [{"name":"Ada","age":36}], or hit Load example to drop in sample data. The CSV appears instantly in the Output pane on the right. Use Copy to grab it and paste into Excel or Google Sheets, or Download to save it as a .csv file.
- What if my JSON has a mistake in it?
- The tool validates as you type. If the input is not valid JSON, an error message appears instead of the CSV, pointing at the position or line of the syntax error, so you can fix that one spot and watch the CSV reappear. Nothing is uploaded during validation; it all runs in your browser.
- Can I load sample data or clear everything quickly?
- Yes. Load example fills the input with a small JSON array so you can see the CSV format straight away, and Clear empties both panes so you can start fresh. Copy and Download act on the CSV in the output pane.
- What happens to values with commas, quotes, or line breaks?
- They are handled correctly. Any value containing a comma, quote, or newline is wrapped in double quotes and its inner quotes are doubled, following standard CSV rules, so your file opens cleanly in a spreadsheet.
- How are nested objects or arrays converted?
- Nested objects and arrays are written as JSON text inside that cell rather than being dropped. The header row is built from every key found across your objects, so uneven records still keep all their columns.
- Is my JSON uploaded anywhere?
- No. The conversion runs entirely in your browser using JavaScript. Your JSON never leaves your device, which makes it safe for private API responses or sensitive data. It is also free with no sign-up.
Related converters
Last updated: June 15, 2026