How to Repair a Corrupted Excel File

If you need to know how to repair Excel file damage, start with Excel's built-in tool: go to File → Open, select the workbook, click the arrow next to Open and choose Open and Repair, then Repair. If that fails, run it again and choose Extract Data to pull out values and formulas. Most corrupted workbooks open with one of these two options.

When they do not, there are still several reliable ways to get your data back, from opening the file with calculation switched off to restoring an earlier version. This guide works through them in order, from quickest to most involved.

What Causes an Excel File to Become Corrupted?

An Excel file usually becomes corrupted when it is not written to disk completely. A workbook is really a compressed bundle of smaller files, and if any part is cut off or damaged, Excel cannot rebuild the whole.

Common causes include:

• A crash or power cut while saving. The save stops part-way, leaving an incomplete file.
• Removing a USB drive or losing a network connection during a save.
• Sync conflicts when two people or two devices edit the same file in a synced folder.
• Disk errors on an ageing drive, which can damage any file stored on bad sectors.
• Problem add-ins that crash Excel when the workbook opens, which can look like corruption even when the file is fine.

Typical symptoms are messages such as "Excel cannot open the file because the file format or file extension is not valid" or "We found a problem with some content", a blank grid, or Excel freezing on open.

Which Excel Repair Method Should You Try First?

Try the methods in the order below. Each one is less convenient than the last but recovers data in situations the earlier ones cannot. Before you start, make a copy of the damaged file and work on the copy, so a failed attempt cannot make things worse.

How Do You Use Open and Repair in Excel?

Open and Repair is Excel's built-in recovery tool, and it works in Excel 2016, 2019, 2021, 2024 and Microsoft 365. It cannot be reached by double-clicking a file; you must open the workbook from inside Excel.

1. Open Excel with a blank workbook.
2. Go to File → Open → Browse.
3. Navigate to the folder and select the damaged workbook once. Do not double-click it.
4. Click the small arrow next to the Open button and choose Open and Repair.
5. Select Repair to recover as much as possible.
6. If Excel reports that it could not repair the file, repeat steps 2–4 and select Extract Data instead. If asked, choose whether to keep formulas or convert them to values.
7. Review the repair log Excel shows, then save the result under a new name with File → Save As.

Microsoft's article on how to repair a corrupted workbook covers the same steps and the alternative methods below.

What If Excel Crashes When Opening the File?

If Excel freezes or crashes while opening a workbook, set calculation to manual first. A large or broken formula chain can stop the file loading, and manual calculation stops Excel recalculating everything on open.

1. Open Excel and create a Blank workbook.
2. Go to File → Options → Formulas.
3. Under Calculation options, select Manual and click OK.
4. Go to File → Open and open the damaged workbook.
5. If it opens, save a copy straight away, then look for the formula or sheet causing the problem.

If every workbook crashes, the file may not be the problem at all. Start Excel in Safe Mode, which loads it without add-ins: press Windows key + R, type excel /safe and press Enter, or hold Ctrl while opening Excel. If files open normally in Safe Mode, disable add-ins one at a time under File → Options → Add-ins to find the culprit.

If Excel itself is damaged, repair the Office installation. Right-click Start, select Installed apps, find your Office product, select … → Modify and choose Quick Repair. If that does not help, run Online Repair, which takes longer but is more thorough.

How Do You Recover Data When the Workbook Won't Open at All?

When Open and Repair fails and the file will not open in any mode, you can still pull out cell values by linking to the damaged workbook from a new one. This is called an external reference, and it reads data without fully opening the file.

1. Note the damaged file's exact name and folder.
2. Create a new Blank workbook.
3. In cell A1, type =FileName!A1, replacing FileName with the damaged workbook's name without the extension, and press Enter.
4. If Excel opens an Update Values dialog, select the damaged workbook. If asked, choose the sheet you want.
5. Copy cell A1 and paste it across a range about the size of your original data.
6. With the range selected, copy again and use Home → Paste → Values to replace the links with the actual data.

