Skip to content
toolsdocks

Convert Excel to JSON

Turn a worksheet into JSON for an API, a script or a config file. This page opens the converter with JSON output and typed values; the first row becomes the keys and each following row becomes an object.

Runs on your device

More options in the full CSV, Excel and JSON converter.

Loading tool…

How to convert Excel to JSON

  1. Choose the Excel file.
  2. Keep Output format on JSON; pick the JSON shape and indentation if you need a different one.
  3. Select Convert, and choose another sheet from the Sheet menu if the workbook has several.
  4. Download the JSON file.

Worked example

The Team sheet of the sample workbook has the header Name, Joined, Active and two rows. It becomes [{"Name":"Ann","Joined":"2026-03-04","Active":true},{"Name":"Bilal","Joined":"2025-02-12","Active":false}]: the date is text and the boolean is typed.

Formats and limits

InputXLSX, XLSM, XLS, ODS
OutputJSON, JSON Lines
LimitsUp to 100 MB.
EngineSheetJS Community Edition + Papa Parse; dot-path flattening for nested JSON

Limitations

  • Keys are the header cells exactly as written, and dots in a header are not split into nested objects here.
  • Formatting, charts, comments and merged-cell layout are not part of JSON.
  • Password-protected workbooks cannot be opened.
  • Up to 100 MB per file.

Questions

Which sheet is converted?

The first sheet. After converting a workbook with several sheets a Sheet menu appears so you can pick another, or tick Workbooks: convert all sheets to get one JSON file per sheet.

How are dates, formulas and empty cells written?

A date cell becomes a text value such as 2026-03-04. A formula is written as its last calculated value. Empty cells become null while typed values are on, and an empty string when they are off.

Why does a ZIP code stay in quotes?

Values with leading zeros, such as 02134, and numbers longer than 15 digits always stay strings so nothing is lost. Other plain numbers become JSON numbers.

Is my workbook uploaded?

No. The file is read and converted in your browser; nothing is uploaded.

Privacy

Runs on your device. Files and text are processed in this browser tab and are not uploaded.

This page opens the CSV, Excel and JSON converter ready for this task. See the privacy policy for how toolsdocks handles data.