Microsoft Excel Corrupt File? How to Repair It

If an Excel file is corrupt, first make a copy of it, then try Excel for Microsoft 365 on Windows: choose File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. If that does not work, try a previous cloud or backup version, or use Excel’s data-extraction option; the best method depends on whether you need the whole workbook or only its values and formulas.

What an Excel file corruption message means

A corrupted workbook is a file whose contents Excel cannot read or interpret reliably. It may fail to open, open with a warning that Excel found a problem, or display missing sheets, formulas, formatting, charts, or other content. Sometimes Excel opens the file but reports that it repaired or removed unreadable records. That is different from an ordinary calculation error, which usually affects a cell or formula rather than the workbook’s file structure.

The message does not always prove that the workbook itself is damaged. Excel may also reject a file if its extension does not match its actual format, if a download is incomplete, or if the file is blocked by a permission or security issue. A password-protected workbook, a file currently in use, and a workbook that is simply too large or slow to open are not automatically corrupt. Identifying the exact message and checking whether other workbooks open can narrow down the cause.

Excel workbooks can contain more than visible cell values: formulas, styles, named ranges, charts, pivot tables, links, macros, and embedded objects may all be stored in the file. Repair may therefore restore the ability to open a workbook without preserving every feature. Treat a repaired file as a recovered copy to inspect, not as proof that every original item is intact.

Protect the original before troubleshooting

Before attempting repairs, make a duplicate in File Explorer and work on that copy. Keep the original unchanged, especially if the workbook is important or is the only available version. If it is stored on a network drive, USB device, or cloud-synced folder, copy it to a local folder before repair; this can avoid problems caused by an interrupted connection or sync operation. Do not repeatedly save over the only copy while testing different recovery methods.

Check that the file has finished downloading or syncing, then compare its size with the sender’s copy if possible.
Confirm that the extension is plausible for the workbook, such as .xlsx for a standard macro-free workbook or .xlsm for one that can contain VBA macros.
Do not simply rename a file from .xls to .xlsx to convert it. Changing the name does not convert the file’s internal format.
If Windows shows a permissions or blocked-file warning, address that issue separately rather than assuming the file is corrupt.

When a workbook arrived by email or download, ask for a fresh copy if the sender still has the original. A clean copy is often safer than attempting to reconstruct a damaged one, and it gives you a way to compare recovered content later.

Use Excel’s Open and Repair command

In Excel for Microsoft 365 on Windows, open the repair dialog from the Open screen. Select File > Open > Browse, locate the copied workbook, select it once, and use the arrow beside the Open button. Choose Open and Repair. In the dialog, choose Repair first. Excel attempts to restore as much of the workbook as it can. If that does not succeed, repeat the process and choose Extract Data, which may recover cell values and formulas even when a complete repair is not possible.

After the file opens, read any repair notice and inspect the workbook carefully. Look at every sheet, not just the first one. Check formulas in important areas, totals, named ranges, charts, pivot tables, external links, and formatting that carries meaning. If you rely on macros, verify that the recovered workbook still has the expected .xlsm format and that its VBA content is present. Save the recovered result with a new name using File > Save As, then close and reopen that new file to confirm it opens normally.

Open and Repair is not a guarantee. Excel may remove records or features it cannot read, and a successful opening does not establish that every value is correct. Keep the original and any repair log or warning details until you have compared the recovered workbook with a trustworthy source.

The Windows desktop command described here is not available in the same form in Excel for the web. Excel for Mac also has different recovery options and does not use this Windows Open and Repair dialog in the same way. If you are on a Mac, start by making a copy and checking cloud version history or backups; if practical, try the copied file in desktop Excel for Windows using Open and Repair.

Look for an earlier or unsaved version

A previous copy may be more complete than a repaired file. If the workbook is stored in OneDrive or SharePoint, use the file’s Version history to find an earlier version. You can open or restore a version from the cloud service, but first preserve the current file if it contains any newer work. In Excel for Windows, version history is also available for supported cloud files through File > Info > Version History. The exact options can depend on where the file is stored and your account permissions.

If Excel closed unexpectedly before a workbook was saved, check File > Info > Manage Workbook for an unsaved-workbook recovery option. This is intended for unsaved work and AutoRecover copies; it is not a universal repair tool for an already saved, damaged file. The available entries depend on whether Excel had time to create a recovery copy and on the application’s settings. Open any candidate carefully and save it under a new name.

Also check ordinary backups, Windows File History if it was configured, or a company backup system. A backup is useful only if it predates the damage and contains the needed changes. If the workbook was edited by several people, ask whether another collaborator has a local or downloaded copy that opens successfully.

Extract data when the workbook will not repair

