FixFile
File Format

XLS (.xls)

Microsoft Excel's legacy binary spreadsheet format used from 1987 to 2007. Contains formulas, charts, and multiple worksheets in a proprietary binary structure.

Extension
.xls
MIME Type
application/vnd.ms-excel

Last updated

Overview

XLS is the binary file format used by Microsoft Excel from Excel 2.0 (1987) through Excel 2003. Like DOC for Word, it uses the Compound File Binary Format (OLE2) container with a complex binary structure storing worksheets, formulas, charts, VBA macros, and formatting. Excel 2007 replaced XLS with XLSX, but XLS files remain prevalent in corporate and financial systems that have not migrated.

XLS files are still encountered in financial institutions, ERPs, and legacy reporting systems. Many automated reports generated by older enterprise software produce XLS output. Excel can open and save XLS files natively; LibreOffice Calc provides compatible support with minor differences in complex formula handling.

Common Uses

  • Legacy financial reports — ERP systems (SAP, Oracle) generate XLS exports from pre-2010 configurations
  • Old templates and macros — Excel macro workbooks from the 1990s–2000s in .xls format
  • Banking and financial data — many financial institutions still distribute statements and reports as XLS
  • Manufacturing and logistics — older factory floor systems output XLS for production records

Advantages

  • Universal Excel compatibility — every version of Excel from 97 onward opens XLS without conversion
  • VBA macro support — full Visual Basic for Applications macro execution
  • Familiar format — recipients with Excel can open XLS without any action required

Limitations

  • Row limit — XLS supports a maximum of 65,536 rows per sheet; XLSX supports 1,048,576 rows
  • Proprietary binary — complex binary format; minor differences in non-Microsoft implementations
  • Larger file size — binary format is less efficient than XLSX's compressed XML
  • Macro security risks — XLS files with VBA macros are a major malware vector
  • No modern features — no support for Power Pivot, dynamic arrays, or other Excel 2010+ features

Supported Software

  • Windows: Microsoft Excel (all versions), LibreOffice Calc, WPS Spreadsheets
  • macOS: Microsoft Excel for Mac, Numbers (limited import), LibreOffice Calc
  • Online: Google Sheets (upload and convert), Microsoft 365