File Repairer
Windows 10 & 11 Buy license · $29.95
Office documents

How to Repair a Corrupted Excel File (.xlsx and .xls)

Repair a corrupted Excel workbook with Open and Repair, Extract Data, manual calculation and version history, then rebuild it with sheets and formulas.

Updated 5 minute read The File Repairer team

To repair a corrupted Excel file, open Excel, go to File > Open > Browse, select the workbook, click the arrow next to Open and choose Open and Repair, then click Repair. If that fails, run it again and choose Extract Data to rescue values and formulas. You can also set calculation to manual before opening, link to the damaged workbook from a new one to pull its data out, or restore an earlier version from OneDrive or Previous Versions. When Excel's own tools fail or lose sheets and formulas, a file repair tool can rebuild the workbook itself.

Make a copy of the damaged workbook before you try anything, and work on the copy.

Excel's built-in repair options compared

MethodWhat you get backWhat you can lose
Open and Repair: RepairAs much of the workbook as Excel can fixFormatting, charts, named ranges or whole sheets if badly damaged
Open and Repair: Extract DataCell values, optionally formulasFormatting, charts, macros, pivot tables
Manual calculationThe full workbook, if recalculation was the triggerNothing, if it opens
External reference linkValues from specific sheetsFormulas, formatting, everything except values
Version history / Previous VersionsAn earlier, undamaged copyChanges made since that version

Method 1: Open and Repair

  1. Open Excel with a blank workbook.
  2. Go to File > Open > Browse and select the damaged workbook (single-click, do not open it).
  3. Click the arrow next to Open and choose Open and Repair.
  4. Click Repair to recover as much as possible.
  5. If Repair fails, repeat the steps and click Extract Data. Choose Recover Formulas to keep formulas where possible, or Convert to Values if that fails.

When Excel finishes, it lists what it repaired or removed, for example "Removed Records: Formula from /xl/worksheets/sheet2.xml part". Read that list carefully, because it tells you exactly what to check. Save the result with File > Save As under a new name.

Method 2: Other tricks worth trying

Set calculation to manual

Sometimes the file is fine but Excel crashes recalculating it. Open a blank workbook, go to Formulas > Calculation Options and choose Manual. Then open the damaged file with File > Open. If it opens, save a copy straight away.

Link to the damaged workbook

If you know the sheet names, you can pull the values out with an external reference, even when Excel will not open the file itself.

  1. In a new workbook, click cell A1 and type a formula such as ='C:\Reports\[Budget.xlsx]Sheet1'!A1, using the real path, file name and sheet name.
  2. Press Enter. If Excel asks you to find the file, select the damaged workbook.
  3. Copy A1 across and down to cover the area your data used.
  4. Select everything, copy, then Paste Special > Values to keep the numbers without the links.

This only recovers values, one sheet at a time, but it can rescue numbers you cannot get any other way.

Restore an earlier version

  • OneDrive or SharePoint: right-click the file and choose Version history.
  • Previous Versions: right-click the file, choose Properties and open the Previous Versions tab (needs File History or restore points).
  • Unsaved workbooks: File > Info > Manage Workbook > Recover Unsaved Workbooks.

Not every Excel error means corruption

"Excel cannot open the file because the file format or file extension is not valid" sometimes means the workbook really is damaged, but it can also mean the extension is wrong, for example a CSV or an old .xls renamed to .xlsx, or a file saved by another program. Our guide to that file format or extension error explains how to tell the difference. Files from email or the internet may also be blocked; right-click, choose Properties and tick Unblock if it is shown, as covered in "the file is corrupt and cannot be opened".

When Excel's repair isn't enough

Excel's repair is designed to get you a file that opens. When a part of the workbook is broken, it often removes that part entirely: a whole sheet, all the formulas on a sheet, or the formatting. Extract Data can lose everything except plain values. That may be acceptable for a simple list, but not for a financial model built on hundreds of formulas.

An .xlsx workbook is a ZIP container with a separate XML part for each sheet, plus shared strings, styles and the list that tells Excel which sheets exist. Damage to the container or to that list can make Excel reject the whole workbook even though every sheet is still inside.

Rebuild the workbook with File Repairer

File Repairer rebuilds damaged Excel workbooks rather than stripping them down. It salvages the ZIP container, recovers broken XML and rebuilds the sheet list and the links between parts, recovering sheets, formulas, formatting, tables and images. Older .xls workbooks are repaired and saved as .xlsx, with their formulas kept as working formulas, not just the values.

  1. Drag the workbook, or a folder of them, into File Repairer and click Repair All.
  2. Preview the repaired spreadsheet sheet by sheet, with a panel showing what was recovered.
  3. Save the copy. It is named with " (repaired)" and your original stays exactly as it was.

If a workbook is too damaged to rebuild, Tools > Extract Text & Data pulls out every readable piece of data into a new file. All of this runs on your PC, so confidential spreadsheets are never uploaded. Checking, repairing and previewing are free; saving the repaired workbook needs an Installation Key.

Some limits to know: data that was never written to disk, for example because a save was interrupted, cannot be rebuilt, so some repairs are partial. File Repairer does not remove workbook or sheet passwords, and it does not recover deleted files.

Protecting your workbooks

  • Store important workbooks in OneDrive or SharePoint for automatic version history.
  • Turn on Always create backup in File > Save As > Browse > Tools > General Options for critical files.
  • Avoid working on large workbooks directly from USB sticks or unreliable network drives.
  • After Excel repairs a file, save a clean new copy and work from that.

Frequently asked questions

What is the difference between Repair and Extract Data in Excel?

Repair tries to fix the whole workbook so it opens normally. Extract Data is a fallback that pulls out cell values, and optionally formulas, but leaves behind formatting, charts and other objects.

Can I recover formulas from a corrupted .xls file?

Often, yes. Excel's Extract Data can try to recover formulas, and File Repairer converts damaged .xls workbooks to .xlsx with their formulas kept as working formulas.

Why did Excel remove a sheet when it repaired my file?

Excel removes parts it cannot read so the rest of the workbook opens. The sheet's data may still be inside the damaged file, so keep the original and try a deeper repair before giving up on it.

Get three guides like this every month, plus software update notices.Subscribe →