Fixing a Corrupted Excel File: Recovery Steps

How-to basics · Updated November 21, 2026

To fix a corrupted Excel file, first make a copy of it, then in Excel for Microsoft 365 on Windows choose File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, repeat the process and choose Extract Data to try to recover values and formulas. Neither option guarantees a complete recovery, so preserve the original and check any recovered workbook carefully.

What Excel file corruption means

An Excel workbook can become unreadable or partially damaged when its file contents are incomplete, inconsistent, or altered unexpectedly. An interrupted save, a computer crash, a failing or disconnected drive, a sync conflict, or a transfer that did not finish can all be possible causes. The error message may say Excel cannot open the file, that the file format or extension is not valid, or that some content is unreadable.

Corruption does not always mean every sheet and value is gone. A workbook may open with a warning while losing some formatting, formulas, charts, links, or other features. In other cases, Excel may not be able to read the file at all. The file extension alone cannot establish whether a workbook is valid: changing a damaged file from .xlsx to .xls, for example, does not repair its contents.

It is also useful to distinguish corruption from other problems. A password prompt, a read-only warning, a blocked download, an unsupported file type, or a workbook that opens but calculates incorrectly may have a different cause. The recovery steps below are aimed at a workbook that is genuinely damaged or cannot be opened normally.

Protect the original and check the file

Before trying repairs, avoid repeatedly saving over the only copy. Excel’s repair process may recover only part of a workbook, and a save can replace the original with that incomplete result. In File Explorer, copy the file to a separate folder or another drive and work on the copy. If the file is stored in OneDrive or SharePoint, make a separate copy there or download a copy before experimenting.

Then check a few simple causes that can look like corruption:

  • Confirm that the file has finished downloading or copying. Compare its size with the source if you have access to one.
  • Make sure the extension matches the type of file you expect, such as .xlsx, .xls, or .xlsm. Do not rename an extension just to bypass an error.
  • Try opening another workbook in Excel. If other files also fail, the issue may involve Excel, an add-in, or the computer rather than this particular file.
  • If the workbook is on a network share or removable drive, copy it to a local folder and try the copy. This can help separate a file problem from a connection or permissions problem.
  • If the file came from email or a website, verify that it is a genuine Excel workbook and obtain a fresh copy from the sender or source when possible.

Do not disable security protections or enable macros simply because a file will not open. A damaged workbook and an unsafe workbook are different issues; opening a file from an untrusted source can create a separate security risk.

Use Excel’s Open and Repair command

In Excel for Microsoft 365 on Windows, open the recovery copy with Excel’s built-in repair command. Start Excel, choose File > Open > Browse, navigate to the file, and select it once. Use the arrow on the Open button and choose Open and Repair. The arrow can be easy to miss because clicking the main Open button normally attempts a standard opening instead.

  1. Choose Repair when Excel offers the choice. This asks Excel to recover as much of the workbook as it can.
  2. If Repair does not work, close the dialog and start Open and Repair again on the untouched copy.
  3. Choose Extract Data if the repair attempt fails. Excel may offer a choice to recover values or formulas; follow the options displayed in the dialog.
  4. If Excel opens the workbook, immediately use File > Save As to save the recovered result under a new name and, if appropriate, in a new location.

Repair and Extract Data are not interchangeable guarantees. A repaired workbook may retain more of its structure, but some content or features can still be missing. Extraction is intended to salvage data when a normal repair is unsuccessful; it may not preserve the original layout, charts, formatting, links, or every workbook feature. Keep the original copy untouched even if the result appears usable.

Excel for Mac does not present the same Windows Open and Repair workflow in every version. On a Mac, make a copy first, then try opening it in Excel and check File > Open for any recovery prompt or options available in that version. If the workbook is available through OneDrive or SharePoint, checking its version history may provide a better recovery route than attempting to repair the damaged copy. Excel for the web also does not offer the same desktop Open and Repair command; download a copy and use the desktop app if that command is needed.

Look for an earlier or unsaved version

A clean earlier copy is often more useful than a partially repaired workbook. If the file is saved in OneDrive or SharePoint, use the file’s Version History to inspect and restore an earlier version. In Excel for Windows, you can check File > Info for Version History when the workbook is stored in a supported cloud location. You can also use the version-history option in OneDrive or SharePoint. Review the date and contents before replacing anything; save or download an earlier version as a separate file when possible.

If Excel closed unexpectedly before the latest changes were saved, check File > Info for Manage Workbook or the Recover Unsaved Workbooks option. The exact labels and availability can vary with the workbook’s save status and Excel version. AutoRecover may have a recent copy, but it is not a substitute for saving: it may be missing recent edits, and it cannot restore content that was never written to a recovery file.

