How to Tell If Your Excel File Is Corrupted: Key Signs

You can suspect an Excel file is corrupted if Excel cannot open it, displays a repair warning, or shows damaged or missing workbook content. Check the file in Excel, compare it with a known-good copy, and try opening a duplicate before attempting any repair. These checks help you distinguish corruption from common problems such as a wrong file extension, a sync delay, or a blocked download.

What You’ll Need

The file you want to check, plus its original location or download source if available.
Microsoft Excel for Microsoft 365 on Windows. If you use a Mac or Excel for the web, see the differences below.
A safe place to save a separate copy, such as a local folder or an external drive.
Any earlier version of the workbook, if one exists, for comparison.

Step-by-Step

Preserve the original file. Before testing or repairing it, make a copy in File Explorer. Right-click the file, choose Copy, open a different folder, and choose Paste. Give the copy a clear name, such as Workbook-check-copy.xlsx. Keep the original unchanged until you know whether the copy opens and contains the expected data. If the file is on a network drive or cloud service, download or copy it to a local folder first; this helps separate a file problem from a connection or sync problem.
Check the file name, extension, and size. Confirm that the name ends in a file type Excel supports, such as .xlsx, .xlsm, or .xls. In File Explorer, turn on View > Show > File name extensions if you cannot see the ending. A file named report.xlsx.xlsx may simply have a confusing name, while changing a PDF or CSV extension to .xlsx does not convert it into a real Excel workbook. Check the file size in Properties. A size of zero bytes, or a file far smaller than an earlier copy, is a warning that a download or transfer may have been interrupted, although size alone cannot prove corruption.
Open Excel first, then open the copy from inside the app. Start Excel and choose File > Open > Browse. Select the copied file and choose Open. Watch for a specific message. Excel may say that the file format or extension is not valid, that it cannot open the file, or that it found unreadable content and offers to repair it. Write down the exact wording. A repair prompt is meaningful evidence of a problem, but it does not tell you whether every sheet or feature is damaged. A request for a password, an access-denied message, or a Protected View bar is not, by itself, proof of corruption.
Look for damaged content if the workbook opens. If Excel opens the file, check whether expected worksheets are present and whether their names, cell values, formatting, charts, and formulas look right. Look for blank areas where data should be, error messages that were not there before, objects that appear missing, or formulas replaced by values. Compare important totals and a few representative cells with a trusted source or an earlier version. A workbook can open successfully and still have lost or altered content, so opening is only one check.
Try Excel’s repair option on the copy. In Excel for Microsoft 365 on Windows, choose File > Open > Browse. Select the copy, then click the arrow beside the Open button and choose Open and Repair. In the dialog, choose Repair first. If Excel cannot repair the workbook, repeat the process and choose Extract Data, which may recover values and formulas but can omit formatting, charts, or other features. Save recovered content under a new name; do not overwrite the original. Open and Repair is a Windows desktop feature and may not appear in Excel for Mac or Excel for the web.
Compare with another version or opening method. If available, open an earlier version from your backup or cloud version history and compare the same sheets and key data. For a copy stored in OneDrive or SharePoint, check its version history from the service or through File > Info when that option is available. You can also try opening the local copy in Excel for the web or a different current desktop installation. If only one installation or one location fails, the cause may be a local app, permission, or sync issue rather than damage to the workbook itself. Avoid repeatedly saving a questionable file while comparing it.
Decide whether the evidence points to corruption. Corruption is more likely when Excel repeatedly reports unreadable content, Open and Repair is needed, or the same workbook shows missing or altered content on more than one device. It is less likely when the file opens normally elsewhere, has a password or access restriction, or works after a complete download. If you recover the file, check the recovered workbook against your source data before relying on it. Preserve both the original and the repaired copy until the contents have been verified.

Common Mistakes

