Excel File Corrupted? How to Check, Repair, and Recover

How-to basics · Updated November 21, 2026

Your Excel file may be corrupted if Excel cannot open it or reports damaged content, but an error message alone does not prove the workbook is ruined. On Windows, first make a copy of the file, then try File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair; choose Repair first, or Extract Data if repair fails.

Check What Is Actually Going Wrong

Before repairing anything, note the exact message and when the problem occurs. A workbook that fails on one computer but opens on another may be affected by a local Excel setting, an add-in, permissions, or a network connection rather than damaged file contents. Likewise, an error that appears only when you click a link or run a macro may concern that feature, not the whole workbook.

Try opening a different workbook in Excel. If other files open normally, the problem is more likely specific to the affected file. If none open, troubleshoot Excel itself or its installation before assuming every workbook is corrupted. You can also try opening the file from Excel using File > Open rather than double-clicking it in File Explorer; this can help distinguish a file-association issue from a workbook problem.

Check that the file is fully downloaded or copied, has a nonzero size, and is in a location you can access. A cloud-sync conflict, interrupted download, disconnected network drive, or read-permission problem can make a sound workbook appear unavailable. If the file is still syncing, wait for synchronization to finish and retry from a local copy.

Common Signs of Workbook Corruption

Possible signs include Excel refusing to open a workbook, reporting that the file format or extension is not valid, displaying a message that it found unreadable content, or opening the file with missing sheets, formulas, charts, or formatting. Excel may also close unexpectedly while opening or saving a particular workbook. These symptoms are clues, not a diagnosis: an incorrect extension, unsupported feature, or incomplete transfer can produce similar behavior.

Pay attention to whether the issue affects the whole workbook or only part of it. If one worksheet is blank but other sheets work, some workbook content may be damaged while the rest remains readable. If Excel offers to repair the file and then lists removed records, read that report carefully. The recovered workbook may open successfully even though certain components were discarded.

An extension mismatch is a common source of confusion. For example, renaming a text file or an older-format file to .xlsx does not convert it into a valid modern Excel workbook. A file may also have an extension that does not match its actual format after being exported or renamed. Do not repeatedly change extensions as a repair technique; identify how the file was created and ask for a fresh export if necessary.

Why Excel Files Can Become Damaged

Excel workbooks are saved as structured files that contain worksheets and other components, such as formulas, styles, charts, and sometimes macros. Saving can be interrupted by a computer shutdown, a crash, a failing storage device, or a disconnected network location. A failed upload or download can leave a partial or incomplete copy. Synchronization conflicts can also create multiple versions, making it unclear which copy contains the latest changes.

Not every opening error means the file structure is damaged. Password protection, access restrictions, a blocked download, an unsupported feature, or a problem with a third-party add-in can prevent normal use. Excel may show Protected View for a file from the internet or another untrusted location; that warning is a security feature, not proof of corruption. Do not enable editing or macros simply to make an error disappear. Confirm that the file and its sender are trustworthy first.

Take Safe Steps Before Repairing

Protect the original before trying recovery. Make a copy in a separate folder and perform repair attempts on that copy. If the workbook is stored in OneDrive, SharePoint, or another managed location, check whether version history is available before overwriting anything. Keep the original error message and any repair log, because they can help explain what Excel could not read.

  • Check the file size and confirm the copy or download has completed.
  • Try a local copy if the workbook is on a network drive or in a syncing folder.
  • Open a different workbook to see whether Excel itself is working normally.
  • Ask the sender to resend the original attachment or export a fresh copy if the file came from someone else.
  • Avoid uploading confidential workbooks to unfamiliar online repair services; the file may contain personal, business, or financial information.

If the workbook opens on another device, save a new copy from that device rather than replacing the only original. If it does not open anywhere, that still does not establish that every piece of data is lost: backups, temporary recovery copies, or partial extraction may help.

Use Open and Repair in Excel for Windows

In Excel for Microsoft 365 on Windows, use File > Open > Browse to reach the Open dialog. Select the workbook, click the small arrow beside the Open button, and choose Open and Repair. If Excel asks what to do, choose Repair first. This option attempts to restore as much of the workbook as it can. If it cannot repair the file, repeat the process on a copy and choose Extract Data to try to retrieve values and formulas.

