How to Fix a Corrupted Excel File: Methods That Actually Work

A corrupted Excel file can mean anything from a workbook that refuses to open, to one that opens with scrambled data, missing sheets, or persistent error messages. The good news: Excel and the tools around it offer several recovery paths. The one that works for you depends on how the corruption happened, which version of Excel you're running, and how much of the original data still exists in recoverable form.

What Causes Excel File Corruption?

Before trying to fix a corrupted file, it helps to understand what you're dealing with. Corruption typically falls into a few categories:

• Abrupt shutdown or power loss while the file was open and being written
• Storage media failure — a failing hard drive, bad USB drive, or interrupted cloud sync
• File transfer errors — partial downloads, interrupted uploads, or email attachment encoding issues
• Software conflicts — add-ins, antivirus programs, or version mismatches between Excel releases
• File size and formula complexity — extremely large files with circular references or volatile functions can become unstable over time

The cause matters because it tells you something about what's still recoverable. A file corrupted during a crash often has most of its data intact — it just needs the right tool to extract it. A file on a failing drive may have sectors genuinely unreadable at the hardware level.

Method 1: Use Excel's Built-In Open and Repair Tool 🔧

This is the first thing to try. It's built into every modern version of Excel and costs nothing.

1. Open Excel (don't open the file directly)
2. Go to File → Open → Browse
3. Navigate to the corrupted file
4. Instead of clicking Open, click the dropdown arrow next to the Open button
5. Select Open and Repair
6. Choose Repair first; if that fails, try Extract Data

The Repair option attempts to recover the full workbook. Extract Data is a fallback that pulls out values and formulas even if the structure is too damaged to rebuild. You may lose formatting, charts, and pivot tables, but the raw data often survives.

Method 2: Recover from AutoRecover

Excel's AutoRecover feature saves temporary versions of your file at regular intervals. If the file corrupted during a session, an AutoRecover version may predate the corruption.

Find AutoRecover files by going to File → Info → Manage Workbook → Recover Unsaved Workbooks. Alternatively, check the AutoRecover folder directly:

AutoRecover files use the .xlk or .tmp extension. Open them as you would any Excel file. How useful this is depends entirely on how frequently AutoRecover was set to save — the default is every 10 minutes, but this is adjustable in File → Options → Save.

Method 3: Change the File Format and Re-Open

Sometimes the issue isn't deep corruption — it's a format mismatch or a damaged header. Changing the file's extension can bypass this.

Try renaming the file from .xlsx to .zip. Excel's modern format is actually a ZIP archive containing XML files. Once renamed, you can open it as a folder and manually inspect or extract the internal XML — particularly xl/worksheets/sheet1.xml — to recover data directly.

If the file is in the older .xls format, try opening it in a different application like Google Sheets or LibreOffice Calc. These tools sometimes parse corrupted binary Excel files more tolerantly than Excel itself.

Method 4: Open in Google Sheets or LibreOffice

Third-party spreadsheet applications use different parsing engines. A file that Excel refuses to open will occasionally load without issue in Google Sheets or LibreOffice Calc.

To try Google Sheets: upload the file to Google Drive, right-click it, and select Open with → Google Sheets. If it opens, export it back as .xlsx for use in Excel.

This approach works best on .xlsx files with minor corruption — typically damaged metadata or broken relationships between internal components rather than corrupted cell data.

Method 5: Restore a Previous Version 📁

If the file lives on OneDrive, SharePoint, or a Windows system with File History enabled, version history may give you access to a clean copy.

• OneDrive/SharePoint: Right-click the file → Version History
• Windows File History: Right-click the file or its containing folder → Restore previous versions
• macOS Time Machine: Browse to the file location in Time Machine and restore a prior version

Version history is arguably the cleanest recovery method when it's available — no repair tools needed, no data loss from the repair process itself. The limiting factor is whether versioning was active before the corruption occurred.

Method 6: Third-Party Recovery Tools

When built-in methods fail, dedicated file repair tools go deeper. These tools parse the raw binary structure of Excel files, bypassing the application layer that's refusing to open the file.

What these tools do well:

• Recover data from files Excel won't touch at all
• Reconstruct workbook structure from partial data
• Handle both .xls and .xlsx formats

What varies between tools:

• Whether they can recover formatting and formulas vs. values only
• Support for charts, pivot tables, and embedded objects
• Pricing and licensing models

Quality and reliability differ significantly between options. The key variable is the nature and depth of the corruption — no tool recovers data from sectors that are physically unreadable.

What Determines Your Best Path

The method most likely to work for you depends on several factors that aren't visible from the outside:

• How the corruption happened — crash recovery vs. storage failure vs. transfer error each responds differently
• Which Excel version you're running — Open and Repair behaves differently across Excel 2016, 2019, 2021, and Microsoft 365
• Where the file is stored — local drive, network share, cloud sync, or external media each affects both the cause and available solutions
• What you need to recover — raw data only, or full formatting and formulas
• Whether versioning or backups existed — this single factor often determines whether recovery is simple or complex

The severity of corruption exists on a spectrum. Some files need one click to repair. Others require chaining multiple methods together — Extract Data after Open and Repair fails, followed by manual XML inspection, followed by a third-party tool. Where your file sits on that spectrum, and which combination of tools fits your environment, is something only your specific situation can answer.