Fix Excel 'File is corrupt' error on .xls files

You double-click an old .xls file—maybe something you saved from Excel 2003 or downloaded from an old company server—and instead of opening, you get a gray dialog box: “The file is corrupt and cannot be opened.” Sometimes it appears right away, sometimes after Excel asks if you want to recover the file. You click Yes, and nothing happens. The file just sits there, mocking you.

Here’s the thing: that error message is often wrong. The file might not be corrupted at all. In many cases, the issue is that Excel is trying to open a file that’s actually a different format than what the extension says. Or the file has a minor structural issue that Excel’s strict parser rejects. Let me walk you through the fixes that work, in the order I’d try them.

What’s really going on?

An .xls file is a binary format from the old days (Excel 97–2003). Modern Excel (2010 through Excel 365) can still read it, but it’s picky. If the file was saved by a third-party program (like a reporting tool or an accounting system) and just tagged with an .xls extension, it might actually be an HTML file or XML data. Excel sees the extension, tries to parse it as a binary workbook, and fails—so it screams “corrupt.”

Another common cause: the file was partially downloaded from email or a web server, leaving it incomplete. Or the file was saved from a Mac with a slightly different encoding. Whatever the reason, the fix is usually the same.

Fix 1: Use Open and Repair (the first thing to try)

This is built into Excel and doesn’t require any special tools. It scans the file and recovers what it can.

1. Open Excel (not the file—just the application).
2. Click File in the top-left corner, then click Open.
3. Click Browse to find your .xls file.
4. In the Open dialog, click once on the file to select it, but don’t double-click it yet.
5. Look at the bottom-right of the dialog. There’s a small down arrow next to the Open button. Click that arrow.
6. Select Open and Repair from the drop-down menu.
7. Excel will ask you to choose: Repair or Extract Data. Start with Repair.

After you click Repair, you should see a message like “Excel repaired the file” and then the workbook opens. Sometimes it takes a few seconds, so don’t click anything else. If Repair fails, repeat steps 1–6 but choose Extract Data this time. That pulls out formulas and values even if the formatting is lost.

Fix 2: Change the file extension to .xlsx

If Open and Repair didn’t work, the file might be a newer format that got mislabeled. This happens more than you’d think. Here’s how to check:

1. Right-click the file and select Rename.
2. Change the extension from .xls to .xlsx. If Windows doesn’t show the extension, you’ll need to enable them first: open File Explorer, click View, then check the box File name extensions.
3. Now try opening the file with Excel.

If it opens—great, you’re done. If you get a different error like “The file format and extension don’t match,” that’s actually good news. It means Excel recognized the content as .xlsx. Click Yes to open it anyway, then immediately save it as .xlsx using File → Save As.

But wait—sometimes the file is actually a web page saved with an .xls extension. If renaming to .xlsx fails, try renaming to .html and opening that in a browser. You’ll see the data in table form. You can then copy and paste it into Excel. It’s a hack, but it works.

Fix 3: Open in Google Sheets (the no-install workaround)

Google Sheets is surprisingly good at opening files Excel refuses to touch. If you have a Google account (free), do this:

1. Go to sheets.google.com and sign in.
2. Click the folder icon to open the file picker, or drag and drop your .xls file directly onto the page.
3. If Google can read it, you’ll see the data in a new spreadsheet.
4. Then download it back to Excel format: File → Download → Microsoft Excel (.xlsx).

This won’t preserve complex macros or charts, but for plain data it’s a lifesaver. I’ve used this trick for files that were completely dead in Excel 2019—Google read them like nothing was wrong.

Fix 4: Recover a previous version (if you’re on Windows)

If the file was on your local drive and you have File History or a system restore point, you might be able to grab an older, good copy.

1. Right-click the file, select Properties.
2. Go to the Previous Versions tab.
3. If there are versions listed, select one from before the corruption and click Restore.

This only works if File History was turned on, so don’t count on it. But check anyway—you’d be surprised how often it saves the day.

What if none of this works?

If you’ve tried Open and Repair, changed the extension, tried Google Sheets, and checked previous versions—and the file still won’t open—then it’s genuinely corrupt. At that point, you have two options:

• Use a third-party recovery tool like Stellar Phoenix or Disk Drill. These are paid, but they can sometimes piece together fragments of a broken .xls file. I’d only go there if the data is absolutely critical.
• Accept the loss and start fresh. I know that hurts, but it’s the realistic endgame for a truly dead file.

One last thing: if you manage to recover the file by any method, immediately save a backup copy in .xlsx format and maybe even a PDF copy. That way, next time this error pops up, you’re not scrambling.

Good luck. And remember—when Excel says a file is corrupt, it’s often lying. Try these fixes before you give up.