Skip to content

Excel XLS converter

Convert XLS files with guidance for BIFF workbooks, old Excel limits, encodings, macros, and safer XLSX output.

.xls

Format

About Excel XLS

XLS is Excel's legacy binary workbook format used by Excel 97 through Excel 2003 and many older reporting systems. Instead of a zipped XML package, an XLS file stores workbook streams inside a binary OLE Compound File container. It can contain worksheets, formulas, styles, merged cells, charts, macros, embedded objects, and workbook metadata, but it carries older limits and older compatibility assumptions. Our matrix treats XLS as readable and exportable to modern targets, but not as a write target. When an old workbook needs a spreadsheet output, use XLSX or ODS rather than trying to create a new XLS file.

Version details matter because XLS covers BIFF-era workbooks with smaller row and column limits than modern XLSX. The common BIFF8 format caps worksheets at 65,536 rows and 256 columns. Code pages, date systems, formula functions, and macro storage can differ from newer Office files. Some files named .xls are actually HTML tables or CSV files sent with the wrong extension, while some valid XLS workbooks are password-protected or damaged by email gateways. A converter should verify the container, read visible sheets, and avoid executing macros. We ran the local API on sample.xls to xlsx and received an Office Open XML package with two worksheet XML files.

Readers and writers include old Excel, LibreOffice, accounting systems, lab instruments, ERP exports, government forms, and archive folders that have not been normalized. Many recipients cannot open XLS on locked-down devices because old binary Office formats are treated as higher risk. XLS is also awkward for web applications and data tooling because parsing binary workbooks is heavier than parsing XLSX packages or delimited files. Conversion is often a preservation step: open the old workbook, check that formulas and displayed values still make sense, then save a modern derivative for daily use.

The main gotchas are hidden workbook state and silent modernization. XLS to CSV exports a sheet-shaped table and drops formulas, styles, comments, charts, macros, and other workbook features. XLS to XLSX can keep multiple sheets and many cell values, but older formulas may be recalculated differently by the next application. XLS to PDF depends on print areas, page breaks, and fonts. XLS to JSON, SQL, or Parquet needs clean headers and stable row types. Before converting, note sheet names, hidden sheets, print areas, and whether the values or formulas are authoritative. Keep the original if it is part of an audit trail.

Common Excel XLS problems

A partner still sends old binary Excel files.

Use /convert/xls-to-xlsx for a modern workbook, then review the sheets because new XLS output is not supported.

Only the data table is needed for import.

Use /convert/xls-to-csv for one tabular extract, and confirm which worksheet was selected before loading it.

The workbook needs a printable record copy.

Use /convert/xls-to-pdf and check page breaks, print area, and whether hidden sheets should be excluded.

OpenDocument users need the workbook.

Use /convert/xls-to-ods, then compare formulas whose names changed between Excel and OpenDocument formula syntax.

A data lake job cannot read binary workbooks.

Use /convert/xls-to-parquet after flattening workbook context and verifying dates, identifiers, and blank rows.