Corrupted Excel File: How to Repair and Recover It

How-to basics · Updated November 21, 2026

To fix a corrupted Excel file, first make a copy of it, then try Excel’s built-in Open and Repair command. If that does not work, restore an earlier copy or extract what data you can into a new workbook. These steps are for Excel for Microsoft 365 on Windows; the options differ on Mac and Excel for the web.

What You’ll Need

  • The damaged workbook and enough free storage to make a separate copy.
  • Excel for Microsoft 365 on Windows. If you use Excel for Mac or Excel for the web, see the relevant notes below.
  • Any available backup, OneDrive or SharePoint version history, or original file source.
  • A new destination workbook or folder where you can save recovered content without overwriting the damaged file.

Step-by-Step

  1. Make a working copy. Close the workbook if it is open. In File Explorer, copy the file and paste the copy into a different folder; give it a clear name such as Recovery Copy.xlsx. Keep the original unchanged. If the file is on a network drive, USB drive, or cloud-synced folder, copy it to the computer’s local drive before attempting repairs. A damaged connection or incomplete sync can sometimes look like workbook corruption.
  2. Check that the file is complete and has the right extension. Compare its size with the sender’s copy or a known backup if possible. A file that is zero bytes or much smaller than expected may be incomplete; ask for it to be sent again rather than repeatedly repairing it. Confirm that the extension matches the workbook type, such as .xlsx, .xlsm, or .xls. Do not simply rename an extension to make a file open: changing .xlsx to .xls does not convert its contents and can cause confusion.
  3. Try opening the copy normally. Start Excel first, then use File > Open > Browse to locate the copy. If Excel displays a warning or offers to repair the workbook, read the message and proceed with the copy, not the original. If the workbook opens, save recovered content to a new filename immediately. Keep the source file until you have checked the result.
  4. Use Open and Repair. In Excel, select File > Open > Browse. In the file picker, select the copied workbook, then select the arrow beside the Open button and choose Open and Repair. Choose Repair first. Excel will attempt to restore the workbook’s structure and contents. If Excel reports that it repaired or removed content, note the message and inspect the recovered file carefully before relying on it.
  5. Try Extract Data if Repair fails. Repeat the Open and Repair process and choose Extract Data instead of Repair. If prompted, choose whether to recover values and formulas or to recover values only. This option aims to salvage cell contents when normal workbook repair is unsuccessful; it may not preserve formatting, charts, tables, macros, or other workbook features. Save the result as a new workbook and compare important sheets with another source where possible.
  6. Check for an earlier version before trying riskier recovery methods. If the file is stored in OneDrive or SharePoint, open the storage location in a browser, find the file, and use its Version history option to review earlier versions. Download a version to a separate location or restore it only after confirming which version you need. If the file is on a Windows computer with File History or another backup system, use that system to recover a copy. A healthy earlier version is often safer than a partial repair.
  7. Open Excel without add-ins if the problem may be Excel rather than the file. Close Excel. Press Windows key + R, type Excel /safe, and press Enter. Try opening the copied workbook. If it opens in Safe Mode, an add-in or startup setting could be interfering. Close Safe Mode, then in Excel go to File > Options > Add-ins. At the bottom, choose COM Add-ins beside Manage and select Go; clear an add-in’s checkbox to disable it, then test Excel again. Disable only add-ins you recognize, and turn them back on one at a time to identify a cause.
  8. Copy accessible sheets or cells into a clean workbook. If the damaged file opens far enough to show its contents, create a blank workbook. In the damaged workbook, select a sheet tab, right-click it, choose Move or Copy, select the new workbook as the destination, and select Create a copy. If copying a whole sheet fails, copy smaller ranges of cells and paste them into a new sheet. Check formulas, names, links, tables, charts, and formatting afterward: a copied sheet may retain references to the old workbook or omit features that did not copy cleanly.
  9. Save and verify the recovered file. In the new or repaired workbook, select File > Save As and choose a new name and a suitable format. Use .xlsx for a workbook without macros; use .xlsm if the workbook needs to retain VBA macros. Do not save a macro-enabled file as .xlsx if its macros matter, because that format cannot store them. Close the recovered file, reopen it, and check each important sheet, formulas, dates, totals, charts, and any links before treating it as usable.

Common Mistakes

Repairing the only copy: Open and Repair may remove content it cannot read. Keep an untouched original and do all experiments on a duplicate.

Overwriting a good backup: Version history and backups can contain the best recovery option. Download or copy the candidate version first, then inspect it before restoring anything over the current file.

