Check If an Excel File Is Corrupted: Signs and Fixes

To check whether an Excel file is corrupted, make a copy and try opening it in Excel; if Excel reports a problem or cannot open it, use its built-in repair option on the copy. If the workbook opens normally, inspect important sheets, formulas, charts, and data before deciding that it is healthy: a file can open while still having missing or damaged content.

What Excel file corruption means

An Excel workbook is a structured file containing worksheets and other elements, such as formulas, styles, charts, tables, and sometimes macros or connections to external data. Corruption means some of that file structure or its contents have become damaged or unreadable. It does not necessarily mean every sheet or value is lost. Excel may be able to open the workbook, recover some content, or report that it cannot read the file.

There is no single visual check that proves a workbook is completely intact. A successful open is a useful first sign, not a guarantee that every feature is present and correct. Conversely, an opening error does not prove the workbook itself is corrupt. A blocked download, incorrect file extension, unavailable network location, incompatible file format, or Excel add-in can also prevent a workbook from opening.

Signs a workbook may be damaged

Possible warning signs include an error when opening the file, Excel closing unexpectedly while loading it, or a repair message saying that content was removed or repaired. After opening, look for specific changes: missing worksheet tabs, blank areas that previously contained data, broken charts, formulas replaced by values or errors, or formatting that has disappeared. Compare the workbook with a known-good copy if one exists.

Excel cannot read the file: The message may say the file format or extension is invalid, or that Excel found unreadable content.
Excel opens a repaired version: Read the repair report or message. It may identify removed elements, but it does not always describe every practical consequence.
Only one copy or location fails: A damaged download or an unstable network connection may be the issue rather than the original workbook.
Parts of the workbook behave differently: Check formulas, named ranges, charts, PivotTables, links, and macros that matter to your work.

A warning about macros or Protected View is not, by itself, evidence of corruption. Those are security protections. Likewise, a formula returning an error can result from changed source data, a missing link, or a calculation issue rather than file damage.

Run safe checks before repairing

Start with checks that do not alter the original. Close Excel if it is still trying to open the workbook, then make a separate copy using File Explorer. Keep the original untouched, particularly if it is the only available copy. If the file is on a shared drive, cloud folder, USB drive, or email attachment, copy it to a local folder and try that copy. A network interruption or incomplete download can look like corruption.

Check the file size in File Explorer. A zero-byte file, or a file far smaller than an earlier copy, may be incomplete. Size alone does not prove damage.
Confirm the extension and source. Common Excel formats include .xlsx, .xlsm, .xlsb, and the older .xls format. Do not simply rename an extension to make a file open; changing the name does not convert its contents.
Try opening another workbook in Excel. If several unrelated files fail, investigate Excel, an add-in, or the computer before concluding that one workbook is damaged.
If the file came from a website or email, download it again from the trusted source. Do not disable security features or enable macros just to get past an unfamiliar warning.

If a workbook opens in Excel for the web but not in desktop Excel, or the reverse, note the difference. The two versions do not support every feature identically, and a feature or compatibility issue may explain the behavior without proving that the file is corrupt.

Use Excel’s Open and Repair tool on Windows

In Microsoft Excel for Microsoft 365 on Windows, use Open and Repair when a workbook will not open normally or Excel reports unreadable content. First make a copy. Then open Excel, choose File > Open > Browse, and navigate to the copied workbook. Select the file, click the arrow next to the Open button, and choose Open and Repair. If Excel offers a choice, select Repair first.

Repair attempts to recover as much of the workbook as possible. If that does not work, repeat the steps and choose Extract Data if Excel offers it. This option may recover values and formulas even when Excel cannot restore the workbook as a fully functioning file. The exact content recovered depends on what remains readable; it is not a promise that every sheet, formula, chart, macro, or formatting detail will survive.

After either option succeeds, save the recovered workbook under a new name and, where appropriate, in a suitable Excel format. Do not overwrite the only original. Review Excel’s repair information and compare the result with other copies or source records. If the workbook contains macros, retain the correct macro-enabled format, such as .xlsm, rather than saving it as .xlsx and discarding macro support.

Check the repaired workbook carefully

Opening a recovered workbook is only the beginning of verification. Start with the content that would matter most if it were wrong: key totals, dates, identifiers, formulas, and records near the areas Excel reported as damaged. Compare those values with a prior version, exported source data, or another trusted record. Pay particular attention to formulas that refer to other sheets or workbooks, because a missing reference can produce a plausible-looking but incorrect result.

