Convert JSON to CSV online, with nested fields flattened into columns for Excel and Sheets. Upload files up to 20GB and download the converted result in a few clicks.
Convert CSV to JSONDrag & Drop your JSON file here
JSON files, up to 20GB
Files stay private.
Automatically deleted after 24 hours.
Link
20GB upload limit.
4.8/5
Trusted for 1,827,796+ conversions
HOW IT WORKS
Three steps, no account, nothing to install.
01
Add your JSON
Drag and drop or upload a .json file: an array of objects, an API response, a Firebase export or JSON Lines. UTF-8 and UTF-16 files both work.
02
Convert to CSV
Keep CSV as the output format and start the conversion. The list of records is found up to 3 levels deep, and every key found becomes a column.
03
Download the CSV
Download a comma-separated UTF-8 CSV. When the file holds a second large list of records, you get numbered CSVs in a ZIP.
JSON
JSON is a structured text format built from objects, arrays, strings, numbers, and other simple values. It is commonly used for APIs, application data, automation, configuration, and machine-readable exports. Records are often nested several levels deep, which a flat table cannot show directly.
CSV
CSV is a plain-text tabular format in which values are separated by commas or another delimiter. It is simple, portable, and widely used to move structured rows and columns between spreadsheets, databases, CRMs, and analytics tools. It opens in Excel, Google Sheets and LibreOffice Calc.
FILE FORMATS
SOURCE
JavaScript Object Notation, standardized as RFC 8259, is how web APIs, config files and NoSQL databases exchange data. It is plain text with named keys, strings, numbers, booleans, arrays and nested objects. Every programming language reads it, and tools like MongoDB, Postman and JavaScript apps expect it.
TARGET
Comma-separated values is the simplest way to move a table between programs. Each line is a row, and quotes protect values that contain commas or line breaks. CSV has no formulas, formatting or multiple sheets, which is exactly why databases, CRMs, accounting tools and data scripts all import it.
| Feature | JSON | CSV |
|---|---|---|
| Developed by | Douglas Crockford (RFC 8259) | No owner (RFC 4180) |
| File extension | .json | .csv |
| Editable | Yes (text) | Yes (text) |
| Layout | Nested objects and arrays | Rows of values |
| Best for | APIs, apps and databases | Importing data into other systems |
| Opens in | Code editors, browsers, APIs | Spreadsheets, databases, code |
USE CASES
Practical workflows where JSON to CSV conversion is useful.
Open an API response in a spreadsheet
A response shaped like {"data": {"results": [...]}} gives one row per result, with fields such as status or page repeated as columns.
Flatten nested customer records
Nested objects such as customer.address.city become their own columns, so every field lands in a cell you can filter.
List the line items of orders or invoices
An order or invoice with line items gives one row per item, with the order number, customer and total repeated on every row.
Export a Firebase database backup
Records keyed by id, as in a Firebase Realtime Database export, become one row each with the id in a first column named key.
Analyze JSON Lines logs
Application logs in JSON Lines (NDJSON), saved or renamed as .json, give one row per event, ready to filter in Excel or a pivot table.
Review GeoJSON attributes
A GeoJSON file saved or renamed as .json gives one row per feature, with each property in its own column and the coordinates kept as JSON text in one cell.
Import contacts into a CRM
Export contacts from a web app as JSON and convert them to CSV for the bulk import in a CRM, a newsletter service or an accounting system.
Keep long IDs and prices exact
Numbers are copied exactly as written, so 20-digit order IDs stay intact and a price of 1.10 keeps its trailing zero.
Hand data to spreadsheet users
Developers turn a JSON export into a CSV that colleagues can open in Excel, Google Sheets or LibreOffice without writing code.
Load JSON data into a SQL database
Most database import tools read CSV. Convert the JSON first, then load the rows with COPY, LOAD DATA or a database GUI.
SUPPORTED FILES
JSON arrays, API responses and JSON Lines are supported.
One row per object.
The main list of records, up to 3 levels deep, becomes the rows.
One record per line.
Become parent.child columns.
Large ones get their own CSV, delivered together.
TROUBLESHOOTING
JSON is nested and CSV is flat, which explains most surprises.
01
Lists inside a record stay in one cell as JSON text instead of becoming extra rows.
02
A second list of records longer than 1,000 characters gets its own CSV.
03
The message gives the error position. Comments and trailing commas count as invalid.
04
The whole file is loaded into memory, so JSON of several hundred MB can fail.
05
Records missing a key, and null values, give empty cells.
06
The CSV keeps them; Excel removes them on opening. Import the column as Text.
Excel, Google Sheets and a few lines of Python can do this conversion if you have them set up. dragdropdo converts JSON to CSV in the browser, with nothing to configure.
| What matters | dragdropdo | Spreadsheet Apps and Scripts |
|---|---|---|
| Nothing to install | ✓Yes. Runs in any modern browser. | ~Spreadsheet apps or a Python setup. |
| Works on phones and tablets | ✓Yes. Desktop, Android, iPhone and iPad. | ~Spreadsheet apps work on phones; scripts don't. |
| Batch conversion | ✓Yes. Add many files and download one ZIP. | ~Scripts can; spreadsheet apps go one file at a time. |
| Share finished files | ✓Yes. Send a unique link from the result page. | ~You upload and share the files yourself. |
| Pricing | ✓Free with daily limits. $2.99 or $6.99 passes for unlimited use, no monthly plan. | ~Free (Google Sheets, LibreOffice, Python) to subscription (Excel). |
| Choosing the output layout | ✓Not in the converter. The layout is fixed. | ~Yes, with export options or code. |
Other tools use different pricing, limits and workflows. This comparison describes dragdropdo's own features without assuming every other tool works the same way.
1.8M+
Files converted
and counting
4.8
Average rating
from our users
~4s
Avg. conversion
per file
0
Files kept
Auto-delete in 24h
WHY DRAGDROPDO
Convert JSON to CSV in your browser, with nothing to install and nothing kept after 24 hours.
Private by default
Files are encrypted in transit and deleted from our servers automatically after 24 hours.
No install required
Convert in any modern browser on Windows, Mac, Linux, Android, iPhone or iPad. No app and no sign-up wall.
Big files and batches
Upload files up to 20GB each, add several at once, and download the results one by one or as a ZIP.
Share & download
Save finished files to your device or pass them on with a share link from the result page.
MORE JSON TOOLS
JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. Widely used in web applications for data exchange, JSON supports a text format that is completely language-independent, making it a preferred choice for APIs and configuration files.
Explore all tools
FAQ
Answers to common questions about dragdropdo's JSON to CSV converter.
