Convert JSON to CSV
Turn a JSON list of records into a CSV you can open in Excel, Sheets or a database tool. Nested data becomes columns. Your data is converted in your browser and never uploaded.
- No watermark or limits
- Client-side only
- Nested values become columns
- Formula guard option
- Runs on your device. Files are never uploaded.
- Free and unlimited. No sign-up, no watermark.
JSON to CSV in three steps
No account, no email, no waiting for an upload.
- STEP 01
Start with your JSON
Use a list of objects, or an object that wraps a single list.
- STEP 02
Set the output options
Choose how to treat nested values, the CSV separator, and whether to guard against spreadsheet formulas.
- STEP 03
Copy or download the CSV
The note shows how many rows were written.
What JSON to CSV does, and what it doesn't
We'd rather tell you up front than surprise you after the download.
What you get
- Columns from all recordsThe header is the combined set of keys across every record, so a field that appears in only some of them still gets a column.
- Three ways to treat nestingFlatten everything into columns like address.city and tags.0, flatten objects but keep lists as JSON text, or keep nested values as JSON text.
- Separator choiceWrite with commas, semicolons or pipes, for regional spreadsheet settings or tools that expect them.
- Formula guardOptionally escape cells that start with =, +, - or @, which spreadsheets might treat as formulas.
- Proper quotingValues with separators, quotes or line breaks are quoted, with inner quotes doubled, as RFC 4180 describes.
Good to know
- Wide, sparse dataRecords with very different shapes produce many mostly-empty columns. Convert one record type at a time.
- Line breaks are LFRows end with a line feed rather than CRLF. If a tool wants CRLF, run the file through the CSV formatter.
- Big integersNumbers beyond 2^53 are read by the browser and may lose precision before conversion.
Your data never leave your device
The tool runs inside your browser instead of on our servers, so there is nothing to upload, store or delete afterwards.
Typical online tool upload
Your file travels over the internet, sits on someone else's computer for a while, and you wait for the upload and the download.
Mediaextractr no upload
The tool loads into your browser once, then works on your file locally. Nothing is sent, so nothing can leak.
When people use JSON to CSV
Analyze an API export in a spreadsheet
Open the result in Excel or Google Sheets for filtering and pivots.
Load records into a database
Use CSV for a bulk import, or go straight to JSON to SQL INSERT.
Share data with colleagues
Give non-developers a file they can open.
Check data quickly
See a table of values rather than nested braces.
Mediaextractr vs typical upload tools
| MediaextractrPrivate | Typical upload tools | |
|---|---|---|
| Your file is uploaded | Never | Yes |
| Sign-up needed | No | Often, after a few files |
| Daily file limit | None | Often 1–2 free files |
| Watermark | Never | Sometimes |
| Wait for upload & download | No | Yes |
| Speed on very large files | Depends on your device | Depends on their servers |
How JSON becomes rows and columns
Each object in the list becomes one row. Each key becomes a column. For nested objects, the default is to join the key names with a dot, so {"address": {"city": "Pune"}} gives an address.city column. List entries get a position, such as tags.0 and tags.1.
If your JSON is a single object with one list inside, the tool uses that list automatically and tells you which key it used.
Avoiding common surprises
Spreadsheets can change data on open, so a little care helps:
- Long numeric IDs and leading zeros can be altered by Excel. Import the file as text instead of double-clicking it.
- Turn on the formula guard if the data comes from users and the file will be opened in a spreadsheet.
- Use semicolons if your spreadsheet uses a comma as the decimal mark.
- Go the other way with CSV to JSON.
From API data to a spreadsheet
A typical flow is to copy a JSON response from your browser's network tab, convert it here, and open the CSV in a spreadsheet for sorting and pivot tables. If the response wraps its records in an object with one list, such as a data or results key, the tool finds that list for you and tells you which key it used.
Questions, answered
How do I convert JSON to CSV?
Paste a JSON list of records, pick your options and copy or download the CSV.
How does it handle nested JSON?
By default nested keys become dotted column names, such as address.city. You can also keep nested values as JSON text.
Is customer data in my JSON uploaded during conversion?
No. The conversion to CSV happens in this browser tab and nothing is transmitted, so exports with personal details stay on your device.
What does the formula guard do?
It escapes cells that begin with =, +, - or @, so a spreadsheet shows them as text instead of evaluating them as formulas.
Can I get semicolon-separated output?
Yes. Choose the semicolon as the CSV separator.
Can I convert on Android or iPhone?
Yes. It works in the current mobile browsers, and the CSV can be saved to Files or Drive.