Does it convert every sheet?

It offers every sheet and you choose. The default is one output file per selected sheet rather than silently taking the first one.

How are dates handled?

They are written as ISO-8601 strings, so you never see a raw Excel serial number like 45231 in the output.

Does it need Excel installed?

No. DataTray reads the workbook itself.

Free converter

ExcelJSON

Excel to JSON Converter

A workbook is where the data was maintained; JSON is where it needs to go. DataTray reads every sheet, keeps the cell types Excel already knows about, and writes clean JSON without a round trip through CSV.

Windows 10/11 (x64) · Free · No account

Drop in your files — Output is written per sheet by default, so a forty-sheet workbook does not become one unreadable file.

Why convert

Keeping the types Excel already has

Unlike a CSV, an Excel file already records whether a cell is a number, a date or text. Converting via CSV throws that away and makes the next tool guess again. Reading the workbook directly keeps it — dates stay dates rather than becoming ambiguous strings.

Turning a maintained spreadsheet into a config or fixture file.
Feeding a workbook into an API or an import job.
Extracting one sheet out of forty as its own JSON file.
Getting dates out of Excel without the usual serial-number confusion.

How it works

Convert Excel to JSON in a few clicks

1
Open the workbook
Every sheet is listed, with row counts, so you can pick the ones you actually want.
2
Choose the output shape
One JSON file per sheet, or a single file keyed by sheet name.
3
Convert
Types come from the workbook itself; dates are written as ISO-8601.

The details

Excel to JSON, at a glance

Input: .xlsx, .xls and .xlsb
Sheets: All of them — pick which, and get one output each or one combined
Dates: ISO-8601, not Excel serial numbers
Output: JSON or NDJSON, UTF-8, no BOM

Questions