XLS File Format: What It Is and How to Open It

The Two Histories Hiding Behind an XLS Extension

An XLS file is an Excel workbook from the older binary family. Microsoft calls the common later version the Excel 97-2003 Binary file format, also known as BIFF8. That means an XLS attachment may have been created by Excel 97, 2000, 2002, or 2003, though modern Excel can still open it. The same three-letter extension is older than that: Excel 5.0 and 95 also used .xls, but their files use BIFF5 rather than BIFF8. An extension alone therefore does not identify the exact internal version. A real XLS workbook can hold several worksheets, formulas, number formats, charts, print settings, names, and links to other workbooks. It is not merely a table of numbers, which is why opening it successfully is only the first check.

XLS remained common long after Excel moved on because old reporting systems, imports, and stored records often named it as a requirement. Microsoft changed Excel's default workbook type to the XML-based XLSX format with Excel 2007. The old extension can still arrive in email, download folders, document archives, or exports from other spreadsheet programs. It is worth separating the file's age from its value: an XLS file may contain the only working copy of an old calculation or a required import layout. It is also worth separating a genuine workbook from a mislabeled download. Some sites deliver tab-separated text with an .xls name; Excel can warn that the file format and extension do not match. Renaming such a file does not turn text into a binary workbook, and renaming a binary workbook does not repair it.

Inside the Binary Workbook Rather Than a Modern Package

The usual Excel 97-2003 XLS file is built from a Compound File Binary container, sometimes called OLE structured storage. Think of it as a small directory system inside one file rather than a readable text document. The container keeps named streams, and the Excel workbook stream stores a run of binary records. BIFF records describe workbook settings, sheets, cells, formulas, fonts, styles, shared strings, and other features. This helps explain why opening an XLS file in a text editor produces unreadable characters and why a damaged record can affect a part of the workbook that seems unrelated to the visible cell data. The Microsoft XLS specification describes the format for Excel 97 through Excel 2003; it is a documented binary structure, not a ZIP archive with XML files inside.

XLSX takes a different route. It is an Office Open XML package: its parts are XML files held in a ZIP-based package. Moving from XLS to XLSX changes the way workbook information is stored, but it does not improve a number merely by changing the container. A formula result that was already wrong, a missing external source, or a value saved only as text remains a data problem after conversion. Likewise, converting an XLS file to CSV strips the workbook down to text values from one sheet, so formulas, charts, formatting, additional sheets, and print layout no longer have a place to go. Conversion is useful when the target program needs a different format. It is not a cure for a source workbook whose calculations or records were already damaged.

The Narrow Reasons to Keep an XLS File

• Legacy receiving software: XLS is the BIFF8 workbook format explicitly associated with Excel 97 through 2003, so an older import may require it even when the sender uses modern Excel.
• Editable workbook behavior: cells, many formulas, multiple sheets, and charts can remain workbook features; a CSV export cannot retain that structure.
• Smaller legacy grid: one worksheet is limited to 65,536 rows and 256 columns, ending at column IV. That limit is a reason to leave XLS, not a benefit for large data.
• Old-style compatibility: current Excel opens an XLS workbook in Compatibility Mode, which intentionally prevents use of features the old format cannot save.
• Risk of feature loss: saving a modern workbook back to XLS can discard unsupported features, including data outside the old grid, rather than hiding them for later recovery.

The practical choice is usually to preserve the received XLS unchanged and create an XLSX working copy if the next program accepts it. Do not overwrite the only source while testing. An XLSX copy has a much larger worksheet grid: 1,048,576 rows by 16,384 columns in Excel 2007 and later, compared with XLS at 65,536 by 256. That difference matters even when the visible report is small, because data or formulas may sit outside the visible area. If an importer truly insists on XLS, test a copy in that importer. If the instruction only says "Excel file," confirm whether XLSX is acceptable before choosing the older, more constrained format.

Compatibility Mode Is an Active Limitation

Microsoft says that opening an Excel 97-2003 workbook in current Excel automatically uses Compatibility Mode. This is not just a label in the title bar. It keeps the file in its original format so that a later save remains usable by old Excel. The tradeoff is that newer capabilities cannot be stored in the old file. Microsoft's Compatibility Checker gives concrete examples: data beyond the 65,536-row by 256-column boundary is not saved, and formulas referring to that lost area return #REF!. A 65,536-row dataset plus one header row is already one row too many for a single XLS sheet. Check every worksheet, including hidden ones and sheets with formulas far below the visible report.

Other limits are less obvious. Microsoft documents a maximum of 4,000 unique cell formats in Excel 97-2003, whereas later Excel versions allow 64,000. Newer cell effects and shadows are changed to the closest old format when saved as XLS. Sparklines are not displayed by Excel 97-2010, and charts such as treemaps introduced in Excel 2016 are removed by an older-format save. Power Query data cannot be refreshed in Excel 97-2003, because those Get and Transform capabilities arrived with Excel 2016. These are not reasons to distrust every old workbook. They are reasons to identify which exact feature carries meaning in a particular file, then check that feature after a conversion rather than comparing only a total in the first sheet.

When an Old Workbook Opens Badly or Refuses to Open

A common real failure is Excel reporting that it found unreadable content and offering to repair the workbook. Microsoft says current Excel starts File Recovery automatically when it recognizes corruption, and it provides an Open and Repair choice when automatic recovery is not enough. Start with a duplicate of the file, not the only copy. Microsoft also advises moving a workbook from a network location or unreliable disk to a local drive before recovery if a disk or network error is involved. If repair cannot rebuild every feature, Excel can attempt to extract data. That recovery may save cell values and formulas while leaving behind some workbook behavior, so the recovered file needs a new name and a careful comparison with the original where it still opens.

Microsoft's recovery instructions contain two unusually useful details. Opening a damaged workbook with calculation set to Manual can help because Excel then does not try to recalculate it during opening. If the data must be rescued from a workbook that will not open cleanly, a new workbook can use external references to pull values from it, then paste those results as values. That method deliberately removes the links, so it is a data rescue, not a formula-preserving repair. Saving as SYLK can filter printer corruption, but SYLK saves only the active sheet. It must therefore be repeated per sheet and cannot be treated as a full-workbook backup. These choices explain why an online converter may create an apparently usable file yet fail to preserve the part that made the old workbook valuable.

XLS Limits That Change a Conversion Decision

Questions Worth Asking Before You Trust an XLS Workbook

Can I rename .xls to .xlsx?
No. The extension is not the contents. A true conversion has to read the Compound File Binary and create a new XML package; a renamed file can trigger an extension-mismatch warning.

Why does Excel show Compatibility Mode?
The open file is in the Excel 97-2003 format. Excel keeps the older file rules active so that saving without changing format can remain compatible with that generation.

Will saving as XLS remove rows I cannot see?
It can. Excel says cells outside 65,536 rows by 256 columns are not saved in the older format, and formulas that refer to the lost region return #REF!.

What should I compare after converting an XLS file?
Check sheet names and counts, the final used row and column, several key totals, a date, a leading-zero identifier, one cross-sheet formula, chart source values, and the printed layout if pages matter. Change one harmless input and confirm that a dependent formula recalculates.

What if the workbook is corrupt?
Work on a copy. Try Excel's Open and Repair option, move a network-held file to local storage first if that is relevant, and use Extract Data only with the understanding that it may save values and formulas but not every original workbook feature.