JSON to CSV Converter
Open API responses and JSON exports in Excel or Google Sheets: each object becomes a row and each key a column, with nested objects flattened into columns like address.city.
Runs in your browser
How to use
- Paste a JSON array (or a single object).
- Choose the delimiter.
- Copy the CSV or paste it into a spreadsheet.
How it works
Columns are the union of all keys across objects, in order of first appearance, so objects with missing fields still line up. Nested objects are flattened with dotted names; arrays are written as JSON text in one cell. Fields containing the delimiter, quotes or line breaks are quoted according to RFC 4180.
Use the semicolon delimiter for Excel in locales that use a decimal comma (France, Germany, Morocco…).
Examples
- API export
- [{"id":1,"address":{"city":"Paris"}}] → id,address.city / 1,Paris
Common uses
- Analysing API data in spreadsheets
- Sharing data with non-developers
- Reporting
Privacy & security
This tool runs entirely in your browser. Your files and text are never uploaded to our servers — processing happens on your device and results are created locally. How each tool handles files
Frequently asked questions
What happens with arrays inside objects?
They're written as JSON text in a single cell.
Can I get an .xlsx file?
Convert here, then use CSV to Excel.
Last updated: