Excel File Is Corrupted and Cannot Be Opened: What It Means and How to Fix It

Quick answer

Excel says the file is corrupted because something in the workbook’s internal structure no longer parses cleanly — usually a bad save, a sync conflict, or a broken transfer. Make a copy of the broken file first, then try File → Open → Open and Repair in Excel. Most recoverable files come back at this step. If they don’t, work down the methods below in order, and stop the moment you have something usable.

Before you start

Back up the broken file first. Make a copy and put it somewhere safe. Every fix below modifies the file or its environment, and if a step makes things worse you want the original intact to try the next method on. This single habit is the difference between recovering most workbooks and losing a recoverable one.

Don’t double-click the file repeatedly hoping it’ll open this time. It won’t, and on some systems Excel overwrites parts of the recovery cache each time.

Do not download a “free Excel repair tool” before you’ve tried Excel’s own recovery flow. Excel’s built-in repair handles most fixable cases, costs nothing, and won’t ask for your file. Paid third-party tools have a place — but only after you’ve exhausted what’s already on your machine.

If this is a work or school file, see the work-device section below before changing any settings.

What this means

The error usually appears as one of these messages: “Excel cannot open the file ‘workbook.xlsx’ because the file format or file extension is not valid”, “The file is corrupt and cannot be opened”, or sometimes a more generic “Excel found unreadable content in workbook.xlsx” with a Yes/No prompt to recover.

A modern Excel file (.xlsx, .xlsm) is technically a ZIP archive containing XML files that describe sheets, styles, formulas, and shared strings. When Excel says the file is corrupted, it means at least one of those internal pieces won’t parse — the ZIP structure is broken, an XML file is malformed, or a relationship reference points to something that isn’t there.

That’s important because it tells you what’s actually recoverable. If the data inside the file is mostly intact but the wrapper is broken, recovery is straightforward. If the data sectors themselves are damaged — the cells, the shared string table — you’ll get partial recovery at best.

Where this error appears

Excel desktop on Windows 10, Windows 11 (including 24H2 and 25H2), and macOS — most common surface.
Excel for the web when opening a corrupted file from OneDrive or SharePoint.
Excel mobile apps, with a less informative error message.
Files attached to Outlook emails — frequently because the attachment was truncated mid-download or blocked by Protected View.
Files transferred from older versions of Office (2003 or 2007) into Microsoft 365.
QuickBooks, Xero, and similar exports that produce .xlsx files programmatically — these sometimes fail Excel’s stricter modern validation.

Common causes

Most “corruption” isn’t deep corruption. The likely culprits, ordered by frequency:

An interrupted save. Excel was force-closed, the laptop went to sleep mid-save, OneDrive sync interrupted the write, or the network drive disconnected.
Sync conflicts. OneDrive or SharePoint produced two competing versions and the merge failed. Look for files like workbook 1.xlsx or workbook-Conflict-PC1.xlsx in the same folder.
A wrong or missing extension. The file is fine, but Windows or Excel can’t tell what it is. (See the Excel file format or extension is not valid guide for this scenario specifically.)
A truncated transfer. Files downloaded from email or moved from a USB stick that disconnected before the copy finished.
A genuinely corrupt sector on the drive where the file lives. Rare, but real — especially on SD cards and aging external drives.
An add-in that wrote bad data into the file on the last save. COM add-ins for accounting, ERP, or analytics tools are the usual suspects.
An older Office version writing a format newer Excel rejects. Excel 2007 and 2010 produced edge-case .xlsx files that current Excel sometimes refuses.

Notice what’s not on the list: viruses don’t usually corrupt single Office files. If multiple unrelated files are unreadable on the same machine, you have a different problem — but a single broken workbook isn’t malware evidence.

Fixes to try first

Work through these in order. Each one is reversible, low-risk, and free. Stop the moment you have your data back.

1. Use Open and Repair

This is the single highest-yield fix and most users miss it because Excel doesn’t surface it on a double-click.

Open Excel with no workbook (just the start screen).
Go to File → Open → Browse.
Click the broken file once to highlight it. Don’t double-click.
Click the small dropdown arrow next to the Open button at the bottom-right.
Choose Open and Repair.
When prompted, choose Repair first. If repair fails or returns a near-empty workbook, run it again and choose Extract Data.

