Reference Formats
XLS
Microsoft Excel's original proprietary binary spreadsheet format, used as the default from 1987 until Excel 2007 introduced XLSX.
Extension
.xls
Full name
Excel Binary File Format (BIFF)
Introduced
1987 (Excel 2.0 for Windows), final binary revision BIFF8 with Excel 97
Vendor
Microsoft
What is inside the container
XLS uses the Binary Interchange File Format (BIFF), where workbook and worksheet data is written as a sequence of binary records inside a Compound File Binary (OLE2) container rather than as text or XML. This makes XLS opaque to generic tools — extracting cell values or metadata requires a dedicated binary parser rather than an archive extractor. BIFF8, introduced with Excel 97, added Unicode strings, 65,536-row support, and OLE-embedded object storage, and remained the format's final major revision.
How to open it
For archives
XLS is a legacy risk for a DAM: its binary BIFF structure is undocumented outside Microsoft's published specifications and third-party reverse engineering, and current Excel versions increasingly de-prioritize round-trip fidelity for it. Convert XLS assets to XLSX at ingestion where the original binary isn't needed for legal or provenance reasons, and keep the original file as a preservation copy alongside the converted, more durable version.
The .xls extension traces back to Excel 2.0 for Windows in 1987, and the underlying Binary Interchange File Format evolved through several major revisions — BIFF2 through BIFF8 — as Excel added rows, columns, Unicode support, and richer object embedding. BIFF8, shipped with Excel 97, became the long-standing default and is what most people mean when they refer to a modern “XLS” file; it remained Excel’s native format for a full decade until Office 2007 replaced it with the XML-based XLSX.
In a DAM context, XLS shows up mostly as legacy inherited content — old financial models, historical price lists, or data exports from systems that never updated their export routines. Because BIFF is a binary record stream rather than a documented text structure, a DAM cannot cheaply extract text or metadata from XLS the way it can from XLSX’s XML parts; doing so requires a binary-aware library. This is one of the clearer cases in a DAM where normalizing legacy assets to a modern equivalent format on ingest pays off in searchability and long-term tooling support.
| XLS (legacy) | XLSX (current) | |
|---|---|---|
| Structure | Binary BIFF records inside an OLE2 compound file | ZIP archive of XML parts |
| Text/metadata extraction | Requires a dedicated binary parser | Readable directly from XML |
| Row limit | 65,536 rows (BIFF8) | Over 1 million rows |
| Default since | Excel 97 (BIFF8) | Office 2007 |
Frequently asked
Why can't a DAM full-text index XLS files as easily as XLSX?
XLSX is a ZIP archive of XML files, so search engines can unzip it and extract text with a generic XML parser. XLS instead packs data as BIFF (Binary Interchange File Format) records inside an OLE2 Compound File container—string tables, cell values, and formulas are encoded in binary structures. A DAM's indexer needs a dedicated BIFF parser, such as Apache POI or xlrd, rather than a generic text extractor, adding a maintenance dependency.
Should old XLS assets in a DAM be converted to XLSX?
Generally yes. XLSX's XML-based structure is smaller after ZIP compression, opens faster, and lets a DAM's search index read text without a binary parser, improving discoverability and long-term software support since Microsoft has de-emphasized BIFF in favor of Open XML. However, keep the original XLS alongside the converted copy when the file has legal, contractual, or provenance value, or when it contains legacy macros or chart types that may not migrate cleanly.
Does modern Excel still fully support opening XLS files?
Yes, but with caveats. Current Excel versions open, edit, and resave XLS files created from Excel 97 onward, since that BIFF8-based format remains part of Excel's supported import filters. However, Microsoft has reduced feature parity for XLS, discourages saving new files in it, and very old pre-1992 BIFF2 through BIFF4 files created before Excel 97 may fail to open or require an older Excel version to read.
What's the difference between XLS and the newer XLSB binary format?
XLSB is a newer binary format introduced alongside XLSX in Office 2007 that keeps binary performance benefits but is a distinct, more modern structure — it is not the same as legacy BIFF-based XLS.
Can malware hide inside XLS files stored in a DAM?
Yes. Because XLS uses the OLE2 Compound File container, it can carry embedded OLE Package objects, legacy VBA macros, or DDE (Dynamic Data Exchange) formulas that can execute commands without a macro-enabled extension or explicit user consent. Historically these vectors have been used to deliver macro viruses and downloader malware. A DAM ingesting XLS files should run antivirus and macro or OLE-object scanning at upload rather than trusting the file extension alone.
Is there a risk of losing formulas when converting XLS to XLSX?
Most standard formulas convert cleanly, since Excel maps BIFF formula tokens to their XLSX equivalents automatically. Risk increases with legacy elements: older chart types, external workbook links, array formulas, or VBA macros, which need re-saving as XLSM, may not migrate perfectly and can require manual review. Testing converted files against the originals, especially for complex financial models, is safer than assuming full fidelity after a bulk conversion.
How old can an XLS file be and still open correctly today?
Files using BIFF8, the format Excel 97 through Excel 2003 wrote, generally open reliably in current Excel and in tools like LibreOffice or Apache POI. Earlier BIFF versions—BIFF2 from Excel 2.0 in 1987, BIFF3, and BIFF4 from Excel 4.0 in 1992—predate that standardization and are unsupported by modern Excel; opening them typically requires legacy software like Excel 2003 or specialized conversion utilities.
Can a DAM generate an accurate thumbnail preview for XLS the same way it does for XLSX?
Yes, if it uses a rendering engine like LibreOffice headless that supports the legacy binary import filter, though rendering fidelity for very old files can be less reliable than for XLSX.
Sources
- The first Microsoft version of the XLS binary format was released in 1987 as Excel 2.0, and BIFF8 (Excel 97) expanded it with Unicode support, 65,536 rows, and OLE storage. checked 2026-08-07 — docs.fileformat.com - XLS File Format
- The Microsoft Office Excel 97-2007 Binary File Format (BIFF8) is documented as a sustainability format entry by the Library of Congress. checked 2026-08-07 — Library of Congress - Microsoft Office Excel 97-2003 Binary File Format