Home  /  File formats  /  xls

XLS file format

Extension.xls
Categorydocuments
Programs
Microsoft Office
LibreOffice
Kingsoft Office
Google Docs
Main programMicrosoft Office
DescriptionThe .xls format is synonymous with spreadsheets created in Microsoft Excel, especially in versions prior to 2007. This binary file format has the capability to store data in cells that are systematically arranged in rows and columns. It's also flexible enough to support formulas, charts, graphs, and a plethora of formatting features to assist with data manipulation and visualization. The .xls format was a common go-to in sectors such as business and finance, or any field that necessitated data analysis and presentation. However, the advent of the more sophisticated .xlsx format has largely overshadowed its use.
Technical detailsDiving into the technical details, the .xls format, the golden standard for Microsoft Excel versions prior to 2007, is capable of storing a range of spreadsheet elements, including worksheets, formulas, and macros. As a proprietary binary format birthed by Microsoft, its undocumented internal architecture has posed a significant challenge to compatibility with third-party software. The format is comprised of binary records that contain data, formatting, and embedded objects, offering the possibility of multiple worksheets, a variety of functions, and inter-sheet referencing. .xls files also have the capacity to include Visual Basic for Applications (VBA) macros, opening up avenues for automation and complex calculations. Despite the existence of alternatives like OpenOffice Calc, and options to convert between .xls and other formats such as .xlsx, the .xls format continues to hold its ground, largely due to its compatibility with older Excel versions and legacy systems. However, it's important to note that the newer .xlsx format, which made its debut in Office 2007 and harnesses XML and ZIP technologies, brings to the table improved efficiency and security features. Despite the potential security risks associated with macros, the .xls format continues to be widely used.
MIME type
application/vnd.ms-excel