Microsoft Excel Spreadsheet (Legacy)
3.8 | 784 Votes
What is an XLS file?
An XLS file is a spreadsheet file created by Microsoft Excel or exported by another spreadsheet program, such as OpenOffice Calc or Apple Numbers. It contains one or more worksheets that store data in a table format and may include mathematical functions, charts, styles, and formatting. Microsoft replaced XLS files with .XLSX files when it released Excel 2007, but Excel and other spreadsheet applications can still open XLS files.
Microsoft introduced the Excel Spreadsheet (XLS) binary format in 1987 when it released Excel. The XLS format stores one or more worksheets comprising a spreadsheet and a table with rows and columns of cells. Additionally, the cells in a table may contain manually-entered data or the results computed from the data of other cells.
Microsoft replaces XLS files with XLSX files
After Microsoft introduced XLS files in 1987, the file type became one of the most common types for saving spreadsheets until the release of Excel 2007, when Microsoft released Excel 2007, introducing the Microsoft Excel Open XML Spreadsheet (XLSX) format. Spreadsheet files saved in the XLSX format bear the .xlsx file extension, replacing the .xls file extension.
While XLS files are no longer as common as they once were, you may still encounter them in home, school, and business environments when organizing, analyzing, manipulating, or visualizing data. For example, a co-worker may send you an XLS spreadsheet storing financial data from the 1990s.
Common XLS Filenames
Workbook1.xls - The default filename Microsoft Excel gives to new spreadsheets prior to Excel 2007, which creates new spreadsheets with the Workbook1.xlsx filename.
How to open an XLS file
You can open XLS files with Microsoft Excel in Windows and macOS. Excel is the best program for opening XLS files because it fully supports the formatting of Excel spreadsheets, which includes data fields and graphs. Excel is also available for Android and iOS devices.
Many other spreadsheet programs can open and edit XLS files, but they may not fully support the formatting of XLS spreadsheets. Alternative programs include Corel Quattro Pro (Windows), Apple Numbers (Mac), and OpenOffice Calc (cross-platform).
You can also open XLS files with various web programs. Google Sheets is a great free option that allows you to upload an XLS file and view, edit, save, and convert the spreadsheet.
How to convert an XLS file
Various spreadsheet applications, including Microsoft Excel, Corel Quattro Pro, and OpenOffice Calc, can convert XLS files to other formats.
For example, in the Windows and Mac versions of Microsoft Excel, select File → Save As to convert XLS files to one of the following formats:
- .XLSX - Microsoft Excel Spreadsheet
- .XLSB - Microsoft Excel Binary Spreadsheet
- .ODS - OpenDocument Spreadsheet
- .PDF - Portable Document Format
- .XPS - XML Paper Specification (Windows only)
- .CSV - Comma-Separated Values
- .DIF - Data Interchange Format
- .RTF - Rich Text Format
- .HTML - HTML Webpage
- .XML - Extensible Markup Language