What to do when Excel won't open your file
When Excel refuses to open a file or shows an error message, the file itself may be corrupted — meaning some of the data inside got scrambled or damaged. Excel has a built-in repair tool that can often fix this without you losing the whole spreadsheet. The repair happens automatically in most cases, but you may need to tell Excel to try it, or use a different method if the automatic repair fails.
The fastest approach depends on what error message you see and whether the file opens at all. Some files repair themselves the moment you try to open them again. Others need you to use Excel's Open and Repair feature. A few may require you to save the file in a different format or recover an earlier version from your backup.
Key Takeaways
- Excel's Open and Repair tool is built into the File menu and works without installing anything extra.
- If the file opens but shows errors, you can often save it as a different format (like CSV or XLSX) to strip out the corruption.
- Windows stores automatic backups of recent files in a hidden folder you can browse if the original is too damaged to repair.
- If you have a backup from before the corruption happened, restoring that version is usually faster than trying to repair the damaged file.
- Some corruption is permanent, especially if the file was damaged during a crash or power loss — this is why backups matter more than repair.
Using Excel's Open and Repair feature
This is the first thing to try. Open Excel (not the file itself). Go to File at the top left, then click Open. In the dialog that appears, find your corrupted file and select it — but do not double-click it yet.
Instead, look for a dropdown button next to the Open button (it may say "Open" with a small arrow). Click that dropdown and choose Open and Repair. Excel will attempt to fix the file automatically. If it succeeds, the file opens and you can save it fresh. If it fails, Excel tells you it could not repair the file, and you move to the next method.
This works because Excel can often rebuild the structure of a spreadsheet even if parts of it are damaged. The repair process strips out the corrupted sections and recovers what it can. You may lose some formatting or a few cells of data, but the bulk of the spreadsheet usually survives.
Saving the file in a different format
If Open and Repair does not work, try opening the file in a different format. Corruption often lives in one part of the file structure, and saving as a different format forces Excel to rewrite the entire file from scratch, leaving the corruption behind.
If the file is named something.xlsx, try saving it as something.csv (comma-separated values). Open the corrupted file in Excel if it will open at all, then go to File > Save As. Change the file type dropdown to CSV (Comma delimited) and save it with a new name. Then close that file and open the new CSV file. Excel will ask you about formatting — click Yes to keep going. Once it opens, go to File > Save As again and save it back as an Excel file (.xlsx).
This round-trip conversion works because CSV is a simpler format with less room for corruption to hide. The data survives the conversion even if the original formatting does not. You may lose colors, merged cells, or formulas, but numbers and text usually come through intact.
Recovering an earlier version from Windows
Windows automatically saves backup versions of files you have been working on. These backups live in a hidden folder and are not the same as the backups you made yourself — they are snapshots Windows takes while you work.
To find them, right-click the corrupted file in File Explorer and select Restore previous versions (on Windows 10 or 11). A list appears showing older versions of that file with dates and times. Pick a version from before the corruption started (if you know when that was) and click Restore. Windows replaces the corrupted file with that older version.
This only works if you have File History or System Protection turned on, which is the default on most Windows machines. If the list is empty, those backups were never created or have been deleted. This is another reason to keep your own backups — Windows backups are helpful but not may provide to exist.
Restoring from your own backup
If you backed up your files before the corruption happened, this is the fastest and most reliable fix. straightforward copy the backup file back to its original location (or a new location if you want to keep both). The backup should open normally because it was made before the damage occurred.
This is why backups matter more than repair tools. Repair can recover some data from a damaged file, but a backup gives you the whole file exactly as it was. If you have a backup from yesterday and the file corrupted today, you lose only one day of work instead of the entire file.
Check your backup location — whether that is an external drive, a cloud service like OneDrive or Google Drive, or a network folder. If you set up automatic backups, they may be running in the background without you having to do anything. Look in your backup software to see what versions are available and when they were made.
When corruption cannot be repaired
Some files are too damaged to fix. This usually happens when the file was open during a power loss, a system crash, or a sudden disconnection from a network drive. The file structure gets scrambled in a way that even Excel's repair tool cannot rebuild.
If none of the methods above work, the file is likely beyond recovery. At that point, your only option is to restore from a backup. If you do not have a backup, you will need to rebuild the spreadsheet from scratch or from any printed copies or exports you may have made.
This is the hard lesson corruption teaches: repair tools are helpful for minor damage, but they are not a substitute for backups. A file that is too corrupted to repair is also too corrupted to recover any other way. The best protection is a backup made before the corruption happened.
Preventing corruption in the future
Corruption usually comes from one of three causes: the file was open when the power went out, the file was on a network drive that disconnected suddenly, or the file was being written to when the program crashed. You cannot prevent every accident, but you can reduce the risk.
Save your work often — every 15 or 30 minutes if you are working on something important. This means if corruption does happen, you lose only the work since your last save, not the whole file. Use File > Save or press Ctrl+S (Windows) or Command+S (Mac) regularly.
Keep your backup current. If you back up once a month but work on a file every day, a corruption event could still cost you weeks of work. Back up at least weekly, or use automatic backup software that runs in the background without you having to remember.
Avoid working on files stored on network drives or USB sticks if you can help it. These connections can drop unexpectedly, leaving the file in an unsafe state. Work on files stored on your computer's main drive, then copy the finished version to your backup location.
Frequently Asked Questions
Can I recover data from an Excel file that will not open at all?
Sometimes. Use Open and Repair first — it works even if the file will not open normally. If that fails, try the CSV conversion method, which forces Excel to rebuild the file. If both fail, check Windows for an earlier version of the file. If none of these work, the file is too damaged to recover without a backup.
Will I lose data if I use Open and Repair?
You may lose some formatting, colors, or a few cells of data, but the bulk of the spreadsheet usually survives. The repair process prioritizes getting the data back over keeping everything exactly as it was. Save the repaired file with a new name so you can compare it to the original if needed.
What is the difference between a Windows backup and my own backup?
Windows backups (File History or System Protection) are automatic snapshots the system takes while you work. Your own backups are copies you make or that backup software makes on your schedule. Windows backups are helpful but not may provide to exist. Your own backups are under your control and should be your main protection.
Why did my file get corrupted in the first place?
The most common causes are a power loss or system crash while the file was open, a sudden disconnection from a network drive, or a program crash while saving. These are accidents you cannot always prevent, which is why backups are essential — they protect you from events you cannot control.
Should I try to repair the file or just restore from backup?
If you have a recent backup, restore from it. It is faster and more reliable than repair. Use repair only if you do not have a backup and the file is important enough to spend time trying to fix it. Repair is a last resort, not a first choice.