How to Know If an Excel File Is Corrupted and What to Check

Formulas & functions · Updated November 21, 2026

To check whether an Excel file is corrupted, first make a copy, then try opening that copy in desktop Excel. If Excel reports unreadable content, fails while other workbooks open normally, or displays missing or damaged data, corruption is possible—but a bad download, incompatible format, add-in, or storage problem can look similar. Compare the file in another location or Excel version, then use Excel’s repair option on the copy if needed.

What You’ll Need

  • The workbook file and enough storage space to save a separate test copy.
  • Microsoft Excel for Microsoft 365 on Windows, preferably updated. If you use Excel for Mac or Excel for the web, some diagnostic and repair options differ.
  • Access to the file’s original source, such as an email, shared folder, or cloud storage version history, if you need to compare or restore it.

If the workbook contains confidential information, do not upload it to an unfamiliar online repair service. Keep the original unchanged while you investigate.

Step-by-Step

  1. Protect the original before testing. In File Explorer, copy the workbook and paste the duplicate into a local folder such as Documents. Give the copy a clear name, such as Budget-test.xlsx. Do not rename the only original, overwrite it during repair, or save changes over it. If the file is on OneDrive or SharePoint, check that it has finished syncing before copying it; a partially synced download can resemble a damaged workbook. For a file on a network drive, make a local copy if you have permission.
  2. Check the file itself and its extension. In File Explorer, look at the file size and confirm it is not zero bytes or unexpectedly tiny compared with a known-good copy. Right-click the file, choose Properties, and check its name and location. Confirm the extension matches the actual file type: for example, an Excel workbook is commonly .xlsx, while a macro-enabled workbook is .xlsm. Do not simply change an extension to make a file open; that does not convert its contents and can obscure the real problem. If Windows hides extensions, turn on View > Show > File name extensions in File Explorer.
  3. Try opening the test copy in desktop Excel. Start Excel first, then choose File > Open > Browse and select the duplicate. Note the exact error text and whether it appears before or after the workbook window opens. A message that Excel cannot read the file or found unreadable content is a warning, but not proof of corruption. A password prompt, blocked-file warning, or request to enable editing may instead reflect the workbook’s security settings. Do not enable macros just to test whether a file opens.
  4. See whether the problem is limited to this workbook. Open a different, known-good Excel workbook from the same computer. If that also fails, Excel itself, an add-in, a recent update, or the Windows profile may be involved. If the other file opens normally but the suspect workbook does not, the issue is more likely tied to that file or its source. Also try creating a blank workbook with File > New > Blank workbook. If Excel cannot create or save one, investigate the application or storage before concluding the original file is corrupt.
  5. Get a fresh copy from the source. If the workbook came from email, a website, or a shared drive, download or copy it again rather than repeatedly opening the same local copy. Compare the new copy’s size with the first one. Ask the sender to confirm that their version opens and, if possible, send it again as an attachment or through the original sharing service. For OneDrive or SharePoint files, use the service’s version history to check for an earlier version. A successful fresh copy points to an incomplete transfer or sync problem rather than necessarily damaged workbook contents.
  6. Use Open and Repair on the duplicate in Windows Excel. In Excel, choose File > Open > Browse. Select the test copy, click the arrow beside the Open button, and choose Open and Repair. Choose Repair first if Excel offers a choice; Excel may report what it recovered. If Repair does not work, repeat the process on another copy and choose Extract Data, if that option is offered. Extract Data may recover values and formulas while leaving formatting, charts, or other workbook features behind. Save recovered content under a new name and inspect it before relying on it.
  7. Check whether Excel for the web or another computer behaves differently. If you have access to a trusted computer, test a copy there with a compatible Excel version. You can also try Excel for the web through OneDrive, but a web version opening successfully does not prove every feature is intact: macros, connections, controls, or some formatting may behave differently. Upload only to an account and storage location approved for the file’s sensitivity. If the file fails in several independent environments while other workbooks work, that strengthens the case that the workbook itself is damaged.
  8. Inspect the recovered workbook before treating it as fixed. Compare sheet names, row and column counts, key totals, formulas, charts, images, and named ranges with a prior copy or a trusted source. Look for blank sheets, error values, missing formatting, or warnings about removed records. Check important formulas by selecting a few cells and reviewing the formula bar. If the workbook is macro-enabled, confirm that required macros and buttons are present, but do not run unknown macros. Keep the original, the damaged test copy, and the recovered file until you have verified the data and saved a separate backup.

