Restore a Corrupted Excel File: Safe Recovery Guide

To restore a corrupted Excel file in Microsoft Excel for Microsoft 365 on Windows, first make a copy of the damaged workbook, then select File > Open > Browse, select the file, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, use Extract Data. Save any recovered content to a new file, because repair is not guaranteed and may not preserve every formula, format, or feature.

How to tell whether an Excel file is corrupted

A workbook may be damaged if Excel displays a message that it cannot open or read the file, reports an invalid file format or extension, or closes while loading it. Other clues include missing worksheets, garbled cell contents, formulas replaced by errors, or a workbook that opens only after repeated warnings. These symptoms do not prove corruption: a renamed file, an incomplete download, an incompatible feature, or a temporarily unavailable network location can cause similar trouble.

Check the file’s name and location before attempting repair. An Excel workbook commonly ends in .xlsx, .xlsm, .xlsb, or the older .xls format. An extension that does not match the actual file type can trigger an opening error. If the file is on a network drive, USB device, or cloud-synced folder, copy it to a local folder and try again; an interrupted transfer or sync may leave an incomplete copy. If other workbooks also fail to open, the issue may be Excel or the computer rather than this particular file.

Protect the original before trying fixes

Make a separate copy before using repair tools. In File Explorer, copy the workbook to another folder and give the copy a clear name, such as Budget-recovery-copy.xlsx. Keep the original unchanged. If the workbook is important, make a second backup on a different storage location. This gives you a way back if a repair attempt changes the file or if later recovery options produce different results.

Avoid repeatedly opening and saving the only copy. Excel may prompt you to save a recovered workbook, and accepting could replace useful data with a partial recovery. Do not change the extension by simply renaming the file; an .xlsx workbook is not converted into .xls by changing its name. Also avoid uploading confidential workbooks to an unfamiliar online repair site. Financial, customer, employee, and health information can be exposed when a file is sent to a third party.

Use Excel’s Open and Repair command

Open and Repair is the built-in Windows desktop option for attempting to repair a workbook that Excel cannot open normally. It is available in current Microsoft 365 desktop Excel, though the exact dialog wording can vary slightly. Use the copy rather than the original, and follow these steps:

Start Excel, then select File > Open > Browse. Use Browse to open the Windows file picker rather than double-clicking the damaged file.
Select the workbook once. Click the arrow on the Open button and choose Open and Repair.
In the dialog, choose Repair. If Excel opens the workbook, inspect the worksheets and save the result under a new name with File > Save As.
If Repair does not work, repeat the process on a fresh copy and choose Extract Data. This option may recover cell values and formulas even when Excel cannot restore the workbook structure.

Repair and Extract Data are different recovery attempts, not guarantees. Repair aims to preserve as much of the workbook as it can, including its structure, while extraction may prioritize recoverable information. Either result can omit content. If one attempt yields a partially useful file, save it separately before trying other methods. Do not assume that a workbook is complete just because it opens without an error.

Excel for the web does not provide the same Windows Open and Repair command. Excel for Mac also has different recovery options, and users should not assume that the Windows command is available there. If you have access to Excel for Microsoft 365 on Windows, try Open and Repair on a copy; otherwise, check cloud version history, local backups, and any AutoRecovery files available in your version of Excel.

Look for an earlier or automatically saved copy

A previous version is often more complete than a repaired file. If the workbook is stored in OneDrive or SharePoint, check its version history before editing or replacing it. In desktop Excel, open the workbook and look under File > Info for Version History. You can also locate the file in OneDrive or SharePoint and use its version-history option. Open an earlier version to check its contents, then save a separate copy if it is the one you need. Availability and retention depend on the account, storage service, and organizational settings.

If Excel closed unexpectedly, check its recovery pane the next time you start the application. Excel may show recovered versions that were saved through AutoRecover, but these are not the same as a complete backup and may be older than your last edits. You can also check File > Info > Manage Workbook for available recovery options, including unsaved workbooks. The items shown depend on whether Excel had a recoverable copy and on your save settings.

On Windows, AutoRecover settings are available under File > Options > Save. The interval controls how often Excel saves recovery information; it does not guarantee that every change will be preserved, and it does not replace saving the workbook or keeping backups. If the workbook was attached to an email, downloaded, or shared through another service, check that original location for a fresh copy rather than relying only on the damaged local version.

Recover data when the workbook will not open

