JSON to CSV
Turn a JSON array into a CSV you can open in Excel or Google Sheets.
Input
Waiting for input
Output
or press ⌘/Ctrl + EnterYour result appears here.
- Runs in your browser
- Nothing is uploaded
- Free, no sign-up
How to use it
- Paste a JSON array of objects, or an object that contains one.
- Choose the separator (comma for most tools, semicolon for Excel in many European locales).
- Run it and download the CSV or copy it.
Why Tool Dock
- FastEverything runs on your own device, so there is no queue and no waiting for uploads.
- PrivateYour files and text never leave the browser. Close the tab and they are gone.
- Batch friendlyDrop several files at once and download each result, or all of them together.
Questions
How are nested objects handled?
With flattening on, nested keys become dotted column names such as address.city, and array items become address.0, address.1. Turn it off to keep nested values as JSON text in one cell.
What if objects have different keys?
The column list is the union of every key, in the order first seen. Missing values are left empty.
Excel shows everything in one column. Why?
Your Excel expects a semicolon. Choose ';' as the separator, or use Excel's Data → From Text import and pick the comma.
Related tools
- CSV to JSONTurn CSV or TSV data into JSON objects, with the delimiter detected for you.
- JSON to TypeScriptTurn a JSON sample into TypeScript interfaces, nested types included.
- YAML to JSON ConverterConvert YAML to JSON and JSON to YAML, with the exact line of any error.
- Base64 DecodeTurn Base64 back into text, images or files, right in your browser.
- Base64 EncodeTurn text or any file into Base64, right in your browser.
- BIMI CheckerCheck whether your brand logo can show next to your emails: BIMI record, logo, certificate and DMARC.