Can a Corrupted Excel File Be Fixed? Recovery Steps

How-to basics · Updated November 18, 2026

Yes, a corrupted Excel file can often be fixed, especially if the damage is limited or a recent backup is available. In Excel for Microsoft 365 on Windows, first make a copy of the file, then try File > Open > Browse, select the workbook, open the arrow beside Open, and choose Open and Repair; recovery is not guaranteed, so check the result carefully.

What Excel file corruption means

A workbook is corrupted when some of its saved content or internal structure can no longer be read correctly. The problem may affect the whole file, or just part of it. You might see an error saying Excel cannot open or repair the file, a message that the file format or extension is not valid, missing worksheets, damaged formatting, or a workbook that opens but behaves unpredictably.

Modern Excel workbooks such as .xlsx and .xlsm files are packaged containers holding data and supporting information, including worksheets, formulas, styles, charts, and—in macro-enabled files—VBA project content. A damaged component can prevent Excel from reading the package normally. Older .xls workbooks use a different binary format, but can also be damaged. Renaming a file extension does not convert its format or repair it.

Corruption is different from a workbook that is merely difficult to open. A password prompt, a blocked download, an unsupported file type, a broken external data connection, or a file opened in a program that does not support one of its features can look like a corruption problem. Identifying the exact message and when it appears helps avoid unnecessary repair attempts.

Why workbooks become damaged

Excel files can be damaged when saving or transferring is interrupted. For example, a computer may lose power while a workbook is being saved, an application may freeze, or a removable drive may disconnect during a write. Network interruptions and sync conflicts can also leave a file incomplete or replace a good copy with a problematic one.

Other possibilities include a failing storage device, a faulty transfer, a program or add-in that changes workbook content, or an issue with the Excel installation. A file is not necessarily corrupted just because Excel reports a problem: the extension may not match the actual format, or the file may have been created by another application with features Excel handles differently. If several unrelated workbooks fail, investigate Excel, Windows, or the storage location as well as the individual file.

Protect the original before trying repairs

Before experimenting, make a copy of the affected workbook and keep the original unchanged. If it is on a shared drive or cloud service, download or copy it to a local folder first, rather than repeatedly saving changes over the only copy. Give the copy a distinct name so you can tell it apart from the original and any recovered versions.

Then check whether another good copy already exists. Look in the original folder, email attachments, shared folders, backup software, and cloud version history. A recent intact version is often more complete and easier to restore than a repaired file. If the workbook contains important business, research, or personal records, preserve every candidate version until you have compared the recovered content.

  • Note the full error message and when it appears: during download, opening, or saving.
  • Check the file size. A zero-byte file or one far smaller than expected may be incomplete.
  • Confirm that the file extension is plausible, but do not rename it as a repair attempt.
  • Try a copy, not the only original, when using repair or conversion tools.

Use Excel Open and Repair on Windows

For Excel for Microsoft 365 on Windows, use Excel’s built-in repair option. Open Excel, choose File > Open > Browse, navigate to the file, and select it once. Instead of selecting Open directly, choose the small arrow beside the Open button and select Open and Repair. If Excel offers a choice, select Repair first. This asks Excel to recover as much workbook structure and content as it can.

If Repair does not work, repeat the process and choose Extract Data when that option is offered. Extract Data is a fallback that may retrieve values and formulas even when Excel cannot restore the workbook normally. It is not equivalent to a full repair: layout, formatting, charts, or other workbook features may be missing. Save any successful result under a new name and in a new location, then inspect it before treating it as complete.

If the file is stored on a network or removable drive, copy it to a local folder and try again. If Excel opens it in Protected View, use care before enabling editing: do so only when you trust where the file came from. Protected View is a security feature, not proof that a workbook is corrupted. If the Open and Repair option is unavailable or the menus differ in your Excel release, consult that version’s support guidance rather than assuming the same command exists on every platform.

Try backups, version history, and recovery copies

For a workbook saved in OneDrive or SharePoint, check its version history and restore or download a version from before the problem began. In Microsoft 365, version history is typically available from the file’s menu in OneDrive or SharePoint; the exact location can vary with the web interface and account. Be cautious about replacing the current file: download an earlier version or make a copy first, then compare it with the damaged one.

For files stored locally, check Windows File History or your organization’s backup system if either was configured. If Excel closed unexpectedly, reopen Excel and look for the Document Recovery pane. AutoRecover may have a usable draft, but it is not a substitute for a saved backup and may not contain the latest edits. Excel’s recovery settings can be reviewed through File > Options > Save on Windows; available options depend on the version and configuration.