If Excel can extract data but cannot restore the workbook as a whole, decide what information matters most. A clean set of cell values may be enough for a simple table, but it may not preserve formulas, formatting, charts, validation rules, macros, or links. Compare key totals and a sample of source rows against a report, export, or earlier version before treating extracted content as reliable.

For a workbook that opens intermittently, you can try copying visible data from its sheets into a new workbook, saving the new file, and reopening it. Copying only the required ranges may avoid carrying damaged content into the replacement. However, copying and pasting is not a complete recovery method: it can omit hidden sheets, defined names, objects, formulas that depend on other sheets, and workbook-specific features. Record which items were transferred and check formulas after moving them.

CSV can be a fallback for plain tabular data, but it stores text values in a delimited format, not a full Excel workbook. It does not preserve multiple sheets, workbook formatting, charts, formulas as formulas, or macros. If you save as CSV, Excel normally saves only the active sheet, so select the intended sheet and keep the original workbook copy. Use CSV only when the data itself is what you need and its limitations are acceptable.

Common causes and how to reduce repeat problems

Corruption can follow an interrupted save, an unexpected shutdown, a failing storage device, a dropped network connection, or a sync conflict. A third-party application that writes workbook files incorrectly can also produce a file Excel cannot read. These are possibilities, not a diagnosis: a single error message usually cannot identify the cause by itself.

To reduce the risk of losing work, save regularly, keep important files in a location with a dependable backup process, and allow cloud synchronization to finish before shutting down or disconnecting. Avoid editing the same file simultaneously through conflicting copies unless the collaboration service supports that workflow. If several unrelated workbooks suddenly stop opening, investigate Excel, an add-in, storage, or the device rather than assuming each file independently became corrupt.

When a workbook opens in Safe Mode but not in a normal Excel session, an add-in or startup customization may be involved. Safe Mode can help separate an application-level problem from a file-specific one, but it does not repair the workbook by itself. If the failure follows the file across machines or Excel sessions, focus on recovering or replacing that file and keep a copy before making changes.

Check the recovered workbook before relying on it

A workbook that opens is not necessarily accurate. Check the items that drive decisions or downstream work first: key totals, formulas, dates, hidden rows or columns, sheet names, and links to other files. If a formula displays an error, compare its formula with a known-good copy rather than assuming the repair caused it; the source workbook may already have contained the issue.

Compare important totals and record counts with a report or source system.
Check whether formulas were replaced by fixed values or removed.
Inspect charts, pivot tables, dropdowns, conditional formatting, and print layouts if the workbook depends on them.
Test external links and macros only in a trusted file and environment.
Save a verified recovered copy under a new name and retain the original until the replacement is accepted.

If the workbook contains sensitive data, avoid uploading it to an unfamiliar online repair service. A workbook can include hidden sheets, personal information, business records, and links that are not obvious from the visible cells. Prefer Excel’s built-in recovery, your organization’s approved support channel, or a trusted backup administrator.

When to seek another copy or technical help

If Open and Repair fails, no earlier version exists, and the contents are important, stop experimenting on the sole original. Ask the file’s sender or owner for another copy, contact your organization’s IT or backup administrator, or consult a reputable data-recovery professional if there may be a storage-device problem. Repair utilities from third parties vary in capability and may expose confidential workbook contents, so review their source, privacy terms, and organizational rules before using them.

If Excel cannot open any workbook, create a test workbook or try a known-good file. A broader application or system problem may need attention, such as an Office update, add-in, permission, or storage issue. If only one file fails, the file itself, its format, or its path is a more likely place to investigate. Keep notes about the exact message, the file’s origin, and what changed before the issue appeared; those details help support staff distinguish a file problem from an Excel problem.

Frequently Asked Questions

Can a corrupted Excel file be repaired?
Sometimes. Excel’s Open and Repair command can restore a workbook or extract some data, but it cannot guarantee recovery of every sheet, formula, macro, or object. Keep the original and verify the repaired copy against a reliable source.

Where is Open and Repair in Excel?
In Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. Make a copy first and try Repair before Extract Data.

Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, the download may be incomplete, or the file may be damaged. Get a fresh copy if possible. Renaming the extension alone does not convert or repair a workbook.

Can I recover an Excel file that I did not save?
Possibly. In Excel for Windows, check File > Info > Manage Workbook for available unsaved-workbook recovery entries. Recovery depends on whether Excel created a usable AutoRecover copy; it cannot be assumed that every unsaved change was captured.

Will converting a damaged workbook to CSV fix it?
No. CSV is a way to preserve plain tabular data, not a repair of the original workbook. It does not retain multiple sheets, formulas as formulas, formatting, charts, or macros, so use it only if those features are not needed.

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.