How to Recover a Corrupted Word or Excel File

Word reports that the file cannot be opened because there are problems with the contents. Excel announces unreadable content and offers to recover what it can. Either way the document you need is sitting there refusing to cooperate.

Before anything else: make a copy of the file and work only on the copy. Several of the techniques below modify the file, and a failed repair attempt can destroy data that a different method would have recovered. Keep the original untouched in a separate folder.

With that done, the routes below run roughly from highest to lowest odds.

Check it is actually corrupt first

Three things look like corruption and are not. Rule them out before doing anything invasive.

The last row is final rather than fixable. A file that arrived at 0 KB never arrived, and no software recovers content that was never written. Ask for it again, preferably as a share link rather than an email attachment.

The Protected View case catches people constantly: the file is perfect, Windows has flagged it because it came from the internet, and the error message does not make that obvious. If Excel opens grey rather than reporting an error, the causes are different and covered in Excel opening blank or grey.

1. Check the cloud version first

If the file ever lived in OneDrive, SharePoint or Google Drive, stop troubleshooting and look at version history. Each saved version is a separate complete copy, and corruption usually affects only the most recent write.

Right-click the file in the web interface and choose Version history, then open versions from newest backwards until one works. This is faster and more reliable than every repair technique below, and it gives you a genuinely intact file rather than a salvaged one.

The same applies to any backup — File History on Windows, Time Machine on macOS, or a copy on a drive you forgot about. A clean old version beats a repaired new one every time. Recovering a deleted file from OneDrive or Google Drive covers finding these.

2. Open and Repair

Office has a repair mode that is not obvious because it hides behind a dropdown arrow.

1. Open Word or Excel, but not the file.
2. File → Open → Browse.
3. Select the damaged file but do not double-click it.
4. Click the small arrow on the right of the Open button.
5. Choose Open and Repair.

Excel may then ask whether to Repair or Extract Data. Try Repair first; if it fails, Extract Data pulls values and formulas out without attempting to rebuild the structure.

This works often enough to always be worth trying, particularly for files damaged by an interrupted save. When it works, immediately Save As to a new filename rather than saving over anything.

3. Open it from a different context

Several tricks work by making Office read the file differently.

Insert it into a blank document. In Word, create a new blank document, then Insert → Object → Text from File and select the damaged one. This pulls the content through a different code path that sometimes tolerates damage the normal open does not.

Open it in a different application. LibreOffice, Google Docs and the web version of Office all parse Office formats with their own code. A file that defeats Word occasionally opens in one of them. Upload to Google Drive and double-click, or install LibreOffice and try there.

Change the extension. For a modern .docx or .xlsx, copy the file and try renaming the copy to .rtf for Word or .csv for a single-sheet Excel file, then open it. This fails more often than it works but costs nothing.

4. Extract the raw content from the ZIP

Modern Office files are ZIP archives. If the package structure is damaged but the contents are not, you can reach inside.

1. Copy the file and rename the copy from .docx to .zip.
2. Open it. If Windows opens it at all, the archive is readable.
3. word/document.xml contains your text surrounded by XML markup. Open it in Notepad and your words are there, interspersed with tags.
4. word/media or xl/media contains every embedded image, intact and extractable as normal files.

For Excel, xl/worksheets/sheet1.xml holds cell data and xl/sharedStrings.xml holds the text values. Both are readable in a text editor, though reconstructing a spreadsheet from them by hand is only worth it for small files.

This is also how you rescue images from an otherwise dead presentation or document. Even when the text is gone, the media folder frequently survives.

5. Recover Text from Any File

Word’s last-resort filter. It discards everything that is not a readable character.

1. File → Open → Browse.
2. Change the file-type dropdown in the bottom right to Recover Text from Any File (.).
3. Open the damaged file.

You get your text with no formatting, no images, no tables and a quantity of binary noise mixed in. Deleting the noise takes a while on a long document, and it still beats retyping twenty pages.

Excel’s rough equivalent is to try opening the file with the HTML or XML filter, which sometimes extracts cell values when nothing else will.

6. Excel-specific routes

Set calculation to manual before opening. If Excel crashes whilst opening the file, open a blank workbook first, go to Formulas → Calculation Options → Manual, then open the damaged file. A crash during recalculation looks identical to corruption.

Link to the data from a new workbook. In a blank workbook, type ='C:\path\to\[damaged.xlsx]Sheet1'!A1 in a cell and fill it across and down. If Excel can read the file at all, this pulls values out without opening it properly.

Try the autorecover and temp files. Excel writes working copies in the same places Word does. The routes are the same as for recovering an unsaved Word document, and the %Temp% folder is worth searching for files with a tilde prefix.

What not to do

• Do not keep saving over the damaged file. Each failed attempt can overwrite recoverable fragments. Copies, always.
• Do not run a disk cleanup or a PC optimiser whilst you are working on this. Temporary files are exactly what those remove, and your recovery candidates are temporary files.
• Do not pay for repair software before trying everything above. The free routes use the same techniques. Where a paid tool offers a preview, judge it on the preview, not on the marketing.
• Do not trust a repaired file silently. Check numbers, check formulas, check the end of the document. Partial recovery that looks complete is the worst outcome, because you find the gap three weeks later.

The honest limits

Some corruption is not recoverable, and it is worth knowing which.

A file truncated by an interrupted write — the save was half-finished when the machine lost power — is missing data that was never written. Nothing recovers it. The ZIP will usually not open at all, which is the tell.

A file encrypted by ransomware is not corrupt, it is encrypted, and repair tools cannot help. The only routes are backups and version history.

A file on failing storage may read differently each time you try. If other files from the same drive are also misbehaving, stop repairing documents and copy everything off the drive immediately, then deal with individual files from a healthy location.

Realistically, Open and Repair or a cloud version resolves most cases within a few minutes. When they do not, the text-extraction routes recover content without structure, and that is often enough. What almost never happens is a perfect recovery of a badly damaged file through a paid tool after the free methods have failed — if the data is not in the file, no software puts it back.