XLS to JSON
Convert to
Tools for this file
Your files never leave your device.
The first row becomes the keys and every row after it becomes one object. A workbook with several sheets gives one list per sheet.
Questions about XLS to JSON
How does XLS to JSON work?
XLS to JSON turns an old Excel 97–2003 workbook into JSON objects. Numbers and true/false keep their types, and formulas give their results. A single sheet gives one array of objects.
What does the JSON look like for several sheets?
An object keyed by sheet name, such as {"2023": [...], "2024": [...]}. Each list holds one object per non-empty row, using that sheet's own first row as the keys.
How are empty cells shown?
As null, so every object from a sheet has the same keys even when a cell is blank. Rows that are completely empty are left out.
Do dates come out as serial numbers?
No. Although Excel stores dates as numbers internally, they come out as readable ISO dates like 2024-01-15.