JSON to Excel

Why convert JSON to Excel

API responses and app exports come as JSON, but people read data in spreadsheets. Converting gives an Excel sheet with one row per record and one column per field, nested fields flattened into dotted column names, ready to filter, sort and chart.

JSON is the data format of web APIs and apps, here a list of records; Excel is an Excel workbook (XLSX, XLS, or OpenDocument ODS), with sheets, formats and formulas.

What to expect

• The JSON must be a list of records (or an object holding one); nested objects become dotted columns such as address.city, and lists are kept as JSON text.
• Numbers follow the file's own convention: in semicolon files 1.250,50 becomes the number 1250.5, in comma files 1,250.50 does. Codes with a leading zero (postcodes, phone numbers) stay text.

Your data stays on your device

Spreadsheets often hold customer lists, salaries or financial records. Here the conversion runs in your browser and nothing is uploaded; you can convert up to five files at once.

The file is read in a Web Worker by SheetJS Community Edition, an open-source spreadsheet library that reads XLSX, XLS, ODS, CSV and JSON. It builds a workbook in memory and writes it out as Excel: an Office Open XML workbook with one sheet per source sheet, compressed. Results appear on the page and can be downloaded.