Corrupted Excel File Repair: What to Try First

How-to basics · Updated November 18, 2026

For a corrupted Excel file, first make a copy of the file, then try Excel’s built-in Open and Repair command: in Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. If that cannot restore the workbook, try extracting its data or recovering an earlier copy before using a third-party repair tool.

What a corrupted Excel file means

A workbook is a structured file containing data, formulas, formatting, worksheets, and other elements. In an .xlsx file, much of that information is stored in a package of related components. If a component is damaged or incomplete, Excel may be unable to read the workbook normally. The problem can affect the whole file or only a feature, sheet, or range.

Common signs include an error message when opening the file, Excel closing unexpectedly, missing sheets, unreadable content, or a workbook that opens with some formatting or formulas gone. These symptoms do not prove that the file itself is corrupt. A damaged download, a sync conflict, a full or failing storage device, an incompatible add-in, or a workbook that is simply too large can cause similar trouble.

“Repair” can mean different things. Excel may rebuild enough of the workbook to open it, or it may recover values while discarding formulas, styles, charts, or other components. A file that opens is not necessarily fully restored, so check the contents before treating it as a good copy.

Start with a safe copy and basic checks

Do not keep overwriting the only copy while trying repairs. Use File Explorer to copy the workbook to a separate folder, and work on the duplicate. If the file is stored in OneDrive or SharePoint, check its version history before making changes; an earlier version may be a cleaner recovery route than repairing the current one.

  • Confirm the download or transfer finished. If the workbook came by email or from a website, download it again or ask the sender to resend it.
  • Check that the file has an Excel workbook extension, such as .xlsx or .xlsm, and that it was not renamed from another format.
  • 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 one file.
  • If the file is on a network drive or removable device, copy it to a local drive and try the copy. A connection interruption can leave a file incomplete.

Keep the original untouched until you have checked any recovered version. This matters especially for workbooks containing macros, important calculations, or records that cannot easily be recreated.

Use Excel’s Open and Repair command

In Excel for Microsoft 365 on Windows, use this sequence:

  1. Open Excel, then choose File > Open > Browse.
  2. In the file picker, select the duplicate workbook. Do not double-click it.
  3. Click the small arrow next to the Open button and choose Open and Repair.
  4. Choose Repair when Excel offers the choice. Let the process finish, then inspect the workbook before saving it under a new name.

If Repair does not work, repeat the steps and choose Extract Data if Excel offers that option. This may recover cell values and formulas, but it is not a full rebuild of the workbook. For example, a worksheet’s numbers might be recoverable even if its charts, formatting, or some formulas are not. Save extracted results as a new file and compare them with a known-good source where possible.

On a Mac, the Windows Open and Repair command is not available in the same way in many current Excel builds. Try opening a duplicate in Excel for Mac and follow any recovery prompt, then check OneDrive or SharePoint version history, Time Machine backups, or another backup. Excel for the web can open supported workbooks, but it is not a substitute for Windows’ Open and Repair workflow.

Check recovered data before relying on it

After a workbook opens, verify more than the first visible sheet. Check every sheet tab, hidden sheets if relevant, formulas, named ranges, charts, links, and macros. Look for blank regions, error values, missing rows, or formulas that have become fixed values. Compare important totals with an earlier report or another trusted source.

Excel may show a repair log or a message describing removed records. Read it rather than dismissing it: a workbook can appear normal while a feature has been removed. If formulas or links matter, test a few known calculations and confirm that references still point to the intended sheets and files. For an .xlsm workbook, check that macros are still present, and do not enable macros in a file unless you trust its source.

When the recovered file looks right, use Save As to create a new workbook with a different name. Keep the original and the repaired copy separately until the repaired file has been checked by whoever depends on its contents.

Why Excel files become damaged

Unexpected shutdowns during a save, interrupted uploads, failing storage, and sync conflicts are common ways a workbook can become incomplete or inconsistent. Repeated editing across different spreadsheet programs can also change features or formatting, although a changed workbook is not automatically a corrupted one. An Excel warning about a file extension or format may indicate a mismatch, not damage.

There is also a useful distinction between a file problem and a workbook problem. A workbook may open correctly but contain broken formulas, external links that no longer work, or incorrect data. Repair tools cannot determine whether a formula is logically right or whether a value was entered correctly. Those issues require checking the workbook’s contents and sources, not simply repairing its file structure.

