JSON to CSV Converter
Convert JSON to CSV online, free and instantly. Runs entirely in your browser — nothing is uploaded, and there is no file size limit.
Input
Output
Ready
Drop a file to load it
About this tool
Convert JSON into CSV in a single step. JSON is the default interchange format for web APIs; CSV is the lowest common denominator for spreadsheets and data exports. The converter is structure-aware rather than a text substitution, so nested data is flattened predictably.
When you would use it
- Opening JSON data in Excel, Numbers or Google Sheets
- Migrating a dataset from JSON to CSV
- Inspecting JSON in a shape that is easier to read
Worked example
{
"id": 4815,
"name": "Ada Lovelace",
"active": true,
"score": 91.5,
"roles": ["admin", "editor"],
"address": { "city": "London", "postcode": "NW1" }
}
id,name,active,score,roles[0],roles[1],address.city,address.postcode 4815,Ada Lovelace,true,91.5,admin,editor,London,NW1
Things worth knowing
- CSV is flat, so nested objects and arrays are flattened into dot-notation columns such as
address.cityandroles[0]. - The header row is the union of every key across all rows, so records with different shapes still line up.
- Fields containing a comma, quote or newline are quoted and interior quotes are doubled, per RFC 4180.
Questions
Frequently asked
Is JSON to CSV conversion lossless?
Not entirely. CSV is flat, so nested structures are flattened into dot-notation columns. The data survives and can be rebuilt, but the shape is expressed in the column names rather than the structure.
Why convert JSON to CSV?
JSON is the default interchange format for web APIs, while CSV is the lowest common denominator for spreadsheets and data exports. Converting is usually about handing data to a tool that only speaks one of them — a spreadsheet, for instance.
Is my data uploaded anywhere?
No. Every tool on JSONWorks runs entirely in your browser using JavaScript. Your input is never sent to a server, never logged and never stored. The simplest proof is to disconnect from the internet — the tools keep working. The site does load Google Fonts and a Google Analytics page-view tag, so you will see those two requests in your network tab, but neither receives anything you type or paste.
Related