Microsoft Excel — "Excel cannot open the file because the file format is not valid" — How to Fix It

What Does This Error Mean?

This error means Excel cannot read the file you are trying to open. Either the file extension does not match what is actually inside (for example, a PDF renamed to .xlsx), the file is corrupted, or it was created by a program Excel does not support. Excel is not broken — it just cannot make sense of that specific file.

Affected Models

Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel 2021
Microsoft 365 Excel

Common Causes

The file is corrupted or was not saved correctly the last time it was open
The file has the wrong extension — for example, a CSV or PDF saved with a .xlsx extension
The file was downloaded from the internet and Windows has blocked it for security reasons
The file was created by a different program (like Google Sheets) and exported with an incompatible format
The file was stored on a USB or network drive that had a write error during saving

How to Fix It

Right-click the file, select Properties, and click the Unblock button at the bottom if it is there. Then click OK and try opening the file again.

Windows blocks downloaded files by default. Unblocking is the fastest fix for files you received by email or download.
Try renaming the file extension. Right-click the file, choose Rename, and change .xlsx to .xls or .csv and try again.

Sometimes files are exported in an older format but saved with a newer extension. Changing the extension tells Excel to try a different reading method.
Open Excel, go to File > Open > Browse, find the file, click the arrow next to the Open button, and choose Open and Repair.

This built-in repair tool can fix many types of minor file corruption and recover most of your data.
Try uploading the file to Google Sheets at sheets.google.com. Google Sheets can often open files that Excel refuses to read.

If Google Sheets opens it successfully, download it again as an .xlsx file and it should now open in Excel.
Check if OneDrive or SharePoint has a previous version of the file. Right-click the file in OneDrive and look for Version History.

Cloud storage often keeps older versions automatically. A slightly older copy of the file may open without any problems.

When to Call a Professional

If this is a critical file and none of the fixes below work, a data recovery specialist may be able to extract your data. Alternatively, try opening the file in Google Sheets — it often succeeds where Excel fails. If the file is completely unreadable, check if cloud storage (OneDrive, SharePoint) has a previous version saved.

Frequently Asked Questions

My colleague can open the file but I cannot. Why?

This usually comes down to which version of Excel each person has. Older versions of Excel cannot open files saved with newer features. Ask your colleague to save the file as .xls (Excel 97-2003 format) or as a .csv, and send that version to you.

Can I recover the data if Excel cannot open the file?

Often yes. First try Google Sheets — it is the most reliable free alternative. You can also try LibreOffice Calc, which handles many corrupted or oddly formatted files. If those fail, the free tool Stellar Repair for Excel can recover data from badly damaged files.

How do I prevent this from happening to my files?

Always save Excel files in .xlsx format — it is the most compatible and reliable option. Avoid saving to USB drives while actively editing, as interrupted writes corrupt files. Keep AutoSave turned on if you use Microsoft 365 so that OneDrive always has a backup.