JSON to CSV Convert
Turn an array of JSON objects into a spreadsheet-ready CSV file.
JSON to CSV is a free online tool that turn an array of JSON objects into a spreadsheet-ready CSV file. It runs entirely in your web browser using plain JavaScript, so files are processed on your own device and never uploaded to a server. There is no sign-up, no file size limit imposed by the site, no watermark and no paid tier.
- Price
- Free — no account, no quota, no watermark
- Category
- Convert
- Where it runs
- In your browser, on your device
- Files uploaded
- None
- Technology
- plain JavaScript
- Settings
- 3
- Works offline
- Yes, after the first visit
About JSON to CSV
JSON to CSV is one of 18 convert tools on DuckyTools, and like all of them it runs entirely inside this page. Turn an array of JSON objects into a spreadsheet-ready CSV file.
How to use it
- Paste the text you want to run through json to csv.
- Set delimiter, include header row and flatten nested objects.
The 3 settings
| Setting | What it does | Default |
|---|---|---|
| Delimiter | Choose from 4: Comma (.csv), Semicolon, Tab (.tsv), Pipe. | Comma (.csv) |
| Include header row | On or off. On by default. | On |
| Flatten nested objects | On or off. On by default. | On |
Under the hood
| Runs on | plain JavaScript — runs the whole thing |
| Controls | Delimiter, Include header row, Flatten nested objects |
Questions
What happens to nested objects?
With flattening on, they become dot-notated columns: `address.city` and so on. With it off, the nested object is written into a single cell as JSON. Arrays are always written as JSON, since they have no fixed width.
Will this open correctly in Excel?
Usually. If your regional settings use the comma as a decimal separator, choose the semicolon delimiter instead — otherwise Excel puts every row in one column.
What does the delimiter option change?
It offers 4 choices — Comma (.csv), Semicolon, Tab (.tsv) and Pipe. The default is Comma (.csv), which suits most cases; change it when your input or your destination calls for something specific.