This recovers values only, not formulas, formatting or charts, but it often rescues the numbers that matter.

Can You Restore an Earlier Version of an Excel File?

Yes, if the file was stored in OneDrive or SharePoint, or if Windows File History was set up. Restoring an earlier version is often faster than repairing the damaged one.

For OneDrive and SharePoint files, open the workbook in Excel, click the file name in the title bar and select Version history. Open an earlier version and select Restore. Microsoft keeps the last 25 versions for personal Microsoft accounts; work and school accounts depend on the organisation's settings. This is one practical advantage of cloud storage, which our comparison of Microsoft Office vs Microsoft 365 discusses alongside the licensing differences.

For local files, right-click the workbook in File Explorer, select Show more options → Restore previous versions and see whether a copy is listed. This only works if File History or another backup was running before the damage happened.

Is a Corrupted File the Same as an Unsaved One?

No. A corrupted file exists but cannot be read; an unsaved file was never written to disk, or only partly. The fixes are different. If Excel closed before you saved, look under File → Info → Manage Workbook → Recover Unsaved Workbooks, or in the Document Recovery pane Excel shows after a crash. Our full guide on how to recover an unsaved Excel file covers AutoRecover locations and settings in detail.

A Common Mistake We See

The most damaging mistake is repeatedly opening and saving over the only copy of a corrupted workbook. Each failed save can overwrite parts that a repair tool could still have recovered. Copy the file first, and only ever save repaired results under a new name.

We also see people running Excel versions that no longer receive updates. Office 2016 and 2019 support ended in October 2025 and Office 2021 support ended in October 2026, so fixes for crashes and file-handling bugs no longer reach those versions. Our table of Office end of support dates shows where each version stands. Finally, prevent the next incident: under File → Save As → Browse → Tools → General Options, tick Always create backup, and keep AutoRecover switched on under File → Options → Save.

Frequently Asked Questions

How do I repair an Excel file that won't open?

Open Excel, go to File, Open, Browse, and select the workbook. Click the arrow beside Open, choose Open and Repair, then Repair. If that fails, repeat and choose Extract Data. If Excel crashes instead, set calculation to Manual in File, Options, Formulas before opening the file.

Can I recover an Excel file without third-party software?

In most cases, yes. Open and Repair, manual calculation, Safe Mode, external references and version history are all built into Excel, Windows or OneDrive. Third-party recovery tools exist, but Microsoft treats them as a last resort and they vary in quality, so try every built-in method first.

How do I recover an Excel file not saved after a crash?

Reopen Excel and check the Document Recovery pane, which lists files AutoRecover saved before the crash. If nothing appears, go to File, Info, Manage Workbook and select Recover Unsaved Workbooks. This only works if AutoRecover was switched on before the crash.

Why does Excel say the file format or extension is not valid?

This message usually means the file is damaged, was saved incompletely, or has the wrong extension for its contents, such as an old .xls file renamed to .xlsx. Try Open and Repair first. If the file was downloaded or emailed, also check its Properties for an Unblock option.

Where does Excel keep AutoRecover files?

Go to File, Options, Save. The AutoRecover file location box shows the folder Excel uses, and the same screen sets how often AutoRecover saves, every 10 minutes by default. Make sure Disable AutoRecover for this workbook only is unticked, or the workbook you are working on will not be protected.

Will repairing an Excel file lose my formatting?

Repair tries to keep formatting, charts and formulas, but heavily damaged parts may be dropped, and Excel lists what it removed. Extract Data and the external reference method recover data only, so formatting, charts and macros will need rebuilding. Keep the damaged original in case another method recovers more.

Conclusion

The fastest answer to how to repair Excel file corruption is Open and Repair, followed by Extract Data, manual calculation and version history if needed. Work on a copy, save repaired results under a new name and switch on backups to avoid a repeat. If your Excel version is out of support, a current, supported copy from our Microsoft Office collection or the Office 2024 range keeps you on updated, stable software.

Useful Links