Excel has no single command that proves a workbook is completely uncorrupted. To check a file, make a copy, open it in Excel for Microsoft 365 on Windows, and look for repair warnings or missing content; if you have a trusted original, compare the files’ SHA-256 hashes to verify they are identical.
What Excel file corruption means
A workbook is corrupted when some of its data or internal structure has been damaged, so Excel cannot read it correctly. The problem can be small, such as a damaged chart or formatting record, or serious enough that Excel cannot open the file. Corruption may follow an interrupted download, a device or network failure during saving, a failing storage device, or a sync conflict. A file extension that does not match the contents can also cause an opening error without proving that the workbook itself is damaged.
Excel workbooks can contain formulas, worksheets, charts, links, macros, and other components. A workbook that opens successfully may still have lost a feature or show incomplete information. Conversely, a warning or an unexpected result does not automatically mean corruption: an unsupported feature, a blocked macro, a broken external link, or a calculation setting can produce similar symptoms.
It is useful to separate two questions: “Can Excel read this workbook?” and “Is this the exact file I expected?” Opening and inspecting the workbook helps with the first. A hash comparison against a known-good copy helps with the second. Neither check alone proves that every formula or business value is correct.
Start with safe, simple checks
Before trying repairs, protect the original file and rule out common causes. Do not keep reopening and saving the only copy if Excel reports a problem; a repair or save may alter or remove damaged content.
- Make a copy of the workbook in a local folder, such as Documents. Keep the original untouched, especially if it came from a shared drive, email, or cloud service.
- Check the file size and name. A zero-byte file or a file much smaller than the sender’s expected version may indicate an incomplete transfer. A plausible size does not, by itself, establish that the file is healthy.
- Download or copy the file again from its source. If it was an email attachment, ask the sender to resend it; if it is in OneDrive or SharePoint, wait for syncing to finish and try the current cloud copy.
- Open a different workbook in Excel. If several unrelated files fail, the problem may involve Excel, an add-in, permissions, or the computer rather than this particular workbook.
- Try opening the affected file from Excel using File > Open > Browse instead of double-clicking it. This helps distinguish an Excel opening issue from a file association problem.
If Excel opens the copy without a warning, check that the expected sheet names, visible data, formulas, charts, and workbook structure are present. Compare important totals with a trusted source rather than assuming that a successful opening means all values are correct.
Use Excel’s Open and Repair option
On Excel for Microsoft 365 for Windows, the built-in repair command is a reasonable next step when Excel cannot open a workbook or reports that it found a problem with its contents. Work on a duplicate so that the original remains available if the repair changes anything.
- In Excel, select File > Open > Browse.
- Select the workbook in the file picker.
- Select the arrow next to the Open button, then select Open and Repair.
- Choose Repair first. If Excel cannot repair the workbook, use Extract Data if that option is offered, then review what Excel recovered.
Repair is an attempt to make the workbook readable, not a certificate that every component survived. Excel may remove damaged records or features. Afterward, check the repair message and inspect the workbook closely. Look at worksheets that contain important calculations, charts, tables, named ranges, connections, and macros. Compare key results to a known-good copy, printed report, or source system where possible. Save a repaired workbook under a new name, not over the original.
The Open and Repair workflow described here is for Excel on Windows. Excel for Mac does not provide the same Windows repair dialog. On a Mac, preserve a copy, try opening the file in the current Excel version, and ask the sender or service owner for a fresh copy. If a file opens but behaves oddly, copy its data into a new workbook only after checking what can be transferred; that process may not preserve every workbook feature.
Compare SHA-256 hashes when you have a trusted copy
A cryptographic hash is a short value calculated from a file’s bytes. If two files have the same SHA-256 hash, they are, for practical verification purposes, byte-for-byte identical. This is useful when checking whether a download matches a copy supplied by a sender or stored elsewhere. It does not show that the shared original was correct, nor does a different hash prove corruption: even a legitimate edit changes the hash.
On Windows, open PowerShell and run the following command for each copy, replacing the example path with the actual location:
Get-FileHash "C:\Users\Sam\Documents\Budget.xlsx" -Algorithm SHA256
Compare the SHA256 values shown for the two files. Matching values mean the files are identical. Different values mean at least one byte differs, which could be due to a normal edit, a different version, or damage. If the sender provides an independently communicated checksum, compare your downloaded file’s hash with that value. Do not treat a checksum downloaded from the same untrusted location as independent proof.
You can also use a reputable checksum utility if you prefer a graphical interface. On Mac, command-line users can calculate a SHA-256 hash with the built-in shasum utility in Terminal. Hash comparison checks file identity, not whether Excel can open the file or whether its contents make sense.
Check workbook contents, not just whether it opens
For a file that opens, verify the items that matter for its intended use. A quick visual scan is not enough for a large model, but a focused checklist can reveal missing or changed parts:
- Confirm expected worksheet names, sheet order, and approximate row and column counts.
- Check important formulas and totals against prior reports or trusted source data. Look for blank cells where formulas should be, unexpected error values, and formulas replaced by fixed numbers.
- Inspect charts, PivotTables, tables, named ranges, data validation, and conditional formatting if the workbook relies on them.
- Check external links and data connections. A prompt to update links, or a stale result, may mean the source is unavailable rather than that the workbook is corrupted.
- If the workbook contains macros, confirm that it is the expected macro-enabled file and that macros are handled according to your organization’s security rules. Do not enable macros simply to make an unfamiliar file work.
For a critical workbook, compare it with a previous version using an approved version-history or comparison process. One example: if a monthly sales workbook normally has 12 monthly tabs and a summary formula, verify both the tabs and the summary result. A workbook that opens but has lost the summary sheet is not an acceptable copy, even if Excel displayed no repair warning.
Common errors that can look like corruption
Some opening problems have causes other than damaged workbook data. If Excel says the file format or extension is not valid, check that the extension matches the actual file type and that the download completed. Renaming a file from one extension to another does not convert its format. For example, changing a CSV filename to end in .xlsx does not create a valid Excel workbook.
Compatibility can also be mistaken for corruption. A workbook made with a newer Excel feature may not behave the same in an older edition or another spreadsheet application. A workbook may open with a notice about unsupported features or show different formulas or formatting. Use a supported version of Excel and ask the file’s owner what program created it before concluding that the file is damaged.
Other signs may point to access or synchronization issues. A workbook marked read-only may be locked by another user or opened from a location where you lack edit permissions. A cloud file may still be syncing, and a network drive may temporarily be unavailable. Save a local copy if permitted, reconnect to the source, and check version history rather than repeatedly overwriting a shared file.
Recover data if the workbook still will not open
If Open and Repair fails, stop experimenting on the sole copy. Request a fresh copy from the sender or restore an earlier version from the organization’s approved backup or cloud version history. OneDrive and SharePoint may offer version history depending on the file location and account settings; availability and retention depend on the service and administrator policies.
When only some data is needed, Excel’s Extract Data option may recover values or formulas from a damaged workbook, although it may not preserve the original layout and features. If the workbook opens in another trusted compatible application, that may help recover readable content, but opening and resaving in a different program can change formatting, formulas, or specialized features. Keep a separate copy and compare the result before relying on it.
For business-critical or sensitive files, involve your IT support team or the file owner before using third-party repair tools. Such tools require access to the workbook and may not preserve macros, links, or other features. Avoid uploading confidential workbooks to an unknown online repair service. Once recovered, verify key figures against an independent source before using them for decisions.
Prevent future workbook damage
Prevention is mostly about keeping reliable copies and avoiding interrupted transfers. Save to a stable location, wait for cloud sync to complete before shutting down or disconnecting, and use version history or managed backups for important workbooks. If a workbook is on a network share, follow your organization’s instructions for editing and avoid having multiple people make conflicting copies.
For important handoffs, keep the original file and consider sharing a checksum through a separate trusted channel. A matching checksum can confirm that a recipient received the same bytes, while version history can help restore an earlier state after an unwanted edit. Neither replaces checking whether the workbook’s data and formulas are correct.
Frequently Asked Questions
Does Excel have a command to verify a file is not corrupted?
Excel does not provide a universal integrity certificate. Opening the workbook and inspecting it can reveal problems, and Open and Repair can attempt recovery. A hash can confirm that a file matches a trusted copy, but it cannot certify that the workbook is logically correct.
Can a file be corrupted if it opens normally?
Yes. Some damage may affect only a chart, formula, worksheet, or other feature, and Excel may still open the workbook. Check important content and compare critical results with a trusted source.
Does a different SHA-256 hash mean my Excel file is corrupted?
No. It means the files are not identical. Normal edits, a different saved version, or damage can all produce a different hash. You need a known-good reference and context to interpret the difference.
Will Open and Repair delete data?
It can remove damaged content or fail to recover some features. Use it on a copy, review the repair report, and save the recovered workbook under a new name. Keep the original until you have confirmed what was recovered.
Can I repair an Excel file on a Mac?
Excel for Mac does not use the same Windows Open and Repair dialog. Preserve the original, request a fresh copy, and try a current Excel version. For important files, seek help from the file owner or IT support rather than relying on an unverified repair tool.
Related
- QuickBooks Data Export to Excel: Steps and Options
- QuickBooks Excel and CSV Imports: What You Can Bring In
- Python Excel: Remove Duplicates with pandas or openpyxl
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- One-Row Data Table in Excel: How to Set Up and Use ItA one-row data table in Excel is a What-If Analysis tool that tests several possible values for one…
- Track Changes in Word: How to Remove ThemTo get rid of Track Changes in Word, first turn tracking off, then accept or reject the recorded…
- Excel Current Year: How to Get It with NOW and TODAYAs of 2026, the current calendar year is 2026. In Microsoft Excel for Microsoft 365 on Windows, enter…
- Schedule Email in Outlook: Choose a Send Time on Any DeviceYes. In new Outlook or Outlook on the web, compose your message, select the arrow beside Send, choose…
- Extract Text from an Image in Excel with Data from PictureTo extract a table from a photo or screenshot in Excel for Microsoft 365 on Windows, choose Data…
- Audit an Excel Sheet: A Practical Review ChecklistTo audit an Excel sheet, check its inputs, formulas, totals, data quality, hidden content, and external links, then…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.