Spreadsheet conversion tool

Excel to JSON Converter – Free Online Tool

Convert an Excel worksheet from an .xlsx or .xls workbook into a JSON array of records. Choose a sheet and process the workbook locally in your browser.

XLSX and XLS inputSelect a worksheetWorkbook stays on your device

Convert an Excel worksheet to JSON

The spreadsheet parser is loaded from this site only after you choose a file. Workbook bytes are read in this browser and are not uploaded for conversion.

The first worksheet is selected when a workbook is loaded. You can choose another sheet before converting.

The first non-empty worksheet row is used for property names. Blank cells become empty strings.

What this Excel to JSON converter does

This browser-based tool reads a selected worksheet and turns its header row and records into a JSON array of objects. It supports common Excel workbook files ending in .xlsx and .xls. Workbooks with multiple sheets can be converted one worksheet at a time.

How to convert Excel to JSON

  1. Choose an .xlsx or .xls workbook from your device.
  2. After the workbook loads, select the worksheet you want to convert.
  3. Select Convert worksheet to JSON to create an array of records.
  4. Review the result, then copy it or download converted-data.json.

Example structure

If the worksheet starts with the headings name, department, and active, each subsequent row becomes an object:

[
  {
    "name": "Ada Lovelace",
    "department": "Research",
    "active": true
  },
  {
    "name": "Grace Hopper",
    "department": "Engineering",
    "active": false
  }
]

Headers, values, and limitations

Common troubleshooting

Convert an Excel spreadsheet to a JSON array

A worksheet is a useful starting point when an API, web application, or test fixture expects records as JSON objects. This Excel to JSON converter uses the first non-empty worksheet row as property names and turns each later row into an object in an array. Clear, unique headings make the resulting JSON easier to use in code.

To convert XLSX to JSON or convert XLS to JSON, choose the workbook, select the worksheet, and review the output before copying or downloading it. Each worksheet is converted separately. The tool reads stored formula results when available; it does not recalculate formulas, refresh external connections, or preserve spreadsheet formatting. If you need to clean or validate the resulting JSON, continue with the JSON Formatter; for comma-separated source data, use CSV to JSON.

Workbook processing stays in your browser

No. The workbook is read and parsed locally in your browser; its contents are not uploaded to a backend conversion server. Page-level analytics may still load; see the Privacy Policy for site-wide data practices.

Library attribution: SheetJS Community Edition 0.20.3, licensed under Apache License 2.0. Read the third-party notice and license text.

Excel to JSON FAQs

Which Excel file types are supported?

This page accepts .xlsx and .xls workbooks. Macro-enabled .xlsm and binary .xlsb files are not listed as supported input formats.

Can I choose a worksheet from a workbook?

Yes. After the workbook is read locally, choose one of its worksheet names from the selector. The first worksheet is selected initially.

How are spreadsheet values represented in JSON?

The first non-empty worksheet row supplies object keys. Numeric and Boolean cells remain typed values, blank cells become empty strings, and recognized date cells are serialized as ISO date strings.

Does this converter recalculate spreadsheet formulas?

No. It reads formula results stored in the workbook when available; it does not run Excel's calculation engine or refresh external data connections.

Are my Excel files uploaded?

No. The workbook is read and parsed locally in your browser; its contents are not uploaded to a backend conversion server. Page-level analytics may still load; see the Privacy Policy for site-wide data practices.