What you can do when an Excel file won't open
A corrupted Excel file usually won't open at all, or opens with missing data and error messages. The file itself is still on your computer — the problem is that Excel can't read the structure inside it. You have several ways to recover the data, starting with the simplest: using Excel's built-in repair tool. If that doesn't work, you can try opening the file in a different program, exporting the data to a new file, or using recovery software designed for this problem.
The cause matters less than the fix. Corruption happens when a file is interrupted while saving (power loss, crash, forced shutdown), when malware damages the file, or sometimes when the file is transferred between computers or cloud services incorrectly. None of these mean your data is gone — it usually means Excel just can't parse the file format anymore.
Key Takeaways
- Excel has a built-in repair tool under File > Open > Browse, then right-click the file and choose Open and Repair.
- If repair fails, try opening the file in Google Sheets or LibreOffice Calc, which sometimes read corrupted files that Excel cannot.
- You can export recovered data to a new Excel file by copying and pasting from the alternative program.
- Recovery software like EaseUS Data Recovery or Recuva can restore older versions of the file if the current one is severely damaged.
- Prevention is simpler than recovery: enable AutoSave in OneDrive or SharePoint, or save local backups regularly to a separate drive.
Using Excel's built-in repair feature
Excel has a repair tool that attempts to fix corrupted files automatically. Open Excel itself (not the file). Go to File, then Open. Click Browse to find your corrupted file. Right-click the file name and select Open and Repair from the menu. Excel will attempt to recover the file and open it.
If the repair succeeds, you'll see the file open normally or with a message saying "Excel completed file level validation and repair." Save this version when ready to a new file name — use File > Save As and give it a different name, like "filename_recovered.xlsx". Do not overwrite the original until you've confirmed the data is correct.
If repair fails, Excel will tell you it cannot open the file. This doesn't mean the data is lost — it means this tool can't read it. Move to the next method.
Opening the file in Google Sheets or LibreOffice Calc
Excel is strict about file format. Other spreadsheet programs are sometimes more forgiving. Try uploading your corrupted .xlsx file to Google Sheets: go to sheets.google.com, click the New button, select File Upload, and choose your corrupted Excel file. Google Sheets will attempt to convert and open it.
If Google Sheets opens the file, you'll see the data displayed. Some formatting may be lost, and some cells may show errors, but the raw numbers and text are usually recoverable. Select all the data (Ctrl+A on Windows, Cmd+A on Mac), copy it, then open a new Excel file and paste it in. Save this as a new file.
If Google Sheets also can't open it, read and install LibreOffice Calc (free, from libreoffice.org). Open LibreOffice Calc, go to File > Open, and select your corrupted Excel file. LibreOffice sometimes succeeds where Excel fails. The process is the same: copy the recovered data and paste it into a new Excel file.
Exporting data from a partially opened file
Sometimes Excel opens the file but shows error messages or displays it incorrectly. If you can see any data on screen, you can save what's visible. Select all the cells with data (Ctrl+A), copy them (Ctrl+C), then open a new blank Excel file and paste the data in (Ctrl+V). Save this new file with a clear name like "filename_recovered.xlsx".
This method loses any formulas — you'll get only the values that were calculated. If your spreadsheet contains complex formulas you need to keep, this approach won't fully restore them. But it preserves the actual numbers and text, which is usually the most important part.
Using file recovery software
If the file is severely corrupted and the methods above don't work, recovery software can sometimes restore an older version of the file from your hard drive. Programs like EaseUS Data Recovery Wizard or Recuva scan your disk for file fragments and attempt to rebuild them.
read and install the recovery software on your computer (not on the drive where the corrupted file is stored). Run a scan of the drive containing the file. The software will show you a list of recoverable files, including older versions of your Excel file. Select the version you want and let the software restore it to a different location (like an external drive or USB stick).
Recovery software works best if the file was recently deleted or overwritten. If the file is still on your drive but just corrupted, success is less certain. These tools are not free — most cost between $20 and $100 — so try the free methods first.
Preventing corruption in the future
The easiest fix is to avoid corruption in the first place. If you use Microsoft 365 (the subscription version of Office), enable AutoSave for files stored in OneDrive or SharePoint. AutoSave creates a new version of your file every few seconds, so even if the current version corrupts, you can recover from an earlier version. Go to File > Info and turn on AutoSave if it's available.
If you work with local files on your computer, save regularly and keep a backup copy on a separate drive or cloud service. Use File > Save As to save a copy to an external USB drive or cloud storage (Google Drive, Dropbox, OneDrive) at the end of each work session. This way, if your main file corrupts, you have a recent backup to fall back on.
Avoid interrupting saves: don't force-shut down your computer while Excel is saving, and don't unplug external drives while files are open on them. These are the most common causes of corruption.
Frequently Asked Questions
Can I recover data from an Excel file that was deleted?
If you deleted the file recently and haven't filled your hard drive with new data, recovery software can often restore it. Recovery software scans for file fragments and rebuilds them. The sooner you run the software after deletion, the better your chances. Do not save new files to the drive until you've attempted recovery, as new data can overwrite the deleted file's fragments.
What if the file opens but shows #REF! or #VALUE! errors?
These errors usually mean formulas are broken, not that the file is corrupted. Try using the repair tool first. If repair doesn't fix it, copy all the data to a new file — the errors may not transfer. If they do, you may need to manually re-enter the formulas or check whether linked files (files the spreadsheet references) are missing or moved.
Will I lose formatting if I recover the file?
Possibly. Excel's repair tool usually preserves formatting, but alternative programs like Google Sheets and LibreOffice Calc may not. Colors, fonts, and cell borders sometimes don't transfer. The data itself — numbers, text, and values — almost always survives. If formatting is critical, try Excel's repair tool first before moving to other programs.
Is there a way to recover an Excel file from the cloud if it corrupted?
Yes. If the file is stored in OneDrive or SharePoint, right-click the file name and select Version History. You'll see a list of earlier versions. Select a version from before the corruption occurred and click Restore. This is faster and more reliable than recovery software, so always check version history first if your file is in the cloud.