JSON to CSV for Excel — Import JSON Data to Spreadsheets
Quick Answer: Paste a JSON array of objects to convert it to CSV that Excel can open directly. Nested objects are flattened using dot notation (address.city becomes a column header). The output includes a header row from the JSON keys.
Output will appear here...
FAQ
How do I open JSON in Excel?
Convert JSON to CSV here, then open the .csv file in Excel. Excel 2019+ also has Get Data > From JSON, but CSV import is more reliable for flat data.
How are nested JSON objects handled?
Nested objects are flattened: {address: {city: "NYC"}} becomes a column "address.city". Arrays are joined as comma-separated strings or expanded into multiple columns.