LearnExcel.io
Menu

How to Open an XLS File Step by Step

Written by ··Updated June 14, 2026
How to Open an XLS File Step by Step

To open an XLS file, double-click it to launch Microsoft Excel, or open Excel first and choose File > Open to browse to the file. If you don’t have Excel, you can open the same file for free in Google Sheets, LibreOffice Calc, or Microsoft’s web-based Excel for the web — no installation or paid license required.

An XLS file is a Microsoft Excel Spreadsheet, the binary workbook format Excel used by default through Excel 2003. Files saved by Excel 2007 and later usually end in .xlsx instead, but XLS files remain extremely common because so many older systems, accounting tools, and database exports still produce them. Below you’ll find every reliable way to open one, on both Windows and Mac, plus what to do when a file refuses to open.

What Is an XLS File?

.xls is the legacy binary file format for Microsoft Excel workbooks. It can hold multiple worksheets, formulas, charts, formatting, and macros. The newer .xlsx format (introduced with Excel 2007) is based on open XML and is smaller and more robust, which is why most modern spreadsheets use it. If you need help with the newer format, see our guide on how to open an XLSX file, or for the binary macro format, how to open an XLSB file.

ExtensionFormatDefault in
.xlsBinary worksheetExcel 97–2003
.xlsxOpen XML worksheetExcel 2007+
.xlsmXML worksheet with macrosExcel 2007+
.csvPlain-text comma-separated valuesAny spreadsheet app

How to Open an XLS File in Excel

Microsoft Excel is the native application for XLS files and the most reliable way to keep every formula, chart, and format intact.

On Windows

  1. Double-click the file. If Excel is installed and set as the default app for .xls, the workbook opens automatically.
  2. Or open from inside Excel. Launch Excel, click File > Open > Browse, navigate to your file, select it, and click Open.
  3. Keyboard shortcut. With Excel already open, press Ctrl + O to jump straight to the Open dialog.

On Mac

  1. Double-click the file in Finder to open it in Excel for Mac.
  2. Or open from inside Excel. Click File > Open, select the file, and click Open.
  3. Keyboard shortcut. Press Cmd + O to open the file picker (the Mac equivalent of Ctrl + O).

When you open an older .xls file in a modern version of Excel, the title bar may show [Compatibility Mode]. This simply means Excel is preserving the old format so the file stays usable in Excel 2003. To unlock newer features, you can convert it — see how Compatibility Mode works and when to turn it off.

How to Open an XLS File Without Excel

You do not need a paid copy of Excel to read or edit an XLS file. Here are three free options.

Google Sheets (free, browser-based)

  1. Go to Google Drive and click New > File upload, then select your XLS file.
  2. Right-click the uploaded file and choose Open with > Google Sheets.
  3. Sheets imports the data and you can edit, share, or download it.

This is the fastest no-install option. For more detail, follow our walkthrough on opening an Excel file in Google Sheets or converting an Excel file to Google Sheets permanently. If you regularly move between the two tools, our Excel vs Google Sheets comparison explains where each one wins.

LibreOffice Calc or Apache OpenOffice (free desktop apps)

Both LibreOffice and OpenOffice are free, open-source office suites that open .xls natively. Download and install either one, then:

  1. Open LibreOffice Calc (or OpenOffice Calc).
  2. Choose File > Open and select your XLS file.
  3. Edit and save — you can keep the .xls format or save as .xlsx.

Excel for the Web (free Microsoft account)

If you have a free Microsoft account, upload the XLS file to OneDrive, then open it in your browser. Excel for the web reads .xls files and lets you edit them online without installing anything.

How to Convert an XLS File to a Newer Format

If you plan to keep working with a file long term, converting it away from the legacy .xls format avoids future compatibility headaches:

  • Convert to XLSX: In Excel, open the file and choose File > Save As, then pick Excel Workbook (.xlsx) as the file type.
  • Convert to CSV: For maximum portability with databases and other apps, save as CSV. Our guide on converting Excel to CSV covers the exact steps and the gotchas around losing formulas.
  • Convert to PDF: To share a read-only copy, see save an Excel file as PDF.

