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 the default file format for spreadsheets created in Microsoft Excel, particularly in versions before Excel 2007. This binary file format can store data in cells organized in rows and columns, and it supports formulas, charts, graphs, and various formatting features to manipulate and visualize data. The .xls format was commonly used in business, finance, and any field requiring data analysis and presentation, but has since been largely replaced by the more advanced .xlsx format.
Technical detailsThe `.xls` format, primarily used for Microsoft Excel versions before 2007, stores spreadsheet elements such as worksheets, formulas, and macros. Being a proprietary binary format created by Microsoft, its undocumented internal structure has made compatibility with third-party software quite challenging. This format consists of binary records that contain data, formatting, and embedded objects, allowing for multiple worksheets, various functions, and inter-sheet referencing. `.xls` files can also include Visual Basic for Applications (VBA) macros, which enable automation and complex calculations. While supported in applications like OpenOffice Calc, there are options available to convert between `.xls` and other formats such as `.xlsx`. Despite security concerns related to macros, `.xls` is still commonly used due to its compatibility with older Excel versions and legacy systems. However, the newer `.xlsx` format, introduced in Office 2007 and utilizing XML and ZIP technologies, offers improved efficiency and security features.
MIME type
application/vnd.ms-excel