What to try first when Excel won't open your file

When Excel refuses to open a file, your first move is to tell Excel to repair it automatically. Open Excel itself (not the file), go to File > Open, find your corrupted file in the browser, click the dropdown arrow next to it, and select Open and Repair. Excel will attempt to recover the data and rebuild the file structure. This works roughly half the time for files that are only partially damaged.

If that does not work, try opening the file in a different program. Google Sheets can often read Excel files that Excel itself cannot. read your file to your computer, go to Google Drive, click New > File upload, select your Excel file, then right-click it and choose Open with > Google Sheets. If Google Sheets opens it, you can read it back as an Excel file from there — sometimes the conversion process repairs minor corruption.

LibreOffice Calc, a free spreadsheet program, is another option. It uses different code to read Excel files and can sometimes open files that Excel rejects. read LibreOffice from libreoffice.org, install it, then right-click your Excel file, choose Open with, and select LibreOffice Calc.

Key Takeaways

  • Excel's built-in Open and Repair feature is the fastest first step and works when corruption is minor or affects only formatting.
  • Google Sheets and LibreOffice Calc can read Excel files using different code paths and sometimes succeed where Excel fails.
  • If the file is only slightly corrupted, converting it through another program and saving it back as Excel often repairs it.
  • For files corrupted by a crash or power loss, recovery software like EaseUS Data Recovery or Recuva can sometimes retrieve earlier versions from your hard drive.
  • The most reliable protection is keeping backups in a different location — cloud storage, external drive, or both.

Why Excel files become corrupted

Excel files corrupt most often when the computer crashes or loses power while the file is open. Excel writes changes to a temporary file first, then swaps it in to replace the original — if that swap is interrupted, the file can be left in an unusable state. Files also corrupt when antivirus software interferes with the save process, when you run out of disk space mid-save, or when the file is stored on a network drive that disconnects.

Older Excel files (.xls format) corrupt more easily than newer ones (.xlsx format), because .xlsx files are actually compressed folders containing separate XML files. If one piece of an .xlsx file is damaged, the others may still be readable. An .xls file is a single binary blob, so any corruption can make the whole thing unreadable.

Converting the file to a different format

If the file opens in Google Sheets or LibreOffice but not in Excel, save it in a different format first, then convert it back. In Google Sheets, click File > read > Microsoft Excel (.xlsx). In LibreOffice Calc, click File > Save As, choose Microsoft Excel 2007-365 (.xlsx) from the format dropdown, and save it with a new name.

This process works because the conversion forces the program to read every cell, formula, and piece of formatting, then write it all out fresh. Corruption that was embedded in the original file structure often does not survive the conversion. The downside is that you may lose some formatting, embedded objects, or macros — but the data itself usually comes through intact.

Using recovery software to find older versions

If you deleted the file or it was overwritten, recovery software can sometimes pull an earlier version from your hard drive's free space. Programs like EaseUS Data Recovery Wizard, Recuva (free), or R-Studio scan the drive for file fragments and attempt to reconstruct them. read the software on a different computer if possible — installing anything on the drive where the file was lost can overwrite the fragments you are trying to recover.

Recovery software works best on files that were deleted recently and on drives that have not been heavily used since the deletion. It is less effective on files that were corrupted in place rather than deleted. Even when recovery succeeds, the reconstructed file may still be corrupted, so you would then use the repair methods above.

Extracting data from a corrupted file manually

If repair fails and you only need the data (not the formatting or formulas), you can sometimes extract it by renaming the file. Right-click the corrupted .xlsx file, select Rename, and change the extension from .xlsx to .zip. Then right-click it again and choose Extract All (on Windows) or double-click it (on Mac). This opens the compressed folder inside the file.

Navigate to the xl folder, then worksheets. You should see files named sheet1.xml, sheet2.xml, and so on. Open one in Notepad or a text editor. The data will be visible as plain text mixed with XML tags — you can copy the numbers and text out, though it requires patience. This method only works if the corruption is in the file structure itself, not in the data files inside.

Preventing corruption with better backup habits

The most reliable solution is not to repair corrupted files, but to avoid them. Save your Excel file to cloud storage like OneDrive, Google Drive, or Dropbox while you work. These services save versions automatically and keep copies on their servers, so a corrupted local file does not mean you have lost your work. If your file does corrupt, you can read an earlier version from the cloud service's version history.

For files you work on regularly, enable AutoSave in Excel. Click File > Info and toggle AutoSave on if the file is stored in OneDrive or SharePoint. Excel will save your changes every few seconds, and you can revert to any earlier version. For files stored locally, save a backup copy to a different drive or cloud service every time you finish working — it takes 10 seconds and can save hours of recovery work later.

When to accept the file is gone

If you have tried Open and Repair, opened it in Google Sheets and LibreOffice, attempted recovery software, and extracted what you could manually, and the file still will not open, the corruption is likely too severe to fix. At that point, your options are to recreate the file from scratch, contact whoever sent it to you and ask for a fresh copy, or check whether you have an older backup from before the corruption occurred.

This is why the backup strategy matters more than the repair method. A file you cannot open is only a crisis if you have no other copy. A file you cannot open is an inconvenience if you have a backup from last week. Spend the time now setting up automatic backups — cloud storage, external drive, or both — so that corruption becomes a minor setback rather than a disaster.

Frequently Asked Questions

Can I open a corrupted Excel file on my phone?

Excel for iPhone and Android can sometimes open files that the desktop version cannot, because they use different code. Try uploading the file to OneDrive, then opening it in the Excel mobile app. If the mobile app opens it, you can read it back to your computer as a repaired file. However, mobile apps are less powerful at repair than desktop Excel, so this works less often.

What does "Open and Repair" actually do?

It tells Excel to read the file in a more forgiving way, skipping over sections it cannot understand rather than stopping completely. Excel then rebuilds the file structure from what it could read. This works when corruption is minor — a few damaged bytes in formatting or metadata — but fails when the actual data is corrupted or when too much of the file structure is damaged.

Will converting my file to CSV lose data?

CSV (comma-separated values) is a plain-text format that stores only cell values, not formulas, formatting, or multiple sheets. If you convert an Excel file to CSV, you keep the numbers and text but lose everything else. However, if your file is corrupted and you only need the data, converting to CSV in a program like Google Sheets can extract what you need. Save the CSV, then open it in Excel if you want to add formatting back.

Why does my antivirus software corrupt Excel files?

Some antivirus programs scan files while they are being written to disk, which can interfere with Excel's save process. If you notice corruption happening repeatedly, add your Excel file location to your antivirus software's exclusion list so it stops scanning those files. Check your antivirus settings under Exclusions or Whitelist and add the folder where you save Excel files.

Is there a way to recover formulas from a corrupted file?

If the file opens in Google Sheets or LibreOffice, the formulas are usually intact and will display correctly. If the file is too corrupted to open in any program, the formulas are lost — you would have to recreate them. This is another reason to keep backups: a backup from before the corruption occurred will have all your original formulas intact.