JSON to CSV converter
Your JSON goes in and a CSV comes out. JSON is how apps and websites pass data around. Worth knowing: a CSV will not open in a browser tab, so it is a file for software rather than for the web. Your file never leaves your computer.
Need the other direction? Convert CSV to JSON
How to convert JSON to CSV
- 1 Drop your JSON .json file onto the page, or click to browse for it.
- 2 Check the options. Nothing is thrown away on the way to CSV, so there is no quality dial to set.
- 3 Convert. The work happens on your own machine, so how long it takes depends on your computer and the file.
- 4 Download the CSV, or add more files and do the whole set in one go.
Why convert JSON to CSV
- Opens in every spreadsheet, database and statistics package.
- Streams row by row, so files far larger than memory can be processed.
- Moving tabular data between spreadsheets and analytics tools.
- JSON: no comments, so configuration files cannot be annotated.
JSON compared with CSV
How the two formats differ on the things that decide whether a conversion is worth making.
| Property | JSON | CSV |
|---|---|---|
| File extension | .json | .csv |
| Colour depth | UTF-8 text, six value types, no comments or trailing commas | Delimited text, RFC 4180 quoting, encoding not declared in-file |
| Browser support | Every browser | No browser support |
| Introduced | 2001 | 1972 |
| Developed by | Douglas Crockford | IBM Fortran conventions, later RFC 4180 |
Quality and what changes
Both sides are lossless, so every pixel survives the trip intact and converting back returns the same image. What changes is the size and what the file can carry: CSV stores the data without compression, so expect a much larger file.
- Browsers will not display a CSV, so it downloads rather than opening in a tab.
- One CSV limitation to keep in mind: no type information, so identifiers and dates get mangled by spreadsheets.
Questions about JSON to CSV
Can I open a CSV in a browser?
No. No mainstream browser renders CSV natively, so it will download rather than display. That is fine when the file is heading into desktop software or an archive, and a problem if it is going on a web page.
Is my JSON file uploaded anywhere?
No. The whole thing runs inside the browser tab you already have open. Your JSON is read straight from your own disk, converted on your machine and handed back as a CSV. Nothing is sent anywhere, nothing is stored and there is no account.
Is there a file size limit?
There is no server-side limit because no server sees the file. The real ceiling is your device memory, since the input and the output both have to fit in the tab. A few hundred megabytes is usually fine on a desktop machine and considerably less on a phone.
Can I convert several JSON files at once?
Yes. Add as many as you like and they are processed one after another, then offered as separate CSV downloads or as a single ZIP. Speed depends on your own processor rather than on a queue.
Does the converter work offline?
Yes, after the page has loaded once. The engine is cached by the browser, so you can disconnect, reload and keep converting. That falls out of doing the work locally rather than being a separate mode you switch on.