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.
Excel rebuilds the file structure and recovers formulas, formatting, and as much data as possible. Try this first — it preserves the most.
If Repair fails, this option pulls raw values and formulas into a new workbook. You lose formatting and some references, but the numbers survive.
When Extract Data prompts you, choose Convert to Values to keep results. Choose Recover Formulas if the math matters more than the static results.
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.
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.
Start Excel from the Start menu, not by clicking the broken file. A new blank workbook should appear.
Click File → Info. The right panel shows version history, properties, and the all-important Manage Workbook button.
Click Manage Workbook → Recover Unsaved Workbooks. Excel opens the hidden folder where every 10-minute autosave lives.
Pick the file by timestamp, open it, verify the data, then File → Save As with a proper .xlsx name and folder. Cache files expire after 4 days.
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.
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.
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.
Make a copy of your corrupted .xlsx file. Right-click → Rename and change the extension from .xlsx to .zip. Windows will warn you that changing the extension may break the file — click Yes to proceed. If you don't see the extension at all, enable File name extensions in File Explorer's View tab.
The renamed file is now a ZIP archive. Double-click it to open it like any other archive. You'll see a folder tree inside: _rels, docProps, xl. Your data lives in xl/worksheets/ and xl/sharedStrings.xml.
Inside xl/worksheets/ you'll find files named sheet1.xml, sheet2.xml, and so on — one per worksheet. Extract these to a folder you can work in. Each .xml file contains the cell data in a structured tag format like <c r="A1" t="n"><v>42</v></c> where r is the cell reference and v is the value.
Open the .xml in Notepad++ or VS Code. Text values are stored as indexes into sharedStrings.xml, not inline — so you'll need that file too if your sheet contains text. Numbers and formulas appear directly in the sheet files.
For small sheets, you can copy values manually into a fresh workbook — slow but reliable. For larger sheets, use Excel's Get Data → From File → From XML feature (under the Data tab) to import the sheet1.xml directly. Excel parses the XML and rebuilds the cells.
This method bypasses Excel's normal parser entirely, so it works on files that crash Excel on open. It's tedious but it's a guaranteed last resort when the data really matters — and it costs nothing.
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.
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.
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.
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.
Excel writes files in stages. Killing the process partway through leaves a half-written file that won't reopen. Give Excel 60 seconds before reaching for Task Manager.
Every network save is a multi-step transaction. A timeout at any step corrupts the file. Edit locally, copy to the share when done.
Older macros and third-party add-ins write data structures newer Excel versions read incorrectly. Disable add-ins one by one when crashes follow a pattern.
Failing SSDs, full drives, and antivirus interrupting writes are real causes. If multiple files corrupt in the same week, check disk health before blaming Excel.
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.
Open Excel and start a new blank workbook. Go to File → Info → Manage Workbook → Recover Unsaved Workbooks. A folder opens with every autosaved draft from the past 4 days. Find yours by timestamp, open it, and save under a real name. This is Excel's built-in safety net — it runs every 10 minutes by default.
It's Excel's native repair tool, hidden under the small arrow next to the Open button in File → Open. Two modes: Repair rebuilds the file structure (try first); Extract Data pulls raw values when Repair fails. It fixes about 70% of corruption cases without any third-party software.
Yes — OnlineFile.Repair offers a free tier that uploads your .xlsx and previews the recovered content. The free version limits file size and may require payment for the full download, but the preview alone often confirms whether your data survived. Never upload sensitive or confidential files to free online services.
If the file was on OneDrive or SharePoint, right-click it in the cloud interface and choose Version History — you can restore any version from the last 30 days. For local files, check File → Info → Version History in Excel itself, or use Windows File History if you enabled it before the overwrite. Without a backup system, overwritten files are usually unrecoverable.
Most often it's a corrupted add-in, not the file itself. Open Excel in Safe Mode (hold Ctrl while launching) and try the file again. If it opens fine, an add-in is the culprit — disable them one at a time via File → Options → Add-ins. If Safe Mode also crashes, the file is likely corrupted — run Open and Repair on it.
Enable AutoSave on OneDrive-synced files, set AutoRecover to 2 minutes, never force-quit Excel mid-save, edit on local drives not network shares, and keep workbooks under 100MB. These five habits eliminate the vast majority of corruption cases. Also disable add-ins you don't actively use — older add-ins are a leading cause of crashes.
Worth it only when free methods have all failed. Stellar Repair runs about $49 and recovers things Excel's native repair often loses — chart data, cell comments, conditional formatting, hyperlinks. Use it for one-off serious corruption where the data has real business value. For routine fixes, Open and Repair is free and handles most cases just fine.
Rename your .xlsx to .zip and open it as an archive. Inside, xl/worksheets/sheet1.xml contains your cell data in XML format. Open the XML in Notepad++ or import it back into Excel via Data → Get Data → From XML. Text values reference sharedStrings.xml in the same archive. Tedious but always works when nothing else will.