Excel File Corruption Fix: Safe Recovery Steps

To fix a corrupted Excel file in Microsoft 365 for Windows, make a copy of it first, then open Excel and choose File > Open > Browse. Select the file, open the arrow beside the Open button, choose Open and Repair, and try Repair; if that fails, repeat the process and choose Extract Data to recover values and formulas where possible.

Start with a copy and identify the problem

Before attempting a repair, make a duplicate of the affected workbook and keep the original unchanged. Use File Explorer to copy the file to a separate folder, or use Save a Copy if Excel can still open it. Give the duplicate a clear name such as Budget_repair_copy.xlsx. Repair attempts may remove damaged elements, and having the original makes it possible to try another route if the first result is incomplete.

Corruption can look different from one file to another. Excel might show a message that the file format or extension is not valid, report unreadable content, close unexpectedly while opening the workbook, or display blank sheets or missing objects. A workbook that opens but shows incorrect-looking results is not necessarily corrupted: formulas may have changed, links may be unavailable, or calculation may be set to manual. Check whether other workbooks open normally before concluding that Excel itself is at fault.

Check the file name and extension. A file renamed to .xlsx is not necessarily a genuine Excel workbook in that format.
Check whether the file has an unusually small size, such as zero bytes, or whether it was interrupted while downloading or copying.
Try a known-good workbook in the same Excel installation. If it also fails, troubleshoot Excel or the storage location as well as the individual file.
Do not overwrite the only copy with a recovered version until you have checked what was preserved.

Use Excel’s Open and Repair command

Open and Repair is Excel’s built-in first-line recovery option for a workbook that will not open normally. In Excel for Microsoft 365 on Windows, select File > Open > Browse. In the file picker, select the workbook rather than double-clicking it. Click the arrow next to Open, choose Open and Repair, and then select Repair in the prompt. The exact prompt depends on what Excel detects.

If Repair does not work, repeat the steps and choose Extract Data. This option is intended to retrieve workbook data when Excel cannot restore the full file. Depending on the damage, it may recover values and formulas while leaving out formatting, charts, objects, or other workbook features. It is not a promise that every sheet or cell can be recovered.

When Excel opens a repaired workbook, inspect it before relying on it. Check sheet names, key totals, formulas, charts, named ranges, tables, external links, and macros if applicable. If the file contains important financial or operational information, compare recovered values with a separate source or an earlier version. Save the result under a new name using File > Save As, and keep both the damaged original and the repaired copy until you are confident the recovered content is usable.

Recover an earlier or unsaved version

A previous version is often more complete than a repair of a badly damaged file. If the workbook is stored in OneDrive or SharePoint, use its version history to review and restore an earlier copy. In Excel, the route may be File > Info > Version History; you can also locate the file in OneDrive or SharePoint and use its version-history option. Menu labels can vary by account and application version. Open an earlier version first and save a separate copy if you want to preserve the current file.

For a workbook that was never saved, or for changes lost after an Excel failure, check Excel’s unsaved-workbook recovery. In Microsoft 365 for Windows, select File > Info > Manage Workbook > Recover Unsaved Workbooks, then look for a recent file. This feature is most useful for unsaved work or an unexpectedly closed session; it is not a general tool for repairing every damaged saved workbook. AutoRecover may also have a version, but its availability depends on whether recovery data was created and retained.

If the file is on a network share, external drive, or sync folder, copy it to a local drive before trying again. A temporary connection or synchronization problem can interrupt access and resemble file damage. Do not repeatedly open and save a file while a sync client reports an error; first confirm that the local copy is complete and that the original location has finished syncing.

What causes Excel workbook corruption?

Excel workbooks are complex files that can contain worksheets, formulas, styles, charts, links, images, macros, and other components. A workbook may become unreadable if a write operation is interrupted or the file is only partly transferred. Common circumstances include a computer losing power while saving, a storage device or network connection failing, an application crash, a sync conflict, or a download that did not finish.

These circumstances do not prove that a file is corrupt. A workbook may instead be blocked, password-protected, incompatible with an older Excel version, or stored in a format that does not match its extension. For example, a comma-separated values file is not the same as an .xlsx workbook: CSV preserves plain tabular text but not features such as multiple sheets, formatting, or formulas as workbook formulas. Confirm the source and file type before trying increasingly invasive recovery steps.

