Open JSON data in Excel
Apps and APIs export data as JSON, which is hard to read and won't open neatly in a spreadsheet. Converting it to CSV turns each record into a row and each field into a column.
JSON to CSV runs in your browser, so exported data, which may include customer or account details, is not uploaded.
The output is CSV, not a native .xlsx workbook; Excel can import it and then save it as .xlsx. For example, a record with an address.city field becomes a column named address.city, while arrays are kept as JSON text in one cell. Null values become empty cells. Large exports can produce wide spreadsheets; hide or delete unneeded columns after importing. Import identifier columns as Text to preserve leading zeros, and review untrusted exports carefully before opening them in a spreadsheet. Store and share the CSV with the same care as the original export, especially if it contains customer or account details.
Step by step
- Save the JSON export as a .json file.
- Open JSON to CSV and add the file.
- Convert and download the CSV.
- In Excel, use Data, From Text/CSV, choose UTF-8 and set identifier columns to Text; check the headings and save as .xlsx if needed.
Tips
- JSON should be a list of records for the cleanest result.
- Nested fields become separate columns, so wide data can have many columns.
- Need to send the edited data back to an app? Convert it with CSV to JSON.
Questions
- What happens to nested objects?
- They are flattened into columns so each record fits on one row.
- Why do accents look wrong in Excel?
- Some Excel versions guess the wrong text encoding for CSV; importing through Excel's Data menu usually fixes it.
- Is my data uploaded?
- No. Conversion happens in your browser.