CalcBrew

Data & Spreadsheets

Excel to JSON

Content managed in a spreadsheet — product lists, translations, config tables — becomes JSON your app can load. Pick the sheet and the row that holds the keys.

Runs in your browser — files never leave your device.

Drop Excel (XLSX), Excel 97–2003 (XLS), ODS files here

or click to browse · paste from clipboard · up to 100 MB each

Select files
Options
Share:

Why convert Excel (XLSX) to JSON

Spreadsheets are the interface non-developers are comfortable with; JSON is what code consumes. A direct conversion with proper types (numbers, booleans, ISO dates) removes a whole class of parsing bugs.

Each sheet can be exported separately or all sheets as one object keyed by sheet name. Empty rows are skipped and merged cells are filled.

How it works

  1. Drop Excel (XLSX), Excel 97–2003 (XLS), ODS files onto the box above, click it to browse, or paste from the clipboard.
  2. Adjust the options if you need to — the defaults suit most cases.
  3. Press Convert. The work happens on your device, so speed depends on your computer or phone.
  4. Download the JSON — individually or all at once.

About the formats

Excel (XLSX) · Microsoft Excel workbook · .xlsx

The current Excel format: multiple sheets, formulas, formatting, charts and pivot tables in one file.

  • XLSX stores both the formula and its last computed value, so a converted CSV contains the values.
  • Maximum 1,048,576 rows and 16,384 columns per sheet.
  • XLSM is the same format with macros enabled.

Excel 97–2003 (XLS) · Legacy Microsoft Excel workbook · .xls

The binary Excel format used until 2007, limited to 65,536 rows and increasingly refused by web apps.

  • XLS supports 65,536 rows and 256 columns per sheet — larger data is silently cut off.
  • Many banks and legacy systems still export XLS.
  • Excel opens XLS in Compatibility Mode and recommends saving as XLSX.

ODS · OpenDocument spreadsheet · .ods

The LibreOffice Calc spreadsheet format, an open ISO standard that Excel and Google Sheets can also open.

  • ODS supports formulas, multiple sheets and charts like XLSX.
  • Some Excel-specific functions and pivot features do not round-trip through ODS.
  • ODS files are ZIP archives of XML, like ODT.

JSON · JavaScript Object Notation · .json

The data format of web APIs: nested objects and arrays in plain text, readable by every programming language.

  • JSON supports nesting; converting it to a flat table (CSV, Excel) requires flattening nested keys such as address.city.
  • JSON has no comments and requires double quotes around keys and strings.
  • A JSON array of objects maps naturally to a spreadsheet: one object per row, keys as column headers.

Related conversions

JSON to ExcelOn-deviceJSON arrays into a formatted Excel workbook.Excel to CSVPopularOn-deviceExcel sheets to CSV with chosen delimiter and encoding.CSV to JSONOn-deviceCSV rows into a JSON array of objects.ODS to ExcelOn-deviceLibreOffice Calc ODS to Excel XLSX.Excel to ODSOn-deviceExcel workbooks to open-standard ODS.XLS to XLSXOn-deviceLegacy XLS to modern XLSX.

More in Data & Spreadsheets · All converters

Frequently asked questions