Can You Fix a Corrupted Excel File? Safe Recovery Steps

Yes—Excel can often repair a corrupted workbook, but recovery is not guaranteed and some content may be lost. On Windows, first make a copy of the file, then try Excel’s built-in Open and Repair command; if that fails, check version history, backups, and recovery files before trying other tools.

What Excel file corruption means

An Excel workbook is a structured file that can contain worksheets, formulas, formatting, charts, tables, links, macros, and other data. Corruption means that some part of the file cannot be read or interpreted correctly. The damage might affect only one feature, such as a chart or a worksheet’s formatting, or it may prevent Excel from opening the workbook at all.

A workbook that will not open is not necessarily corrupted. The file may have the wrong extension, be blocked by a security setting, be password-protected, or be in a format that the current Excel version does not support. A file can also be incomplete because it was still downloading or copying when someone tried to open it. Excel’s warning message and the file’s origin can help distinguish these cases, but they do not always identify the exact cause.

Possible causes of genuine damage include an interrupted save, a computer shutdown or application crash during a write, a failing storage device, or an incomplete transfer through a network or removable drive. An unexpected error does not prove that any one of these occurred. Avoid assuming that changing the filename or extension will repair the file: renaming an .xlsx file to .xls, for example, does not convert its contents.

Protect the original before attempting a repair

Before troubleshooting, preserve the file exactly as it is. If Excel or another program manages to open it, a repair or save operation could change the only copy. Make a duplicate in File Explorer, and use the duplicate for recovery attempts. If the file is on a USB drive or network share, copy it to a local folder first, provided the copy completes without an error.

Keep the original file unchanged and note its current name, extension, size, and location.
Make a working copy with a different name, such as Budget-recovery-copy.xlsx.
Do not repeatedly force-close Excel while it is saving, and do not run cleanup or repair utilities on the storage device until you have considered the risk of losing recoverable files.
If the workbook contains confidential or regulated information, do not upload it to an unfamiliar online repair service.

A copy is especially important if the workbook contains macros, external data connections, or business records that cannot easily be recreated. Repair tools may change or discard workbook elements, and the original lets you compare outcomes or try a different recovery route.

Try Excel’s Open and Repair command

In Microsoft Excel for Microsoft 365 on Windows, use the built-in repair option on your working copy. Start Excel, then choose File > Open > Browse. In the Open dialog, navigate to the copy and select it without opening it. Click the arrow beside the Open button, choose Open and Repair, and follow the prompts.

If Excel offers a choice, select Repair first. Excel will attempt to recover as much of the workbook structure and content as it can. If that does not work, repeat the process and choose Extract Data, when available. This option aims to retrieve values and formulas, rather than restore the complete workbook with all its original features. The labels or available choices can vary depending on the file and Excel version.

If Excel opens the workbook, check more than the first visible sheet. Look for missing worksheets, formulas that have turned into values or errors, broken charts, changed formatting, and warnings about links or other content. Review important totals against a trustworthy source. Then use File > Save As to save the recovered workbook under a new name. Keep the original and the repaired copy until you are satisfied with the result.

The Windows Open and Repair workflow is not available in the same way in Excel for Mac. On a Mac, try opening a duplicate from Excel’s File > Open command, check cloud version history or backups, and use any recovery prompt Excel presents. Menu names and recovery options can vary by Excel release. Excel for the web also has different capabilities from the Windows desktop application, so download a copy and try the desktop repair workflow when possible.

If the workbook still will not open

Try straightforward checks before using specialist software. Confirm that the file finished downloading or copying, and try a fresh copy from the original source if one exists. Check that the extension matches the file’s actual format; do not change it simply to silence a warning. If Excel reports that the file extension or format is not valid, the file may be mislabeled, incomplete, or damaged. A matching extension alone does not establish that the contents are healthy.

You can also test whether the problem is specific to the workbook or to the way it is being opened. Start Excel first and open the file from File > Open, rather than double-clicking it in File Explorer. If other workbooks open normally, that points toward an issue with this particular file, but it does not prove the cause. If Excel cannot open any workbook, the problem may involve the application or its environment instead; repairing the Office installation is a separate troubleshooting step and does not repair damaged workbook data.

For a damaged workbook that is partly accessible, try opening it in another compatible spreadsheet application only on a copy. Another program may read some values, but it may interpret formulas or formatting differently and may not preserve Excel-specific features. Avoid saving over the original. If the contents are critical and no backup works, a reputable data-recovery specialist may be worth considering, especially if the storage device itself is failing.

Look for an earlier version or recovery copy

A clean earlier copy is often more useful than a partial repair. If the workbook is stored in OneDrive or SharePoint, check its version history. In Excel for Microsoft 365 on Windows, open the workbook and look under File > Info > Version History when that option is available. You can also use the file’s version-history option in OneDrive or SharePoint. Review the date and contents before restoring an older version, because restoring can replace the current cloud copy. Download or duplicate the version first if you need to compare it.

