Skip to content
Expensico

Excel to JSON Converter

Convert XLSX, XLS or ODS spreadsheets to JSON, with each sheet as an array of objects keyed by column headers. Private, in-browser conversion.

Runs in your browser. Your files are processed on your device and are never uploaded.

How to use the Excel to JSON Converter

  1. Choose or drop your Excel file.
  2. Adjust the options if needed — the defaults work well for most files.
  3. Select Convert. Conversion happens instantly in your browser.
  4. Preview the result and download your JSON file.

About this Excel to JSON converter

Spreadsheets are where data is maintained; JSON is what applications consume. This converter bridges the two with typed numbers and booleans and every sheet in the workbook.

How Excel to JSON conversion works

  1. The workbook is parsed locally with SheetJS.
  2. The header row provides keys; empty cells become null so every object has the same shape.
  3. Numbers and booleans keep their types; dates are output as ISO strings (YYYY-MM-DD).

Conversion quality: Exact. Each sheet becomes an array of row objects keyed by the header row.

When to convert Excel to JSON

  • Seeding a database or CMS from a spreadsheet
  • Turning a content sheet maintained by non-developers into app data

Limitations to be aware of

  • Merged cells are read from their top-left cell only.
  • Formulas are exported as their calculated values.

Excel vs JSON

Excel (XLSX). XLSX is the default Microsoft Excel workbook format since Excel 2007. It can hold multiple sheets, formulas, formatting and charts.

JSON. JSON (JavaScript Object Notation) is the most common format for exchanging structured data between web services. It supports nested objects and arrays, strings, numbers, booleans and null.

This converter also accepts Excel 97–2003, OpenDocument Spreadsheet files as input.

Frequently asked questions

How are dates handled?

Cells formatted as dates are exported as ISO 8601 strings such as 2026-03-31, which every programming language can parse.

Are my files uploaded?

No. This tool reads and processes files directly in your web browser. Nothing is sent to Expensico's servers, and the data is discarded when you close or reload the page.