Very large workbooks, add-ins, macros, or complex links can also contribute to slow opening or crashes, but a crash alone does not establish corruption. If Excel reports a specific error, note its wording. If the problem started after a recent edit, add-in installation, or transfer, that timing may help identify whether the issue lies in the workbook, Excel, or its storage path.

Check Excel, the file location, and compatibility

If repair fails, eliminate simple causes before using third-party tools. Close Excel, restart the computer if appropriate, and make sure the file is not still being copied or synchronized. Try opening the duplicate from a local folder with a short, ordinary file name. If the workbook came by email or download, obtain it again from the sender or source where possible. Compare file sizes if you have another copy, but remember that legitimate edits can change a file’s size.

Consider whether the workbook uses features that your version of Excel cannot fully support. A workbook made in a newer release may open differently in an older application, and a file created by another spreadsheet program may use features Excel does not interpret identically. Microsoft 365 is updated regularly, so installing available Office updates can help with application-level problems, but an update cannot reconstruct data that is absent from the file.

On Mac, first make a duplicate and try opening it in Excel for Mac. The Windows Open and Repair command described above is not available in the same form on every Mac release, so do not assume the Windows menu path exists. Check version history or backups, try the workbook in Excel for the web if it is stored in OneDrive or SharePoint, and consider opening a copy in another compatible spreadsheet application to see whether any content can be read. Another application may change formatting or unsupported features, so do not save over the original.

Protect recovered data and avoid risky fixes

A repair may restore enough to continue working without restoring every workbook feature. Compare important cells and outputs against known records; look for blank areas, missing formulas, changed number formats, broken links, and absent charts or controls. If formulas display as values or results appear stale, check calculation settings and external data separately rather than assuming those symptoms are corruption. For critical workbooks, ask the file’s owner or data source for a clean copy before treating recovered results as authoritative.

Be cautious with websites or utilities that ask you to upload a workbook. It may contain personal, client, business, or confidential data. Review the provider’s privacy and retention terms before sharing anything, and follow your organization’s data-handling rules. Prefer a verified backup or built-in recovery option when possible. Avoid editing the internal parts of an .xlsx file by hand: changing packaged files without understanding their relationships can make recovery harder and may remove content.

Keep the damaged original, a working duplicate, and the repaired output as separate files.
Do not enable macros simply to make a damaged workbook open. Only enable them when you trust the source and need the macro-enabled content.
Do not trust a successful open as proof that every value is correct; validate important results independently.
Once recovered, save a clean copy and create a backup in a separate, reliable location.

When to try another recovery route

If Open and Repair and available version history do not recover the content, look for other copies: email attachments, local backup software, a previous download, a colleague’s copy, or an earlier file in a shared folder. A copy from shortly before the failure may be a better starting point than a damaged recent version. If only part of the workbook matters, extracting data may be adequate; rebuilding a small sheet from source records can be safer than trusting a badly damaged complex workbook.

Third-party recovery software may be an option when the workbook is valuable and no usable backup exists, but results are not guaranteed. Compare the tool’s capabilities, supported Excel formats, privacy practices, and cost before paying or supplying a file. For an organization’s critical records, involve IT or a data-recovery professional rather than experimenting on the only copy. Recovery services cannot guarantee restoration, especially if the file is truncated or its storage device has failed.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?
Sometimes. Excel may detect a problem and offer recovery, but automatic repair is not guaranteed. For a file that will not open, use Open and Repair on Windows, then inspect the repaired copy because some elements may be lost.

Does Open and Repair delete the original workbook?
The recovery command is intended to open or extract from the selected file, but safe practice is still to work from a duplicate and save recovered content under a new name. That preserves the original if the result is incomplete.

Can I recover an Excel file that was not saved?
Possibly. In Excel for Microsoft 365 on Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel created and retained a recoverable copy; it may not contain the latest changes.

Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, the file may be incomplete, or its contents may be damaged. Confirm the source, download or copy it again if possible, and try Open and Repair on a duplicate rather than changing the extension at random.

Will changing .xlsx to .xls fix corruption?
No. Renaming changes the label, not the workbook’s internal format or damaged content. It can make Excel show a different warning and may create confusion. Use a genuine backup, Open and Repair, or another recovery route instead.

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.