Repair can recover a usable workbook, but it cannot promise to restore every component. Excel may remove damaged formulas, formatting, charts, objects, or other content. Compare the result with a known-good version if possible, and check important sheets, totals, formulas, named ranges, and macros before relying on the repaired copy. Save the result under a different name so you preserve both the original and the recovery attempt.

The Windows Open and Repair command is not available in the same way in Excel for Mac. On a Mac, first make a duplicate, install available Office updates, and try opening the copy in Excel. If the workbook is in OneDrive or SharePoint, check its version history. Excel for the web can also be a useful separate opening attempt, but it may not support every workbook feature; do not treat a successful web opening as proof that macros or advanced components are intact.

Look for Backups and Recoverable Versions

A previous saved version is often safer and more complete than a repaired file. For a workbook in OneDrive or SharePoint, use the file’s Version History to inspect and restore an earlier version. In OneDrive on the web, locate the file, open its context menu, and choose Version history. In Excel for Windows, File > Info may also show Version History for a cloud-stored workbook. The options shown can depend on where the file is stored and your account’s permissions.

For a workbook that was never saved, Excel for Windows may offer recovery through File > Info > Manage Workbook > Recover Unsaved Workbooks. This is useful only if an unsaved recovery copy exists; it is not a general way to retrieve any deleted or damaged file. Excel’s AutoRecover settings are under File > Options > Save. AutoRecover can help after some interruptions, but it is not a substitute for saving and maintaining backups.

Also check Windows File History or another backup system if it was enabled and included the folder. Work or school devices may have organization-managed backups, so an IT administrator may be able to help. Keep in mind that restoring an older version can discard later edits. Open it under a new name and compare it with the damaged workbook before deciding which version to keep.

Recovery Mistakes and What to Check Afterward

Changing .xlsx to .xls, .xlsm, or another extension does not rebuild damaged workbook contents. Nor does repeatedly opening and saving the only copy. A different spreadsheet program might open some files, but it can alter features or formatting, particularly in workbooks with macros, complex charts, or specialized functions. If you try another program, use a copy and verify the result in Excel.

After recovery, inspect more than the first visible worksheet. Check formulas and key totals against another source, review hidden sheets if they matter to your work, and confirm that links, charts, and macros behave as expected. A workbook that opens without an error can still have lost or changed information. For a macro-enabled .xlsm file, do not enable macros unless you trust the file’s origin and understand why the macros are needed.

Reduce the Risk of Future File Problems

Use a reliable save location, allow cloud synchronization to finish, and avoid shutting down a computer while Excel is saving. For important workbooks, keep more than one recovery route: for example, cloud version history plus a separate backup. Save meaningful milestones under distinct filenames when a workbook is especially valuable, and periodically confirm that backups can actually be opened.

AutoSave can save changes automatically for eligible files stored in OneDrive or SharePoint, while AutoRecover helps preserve work during certain unexpected closures. Their availability and behavior depend on the workbook’s location and Excel settings. Neither feature guarantees recovery from every form of corruption, deletion, or storage failure. A separate backup remains important for files that cannot be recreated.

Frequently Asked Questions

Can a corrupted Excel file be repaired?
Sometimes. Excel’s Open and Repair feature can restore some workbooks, and Extract Data may recover values or formulas when full repair fails. The outcome depends on what is damaged, so preserve the original and verify any recovered content.

Does an Excel error mean my file is corrupted?
No. The cause could be an incomplete download, incorrect extension, access restriction, Protected View, an add-in, or an Excel problem. Check whether other workbooks open and whether the affected file works from another location or device.

Can I recover an Excel file I did not save?
Possibly. In Excel for Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel created a usable unsaved copy; it is not guaranteed.

Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, or the file may be incomplete or damaged. Renaming the extension alone will not convert the file. Ask for a fresh copy or export if possible, then try Open and Repair on a duplicate.

Is it safe to use an online Excel repair tool?
Consider the privacy risk before uploading a workbook. It may contain sensitive information, and an unfamiliar service may not handle it securely. Prefer Excel’s built-in recovery options, a trusted backup, or your organization’s support team for confidential files.

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.