If Excel cannot repair the workbook, try to recover what matters most rather than experimenting on the only copy. Start with the newest backup or version-history entry. If none exists, use Open and Repair’s Extract Data option. When Excel can display the workbook but some content is missing, copy unaffected sheets into a new blank workbook and save that workbook under a different name. This may preserve usable data, but copying sheets can fail if the damaged workbook contains broken links or structural problems.

For a workbook that opens with warnings, prioritize important values and formulas. Copy a worksheet to a new workbook using the sheet tab’s Move or Copy command, and select a new workbook as the destination. Check formulas that refer to other sheets or files: a formula may still display a value while its source link is broken. Charts, pivot tables, macros, data connections, named ranges, and formatting may not transfer or function as expected. A macro-enabled .xlsm file also needs particular care; saving it in a format that does not support macros can remove VBA content.

Changing an .xlsx file’s extension to .zip and inspecting its internal files is sometimes suggested because .xlsx uses a packaged file format. This is an advanced diagnostic approach, not a dependable repair method. Editing or deleting internal components can make the workbook less recoverable, and the method does not apply identically to every Excel format. Keep an untouched copy and try Excel’s built-in recovery and backups first. If a file is business-critical and no backup exists, consult your organization’s IT support before attempting manual package edits.

Why workbooks become damaged

Workbook damage can follow an interrupted save, a sudden shutdown, storage-device problems, incomplete downloads, or sync conflicts. A workbook may also appear unusable because it was created by a newer or different spreadsheet application, contains unsupported features, or has a mismatched extension. These causes matter: repairing an incomplete download will not fix the source copy, while repeatedly saving to a failing drive may risk other files as well.

After recovery, save a clean copy to a reliable location and check the drive or sync service if the problem repeats. For files stored in the cloud, allow syncing to finish before shutting down or disconnecting. Keep another copy of important workbooks, and consider using OneDrive or SharePoint version history where appropriate. Use Excel’s normal save process, close large workbooks cleanly, and avoid removing a USB drive while a file is being written. These steps reduce risk but cannot prevent every failure.

Check the recovered workbook before relying on it

Opening successfully is only the first check. Compare the recovered workbook with a prior copy, report, or known totals if possible. Look for missing sheets, blank areas, unexpected error values, altered dates, and formulas that have turned into fixed values. Check the workbook’s last-used rows and columns, named ranges, charts, and any external links that are important to the task.

If the file contains macros, data connections, pivot tables, or other advanced features, confirm that they remain present and work as intended. Do not enable macros or external content just because a recovery prompt appears. Only enable content if you trust the workbook’s source and understand why it is needed. Once you have verified the recovered data, save it with a new filename and retain the original damaged copy until you are confident the recovery is complete.

Repair tools, costs, and privacy

Excel’s built-in repair and a backup or version-history copy are sensible first choices because they avoid giving the workbook to an unknown service. Third-party recovery programs vary in capabilities, pricing, and privacy practices; some may offer a scan before charging, while others require payment. There is no universal price or guarantee of success, and a tool cannot necessarily reconstruct information that is absent from the damaged file.

Before installing a recovery program, check that it comes from a reputable publisher, review what data it accesses, and scan downloads according to your organization’s security rules. For sensitive workbooks, ask an IT administrator or data-recovery professional about approved options. A service that requests the original file may be inappropriate for confidential data unless your organization has reviewed its security and privacy terms. Never treat a paid service’s promise as proof that all formulas, macros, or formatting can be restored.

Frequently Asked Questions

Can I restore a corrupted Excel file without losing data? Sometimes. Open and Repair, Extract Data, AutoRecover, and version history may recover some or all of a workbook, but none guarantees a complete result. Work on a copy and compare the recovered workbook with a backup or other reliable records before relying on it.

Where is Open and Repair in Excel? In Excel for Microsoft 365 on Windows, select File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. The command is part of the Windows desktop workflow; Excel for the web does not offer the same option.

What is the difference between Repair and Extract Data? Repair attempts to restore the workbook so it can open as a workbook. Extract Data is an alternative when repair fails and may recover values or formulas without restoring all workbook features. Save either result to a separate file and check it carefully.

Can I recover an Excel file I did not save? Possibly. After an unexpected close, inspect Excel’s Document Recovery pane and File > Info > Manage Workbook for available unsaved or AutoRecover versions. Recovery depends on whether Excel created a recoverable copy and how its settings were configured.

Does renaming an Excel file fix corruption? No. Renaming changes the filename or extension, not the workbook’s internal contents. If the extension is wrong, correcting it may help Excel identify a file, but it will not repair damaged data. Keep the original and use a copy for any extension change.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.