Windows may also show Previous Versions for a file or folder in File Explorer, but only when a suitable backup or File History configuration has kept copies. Right-click the file or its folder, choose Properties, and check the Previous Versions tab if it appears. Do not assume that a version is available just because the tab exists; verify its date and preserve the current file before restoring anything.

Identify what is actually failing

The wording and timing of the error can help narrow down the cause. If one workbook fails while other workbooks open normally, the file itself or its storage location is a stronger suspect. If several files fail, check whether Excel has updated, whether the files are stored on a disconnected drive, and whether the problem also occurs with a new blank workbook. A message about a password or permissions does not prove that the file is corrupt.

Sometimes Excel opens a workbook but displays a warning that it repaired or removed unreadable content. Treat that as a partial recovery, not proof that everything survived. Compare sheets, formulas, named ranges, charts, pivot tables, data connections, and macros against a trusted earlier version or a report from the file’s owner. For workbooks with complex models, verify key totals and representative formulas rather than relying only on whether the file opens.

If a workbook is very large or contains many external links, it may take time to load or calculate. A slow opening by itself is not evidence of corruption. Avoid interrupting a save or closing Excel while it is working unless it is clearly unresponsive for an extended period; forcing it to close during a write can leave the file in a worse state.

Salvage data when repair is unsuccessful

If Open and Repair cannot produce a usable workbook, try the least destructive alternatives first. Obtain another copy from the sender, a coworker, a backup drive, an email attachment, or cloud version history. Ask whether the workbook was last saved in another folder or under a different name. If only a particular sheet or table is needed, an earlier export or a copy of that data may be enough to rebuild the essential information.

If the workbook opens in Excel, even with warnings, copy visible sheets into a new blank workbook when practical. Right-click a sheet tab, choose Move or Copy, select a new workbook, and select Create a copy. This may not transfer every workbook-level feature, so compare the result carefully. If Excel can display needed cells but cannot save the original safely, copying the essential ranges into a new workbook can help recover visible data; formulas, formatting, and hidden content may need separate checking.

For a workbook that contains only simple tabular data, a CSV export may be a useful fallback if Excel can still open or extract the data. CSV stores plain text values for a single sheet; it does not preserve workbook formatting, formulas as working formulas, charts, multiple sheets, macros, or many other Excel features. Do not rename a damaged .xlsx file to .csv and expect a conversion. If you cannot open or extract the data, avoid editing the internal contents of an .xlsx file unless you understand its structure. Such files use a package of related components, and changing one part can make the workbook less recoverable.

Prevent another corrupted workbook

Most prevention is about keeping another copy and avoiding interrupted writes. Save important workbooks to a location with reliable storage, and keep a separate backup or use a cloud service with version history. Syncing is useful, but a synced folder is not automatically a full backup: accidental changes or deletions can sync too. Check that version history or another backup method is actually available for important files.

  • Use File > Save or Ctrl+S regularly in Excel for Windows. On Mac, use Command+S.
  • Wait for a save or cloud sync to finish before shutting down, unplugging a drive, or closing a laptop lid.
  • Keep enough free space on the drive and avoid working directly from a removable device that disconnects unpredictably.
  • Use an appropriate workbook format. For example, .xlsx does not retain VBA macros; macro-enabled workbooks generally use .xlsm.
  • For critical files, keep dated copies or confirm that a backup and recovery process works before you need it.

AutoSave and AutoRecover can reduce the impact of interruptions, but they serve different purposes and should not be treated as a backup plan. AutoSave can save changes automatically for supported files stored in OneDrive or SharePoint. AutoRecover keeps recovery information at intervals, depending on Excel’s settings and circumstances. Neither guarantees recovery of every edit or protects against every kind of damage.

Frequently Asked Questions

Can I recover a corrupted Excel file without losing data?
Sometimes. Make a copy, try Open and Repair, then check cloud history, backups, and unsaved-workbook recovery. The result depends on what was damaged, so compare recovered content with a known-good source before relying on it.

Why does Excel say the file format or extension is not valid?
The extension may not match the actual file type, the download may be incomplete, or the file contents may be damaged. Confirm the source and extension, try a fresh copy, and use Open and Repair on a duplicate. Renaming the extension alone does not repair the workbook.

Will Open and Repair keep formulas and formatting?
It may preserve them, but there is no guarantee. Some workbook content or features can be lost during repair or extraction. Check formulas, formatting, sheets, charts, and other important elements after saving the recovered file under a new name.

Can Excel for the web repair a corrupted workbook?
Excel for the web does not provide the same desktop Open and Repair command. Check OneDrive or SharePoint version history, or download a copy and try the repair workflow in Excel for Windows.

Should I use an online Excel repair website?
Be cautious, especially with confidential, personal, or business data. Uploading a workbook gives another service access to its contents, and third-party tools may have fees or uncertain recovery results. Prefer Excel’s built-in options and trusted backups unless you have checked the service’s security and privacy terms.

Related

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.