JSON to CSV Converter
Convert a JSON array into a CSV that opens straight in Excel, Numbers or Google Sheets. Runs entirely in your browser.
- Free, no watermark
- No account needed
- Nothing is uploaded
JSON CSV
Runs in your browserDrop your JSON files here
or
Google Drive import is not available yet. Choose a file from your device.
Accepts .json, .txt. Up to 100 MB per file, 20 files at a time.
Preparing
At a glance
- Accepts
.json .txt- Produces
- CSV
- Files at once
- Up to 20
- Size limit
- 100 MB per file
- Runs
- In your browser
How it works
How to convert JSON to CSV
-
Add your JSON files
Drag them onto the panel above, or press Choose Files. Accepts .json, .txt.
-
Press Convert to CSV
Your browser does the work. A progress bar tracks it, and nothing is uploaded at any point.
-
Download your CSV files
The result appears with its new size. Take the files one at a time or the whole set as a ZIP.
About this converter
From API output to spreadsheet
An API response or a database export is easy for code to read and awkward for a person to review. CSV opens in a spreadsheet, where filters and pivot tables live. Every key found across the objects becomes a column, so records with missing fields still line up under the right headings.
Nesting and quoting
Nested objects are flattened with dotted keys, so address.city becomes its own column. Arrays of values are joined with a semicolon inside a single cell. Anything containing a comma, a quote or a line break is quoted and escaped, which is what stops a spreadsheet from shifting half your data one column to the right.
JSON to CSV: common questions
What JSON shape does it expect?
An array of objects, which is what most exports and API responses return. A single object converts to a one row file, and an object wrapping an array under a key such as data or results is unwrapped automatically.
Will Excel open it correctly?
Yes. The file is written as UTF-8 with a byte order mark, which is what stops Excel from mangling accented characters and other non Latin text.
How are dates handled?
They are written exactly as they appear in the JSON, with no reformatting, so an ISO timestamp stays an ISO timestamp.
Is my data sent anywhere?
No. The conversion happens in your browser, so a payload containing personal data never leaves the machine.
Related tools
You may also need
Other converters that pair with JSON to CSV.