To check whether an Excel file is corrupted, first make a copy, then try opening the copy in Excel for Microsoft 365 on Windows. If it will not open normally, use File > Open > Browse, select it, click the arrow beside Open, and choose Open and Repair. A successful open does not prove the workbook is flawless, so also check key sheets, formulas, and data before relying on it.
These checks help distinguish actual file damage from a wrong extension, incomplete download, unsupported format, or Excel add-in problem. The repair process can change or remove damaged content, which is why you should preserve the original before trying it.
What You’ll Need
- The Excel file and enough disk space to keep at least one separate backup copy.
- Microsoft Excel for Microsoft 365 on Windows, preferably updated. Excel for Mac can perform many of the same opening and content checks, but it does not offer the same Windows Open and Repair command.
- If the file came from someone else or a cloud service, access to the original sender or source so you can obtain a fresh copy for comparison.
Step-by-Step
-
Preserve the original before testing. Close Excel if the file is already open. In File Explorer, copy the workbook to a different folder, then give the copy a clear name such as Workbook-check.xlsx. Do not perform repairs on the only copy. If the file is on OneDrive, SharePoint, or a network drive, download or copy it locally first; a sync or connection issue can look like file damage. Keep the original unchanged until you have checked the result.
-
Confirm that the file is complete and has the expected type. Check that its name ends in a format Excel supports, such as .xlsx, .xlsm, .xlsb, or .xls, and verify with the sender which format they intended. A renamed file is not converted just by changing its extension: for example, changing .csv to .xlsx does not turn the contents into an Excel workbook. Compare the file size with the sender’s copy or a previous version if possible. A zero-byte file or a download that is much smaller than expected is a strong reason to download or copy it again, not to repair it.
-
Open the copy in desktop Excel. Start Excel, choose File > Open > Browse, select the copied workbook, and click Open. If Excel displays a warning that the file format or extension does not match, stop and verify the source and actual format before proceeding. If the workbook opens, look for repair or unreadable-content messages and note which sheets or records Excel names. Then check several important worksheets, including the first and last sheets, and try selecting cells in areas that matter. A file that opens with missing sheets, blank regions, or unexpected error messages may still be damaged.
-
Check whether the failure is specific to one copy or location. Close the workbook and open the original source again only if doing so will not overwrite a good version. Better, ask the sender to provide a new copy, or download the file again from the trusted source. If the fresh copy opens while the old local copy does not, the original transfer, sync, or storage copy may have been incomplete. If neither copy opens, keep investigating; the issue may be in the workbook itself, but a version or compatibility problem is also possible.
-
Try Open and Repair on the backup copy. In Excel, choose File > Open > Browse. Select the copied workbook once, but do not double-click it. Click the small arrow beside the Open button and choose Open and Repair. In the dialog, choose Repair first. Excel attempts to recover the workbook while retaining as much content as it can. Read any message it displays, and note whether it reports that it repaired or removed records. If Excel opens the file, immediately use File > Save As to save a new file under a different name. Do not overwrite the original.
-
Use Extract Data if Repair cannot open it. Repeat the Open and Repair steps on another copy and choose Extract Data if Excel offers it. Depending on the damage and workbook, Excel may offer to convert recoverable values or recover formulas. This can help retrieve useful contents, but it may not retain layout, formatting, charts, macros, or every formula. Save extracted data as a new workbook and inspect it carefully. Treat this as a salvage option, not proof that the original workbook has been restored perfectly.
-
Check the repaired workbook for missing or changed content. Compare the repaired copy with a known-good version, printed report, or source data if one exists. Review sheet names, row and column counts, formulas in representative cells, named ranges, charts, tables, and links that are important to the task. Pay special attention to the areas named in Excel’s repair message. A workbook can open successfully yet still have lost content. For macro-enabled files, confirm that required macros are still present; do not enable macros in a file unless you trust its source.
-
Rule out an Excel or add-in problem. If other workbooks also fail, close Excel and start it in Safe Mode: press Windows+R, type
excel /safe, and press Enter. Try opening the copied file. If it works in Safe Mode but not in a normal start, an add-in or customization could be involved. In Excel, check File > Options > Add-ins, then use the Manage list and Go button to review add-ins. Change one setting at a time and restart Excel to identify the cause. Safe Mode is a diagnostic check; it does not repair the workbook. -
Decide whether you have verified the file or only made it open. Consider the file usable only after it opens without an unexplained warning and its important data and features match a reliable reference. If the file contains critical business, research, or personal records and you cannot verify its contents, ask the owner for another copy or recover an earlier version rather than assuming a repaired file is complete.
Common Mistakes
Testing the only copy. Open and Repair may remove damaged records, so running it on the original can make recovery harder. Keep an untouched copy and save recovered work under a new name.
Assuming every opening error means corruption. Excel may reject a file because its extension is misleading, the download is incomplete, the workbook uses features from a newer version, or a security setting blocks it. Check the source and format before concluding the file is damaged.
Trusting the absence of a warning. A workbook can open while still missing formulas, charts, or other content. Inspect important areas and compare with a trusted copy or source data.
Using an online repair site for sensitive files. Uploading a workbook can expose personal or company information. Prefer Excel or an approved organizational recovery method unless you have permission to share the file with that service.
Renaming the extension to fix the workbook. Changing the filename suffix does not repair or convert the file’s internal structure. Use the application that created it, request a correctly exported copy, or use Excel’s recovery options.
Tips
- Keep the original file, a working copy, and any repaired copy in separate locations. Use names that make their status clear, such as original, test, and recovered.
- When a workbook is stored in OneDrive or SharePoint, check its version history if you have access. A previous version may be a safer recovery route than repairing a damaged current copy.
- For a workbook received by email or downloaded, obtain a new copy over a reliable connection before attempting multiple repairs. If possible, ask the sender to reopen and save it in a current Excel format.
- Record the exact error message and the steps that triggered it. This helps the file owner or IT support identify whether the problem follows the file, the computer, or the storage location.
- On Excel for Mac, try opening a duplicate through File > Open and check for any repair prompt Excel provides. If you need the Windows Open and Repair workflow, use a trusted Windows computer with Excel; menu options and recovery behavior can differ by version.
Troubleshooting
Open and Repair is missing. Confirm that you are using desktop Excel on Windows and navigating through File > Open > Browse. The command may not be available in Excel for the web or in the Mac interface. If you only have a Mac or browser access, preserve a copy and try desktop Excel for Windows or ask the file owner to provide a new workbook.
Excel says the extension does not match the format. Do not keep changing the extension. Ask the sender what application created the file and request a fresh copy saved as the intended format. If it is actually a text or CSV export, open it as that format and save a separate .xlsx workbook only after confirming the data is interpreted correctly.
The workbook opens in Safe Mode but not normally. Close Excel, reopen it normally, and investigate add-ins one at a time through File > Options > Add-ins. Disable a suspected add-in, restart Excel, and test the file again. If disabling add-ins does not help, update Office and contact your organization’s support team before changing other system settings.
Repair succeeds but important data is missing. Save the recovered workbook separately, then compare it with a previous version, the sender’s copy, or original source data. Check OneDrive or SharePoint version history if applicable. If formulas were replaced or sheets are absent and no reference copy exists, ask the workbook owner or IT support about backups; repeatedly repairing the same damaged file is unlikely to restore content that is no longer available.
Several unrelated workbooks fail to open. This points more toward an Excel installation, permissions, storage, or computer issue than damage to one workbook. Test a simple new workbook, check whether files open from a local folder, restart Excel, and make sure Office is up to date. If the problem persists, contact IT support rather than running repair attempts on every original file.
Frequently Asked Questions
How can I tell if an Excel file is corrupted?
Signs include an Excel error when opening, a repair notice, missing sheets or data, or a file that is unexpectedly empty. None is conclusive by itself; compare a fresh copy and inspect the workbook contents.
Can I check an Excel file without opening it?
You can check its size, extension, source, and whether the download completed, but those checks cannot confirm that all workbook content is intact. The reliable check is to open a copy in Excel and review the result.
Does Open and Repair always recover the workbook?
No. It may restore some or most content, fail entirely, or remove damaged records. Use it on a copy, read Excel’s report, and verify important content against a trusted reference.
Will Open and Repair delete my original file?
It should not replace the source when you open it through the repair dialog, but save recovered content under a different name and keep an untouched backup. That gives you a way back if the recovered version is incomplete.
Can a file be corrupted if it opens normally?
Yes. Some damage may affect only particular sheets, formulas, links, or objects. Check the parts you rely on and compare them with a known-good version instead of treating a successful open as a full validation.
What should I do if the repaired workbook contains critical missing data?
Stop editing the only recovered copy. Look for a previous cloud or local version, request another copy from the sender, or ask IT support about backups. If there is no reference or backup, Excel may not be able to reconstruct data that was lost.
Related
- Flash Fill Months in Excel: How to Extract Month Names
- Flash Fill Multiple Cells in Excel: Steps and Limits
- Excel Flash Fill in Polish: Name and How to Use the Feature
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel LEFT Function: Extract Text from the Left SideTo extract characters from the beginning of a cell in Excel, use the LEFT function. If A2 contains…
- Excel COUNTIFS With Multiple Criteria in One RangeYes. Excel’s COUNTIFS can apply more than one condition to the same range by repeating that range for…
- VLOOKUP Excel: Extended Uses, Examples, and LimitsVLOOKUP can do more than retrieve one value from a simple list: it can use exact or approximate…
- Excel SUMPRODUCT Sample Data: How to Use It in FormulasExcel’s SUMPRODUCT multiplies corresponding values in ranges and adds the results, so it can calculate totals such as…
- Conditional Formatting If Statements in Excel: A GuideIn Excel, an “if statement” for conditional formatting is usually a formula-based rule that returns TRUE or FALSE;…
- VLOOKUP Examples for Practice: Learn Excel Lookup SkillsFor a first VLOOKUP practice problem, put product IDs in A2:A6, prices in B2:B6, and the lookup ID…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.