Common Mistakes

  • Assuming every opening error means corruption. A file can fail because it is still downloading, has the wrong extension, is password-protected, or is being accessed through an unreliable network connection. Test other files and obtain a fresh copy before diagnosing the workbook.
  • Repairing the only copy. Repair tools can remove damaged parts, and saving the result may replace useful evidence or data. Work from a duplicate and save any recovered result under a new name.
  • Changing the extension or trusting a file-size clue by itself. Renaming a file does not fix its internal structure. A small but valid workbook may contain little data, while a large file can still be damaged. Treat size as one clue among several.
  • Ignoring the exact error or what changed. Record the full message, when the failure began, and whether the file was emailed, synced, renamed, or saved by a different program. These details help distinguish a workbook problem from a transfer or compatibility issue.
  • Enabling content or uploading sensitive data too quickly. Macros and external links are not repair steps. Avoid enabling them during diagnosis, and do not send confidential workbooks to third-party sites without authorization.

Tips

  • Keep version history or routine backups for important workbooks. OneDrive and SharePoint version history may let you restore a copy from before the problem started.
  • When a workbook is actively being edited by multiple people, confirm nobody is saving it before making a local copy. A copy taken during a sync or save can be incomplete.
  • Record which Excel version and operating system produced the error. A workbook created with newer features can behave differently in an older version without being corrupted.
  • If Excel opens the file but displays a yellow Protected View bar, use caution and verify the sender. Protected View is a security feature, not by itself evidence that the workbook is damaged.
  • For a workbook that opens with a repair log, keep that log if available. It can identify removed formulas, styles, or drawing parts and help you decide what to compare manually.

Troubleshooting

Open and Repair is unavailable or does not help: Confirm you are using the Windows desktop application and selecting the arrow beside Open in File > Open > Browse. Excel for the web does not provide the same desktop Open and Repair workflow. On a Mac, test a duplicate in desktop Excel and look for any recovery prompt; the Windows menu path is not available in the same form. If repair fails, retrieve an earlier version from the file’s cloud or backup history before trying more invasive recovery methods.

The file opens, but content is missing: Do not save over the source. Check whether the affected sheets are hidden by right-clicking a sheet tab and choosing Unhide, if available. Compare against an earlier version and inspect formulas, charts, and named ranges. A file can open successfully while still having lost some content, so opening alone is not a complete integrity check.

Excel freezes or crashes while opening it: First test a local duplicate and a different workbook. On Windows, close Excel, press Windows key + R, type excel /safe, and press Enter to start Excel in Safe Mode. Try opening the duplicate there. If it works in Safe Mode, an add-in or startup setting may be involved; review File > Options > Add-ins and investigate enabled add-ins carefully. Safe Mode is not the same as repairing the file. On Mac, there is no identical Windows Safe Mode command; restart Excel and test with add-ins disabled through Tools > Excel Add-ins, where available.

Several copies fail, or the file is zero bytes: Stop editing or renaming it and contact the sender, administrator, or storage provider for a clean copy. If no backup exists and the data is important, preserve all versions and seek help from your organization’s IT team or a reputable data-recovery professional. Avoid saving repeated repair attempts into the same location, which can make recovery harder.

Frequently Asked Questions

What are the clearest signs that an Excel file is corrupted?
Repeated unreadable-content or file-format errors, missing workbook parts, or a crash limited to that file are warning signs. They are not conclusive on their own; check the source and test another workbook too.

Can a corrupted Excel file still open?
Yes. Excel may open a workbook after removing or repairing some content. Check the sheets, formulas, charts, and key totals against a reliable earlier copy before assuming everything is present.

Does a file that will not open mean it is corrupted?
No. An incomplete download, sync conflict, permissions issue, password, unsupported feature, or Excel problem can prevent opening. Obtain a fresh copy and test other workbooks to narrow down the cause.

Is Open and Repair safe to use?
It is a built-in recovery option, but it may discard damaged elements. Use it on a duplicate and save any repaired result under a different name. Keep the original until you verify the recovered contents.

Can Excel for Mac repair a damaged workbook?
Mac Excel can sometimes open or recover a workbook, but it does not use the same Windows Open and Repair menu path described above. Test a duplicate and use any recovery prompt offered by your version; otherwise, try a trusted Windows desktop copy or restore a prior version.

How can I prevent workbook corruption?
Save to reliable storage, let cloud syncing finish, avoid interrupting a save, and keep backups or version history. For critical files, periodically open a backup copy and confirm it contains the data you expect.

Related

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.