For a workbook that was not saved, open Excel and look under File > Info > Manage Workbook > Recover Unsaved Workbooks, if the option is available. Excel’s AutoRecover and unsaved-file features can help after a crash, but they are not a complete backup system. Recovery depends on settings, timing, and whether Excel was able to create a recovery copy. A recovered draft may be missing the last changes made before the interruption.

Windows may also have earlier copies through File History or another backup system. In File Explorer, right-click the file or its containing folder and check Properties > Previous Versions if that tab is available. It appears only when a suitable previous-version or backup feature has created copies; it is not a guaranteed archive of every save. On a Mac, check Time Machine if it was configured, as well as any cloud service that stores versions.

What a repair may preserve—or lose

Repair is an attempt to recover readable content, not a promise to reconstruct the workbook exactly. Cell values and formulas may survive even when some formatting does not. Conversely, a workbook may open while containing missing formulas, damaged links, blank areas, or worksheets that are no longer present. Excel can also remove or change features it cannot recover from the damaged file.

Pay particular attention to information that is hard to notice at a glance: hidden sheets and rows, named ranges, data validation, conditional formatting, comments, charts, PivotTables, external connections, and macros. If Excel reports that it removed records or content, treat that as a reason to inspect the result, not as evidence that all important data is intact. Compare critical numbers with a source system, a printed report, or a separate export where possible.

Saving a copy as CSV can sometimes help preserve plain tabular data if Excel can open the workbook, but CSV is not a full workbook backup. It does not retain formulas as formulas, formatting, charts, macros, or multiple worksheets; a CSV file represents a single worksheet. Keep the original Excel format when you need workbook features, and use CSV only when a plain data export is appropriate.

Choose a recovery route based on the situation

The best next step depends on whether the file opens, whether a clean earlier copy exists, and how much of the workbook must be preserved. A practical order is:

The file opens but displays a warning: work on a copy, note the warning, inspect the workbook, and save a new version only after checking the important content.
The file will not open in desktop Excel: try Open and Repair on Windows, then try Extract Data if offered.
The file was recently edited or stored in the cloud: check OneDrive or SharePoint version history before accepting a repair that may lose features.
The file was never saved or Excel crashed: check Recover Unsaved Workbooks and AutoRecover-related prompts.
The file is valuable and the storage device is reporting errors: stop making repeated changes to that device and consider professional advice about data recovery.

Online repair services are another option, but weigh convenience against privacy and security. Uploading a workbook may expose names, customer information, financial figures, formulas, or hidden sheets. Read the provider’s data-handling terms and consider whether your organization permits external uploads. Never enable macros or install software just because a repair site requests it unless you can verify that the file and program are trustworthy.

Reduce the chance of future workbook loss

Excel cannot prevent every crash or storage failure, but sensible file habits make recovery easier. Save important workbooks to a location covered by a reliable backup or version-history system. For critical files, keep a separate backup rather than relying on a single cloud-synced copy. Synchronization can spread deletions or unwanted changes, whereas version history or an independent backup may provide another way back.

Save periodically with Ctrl+S on Windows; on Mac, use Command+S.
Wait for saves and file transfers to finish before shutting down, disconnecting a drive, or closing a laptop.
Use a suitable workbook format: .xlsx for standard workbooks, or .xlsm when the file needs to retain VBA macros.
Keep important source data separately when practical, and periodically confirm that backups can actually be opened.
For large or complex workbooks, consider saving a new version before major structural edits or changes to external links.

AutoSave can reduce the amount of recent work at risk for eligible files stored in OneDrive or SharePoint, but it is not a substitute for independent backups. Availability depends on the file location, account, and workbook features. Likewise, AutoRecover is designed to help recover work after interruptions, not to guarantee recovery from every kind of file damage.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?
Sometimes. Excel may detect a problem and display a recovery prompt, or you can start the Windows Open and Repair process yourself. The repair can be incomplete, so inspect the recovered workbook and keep the original.

Will Open and Repair restore every formula and chart?
No. Excel attempts to recover what it can read, but formulas, charts, formatting, links, macros, or other features may be missing or altered. Compare important results with a reliable source before relying on the repaired file.

Can I repair an Excel file without Excel?
Other spreadsheet programs or specialist services may recover some content, but compatibility and privacy vary. Work only on a copy, and do not assume that a file that opens in another program will preserve every Excel feature.

Does changing .xlsx to .xls fix corruption?
No. Changing the extension changes the filename, not the workbook’s internal format or damaged data. Use the correct extension for the existing format; a real conversion requires opening the workbook in a compatible program and saving it in another format.

Is it safe to upload a damaged workbook to a repair website?
Only if you have assessed the privacy and security risks and are permitted to share the file. Workbooks can contain sensitive or hidden information. For confidential files, try local recovery and backups first, or consult an approved IT or data-recovery professional.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.