Excel for the web and Excel for Mac may have different recovery options from desktop Excel for Windows. On a Mac, first check the original cloud location and its version history, then try opening a copy in the installed Excel app. Do not assume that Windows’ Open and Repair command is available in the same place—or at all—in a different Excel edition. If you use a different platform, consult its current Excel help for the applicable recovery process.

What to check after a workbook opens

A workbook that opens is not automatically a complete workbook. Compare its sheets, visible data, and last known changes with a backup or other source. Check for blank or missing tabs, truncated rows, altered number formats, and unexpected values. If the workbook is used for decisions, verify important totals and calculations independently against source records; a repaired formula can still refer to the wrong cells or produce a different result.

Also inspect features that may not be obvious at first glance. Review named ranges, charts, PivotTables, data connections, conditional formatting, hyperlinks, and any macros the workbook relies on. For an .xlsm file, confirm that expected macro functionality remains, and remember that Excel’s security settings may disable macros independently of file repair. Check external links and refreshable data only when you trust their sources. Save the recovered workbook as a new file, close it, and reopen that saved copy to confirm it remains usable.

Common problems and misleading messages

A message that the file format or extension is not valid can mean the file is damaged, but it can also mean that a renamed file has the wrong extension or that a download did not finish. Ask the sender to export or resend the workbook in its original format, and compare file sizes if you have another copy. Do not change .xlsx to .xls or the reverse and expect the contents to convert.

If only one workbook fails, focus on its copies, backups, and recovery options. If multiple workbooks fail, test Excel with a known-good file and consider whether an add-in, update, or system issue is involved. When a workbook opens but shows a security warning, password prompt, or link-update message, read that prompt separately: those conditions do not by themselves establish corruption. Avoid repeatedly forcing a damaged file to open and save, because each save can change the evidence or overwrite a recoverable version.

Repair tools, privacy, and when to ask for help

Third-party repair utilities may claim to reconstruct damaged workbooks, but their capabilities, costs, and privacy practices vary. A workbook can contain payroll details, customer information, financial records, or confidential research. Before uploading it to an online service, read its data-handling terms and consider whether your organization permits that transfer. Prefer an approved local tool or an IT support team for sensitive files.

Ask your IT administrator or a qualified data-recovery professional for help when the workbook is valuable, all backups are missing, the drive may be failing, or repair attempts produce inconsistent results. If storage hardware is making unusual noises or other files are disappearing, stop writing to it and seek advice; the issue may extend beyond Excel. A repair service cannot guarantee that every formula, macro, or piece of formatting will be restored, so ask what it will do to the original and whether it works on a copy.

How to reduce the chance of future corruption

Save important workbooks to a reliable location and maintain versioned backups, especially before major edits or changes to macros and connections. Cloud storage can provide version history, but syncing is not the same as an independent backup: accidental deletion or a bad change may sync too. For critical files, use a backup arrangement that preserves earlier versions and periodically confirm that copies can be opened.

Use Excel’s normal save process and wait for it to finish before shutting down or disconnecting a drive. Avoid editing the same file simultaneously in multiple applications or through conflicting sync processes. Keep Microsoft 365 and Windows reasonably up to date, and investigate repeated crashes or storage errors rather than treating each damaged workbook as an isolated event. For especially important data, keep a separate export or source record that can be used to rebuild the workbook if necessary.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?
Sometimes. Excel may offer to repair a workbook when it detects a problem, and Windows desktop Excel includes Open and Repair. Automatic recovery is not guaranteed, and the repaired file may have missing content or features.

Will Open and Repair recover every worksheet and formula?
No. It may restore the workbook, recover only some content, or fail. Compare sheets and important calculations with a backup or source data, and do not assume that a file is complete just because it opens.

Can I repair an Excel file without losing data?
Possibly, but there is no assured loss-free method for every damaged file. Preserve the original, try a backup or version history first, and run repair on a copy. Extract Data can recover useful content but may omit workbook features.

Why does Excel say the file format or extension is not valid?
The file may be damaged or incomplete, or its extension may not match its actual format. Obtain a fresh copy from the source when possible. Renaming the extension does not repair or convert the workbook.

Can I repair a corrupted Excel file on a Mac?
You can check backups and cloud version history, and try opening a copy with Excel for Mac. Windows instructions for Open and Repair may not apply to Mac, so check current Microsoft support guidance for the installed Mac version.

Is it safe to upload a workbook to an online repair website?
Not automatically. A workbook may contain sensitive or confidential information. Review the service’s privacy and retention terms and your organization’s rules before uploading; use approved support channels for protected data.

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.