To check whether an Excel file is corrupted, first make a separate copy, then open the workbook in desktop Excel and confirm that its sheets and key contents display correctly. Save the copy, close it, and reopen it. If Excel reports a problem, use File > Open > Browse > the arrow beside Open > Open and Repair. These checks can reveal common damage, but no single check can prove that every cell, formula, or feature is intact.
The steps below are for Microsoft Excel for Microsoft 365 on Windows. Protecting the original matters: repair attempts and format changes can remove or alter content, so work on a duplicate whenever possible.
What You’ll Need
- The Excel file you want to check and enough disk space to make a separate copy.
- Desktop Excel for Windows. Excel for the web can help you check whether a workbook opens, but it does not provide the Windows Open and Repair command.
- If the file came from an email, shared drive, or download, access to the original source in case you need a fresh copy.
Step-by-Step
-
Keep the original unchanged. Close the workbook if it is already open. In File Explorer, copy the file and paste the duplicate into a separate folder, such as Documents or a temporary verification folder. Give the duplicate a clear name, for example
QuarterlyReport-check.xlsx. If the workbook is on a network drive or removable device, copy it to your computer before testing; a connection problem can look like file damage. Do not rename the file extension as a way to fix it. -
Check that the copy is complete. In File Explorer, confirm that the copied file has a sensible file size and the expected extension, such as
.xlsxor.xlsm. A zero-byte file is unusable, and a much smaller copy than expected may indicate an incomplete transfer. A plausible size is not proof that the workbook is healthy, however. If it was downloaded or transferred, compare its size with the source when available, or download or copy it again before proceeding. -
Open the copy normally in Excel. Start Excel, choose File > Open > Browse, locate the duplicate, select it, and choose Open. You can also double-click the copy in File Explorer. Notice any message about unreadable content, repairs, missing records, or an unsupported format. If Excel opens the file in Protected View, that is a security precaution for files from some locations; it does not by itself mean the workbook is corrupted. Only choose Enable Editing if you trust the file and its source.
-
Look for signs that important content is missing or damaged. Check that the expected worksheet tabs are present, and select several sheets rather than relying only on the first one. Look at important ranges, charts, tables, images, pivot tables, and named areas that the workbook is meant to contain. Verify a few known values and formulas, and check whether formulas show results or errors you did not expect. If the workbook normally uses macros, confirm that it is still an
.xlsmfile and do not disable macros if your task depends on them. An unfamiliar warning or an external-link prompt is not, by itself, evidence of corruption. -
Save a verification copy and reopen it. In the copy, choose File > Save As, select a location you can easily find, and save under another new name. Keep the workbook in its original format: for example, save an
.xlsmas an Excel Macro-Enabled Workbook rather than changing it to.xlsx, which does not preserve VBA macros. If Excel warns that features may be lost in the selected format, cancel and choose the matching format. After saving, close the workbook, then open the newly saved copy again. Confirm that it still opens and that key sheets, values, formulas, and features remain available. -
Use Open and Repair if normal opening fails or Excel reports a problem. In Excel, choose File > Open > Browse and select the affected copy. Click the small arrow beside the Open button, choose Open and Repair, and then select Repair. If Repair does not work, repeat the process and choose Extract Data instead, if Excel offers it. Extract Data is an attempt to recover values and formulas; it may not restore formatting, charts, macros, or other workbook features. Save any recovered material under a new name and compare it with the original if you can.
-
Optionally test the package without changing it. Modern
.xlsxand.xlsmworkbooks use a ZIP-based package structure. If you already have a reputable archive utility such as 7-Zip, you can use its archive test function on a copy. An archive error can indicate that the package is damaged, but a successful test only checks the package structure; it does not confirm that Excel can use every workbook component. Do not extract and repack the workbook as a repair method, because that can cause additional problems. Skip this optional check if you are not comfortable using archive tools.
If the copy opens without a repair warning, passes the relevant content checks, and can be saved, closed, and reopened, you have reasonable evidence that it is usable. The level of confidence depends on what you checked: a workbook with complex macros, links, or pivot tables needs those features checked specifically.
Common Mistakes
- Treating a successful open as a complete guarantee. Excel may open a workbook while a particular chart, macro, or formula is missing or altered. Check the features that matter for your use.
- Testing the only copy. Repair, saving, or changing formats can affect content. Keep the source untouched and work on duplicates.
- Changing the extension to force an open. Renaming
.xlsxto.xls, or the reverse, does not convert the workbook and can make diagnosis harder. Use Save As to convert formats, and only when conversion is appropriate. - Assuming every warning means corruption. Protected View, a password prompt, disabled macros, compatibility notices, and external-link warnings can have causes unrelated to file damage. Read the message and assess the source before taking action.
- Overwriting the source with a repaired result. A repair may recover only part of a workbook. Save the repaired version separately so you can compare it with the original or try another recovery route.
Tips
- For important workbooks, keep a backup before checking or repairing them. If a file is shared, ask other users to close it before copying it, so you do not test a partially synchronized or actively changing version.
- When receiving a file from someone else, ask the sender to attach or upload it again if it will not open. A fresh copy can distinguish a transfer problem from a problem in the workbook itself.
- Check a few representative areas, including a sheet with formulas and one with special features such as a chart or pivot table. For a business-critical workbook, compare key totals with a trusted source rather than relying on appearance alone.
- If a file opens in Excel for the web but not desktop Excel, or the reverse, record the exact message and the app used. Differences can relate to features or access permissions, not necessarily corruption.
- On Mac, Excel does not offer the same Windows Open and Repair workflow. Keep a backup, try opening and saving a duplicate in Excel for Mac, and ask for a fresh copy if the issue persists. Excel for the web can be a useful additional opening check, but it is not a substitute for testing features in desktop Excel.
Troubleshooting
Excel says the file format or extension is not valid. Confirm that you are opening the correct file and that its extension matches the format in which it was created. The extension may have been changed accidentally, or the download may be incomplete. Ask for a fresh copy from the source. Avoid changing the extension at random; if you know the actual format, open it from Excel using File > Open > Browse and select the appropriate file type where available.
The workbook will not open, even from a local folder. Try Open and Repair on a duplicate. If that fails, use Extract Data if offered, or request another copy. For an .xlsx or .xlsm file, an archive utility’s test may reveal a damaged package, but it cannot repair the workbook reliably. If the file is password-protected, obtain the correct password; a password prompt is not a corruption message.
Excel opens the workbook but some content is missing. Check whether you opened the expected file and whether a filter, hidden worksheet, or collapsed outline is concealing content. Then compare the workbook with a backup or the sender’s copy. If Excel displayed a repair log or notification, note what it says before saving. Keep the opened original unchanged and save any recovered version under a different name.
The file opens on one computer but not another. Confirm both computers are using a compatible Excel version and that the file has fully synchronized or downloaded. Some workbook features may be unsupported in Excel for the web or an older Excel release. If the same desktop Excel version gives different results, copy the file locally and check permissions, available storage, and whether another process is using it. These problems can imitate corruption without proving it.
Frequently Asked Questions
Can Excel confirm that a file is completely uncorrupted?
No. Opening, saving, and reopening checks for common problems, but Excel does not provide a universal pass/fail certificate for every formula and feature. Verify the workbook areas that matter to your task.
Does a file that opens successfully mean it is safe to use?
Not necessarily. It may still have missing or changed content, and a workbook can contain unsafe macros or links even when it is structurally readable. Check its source, review security warnings, and verify important results before relying on it.
What is the difference between Repair and Extract Data?
Repair attempts to recover a workbook while preserving as much structure as possible. Extract Data focuses on recovering values and formulas when repair fails, and may omit features such as formatting, charts, or macros. Neither option guarantees full recovery.
Can I check an Excel file without installing Excel?
You can try opening it in Excel for the web if you have access, or use a ZIP archive test for an .xlsx or .xlsm copy. These checks have limits: they do not fully validate workbook behavior, and the archive test is not an Excel repair tool.
Should I save a repaired workbook over the original?
No. Save it under a new name and retain the original until you have checked the recovered content. This gives you a way to compare versions or try a different recovery method if needed.
Related
- Flash Fill in Excel: Find the Button and Use It Correctly
- Fit Columns to Text in Excel: Quick Methods and Fixes
- Fixing a Corrupted Excel File: Recovery Steps
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Solver Too Many Variable Cells? Fix the 200-Cell LimitExcel’s built-in Solver add-in allows up to 200 changing variable cells in a model. If your model needs…
- Excel Freeze Panes Not Working? Fix the Common CausesIf Excel Freeze Panes is not working, first choose the cell just below the rows and to the…
- Excel Arrow Keys Not Moving Cells? Fix ItIf Excel’s arrow keys are scrolling the worksheet instead of moving the active cell, turn off Scroll Lock:…
- Excel Cell Outline Not Showing? Fix the Selection BorderIf an Excel cell outline is not showing, first identify which outline is missing: gridlines, a formatted cell…
- Excel Equal Formula Not Working? Common FixesIf an Excel equality formula is not working, first check that it is entered as a formula and…
- ISBLANK Not Working in Excel? Find the Real CauseISBLANK is usually working as designed: it returns TRUE only when the cell it checks has no contents.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.