If Excel crashes only with one workbook, the file or a feature inside it is a likely starting point. If it crashes with many unrelated files, investigate Excel updates, add-ins, available memory, and system storage as well. Avoid repeatedly opening a file from a failing drive; copy it once if possible and consider professional data recovery for valuable files on failing media.

Third-party repair tools: when and how to choose

A third-party Excel repair tool may be an option when Excel cannot open a copy and no usable backup exists. Such tools vary in what they can recover, which formats they support, whether they preserve formulas and macros, and whether they process files locally or upload them to a service. No tool can guarantee recovery of every damaged workbook.

Before paying or uploading confidential information, check the product’s documentation, supported file types, privacy policy, and refund terms. Prefer a tool that lets you preview recoverable content or evaluate a copy before you commit. Ask whether the software changes the source file; it should be used on a duplicate. For payroll, customer, medical, or other sensitive data, an online upload may be inappropriate under your organization’s policies.

  • Confirm that the tool supports the workbook format and features you need, including .xlsm files if macros matter.
  • Look for a clear explanation of what it can recover, rather than a promise that every file can be fixed.
  • Check the cost before scanning or saving. Some products allow a free scan but charge to export recovered data.
  • Download software only from a source you can verify, and be wary of unsolicited repair services or requests for passwords.

Do not send a workbook containing confidential information to an unknown service just because it advertises free repair. For a business-critical file, involve your IT team or data-recovery specialist before experimenting with multiple tools.

Other recovery routes and their trade-offs

If repair fails, an earlier version may be the best recovery tool. For files saved in OneDrive or SharePoint, use the file’s Version history to review and restore an earlier copy; the exact controls can depend on your account and where the file is stored. For a local file, check Windows File History or another backup system if one was configured. On a Mac, check Time Machine or the organization’s backup service.

If the workbook was recently closed without saving, Excel may offer recovery options when reopened. In Windows Excel, you can also check File > Info > Manage Workbook for available recovered or unsaved versions. Availability depends on whether AutoRecover or related recovery data was created; it is not a guaranteed backup and may not include the latest edits.

Opening a copy in another spreadsheet program, such as LibreOffice Calc, can sometimes make readable data accessible, but saving it back may alter Excel-specific formulas, macros, charts, or formatting. Importing it into Google Sheets has similar compatibility and privacy considerations. Use these as cautious ways to inspect or extract content, not as proof that the original workbook has been repaired. Preserve a copy before converting or resaving.

Cost, privacy, and prevention

Excel’s built-in Open and Repair feature is included with Excel, while commercial repair products set their own prices and licensing terms. Backup and version-history options may be available through an existing Microsoft 365, Windows, Mac, or workplace setup, but availability depends on the account and configuration. Compare the cost of a tool with the value of the missing data, and avoid paying before you know what the product can recover.

Prevention is more reliable than relying on repair. Store important workbooks in a location with version history or a managed backup, and make periodic separate backups for files that are especially valuable. Avoid disconnecting a drive or interrupting a sync while a workbook is saving. Close Excel normally, keep software and storage devices in good condition, and make a copy before major format conversions or bulk edits.

AutoSave can help when a workbook is stored in a supported OneDrive or SharePoint location, but it should not be treated as a complete backup. Version history and separate backups provide ways to return to an earlier state if a change or sync problem affects the current file.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?
Sometimes. Excel may detect a problem and offer recovery, or you can use Open and Repair on Windows. The result may omit damaged workbook elements, so inspect recovered sheets, formulas, and other features.

Where is Open and Repair in Excel?
In Excel for Microsoft 365 on Windows, go to File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. If the command is unavailable or fails, check backups and version history.

Can I repair an Excel file without losing data?
There is no guarantee. Excel’s Repair option may preserve more of the workbook, while Extract Data may recover values or formulas but omit other features. Always work on a copy and compare the result with a reliable source.

Can I recover an Excel file I did not save?
Possibly. In Windows Excel, check File > Info > Manage Workbook for available recovered or unsaved versions. Recovery depends on whether Excel saved suitable AutoRecover information; check cloud version history or backups too.

Is an online Excel repair tool safe?
Not automatically. An online tool may require uploading the workbook, which can expose its contents. Review its privacy and security information and follow your organization’s rules; avoid uploading sensitive files to a service you do not trust.

Does Excel for Mac have Open and Repair?
Mac Excel does not offer the same Windows command in many current builds. Try opening a duplicate and follow any recovery prompt, then look for a prior version in cloud history or a Mac backup.

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.