Nested objects become columns
[{ "id": 1, "user": { "name": "Ann", "city": "Oslo" } }]id,user.name,user.city
1,Ann,OsloOpen API responses and JSON exports in a spreadsheet. Paste a JSON array and get a CSV with one column per field — nested objects flattened into columns like address.city, and every value escaped so it opens correctly in Excel, Numbers or Google Sheets.
[{ "id": 1, "user": { "name": "Ann", "city": "Oslo" } }]id,user.name,user.city
1,Ann,OsloEvery key that appears in any object becomes a column; missing values are left empty.
[{ "a": 1 }, { "b": 2 }]a,b
1,
,2Excel sometimes misreads UTF-8 files, turning “é” into “é”. The Excel-friendly option adds an invisible byte-order mark that tells Excel the file is UTF-8. In regions where Excel expects semicolons, choose the semicolon delimiter so columns split correctly.
Values that start with =, +, - or @ can be treated as formulas by spreadsheet apps. If the data comes from untrusted sources, turn on formula protection: such values get a leading apostrophe so they are always shown as text.
No. The conversion runs in your browser and nothing is sent to a server.
An array of objects (the most common), an array of arrays, a single object (one row), or an object with one property that holds the array, such as {"items": [...]}.
Arrays and objects that can’t be flattened into columns are written into the cell as JSON text, for example ["a","b"], so no information is lost.
That happens when formula protection is on and the value starts with =, +, - or @. Turn the option off if your data is trusted and you need the exact text.
Everything you need. One simple place.
Free, fast online tools for text, PDFs, images, data and everyday maths. Every tool runs entirely in your browser, so your files stay on your device.
© 2026 Toolora. All rights reserved.
Built for speed and privacy