Convert a JSON array into CSV you can open in Excel or Google Sheets.
Every object becomes a row and every key becomes a column. Keys are collected from all objects, so a field that appears in only some rows still gets a column, left empty where it's missing. Nested objects are flattened into dotted column names, so { "address": { "city": "Pune" } } becomes a column called address.city. Arrays are kept in their JSON form inside a single cell.
Every value is wrapped in quotes and any quotes inside are doubled, which keeps commas and line breaks in your data from breaking the columns.
The downloaded file includes a small marker (a byte-order mark) that tells Excel it's UTF-8, so accented letters, rupee signs and other non-English text display correctly instead of turning into odd symbols. Google Sheets and LibreOffice open it directly too.
An array of objects, like [{"id":1},{"id":2}], or a single object, which becomes one row.
Nested objects become dotted column names such as user.name. Arrays are stored as JSON text in one cell.
The JSON is probably invalid. Check it with our JSON Formatter, which shows where parsing failed.
No. The conversion runs in your browser.
OneClickly is a set of 119 free tools for PDFs, images, text, everyday math and code. They run in your browser, so the files and text you work with stay on your device.