Repair reconstructs the file’s internal structure. Extract Data drops formatting, charts, and most formulas, but pulls the values and any formulas it can salvage into a new workbook. If Repair gives you a usable file, save it under a new name and stop here. Don’t keep going — every additional method risks the workbook you just got back.

2. Check for sync conflicts and earlier versions

If the file lives in OneDrive, SharePoint, Teams, or Dropbox, the cloud version may be fine even when the local copy isn’t.

OneDrive / SharePoint: right-click the file in File Explorer → Version history. Open earlier versions and save the most recent good one as a new file.
OneDrive web: go to onedrive.com, find the file, click the three-dot menu → Version history.
SharePoint: the same flow works in the document library.

This bypasses the broken local copy entirely. If you find a recent good version, you’re done — save it under a new name and move on.

3. Try opening in a different app

If Excel won’t open it, something else might. This is a useful diagnostic as much as a fix: if a third-party app can read the file, the data is fine and Excel is the problem.

Excel for the web at office.com — sometimes succeeds when desktop Excel fails because it uses a different parser.
Google Sheets at sheets.google.com — upload the file directly. Formatting and macros won’t survive, but values usually do.
LibreOffice Calc — free, available for Windows, Mac, and Linux. Open the file directly.

If any of these open the file, save a clean copy from there as a new .xlsx and you’re back in business.

4. Disable add-ins by opening Excel in safe mode

If Excel itself is the problem rather than the file, an add-in is the usual cause.

Press Windows + R.
Type excel /safe and press Enter.
Excel opens in Safe Mode with all add-ins disabled.
Try opening your file from File → Open.

If the file opens in Safe Mode, you have an add-in problem. Go to File → Options → Add-ins, change the dropdown to COM Add-ins, click Go, and uncheck add-ins one at a time until you find the one that breaks the file. Most often it’s an accounting, BI, or PDF add-in.

Advanced fixes

If the first four didn’t work, the file is more seriously broken. These methods recover less but extract more from genuinely damaged files. They’re more involved, more risky, and only worth trying if the data matters.

Set calculation to manual, then open the file

Some workbooks fail to open because a complex formula triggers a recalc loop the moment Excel parses it. Force the workbook open without recalculation:

Open Excel with a blank workbook.
Go to File → Options → Formulas.
Under Calculation options, set Workbook Calculation to Manual. Click OK.
Now try File → Open on the broken file.

If it opens, save a copy as a new file before changing anything. Then turn calculation back to Automatic.

Reference the broken file from a new workbook

This is the technique to use when the file won’t open at all but you can see it exists. You’re going to pull values out of it without ever fully opening it.

Make sure you have a backup of the broken file.
Open a new, empty workbook in Excel.
In cell A1, type: ='[broken-filename.xlsx]Sheet1'!A1 — replacing broken-filename.xlsx with the real filename and Sheet1 with the actual sheet name.
Press Enter. If prompted to update values, point to the broken file.
If the cell shows the correct value, drag the formula across the area you need.
Once the data is in your new workbook, copy it and Paste Special → Values to break the link.

This recovers data without macros, formatting, or formulas — but for a workbook full of numbers and text, it’s often enough.

Save in a different format to force a rebuild

Saving the file in an older or simpler format forces Excel to rebuild its internal structure, which sometimes drops the corrupted parts.

If you can open the file at all (even partially):

File → Save As.
Choose SYLK (Symbolic Link) to save just the active sheet as text-based data. Repeat for each sheet.
Or choose Excel 97-2003 Workbook (.xls) to force a major version downgrade.
Close the file, reopen the converted version, and save it as .xlsx.

SYLK is the recovery format of last resort — it strips everything that isn’t basic cell data. Old, ugly, and surprisingly effective.

About third-party repair tools

Search results for this error are dominated by paid recovery tools — Stellar Repair for Excel, EaseUS Fixo, Wondershare Repairit, 4DDiG, Recoverit, and others. They exist because there’s a real category of damage Excel’s own recovery doesn’t handle: severely truncated files, malformed compression headers, files where the shared string table is gone.

A few honest points:

They are not magic. Success rates on genuinely corrupted files are often 30–60%, not the 95%+ in marketing screenshots.
Most preview your file for free and only charge to save the recovered output. Use the preview to judge whether it’s worth paying.
They run locally — but most also offer “cloud upload” versions. Don’t upload a sensitive workbook to a third-party server unless you’ve checked the vendor’s policies and your employer’s rules.
“Free” versions usually limit recovery to a small file size or a small number of cells.

If you reach this point, the decision tree on Excel recovery tools walks through which tool fits which scenario. We don’t take affiliate money from any of these vendors.

If you are on a work or school device

A few things change when this is a managed device:

Don’t disable Protected View as a “fix.” It doesn’t repair the file — it just removes a security warning that may not be related to the corruption error in the first place. On managed devices, Group Policy may enforce the setting anyway.
Check OneDrive / SharePoint version history first. Most work files live in cloud storage, and version history may have a clean copy from before the corruption. Highest-yield work-device fix.
Talk to your IT team before installing a third-party repair tool. Most managed environments block third-party software, and uploading a work file to a vendor’s online repair service may violate your data handling policy.
If the file is a shared workbook, the corruption may have come from a co-author’s session. Check whether colleagues have a working version locally before you spend hours trying to repair yours.

If you are the IT person at a small business and this is a recurring problem, look at the OneDrive sync logs and Excel COM add-ins on the affected machines. Most “this keeps happening” cases trace back to a sync misconfiguration or a flaky add-in, not random corruption.

When to stop

There’s a point where continuing to repair the file does more harm than good. Stop when:

You have a usable copy of the data, even if it’s missing formatting, charts, or a few formulas. Save it under a new name and move on.
You’ve worked through Open and Repair, version history, alternative apps, and Safe Mode without success — and the data is not business-critical.
The drive itself is misbehaving (slow reads, other files unreadable, SMART warnings). Stop touching files on that drive and address the storage problem first.
You’ve spent more time trying to recover the file than re-creating its contents would take. A 30-minute spreadsheet rebuilt from notes is better than four hours chasing a 5% chance of full recovery.
The file contains sensitive data and the only options left involve uploading it to a third-party server you don’t trust.

A repaired file with 80% of the data, saved cleanly under a new name, is a win. Closing the laptop and rebuilding from scratch is sometimes also a win. Working from the same broken file all afternoon and ending the day with the same broken file is the only outcome you should refuse to accept.

Excel file format or extension is not valid — when the issue is the wrapper, not the contents.
Which Excel recovery tool fits which scenario — honest comparison of paid recovery tools, when each is worth using, and when none of them are.
How to recover an unsaved Word document — different problem, same family of recovery techniques.

Official references

FAQ

Why does Excel say my file is corrupted when it opened fine yesterday?

Most often, something interrupted the most recent save. OneDrive sync conflict, force-closed Excel, network drive disconnected mid-write, or laptop went to sleep at the wrong moment. The contents are usually fine; the file’s wrapper is what’s broken. Open and Repair fixes most of these.

Will Excel’s Repair option lose my formulas?

Repair preserves formulas where it can. The Extract Data option, which you only use if Repair fails, drops some formulas and tries to keep the calculated values instead. Always run Repair first.

Is it safe to use a free Excel repair tool from a download site?

Be cautious. Many “free Excel repair” downloads are bundled with adware, browser extensions, or bait-and-switch trials. If you’re going to use a third-party tool, download it directly from the vendor’s official site, and check whether your employer permits installing it. Excel’s own Open and Repair handles most fixable files without any download.

Why does the file open on my colleague’s computer but not mine?

Either their Excel installation has a different update level than yours (sometimes a recent Excel update temporarily breaks compatibility with edge-case files), an add-in on your machine is interfering, or your local copy of the file is the corrupt one and theirs is the cloud version. Try opening your copy from the same source they’re using.

Can I recover an Excel file that won’t open at all from OneDrive?

Yes — go to onedrive.com, find the file, and use Version history (three-dot menu → Version history). Earlier versions are stored separately from the current file, so even if the current version is corrupt, the previous one is often intact. This works the same way in SharePoint document libraries.

Should I disable Protected View to fix this?

No. Disabling Protected View doesn’t repair anything — it just removes a security check. If the file is actually corrupt, Protected View isn’t the cause. You’re trading off security for a fix that probably won’t work, and on a managed device you may not be able to change the setting anyway.

↑ Back to top