Confirm that the expected worksheet tabs and important ranges are present.
Check representative formulas and totals, not only whether cells display numbers.
Review charts, tables, PivotTables, defined names, links, and data connections used by the workbook.
If the file uses macros, verify that the code and expected macro behavior remain available. Do not run code from an untrusted file.
Save, close, and reopen the recovered copy. This can reveal a problem that was not obvious during the first open.

For workbooks used for reporting or operational decisions, a visual inspection may not be enough. Reconcile important totals with the original data source and have the responsible person review the recovered file before relying on it.

Other ways to recover an earlier copy

If repair fails or the recovered content is incomplete, look for a known-good earlier version before attempting more changes. If the workbook is stored in OneDrive or SharePoint, check its version history and restore or download an earlier version. The available versions depend on the storage location, account, and retention settings. Keep the damaged file until you have confirmed that the earlier version contains what you need.

Also check Excel’s recovery options after an unexpected shutdown. On Windows, Excel may show a Document Recovery pane when it starts again. You can also look under File > Info > Manage Workbook for available recovered or unsaved versions; the exact entries depend on whether recovery data was saved and the workbook’s state. These options are not guaranteed backups, and they may not help if the file was damaged during saving.

For files stored locally, check any backup system or Windows File History if it was configured. A colleague may also have a separate copy, but confirm its date and content rather than assuming it is current. Restoring an earlier version can recover a clean workbook while losing later edits, so compare versions before replacing anything.

Common causes and how to reduce risk

Workbook damage can follow an interrupted save, a computer shutdown, a storage-device problem, or a failed transfer. A file may also be incomplete if a download or copy stopped early. These are possibilities, not a diagnosis: an error can have other causes, and the file’s history may not reveal exactly what happened.

Reduce the risk by keeping independent backups, allowing saves and cloud synchronization to finish, and avoiding unplugging storage while a workbook is being written. For important files, use a sensible naming or versioning system rather than repeatedly replacing the only copy. If a workbook is unusually large or complex, consider whether all embedded objects, connections, and historical data are still needed, but do not remove content from the only copy as a troubleshooting experiment.

Do not treat changing .xlsx to .xls or another extension as a repair method. The extension identifies a format; renaming does not rebuild the workbook’s internal structure. Avoid third-party repair services for sensitive files unless you understand their privacy and security practices. A workbook can contain confidential business or personal information, and uploading it may share that information with another organization.

Excel for Mac and Excel for the web

The Open and Repair instructions above are for Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web have different interfaces and may not offer the same Windows repair command. On a Mac, first make a copy, try opening it in the desktop Excel app, and check for a usable version in the file’s cloud version history or backup. Do not assume that a Windows menu path or repair option exists on Mac.

Excel for the web can be a useful comparison when a file fails in the desktop app, but it is not a general-purpose file-repair tool. Some workbook features are handled differently or are unavailable in the browser. If the web version opens the file, inspect the content and save a separate copy if appropriate; still verify essential formulas and features in the version of Excel used for the work.

Frequently Asked Questions

Can an Excel file be corrupted if it still opens?
Yes. Excel may open a workbook with missing or repaired content, and damage may affect only particular elements. Check the repair message and compare important sheets, formulas, charts, and data with a trusted copy.

Does a file format or extension error mean the workbook is corrupted?
Not necessarily. The extension may not match the file’s actual format, or the file may be incomplete, blocked, or incompatible. Confirm where it came from and try a fresh copy before assuming the contents are damaged.

Will Open and Repair restore everything?
No. It attempts to recover readable content, but some elements can be lost or changed. Review the repair report, save to a new file, and verify important contents against another source.

Can I repair an Excel file without Excel?
You can check for a backup or earlier cloud version without Excel, but a different spreadsheet program is not a guaranteed repair method and may handle Excel features differently. For an important workbook, preserve the original and use a trusted copy or Microsoft Excel where possible.

Should I upload a damaged workbook to an online repair site?
Only after considering the information it contains and the service’s privacy terms. A workbook may hold confidential data or macros. Prefer a trusted backup or Excel’s built-in options when possible, and never upload sensitive content to a service you do not trust.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.