Assuming a repair message means everything is correct: Excel may open a workbook after removing damaged elements. Check formulas and totals against known results, and look for missing sheets, charts, named ranges, macros, and external links.

Changing the extension or format at random: An extension describes a file type; it does not repair its contents. Saving to an older format can also remove features, while saving a macro-enabled workbook as .xlsx discards its macros.

Repeatedly opening a cloud file while it is syncing: Wait for the sync service to finish, then make a local copy and work on that copy. Do not edit the same workbook in multiple locations during recovery, as this can create conflicting versions.

Tips

  • Keep a separate backup of important workbooks and use OneDrive or SharePoint version history when available. A backup made before corruption is more useful than one that simply copies the damaged file.
  • When a workbook contains business-critical figures, compare recovered data with a trusted export, prior report, or source system. A file that opens is not proof that every value is intact.
  • For large workbooks, test a recovered copy one sheet at a time. This makes it easier to spot a missing sheet or broken formula and reduces the chance of replacing useful content while investigating.
  • Use descriptive filenames for the original, working copy, and recovered version. For example, keep Original.xlsx unchanged and save the result as Recovered-2026-11-03.xlsx.
  • On Excel for Mac, make a copy in Finder before trying to open the workbook. Use File > Open and the available recovery prompts if Excel offers them; the Windows Open and Repair command and its exact controls may not be available in the same form. If recovery is not offered, use a backup or copy accessible sheets into a new workbook.
  • Excel for the web may display an error for a damaged workbook without offering the same repair controls as desktop Excel. Download a copy and try the Windows desktop steps, or retrieve an earlier version from OneDrive or SharePoint.

Troubleshooting

Excel says the file format or extension is not valid. Confirm the full filename and extension, and ask the sender to verify that the upload or transfer completed. If the workbook came from email or a website, download it again rather than opening a temporary preview. If it still fails, use Open and Repair on a copy or obtain another version from the source.

Open and Repair is missing or unavailable. Make sure you are using Excel desktop for Windows and have selected the file through File > Open > Browse. The command is in the arrow beside Open after you select a file. Excel for the web and some Mac versions do not expose the same Windows command; use a Windows desktop copy, an available backup, or another recovery route instead.

Repair completes but the workbook is blank or missing sheets. Do not save over the original. Try Extract Data on another copy and check version history for a more complete version. If you can open a partial result, inspect sheet tabs and use Move or Copy to transfer intact sheets into a fresh workbook.

The recovered workbook opens but formulas show errors. Check whether formulas refer to another workbook, a missing sheet, or a file path that changed. Confirm that calculation is enabled under Formulas > Calculation Options > Automatic, then inspect a few important formulas against their source data. Recovered values may not include the original formulas, depending on the repair method.

Excel crashes or freezes during recovery. Try a local copy, make sure there is free disk space, and open Excel in Safe Mode. If the workbook is very large, avoid opening multiple copies at once. If it continues to crash, stop repeated attempts and use a backup or ask the file’s sender or IT support for an intact source.

A macro-enabled workbook loses macros. Check that the recovered file was saved as .xlsm rather than .xlsx. If the macros were removed during repair, they may not be recoverable from that copy; look for an earlier .xlsm backup. Only enable macros from a source you trust.

Frequently Asked Questions

Can a corrupted Excel file be repaired without losing data?
Sometimes. Open and Repair may restore the whole workbook, but it can also remove unreadable content. Work on a copy, keep backups, and compare important results with a reliable source.

Does Open and Repair work on every Excel file?
No. It can help with some damaged workbooks, but it cannot rebuild every file, especially if the file is incomplete or severely damaged. Try Extract Data or retrieve an earlier copy if Repair fails.

Can I recover an Excel file that will not open?
Try Open and Repair on a duplicate, then Extract Data if offered. Also check OneDrive or SharePoint version history, Windows backups, and the original sender or storage location for an intact version.

Will Extract Data preserve formulas and formatting?
Not necessarily. Excel may let you request formulas and values or values only, but formatting and workbook features may be lost. Verify the result and use another source to rebuild missing content.

Is it safe to change .xlsx to .xls?
No. Renaming the extension does not convert or repair the workbook. Use Excel’s Save As command to convert a workbook, and choose the format that preserves the features you need.

What should I do if only one sheet is damaged?
First make a copy and try to open or repair the workbook. If other sheets remain accessible, copy them into a new workbook and recover the affected sheet from a backup or source data where possible.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.