JSON to CSV Converter
Turn JSON arrays into clean CSV — nested objects flattened, special characters escaped per RFC 4180.
Advertisement
How it works
Paste a JSON array of objects (a single object is wrapped automatically). Nested objects are flattened with dot notation — {"address": {"city": "Berlin"}} becomes a column called address.city — and every column is detected across all rows, so ragged data still lines up.
RFC 4180 escaping
Any field containing a comma, quote, or line break is wrapped in double quotes with inner quotes doubled (" → ""). The result opens cleanly in Excel, Google Sheets, and LibreOffice Calc.
FAQ
How are nested JSON objects handled?
Nested objects are flattened with dot notation: {"address": {"city": "Berlin"}} becomes a column named address.city. Arrays of primitives become semicolon-joined values; arrays of objects are kept as JSON text.
Does the CSV follow RFC 4180?
Yes. Fields containing commas, double quotes, or line breaks are wrapped in double quotes, and inner quotes are doubled — so the output opens correctly in Excel, Google Sheets, and LibreOffice.
Can I choose which columns to export?
Yes. After converting, every detected column appears as a checkbox. Uncheck columns you don't need and convert again — or just download the full CSV and delete columns in your spreadsheet.
Is my JSON data uploaded anywhere?
No. Conversion happens entirely in your browser with JavaScript. Your data never leaves your device.
Advertisement