Excel Cannot Open the File: How to Fix a Corrupt XLSX

Yes—Excel may be unable to open an XLSX when its workbook file is damaged, incomplete, or not really an Excel workbook despite its extension. In Excel for Microsoft 365 on Windows, first make a copy, then try File > Open > Browse, select the file, click the arrow next to Open, and choose Open and Repair.

What the error means

An XLSX workbook is more than a single block of spreadsheet text. It is a packaged file containing linked components such as worksheets, formatting, formulas, charts, and workbook settings. If a component is missing or damaged, Excel may fail to read the package and show a message that it cannot open or repair the file. A failed download, interrupted copy, storage problem, or software crash during saving can leave a file incomplete.

However, the message does not prove that the workbook is corrupted. Excel can also reject a file because it has the wrong extension, is blocked by security settings, is inaccessible, or was created by a program that saved it incorrectly. A file named report.xlsx might, for example, contain a web page or a different file format. The cause matters: repairing a genuinely damaged workbook is different from fixing a download or permission problem.

Protect the original before troubleshooting

Do not experiment on the only copy. Make a duplicate in File Explorer and keep the original unchanged. If the workbook is stored on a network drive, USB device, or cloud-synced folder, copy it to a local folder such as Documents before attempting repair. A connection interruption or sync conflict can complicate recovery, and local work helps separate a file problem from a storage or connection problem.

Check the file size. A zero-byte file or a file far smaller than expected may indicate an incomplete save or download.
Confirm that the name ends in .xlsx and that you selected the intended file. Changing an extension does not convert a file into a workbook.
If the file came from email or a website, download it again from the original source, if available.
If other people use the workbook, ask whether they can open their copy or have an earlier version.

Keep any recovered version under a new name. That makes it easier to compare the repair with the source and prevents a partial recovery from replacing the only copy you have.

Try Open and Repair in Excel for Windows

Use the desktop version of Excel for Microsoft 365 on Windows. In Excel, choose File > Open > Browse. In the Open dialog, navigate to the copied workbook and select it with one click; do not double-click it. Click the small arrow beside the Open button, then select Open and Repair. If Excel offers a choice, try Repair first.

If repair does not work, repeat the steps and choose Extract Data instead. Excel may be able to retrieve values and formulas even when it cannot restore the full workbook. Extraction is a fallback, not a complete repair: charts, formatting, objects, links, or other workbook features may be missing. Review the result carefully, particularly formulas and totals, before relying on it.

When Excel opens a repaired file, immediately choose File > Save As and save it with a new name in the .xlsx format. Close and reopen that saved copy to check that it is readable. Compare important sheets, formulas, named ranges, charts, and external links with an older copy or other source records where possible. A message that the repair succeeded does not guarantee that every element survived.

The Open and Repair command is a Windows desktop Excel feature and may not be available in Excel for the web or Excel for Mac. If you do not see it, do not assume the file is beyond recovery; try the other recovery options below, or use a Windows desktop copy of Excel if one is available.

Check for a better copy or earlier version

Before trying more repair attempts, look for a version saved before the problem began. A clean earlier copy can be more reliable than a repaired workbook, especially if the file is important or contains complex models. Where the workbook is stored determines which version-history tools may be available.

OneDrive or SharePoint: Open the file’s location on the web, find the workbook, and use its Version history option to inspect earlier saved versions. Open or download a version that predates the error before deciding whether to restore it.
Email or messaging: Check the original message or conversation for another attachment. Ask the sender to resend the workbook rather than forwarding a copy that may already be incomplete.
Windows backup: File History or a previous-version option may help only if the relevant backup feature was configured and captured the file. Availability varies by device and setup.
AutoRecover: Excel may offer unsaved or recovered workbooks after a crash, but AutoRecover is not a guaranteed backup of every saved file. Check Excel’s Document Recovery pane if it appears when the application starts.

For a cloud file, check whether sync has finished and whether another device has a newer, healthy copy. Avoid restoring a shared file until you understand who else is using it; replacing a current version may affect collaborators. Downloading an earlier version for inspection is often safer than immediately overwriting the shared workbook.

Rule out format, access, and security issues

If Open and Repair is unavailable or does not help, check the circumstances around the error. Try opening another known-good workbook. If other workbooks open normally, the issue is more likely specific to this file. If Excel cannot open any workbook, investigate Excel itself, an Office update, or an add-in rather than treating every file as corrupted.

Check that the file is accessible and fully downloaded. A disconnected network location, a cloud placeholder that has not downloaded, or insufficient permission can prevent Excel from reading the workbook. Save a local copy and confirm you can open or copy it in File Explorer. If Windows or Office displays a security warning, follow your organization’s policy; do not disable security protections simply to force a file to open.

Also verify that the extension matches the actual file type. A CSV file, for example, is plain text data rather than a full XLSX workbook, and renaming it to .xlsx will not add workbook structure. If you know the file was exported by another application, ask that application to export a fresh .xlsx file or use the appropriate format for its output. A format or compatibility warning is not necessarily evidence of corruption.

Why renaming or unzipping is not a repair

Because XLSX uses a packaged structure, people sometimes recommend changing the extension to .zip and editing files inside. That may expose internal components, but it does not restore missing or damaged content, and changing the package can make the workbook harder to recover. Renaming .xlsx to .xls or another extension is also not a conversion. Use a genuine export or Save As operation when a format change is needed.

Online repair services and unknown recovery utilities carry a separate risk: they may require uploading the workbook. Spreadsheets often contain customer information, payroll, business plans, or personal data. Before sending a file to any third party, check its privacy practices and your organization’s rules. For sensitive or business-critical files, contact the organization’s IT support or an established data-recovery professional rather than uploading it to an unfamiliar site.

What to do after recovery

Check recovered content against an independent source whenever possible. Look at formulas as well as displayed results: a formula may be missing even when a saved number remains visible. Check totals, dates, hidden sheets, charts, and links to other workbooks. If the file feeds reports or business decisions, have another person verify key outputs before using them.

Once you have a usable copy, save it under a new filename and store a separate backup. For shared work, rely on a managed storage location with version history where available, and wait for synchronization to finish before shutting down or disconnecting. A backup is most useful when it is separate from the working file and can be opened independently.

Frequently Asked Questions

Can Excel repair a corrupted XLSX file?
Sometimes. Excel for Windows includes Open and Repair, which may repair a workbook or extract some values and formulas. It cannot guarantee recovery of every sheet, formula, chart, or formatting detail, so check the result against a backup or other source.

Does changing .xlsx to .xls fix the error?
No. Renaming changes the filename, not the contents or file format. If a workbook needs another format, open it successfully and use Excel’s Save As options, or export a fresh file from the program that created it.

Can I use Open and Repair in Excel for the web?
The Windows desktop Open and Repair command is not generally available in Excel for the web. If the workbook is in OneDrive or SharePoint, check version history or download a copy and try the Windows desktop application.

What if Open and Repair is missing?
Confirm that you are using Excel desktop on Windows and opening the file through File > Open > Browse. If you are using Excel for Mac or the web, try a backup or version history, obtain a fresh copy, or use Windows desktop Excel if available.

Is an online XLSX repair website safe?
It depends on the service, but uploading a workbook can expose everything in it to a third party. Do not upload confidential or sensitive spreadsheets unless the service is approved for that data and you understand its privacy and security terms.

Why does the file open on someone else’s computer?
The other person may have a complete copy, a different Excel version, or access to a synced version that finished downloading. Ask them to check the file size and send a fresh copy, and compare the exact filenames and locations before concluding that your Excel installation is at fault.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.