Repair Excel File — Complete Guide (2026)

Repair Excel File — Complete Guide (2026)

Your workbook won't open. Maybe Excel throws an error. Maybe it crashes mid-load. Maybe the file shows zero bytes after a network drive hiccup. Don't reach for a paid tool yet — Excel ships with its own repair engine, and it fixes the majority of cases.

This guide walks through five working methods, ranked by effort. Start with the built-in Open and Repair command. That alone solves roughly 70% of corruption I've seen across years of file rescue. If it can't, move down the list.

The other techniques here aren't widely known. The HTML export trick saves files even when Open and Repair gives up. Renaming an .xlsx to .zip lets you pull out raw data by hand — ugly, but it works when nothing else will. Paid tools exist for catastrophic cases, and there's one free online option worth knowing about.

Quick context on why files break: force-quitting Excel during a save, network drive timeouts, files bloated past 100MB, conflicting add-ins, and the occasional bad sector on disk. Most corruption isn't your fault — but most of it is also fixable. Let's start with the fastest method.

Before you try anything else, make a copy of the broken file. Every method below should run against the copy, never the original. If a recovery attempt makes things worse — and sometimes it does — you want the untouched source still sitting there. Backup first, repair second. That's the rule.

How to Run Open and Repair Step by Step

Launch Excel — but don't double-click your broken file. That's the mistake most people make. Instead, open Excel first with no file loaded, then go to File → Open → Browse. Navigate to your corrupted workbook but don't click it yet.

Click once on the file to highlight it. Now look at the Open button at the bottom-right of the dialog. See the tiny downward arrow on its right edge? Click that arrow, not the button. A short menu appears with options including Open and Repair. Choose it.

Excel asks whether to Repair or Extract Data. Pick Repair. The process takes anywhere from a few seconds to a minute or two depending on file size. You'll see a small status dialog when it completes — it lists any sections that couldn't be recovered. Save the repaired file under a new name immediately. Never save back over the original until you've confirmed the recovery is complete.

When Repair Fails

Run Open and Repair a second time on the same file. This time, pick Extract Data. Excel will ask whether to Convert to Values or Recover Formulas. If your file is mostly static data (reports, exports, finished work), choose Convert to Values — it's more reliable. If the formulas are the point of the file, try Recover Formulas first and fall back to Convert if it errors out. The result lands in a new workbook with whatever Excel could salvage.

One subtle catch: the repaired file sometimes loses macros, named ranges, or VBA modules even when the data looks intact. Open the result and check Formulas → Name Manager and Developer → Visual Basic before declaring victory. If the macros are gone but you have an older copy of the file from backup, you can sometimes paste the VBA back in manually. Always check before you delete the original.

Method 2: AutoRecover for Unsaved Workbooks

Lost a file you never saved? Or saved it but Excel crashed before the save completed? AutoRecover has your back — it silently keeps backups every 10 minutes by default. Here's how to find them.

Open Excel and start a new blank workbook. Go to File → Info. Look for the Manage Workbook button (sometimes labeled Manage Document). Click it and choose Recover Unsaved Workbooks. A folder opens showing every autosaved draft Excel has cached. The filenames look cryptic — random characters with .xlsb extensions — but the modification timestamps tell you which is which.

Open the candidate, check the contents, and save it properly with File → Save As. The unsaved-workbooks cache holds files for up to 4 days, so even old crashes might still have recoverable drafts sitting there. If your file was saved but you want an older version, check File → Info → Version History instead — but that only works for OneDrive or SharePoint files. Local files don't have version history unless you enabled File History on Windows.

Speeding Up AutoRecover

The default 10-minute interval is too slow for serious work. Open Excel Options → Save and drop it to 2 or 3 minutes. The save happens in the background and barely impacts performance. Pair this with enabling AutoSave (the toggle in the top-left of any OneDrive-synced workbook) and you basically can't lose data — every change syncs to the cloud in real time with full version history.

