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

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.

More document file extensions · all file extensions