Changing the extension to force a file to open. Renaming a file from .csv, .pdf, or another type to .xlsx does not turn it into an Excel workbook. Use the program that created it, or obtain a proper Excel export from the source.
Repairing or saving over the only copy. Repair may discard elements or recover only part of the workbook. Always test a duplicate, save recovered data as a new file, and keep the original until you have checked the result.
Treating every warning as corruption. Protected View, a password request, missing permissions, an unsupported feature, or an untrusted download can prevent normal use without indicating damaged workbook contents. Read the full message and check access and file origin first.
Assuming a successful open means everything is intact. Excel might open a workbook after removing unreadable content. Inspect the sheets and compare important information rather than relying only on the fact that the window appeared.
Trying random repair tools or macros. Untrusted utilities can expose sensitive data or make recovery harder. Prefer Excel’s built-in options and a known backup. Do not enable macros in a file you do not trust just to investigate an opening problem.

Tips

Keep a separate backup of important workbooks and, for OneDrive or SharePoint files, know where to find version history. A backup is more useful than repeated attempts to repair the only file.
When a workbook is shared, ask whether another person can open it and whether they see the same warning. Make sure everyone is checking the same version, not an old local copy.
For a downloaded attachment, download it again from the original source instead of forwarding or renaming the first copy. A partial download can look like a damaged workbook.
If Excel opens the workbook after repair, check formulas, named ranges, links, charts, pivot tables, and macros if the file uses them. Some features may not be obvious from a quick visual scan.
Use an appropriate file type when saving. For example, a workbook with macros generally needs the .xlsm format to retain them; saving it as .xlsx can remove macro content. A warning about unsupported features may concern the save format, not corruption.

Troubleshooting

Excel says the extension or format is invalid. Check the actual extension and confirm how the file was created. Ask the sender to export or resend it as a genuine Excel workbook. If it came from an email or website, download it again and compare the new file size with the first one. Do not assume that changing the extension will fix it.

Excel says the file is in use or you do not have permission. Close other Excel windows that may have the workbook open, then check that you can access the folder and have permission to edit or copy the file. For a shared workbook, ask the owner or administrator to confirm access. These messages usually concern a lock or permissions, not necessarily corruption.

Open and Repair is unavailable or fails. Confirm that you are using desktop Excel for Windows and are selecting the arrow beside Open in the File > Open > Browse dialog. If the command is still unavailable, try a different current Windows installation or restore an earlier version. If repair fails, use Extract Data if offered, then check every recovered value against a reliable source. Excel for Mac and Excel for the web do not provide the same Windows Open and Repair command.

The workbook opens, but some information is missing. Check the repair message and any recovery log or status information Excel displays. Compare with a previous version, backup, or the original data source. If the missing content is critical, stop editing the repaired copy and preserve it as evidence while you seek another backup or support from your organization.

The file works on one device but not another. Update Excel if your organization permits it, confirm both devices can access the file, and test a fresh local copy. Differences in Excel versions or features, add-ins, account permissions, and sync status can explain inconsistent behavior. A failure on a single device alone is not enough to conclude that the workbook is corrupted.

Frequently Asked Questions

Can a corrupted Excel file still open?
Yes. Excel may open a workbook while reporting that it repaired or removed unreadable content. Check the repair notice and verify important sheets, formulas, and data against a trusted copy.

Does an Excel repair warning always mean the whole file is corrupted?
No. The issue may affect only part of the workbook, or Excel may be reacting to a file-format mismatch. Preserve a copy, read the warning, and inspect the workbook after opening or repair.

Can I tell whether a file is corrupted without opening it?
You can look for clues such as a zero-byte size, an incomplete download, or an unexpected extension, but those checks cannot confirm corruption. An opening attempt in Excel and comparison with a known-good version provide stronger evidence.

Is it safe to use Open and Repair?
It is a built-in Excel recovery option, but repair can remove damaged content. Use it on a duplicate and save the result under a new name. Keep the original until you verify the recovered workbook.

What should I do if I have no backup?
Keep the original unchanged, make a copy, and try Open and Repair on the copy in Excel for Windows. If Excel offers Extract Data, save that result separately. Check recovered information carefully and ask the sender or file owner for another copy if possible.

Does a workbook that opens normally need no further checks?
Not necessarily. Review the sheets and key calculations, especially if the file previously showed warnings or lost content. Compare important values with the source data before using the workbook for decisions or sharing it.

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.