If you came to this page because a different file type was mislabeled, you may actually need to open a CSV file in Excel or open a text file in Excel instead.

Troubleshooting: XLS File Won’t Open

If the file won’t open, work through these fixes in order.

File opens blank or grayed out

Sometimes Excel launches but the worksheet area stays empty. Go to View and check that no window is hidden, or close and reopen Excel.

”File format or extension is not valid”

This error usually means one of three things: the file is corrupted, it was renamed with the wrong extension, or Protected View is blocking it.

  • Protected View: Files downloaded from the internet or email open in Protected View as a safety measure. Click Enable Editing in the yellow banner to proceed. You can adjust these settings if you trust the source.
  • Corruption: Try the built-in repair tool. In Excel, choose File > Open > Browse, select the file, click the arrow next to the Open button, and choose Open and Repair. Our guide on recovering a corrupted Excel file covers deeper recovery options.

Excel freezes or crashes when opening the file

Launch Excel in Safe Mode to rule out a faulty add-in. Hold Ctrl while starting Excel on Windows, or follow the Mac steps in our safe mode guide. If the file then opens, disable add-ins one at a time to find the culprit.

The file is password protected

If you’re prompted for a password you don’t have, you’ll need it from whoever created the file. If you set the password yourself and forgot it, see recovering an Excel password or removing a password from an Excel file.

XLS Files and Macros: A Security Note

Old .xls files can contain VBA macros — small programs that run inside the workbook. Macros are useful for automation, but they can also carry malware, which is why Excel disables them by default in files from the internet.

  • If you trust the source and need the automation, you can enable macros in Excel deliberately.
  • If you don’t recognize the file, leave macros disabled and scan it with antivirus software first. You can also disable macros entirely for extra safety.

Never enable macros in an XLS file from an unknown sender.

Frequently Asked Questions

How do I open an XLS file?

Double-click the file to open it in Microsoft Excel, or open Excel and choose File > Open (Ctrl + O on Windows, Cmd + O on Mac). If you don’t have Excel, upload the file to Google Drive and open it with Google Sheets, or install the free LibreOffice Calc.

What is the best free XLS file opener?

Google Sheets is the best free option if you want zero installation — just upload to Google Drive and open with Sheets. For a free desktop app that keeps the file local, LibreOffice Calc is the strongest choice and opens .xls natively.

What’s the difference between XLS and XLSX?

.xls is the older binary format used through Excel 2003, while .xlsx is the newer open-XML format introduced in Excel 2007. XLSX files are generally smaller and less prone to corruption. Modern Excel opens both, and you can convert an XLS file to XLSX with File > Save As.

Can I open an XLS file on a Mac?

Yes. Excel for Mac opens .xls files directly — just double-click the file or use File > Open (Cmd + O). If you don’t have Excel for Mac, Apple Numbers, Google Sheets, and LibreOffice Calc all open XLS files for free.

Why won’t my XLS file open?

The most common causes are Protected View blocking a downloaded file, a corrupted file, a wrong file extension, or a problematic add-in. Click Enable Editing in the yellow banner, try Open and Repair, or launch Excel in safe mode to isolate the problem.

Is it safe to open an XLS file?

Opening the data is generally safe, but .xls files can contain macros that may carry malware. Keep macros disabled for files from unknown sources, scan the file with antivirus software, and only enable macros when you trust the sender.

Conclusion

Opening an XLS file is simple no matter what software you have. With Excel, double-click or use File > Open; without it, Google Sheets and LibreOffice Calc read the same file for free. If a file won’t cooperate, Protected View, Open and Repair, and Safe Mode resolve the vast majority of problems. Once the file is open, consider converting it to .xlsx or .csv so you never run into legacy-format issues again.

Related guides

How To

How to Open an XLSB File

Open XLSB files in Excel on Windows or Mac, learn what an XLSB file is, see why Google Sheets needs a conversion first, and convert XLSB to XLSX safely.

April 6, 2024

How To

How to Open an XLSX File

Learn how to open XLSX files in Excel, Google Sheets, and other software. Get tips for handling Excel Workbook files and ensuring data compatibility.

April 6, 2024

View all How To guides →