A note on AutoRecover file location. The cache lives under %LOCALAPPDATA%\Microsoft\Office\UnsavedFiles on Windows and inside the Library folder on Mac. You can browse there directly if Excel itself won't launch — sometimes you'll find a recoverable copy when nothing else works. Mac users can also try the Time Machine restore if it's running.

Method 3: The HTML Export Trick

This one isn't documented anywhere official, but it works on files that defeat Open and Repair. The idea: Excel's HTML export uses a completely different code path than its native binary parser. Files corrupted in the binary layer often export cleanly to HTML.

Here's the move: open the broken file using Open and Repair in Extract mode (any partial result will do). Go to File → Save As → Web Page (*.htm; *.html). Pick Entire Workbook, not just the active sheet. Save it. Close Excel completely.

Now open the saved .html file in Excel directly. It loads as a structured table with formatting and most formulas intact. From there, do Save As → Excel Workbook (*.xlsx). The resulting .xlsx is clean — the round-trip through HTML stripped whatever was broken in the original.

One limitation: charts and pivot tables don't survive the HTML round-trip. You get a snapshot image of the chart, but you lose the live link to the source data. For files that are mostly raw data and formulas, this trick works beautifully. For dashboard-style workbooks heavy on visualizations, expect to rebuild charts after the recovery.

Method 5: Paid Recovery Tools

When the built-in methods can't recover your file and the data is worth real money to rebuild, paid tools become reasonable. They use proprietary recovery algorithms that can salvage files Excel itself gives up on. Here's the honest landscape — what each tool actually does, and when it's worth the cost.

Stellar Repair for Excel is the most cited tool, priced around $49 for a single-user license. It handles deep corruption, recovers cell comments, charts, hyperlinks, and conditional formatting — things Excel's native repair often loses. The free demo previews recovered content so you can verify before paying. Good for one-off serious corruption.

Recover Toolbox for Excel sits at $27 to $99 depending on license tier. It's more aggressive on heavily damaged files but the interface is older. Their online repair service costs $10 per file if you'd rather not install software — useful for a single emergency.

EaseUS Data Recovery Wizard ($69.95+) is a broader file-recovery tool, not Excel-specific. It's the right pick when your problem isn't corruption but deletion — you emptied the Recycle Bin and need the file back from disk sectors. Most Excel-specific tools won't help there, but EaseUS will. Spend the money here only if the file is truly gone, not just broken.

One warning: don't use a paid tool as a first move. Run Open and Repair first. Then HTML export. Then ZIP-XML. Most users who pay for these tools could have recovered their file for free with the techniques above. Reserve paid tools for when free methods have all failed and the file genuinely matters.

Free Online Repair Options

If you can't install software (locked-down work computer, Chromebook, etc.), online repair is a fallback. OnlineFile.Repair is the main free option. Upload your .xlsx, wait for the server-side repair, and download the result. The free tier limits file size and shows preview-only output until you pay for the full download — but the preview is sometimes enough to confirm whether the data survived.

Trust caveats: never upload sensitive financial, HR, or proprietary data to a free online service. The privacy policy is what they say it is. For internal-use files where the contents aren't sensitive, online repair is fine. For anything confidential, stick to local methods or a paid offline tool.

If you want to learn more Excel troubleshooting techniques, our guide on recovering excel files goes deeper on AutoRecover edge cases, and the macros are disabled excel walkthrough covers a related class of opening errors that look like corruption but aren't.

Preventing Excel File Corruption

Most corruption is preventable. The same handful of habits eliminate the vast majority of broken-file emergencies — and they cost nothing to adopt.

Start with AutoSave. If you use Excel through Microsoft 365 with files stored in OneDrive or SharePoint, the AutoSave toggle in the top-left of the window is the single best protection you have. It syncs every change to the cloud in real time and maintains full version history. Even if Excel crashes mid-edit, the next open shows your work intact. Combined with OneDrive's Version History feature (right-click the file in OneDrive web → Version history), you can roll back to any previous state from the last 30 days for free, longer with paid plans.

