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"]] }]
}
  • source describes the original workbook: its name, format, and size.
  • converted_at shows when the JSON was prepared.
  • pages remains an array even when a workbook has no text pages.
  • tables contains 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

  1. Upload an XLS file.
  2. Select JSON as the target format.
  3. Download the result and use the tables array for an import or review.

More about the formats

What the format is, how to open it and how it differs from the others.