What Is a .XLS File? (.xls, .xlt)
A .xls file is a spreadsheet in Microsoft Excel's legacy binary format, the default for Excel 97 through Excel 2003. It stores worksheets, formulas, charts and formatting, but each sheet is limited to 65,536 rows and 256 columns. Many older systems and bank exports still produce .xls files today.
- Extension
- .xls, .xlt
- Full name
- Microsoft Excel 97-2003 Workbook
- Type
- Document file
- MIME type
- application/vnd.ms-excel
- Developed by
- Microsoft
About XLS files
The .xls format (internally called BIFF8) is a binary file rather than the ZIP-of-XML package used by .xlsx. Modern Excel opens it in Compatibility Mode, and anything beyond row 65,536 or column IV is simply not stored. If you add data past those limits and save as .xls, Excel warns that it will be lost.
Like old Word files, .xls workbooks can contain VBA and older Excel 4.0 macros without any change of extension, so unexpected .xls attachments are a classic malware vector. Excel blocks macros in internet-downloaded files by default; leave that protection on unless you trust the source.
A surprising number of ".xls" downloads from web apps are not real Excel files at all but HTML tables or tab-separated text with an .xls name. Excel then shows a "format and extension don't match" warning. The data usually opens fine, but resave it as a proper .xlsx before editing.
What XLS files are used for
- Spreadsheets created in Office 97 to 2003
- Exports from older accounting, banking and ERP systems
- Legacy templates and forms (.xlt)
How to open a .xls file
Windows
Microsoft Excel opens .xls files in Compatibility Mode; LibreOffice Calc and Excel for the web also work.
Mac
Apple Numbers, Excel for Mac and LibreOffice Calc open .xls files.
iPhone and iPad
Preview in the Files app, or open in Numbers or Microsoft Excel to edit.
Android
Google Sheets and the Microsoft Excel app both open .xls files.
Online / any browser
Upload to Google Drive and open with Google Sheets.
How to convert a .xls file
In Excel, open the file and use File > Info > Convert, or File > Save As > Excel Workbook (.xlsx). Choose .xlsm instead if the workbook contains macros you want to keep.
LibreOffice Calc, Numbers and Google Sheets can also save or download the data as .xlsx, CSV or PDF.
Renaming .xls to .xlsx does not convert it; Excel will refuse to open the renamed file.
Changing the extension in the file name does not convert the file. See how to change a file extension for when renaming is safe.
Naming and renaming XLS files
- When converting old .xls archives, keep the base name and change only the extension so references from other documents remain recognisable.
- System exports often have generic names like export.xls or report(3).xls; rename them with the source and date, for example bank-statement_2026-02.xls, as soon as you download them.
- If a download claims to be .xls but triggers a format warning, resave it as .xlsx under a clean name rather than keeping the mislabelled file.
Renaming lots of .xls files? Use the free online bulk renamer for patterns and numbering, or try File Renamer AI to name each file from what is inside it.
Related file types
A .xlsx file is a Microsoft Excel workbook, the default Excel file extension since Excel 2007. It stores one or more worksheets of cells, formulas, charts, formatting and pivot tables in a compressed Office Open XML package. Related Excel extensions are .xlsm (macros), .xlsb (binary) and the older .xls.
A .csv file is a plain-text table where each line is a row and commas separate the columns. It has no formatting, formulas or multiple sheets, which makes it the universal format for moving data between spreadsheets, databases, banking portals, CRMs and code. Any text editor or spreadsheet app can open it.
A .doc file is a word-processing document in Microsoft Word's legacy binary format, used as the default by Word 97 through Word 2003. It holds text, formatting, images and tables in a single proprietary binary file, and is still found in older archives, government forms and email attachments.
A .pdf file is a Portable Document Format document: a fixed-layout file that looks the same on every device, with its text, fonts, images and page geometry packed inside. It is the standard format for sharing finished documents such as invoices, contracts, forms, manuals and scanned paperwork that should not reflow.
Frequently Asked Questions
What is the difference between .xls and .xlsx?
.xls is the binary format of Excel 97-2003 and is limited to 65,536 rows and 256 columns per sheet; .xlsx is the compressed XML format of Excel 2007 and later with over a million rows and no macros.
Why does Excel say the file format and extension do not match?
The .xls file is really HTML, XML or text with an Excel extension, often from a web export. Open it if you trust the source, then save it as a real .xlsx.
Can Google Sheets open .xls files?
Yes. Upload the file to Google Drive and open it with Google Sheets.