For files that have to stay local — confidential data, no cloud allowed — set AutoRecover to its minimum 1-minute interval in File → Options → Save. Yes, it does a tiny bit of disk write every minute. No, you won't notice the performance impact. The recovery cache it builds saves so many emergencies that the trade-off isn't close.

Network drives are the silent killer of Excel files. Every save to a network share is a multi-step transaction — lock file, write data, release lock, update timestamps. A network hiccup at any step can leave the file partially written and corrupted. The rule: edit on local drive, save to local drive, then copy the finished file to the network share. Never use Open in Excel against a network path for files larger than a few MB.

Watch File Size

Excel handles workbooks up to about 100MB reasonably well. Beyond that, the risk of corruption rises sharply — and so does the chance Open and Repair can't recover the file if something goes wrong. If your file is creeping toward 100MB, audit it. Unused formatting on millions of cells, hidden sheets with experimental work, embedded images at original resolution — all of these bloat files without adding value.

Common file-size killers: cell formatting applied to entire columns (use Ctrl+End to find the actual last cell; if it's far below your real data, format only the used range); unused defined names accumulated over years (Formulas → Name Manager → delete unused); and full-quality embedded images (compress via the Picture Format ribbon). Splitting one massive workbook into linked files is almost always better than fighting with a 200MB monster.

Add-Ins, Stability, and the Final Diagnostic Step

If Excel crashes at consistent moments — opening a specific file, after a specific action, or always at the same memory threshold — try disabling add-ins one at a time. Go to File → Options → Add-ins. At the bottom, change Manage to COM Add-ins or Excel Add-ins and click Go. Uncheck each and restart Excel between toggles.

Common culprits include older versions of Bloomberg, Power Query iterations, and accounting integrations that haven't been updated for current Excel builds. Anti-virus extensions that scan every file open also slow things down enough to trigger save-related corruption on big workbooks. Disabling a problematic add-in usually fixes both the crashes and any new corruption issues immediately.

One more diagnostic step worth knowing: Safe Mode. Hold the Ctrl key while launching Excel and it opens with all add-ins disabled and most settings reset. If the broken file opens fine in Safe Mode, the problem isn't the file — it's something in your Excel configuration. If it still won't open in Safe Mode, the file itself is damaged and you're back to the repair methods above.

For repeated corruption, look at your hardware. Run chkdsk /f from an admin command prompt to check disk health. Check that the drive isn't running low on space — Excel needs working room during a save, and a nearly-full drive forces it to write in fragments. Modern SSDs with good wear-leveling rarely cause problems, but older mechanical drives developing bad sectors do.

The combined effect of these habits — AutoSave, short AutoRecover intervals, local editing for network files, regular add-in audits, and disk health checks — drops corruption rates to nearly zero. The worst case becomes a 2-minute Open and Repair instead of an hour of XML extraction. If you've made it through this guide, you now have every tool you need to handle whatever Excel throws at you.

One last tip worth remembering: when you successfully recover a file, save the recovered copy in at least two places before doing any further editing. The repair process can leave subtle issues that don't show up until you save again — formula references that look fine but resolve incorrectly, formatting that gets stripped on the next save, or sheet protection settings that won't reapply. Keep the recovered version untouched as a baseline, and do your work on a second copy. If the second save breaks anything, the baseline is still there to fall back on.

Excel's repair tools are far more capable than most people realize. The combination of Open and Repair, AutoRecover, HTML export, ZIP-XML extraction, and selective use of paid tools covers every realistic corruption scenario short of a disk failure that wipes the file entirely. Treat backup discipline as the real solution — AutoSave, OneDrive sync, and short AutoRecover intervals make corruption a minor inconvenience rather than a disaster.