Convert a JSON array to CSV for Excel or Google Sheets, flattening nested objects.
Nested fields become dotted column names (address.city) and simple arrays are joined, so the result opens cleanly in any spreadsheet.
[{"name":"Ana","address":{"city":"Perth"}}] becomes a CSV with the columns name,address.city and the row Ana,Perth.
Excel sometimes assumes a legacy encoding. Import the file through Data › From Text/CSV and choose UTF-8.
Arrays of plain values are joined into one cell, separated by semicolons. Arrays of objects become numbered columns such as items[0].name and items[1].name.