Excel File Is Corrupted? How to Restore a Damaged Spreadsheet
A corrupted spreadsheet is especially stressful because it often contains data — financial records, tracked numbers over time — that isn't easily reconstructed from scratch. The good news is that partial recovery is often possible even when the file won't open normally.
What typically causes it
The most common causes are an interrupted save (the program or computer crashing mid-write), a file that was only partially transferred or downloaded, or damage to whatever storage medium the file was sitting on. Very large, complex spreadsheets with heavy formula use are also somewhat more prone to corruption than simple ones, since there's more internal structure that can go wrong.
Try opening in a different program first
Different spreadsheet programs have different tolerances for malformed file structure — one might refuse to open a file that another can open with a warning about repaired content. This costs nothing to try and occasionally recovers a file entirely.
Check for an autosave or backup copy
Most spreadsheet software maintains autosave or temporary backup files during editing, sometimes recoverable even after the main file is damaged — worth checking a program's autosave/recovery folder before assuming the data is genuinely gone, since these are often more recent than you'd expect.
If the file partially opens
Sometimes a damaged spreadsheet opens with some sheets or sections missing rather than failing completely — in that case, immediately saving a fresh copy of whatever did successfully open (rather than continuing to work in the damaged original) prevents losing the partial recovery to a second crash.
Recovering from a PDF export, if one exists
If you'd previously exported the spreadsheet to PDF (for sharing or printing) before it became corrupted, that PDF — while not a live spreadsheet — at least preserves the data as it existed at that point, and can be converted back into an editable spreadsheet to recover at least that version's worth of data.
If a PDF export of the data exists from before the corruption, PDF to Excel can extract that data back into a working spreadsheet. Going forward, periodically exporting important spreadsheets with Excel to PDF creates a recovery point that isn't vulnerable to the same corruption risk as the live file, and CSV to Excel is useful if you have the underlying data in a simpler backup format.