Repair Excel File: Diagnose and Fix Corruption Free

Is your Excel file actually corrupted, or is it just throwing an error you haven't seen before? That distinction matters more than most tutorials admit, because the fix for a file that won't open is completely different from the fix for a file that opens but shows garbled data. Jump to the wrong method and you can make things worse. Overwrite the wrong file and the data's gone for good.

I learned that the hard way in 2017, when a client's IT team overwrote three months of logistics dashboard work during a server migration. My local backup was two iterations behind. What I got back was partial, stitched together, and painful. Since then, my philosophy hasn't changed: file repair is a last resort. But when you need it, you need to know what you're actually dealing with before you start clicking. Triage first, fix second, and free and native wherever possible.

If you're newer to Excel and want broader context on how errors and damaged files tend to behave, the Common Excel Errors and Troubleshooting guide covers the full spectrum worth knowing.

What You Can Recover — and How to Diagnose a Corrupt Excel File Before You Try Anything

Before touching the file, make a copy. Right now, before anything else. Paste it to your desktop, rename it with today's date, and treat the original as evidence you don't tamper with. Every step below should happen on the copy.

Not all data survives corruption. VBA macros are often the first casualty — Excel's repair process frequently strips them out even on a successful recovery. Formulas, formatting, and cell values have a much better survival rate. Set your expectations before you start.

What "corruption" actually looks like: symptoms that tell you which fix to try first

The symptom your corrupted file shows you is the fastest diagnostic tool you have. A file that refuses to open entirely (usually throwing a "file format or extension is not valid" error) is structurally damaged, and Open and Repair is your first move. A file that opens but displays scrambled values or missing sheets probably has internal reference damage; external reference extraction is the better path. A file that used to open fine and suddenly doesn't after a system crash is most likely recoverable through AutoRecover or version history, because the content is intact and only the save was interrupted.

What causes Excel files to become corrupted in the first place? System crashes mid-save, abrupt power failures, incomplete network transfers, and storage drive errors are the most common culprits. An xlsx file is actually a ZIP archive containing XML files, and any interruption to that structure can render the whole thing unreadable to Excel.

Match the symptom to the right fix before you start — the wrong method can make recovery harder.

Step 1: Let Excel's Built-In File Recovery Mode Do the First Pass on Your Damaged Workbook

Once you've made your copy and identified the symptom, Excel's own tools are your first line of attack. They're free, private (nothing leaves your machine), and surprisingly effective for crash-interrupted saves.

If Excel detects a problem on its own when you open the file, it'll launch File Recovery mode automatically. You'll see a recovery pane on the left side listing available versions. Open the most recent one, check whether your data looks intact, and if it does, save immediately to a new filename. Don't overwrite the damaged original yet.

Automatic recovery doesn't always trigger. That's normal, especially for structural corruption rather than incomplete saves.

Run Open and Repair manually when automatic recovery doesn't trigger

1. Windows: Open Excel to a blank workbook, go to File > Open > Browse, and navigate to your corrupted file. Don't double-click it. Click the dropdown arrow next to the Open button and select Open and Repair.
2. Mac: The path is the same — File > Open — but the dropdown arrow sits next to the Open button in the dialog itself. Select Open and Repair from there. This works in Excel 2016 and later on both platforms.
3. Excel will ask whether to repair or extract data. Choose Repair first. If that fails, run it again and choose Extract Data.
4. If the file opens, save a clean copy immediately to a new filename.

If Open and Repair comes up empty, that's not the end. It means you're escalating to the next method.

Step 2: Extract Your Data from the xlsx File When Repair Comes Up Empty

Open and Repair is good at fixing interrupted saves. It's not great at recovering data from genuinely damaged file structures. When it fails, you shift from repairing to extracting: pulling the data out before the file itself is gone for good.

Restore a previous version from OneDrive or Windows File History

Check version history before trying any manual extraction. If the workbook was saved to OneDrive, right-click the file in File Explorer (or open it and go to File > Info > Version History). OneDrive often has timestamped snapshots going back weeks. With Microsoft 365 autosave enabled by default for cloud files, there's a real chance a clean version is sitting there waiting.

On Windows without OneDrive, right-click the file in File Explorer and select Restore previous versions. If Windows File History was enabled, it will show available backups. This is the fastest and cleanest recovery path when it works — nothing else competes with it.

Version history is also where most people discover they never turned on File History. After the 2017 disaster, I now give every client written instructions on file versioning: naming conventions, backup frequency, AutoSave settings. It takes ten minutes to set up and it's the difference between a bad afternoon and a catastrophic one.

Pull data out using external references or the SYLK format workaround

If version history is a dead end, you can try pulling data from the damaged workbook using external references from a fresh file. Open a new Excel workbook, click into an empty cell, and type a reference pointing directly at the corrupted file:

='[CorruptedFile.xlsx]Sheet1'!A1

If Excel can read any part of the damaged file's structure, this will pull the value through. It's tedious for large datasets, but it works for rescuing specific data you know is in there.

The SYLK format workaround is another option for files that open but display errors. Save a copy of the damaged file as SYLK (.slk) via File > Save As, close Excel, then reopen the .slk file. SYLK strips formatting and VBA entirely, but it often preserves cell values that other methods can't touch. Think of it as data triage, not a full recovery.

A word on online Excel repair tools: they exist, and some of them work. But if your workbook contains financial records, client data, or anything proprietary, uploading it to a third-party server is a real privacy trade-off. Read the privacy policy and know who's receiving your file before you go that route.

The Excel for Beginners guide covers file security basics worth understanding before you make that call.

Common Mistakes When Repairing an Excel File — Including the Ones That Cost You the Data for Good

Three mistakes account for most permanent data loss, and they're all avoidable.

1. Everything stays on your machine — no privacy risk.
2. Free tools built into Excel and Windows handle the majority of cases.
3. Version history recovery, when available, restores the file completely.

1. Overwriting the original file before making a copy. Once you save over a corrupted workbook with a more damaged version, there's no coming back.
2. Skipping the version history check. A clean copy might be one click away in OneDrive or File History before you burn time on manual extraction.
3. Uploading sensitive files to unvetted online repair tools. Some retain uploaded files. If your file contains anything you'd hesitate to email a stranger, treat it that way.

Failing to maintain backups isn't bad luck — it's a preventable error dressed up as a disaster. The corruption usually isn't your fault. Having no fallback always is. If this experience has you rethinking your error-handling habits more broadly, the Introduction to Excel Errors and Troubleshooting is a solid next read.