Convert XLS (Excel) to JSON
Convert XLS to JSON with source metadata and legacy Excel sheet data in separate tables.
Convert XLS to JSON to import a legacy Excel workbook, compare an export, or process tabular data in code. Sheets are delivered as structured tables, so cell values are not merged into a single text string.
How the result is organised
The JSON always has four top-level fields. For a spreadsheet, sheet data is in tables; pages is present for the shared contract and can be an empty array.
{
"source": { "filename": "price.xls", "format": "xls", "pages": 0, "size_bytes": 18432 },
"converted_at": "2026-09-18 10:30:00",
"pages": [],
"tables": [{ "page": 1, "header": ["SKU", "Price"], "rows": [["A-15", "490"]] }]
}
sourcedescribes the original workbook: its name, format, and size.converted_atshows when the JSON was prepared.pagesremains an array even when a workbook has no text pages.tablescontains a header and data rows for each sheet.- Cell values are returned as strings, numbers and dates included: cast them in your own code.
JSON preserves cell values rather than sheet presentation: column widths, colours, charts, print areas, and formula styling do not carry over. Before importing, check that the first row of each sheet is suitable as a table header.
How to export a legacy workbook
- Upload an XLS file.
- Select JSON as the target format.
- Download the result and use the
tablesarray for an import or review.
More about the formats
What the format is, how to open it and how it differs from the others.