Why won't my xlsx file open?

An xlsx is a ZIP of XML parts, and it fails to open when the archive directory or a required part is damaged, truncated, or contains an illegal character. The cell values are often still intact inside, which is why rebuilding the package usually recovers the file.

How can I recover data from an xlsx that won't open?

Check for a backup or cloud version first, then copy the file and run it through a repair tool that rebuilds the ZIP package and re-serialises every readable sheet into a clean xlsx. If that fails, extract the raw values to CSV to rescue the numbers.

The repaired file is missing a sheet. Is that normal?

Yes, when a sheet was corrupted at the byte level a rebuild may not fully reconstruct it. Recovering the data is the priority, so keep the sheets that came back and fill the gap from a backup, an emailed copy, or the system that produced the numbers.

Can a repair open a password-protected xlsx?

No. A password prompt means the workbook is encrypted, not corrupted. A repair rebuilds structure but cannot decrypt the file, so you need the password itself. If the file is both damaged and encrypted, unlock it first, then repair the result.

Recover an XLSX File That Won't Open

An xlsx file that will not open is one of the more stressful things a spreadsheet can do. There is no crash to explain it and no obvious fix, just a workbook that sits in your folder and refuses to display. Maybe Excel throws an error, maybe it hangs, maybe it opens an empty grid. Whatever the symptom, the question on your mind is simple: can I get my data back? For the great majority of files, the answer is yes.

This guide focuses on recovery. It explains why an xlsx stops opening, how to tell a fixable file from a truly incomplete one, and the exact steps to get your data back, in rough order of how much they preserve. When a rebuild is the right move, the repair XLS tool does it in your browser, and when a file is too far gone for a full rebuild, there is still a way to rescue the numbers.

Why an XLSX Stops Opening

An xlsx is a ZIP archive holding a set of XML parts: one for each worksheet, one for the shared strings, others for styles, relationships, and a content-types manifest. Excel opens the workbook by unzipping this package and reading the parts in a specific order. If any step in that chain fails, the file will not open. The archive directory may be scrambled, a required part may be missing or truncated, an XML part may contain an illegal character, or a relationship may point at a part that is no longer valid.

The encouraging part is that the values in your cells live inside those XML parts. A file frequently fails to open because of a fault in the packaging while the actual data is fully present. That gap between a broken wrapper and intact contents is precisely what a rebuild exploits: it re-parses the readable parts and re-serialises the workbook into a fresh, valid package. That single step is often all that separates a file you can open from one you cannot, even though the data inside it never changed at all.

Is the File Fixable or Truly Incomplete?

Before you spend time on recovery, work out which situation you are in, because they have very different ceilings.

Broken structure, data present: The package is malformed but the worksheet parts are intact. A rebuild is highly likely to recover everything.
Missing data: The file was truncated during a save or download, so some parts were never written. A rebuild recovers what arrived; the rest is gone.
Encrypted file: The workbook opens to a password prompt. This is not corruption, and a repair cannot remove the password.
Wrong file type: The extension says xlsx but the contents are something else. No repair applies; you need the correct opener.

You usually cannot tell broken from missing just by looking, so the sensible approach is to try the cheapest recovery first and escalate only if it falls short. That is the order the steps below follow.

How to Recover the File: Step by Step

Work through these in order. The earlier steps are faster and often make the later ones unnecessary.

Look for a backup or cloud version first. If the workbook lives in OneDrive, Google Drive, SharePoint, or a version history, an earlier good copy is the fastest and most complete recovery there is.
Copy the broken file. If there is no backup, duplicate the file so the original stays safe while you work.
Run a structural rebuild. Upload the copy to the repair XLS tool. It re-parses the readable parts, rebuilds the ZIP package, and re-serialises every sheet it can read into a clean xlsx.
Download and open the result. Save it under a new name and open it in Excel.
Verify every sheet. Scroll through each tab, spot-check totals, and confirm the data you need is present.

For a workbook whose data survived, this sequence usually produces a file that opens normally. If it opens but one sheet is thin, that sheet was likely damaged at the byte level, and the next section covers what to do.

When Recovery Is Partial

A rebuild sometimes returns a file that opens cleanly but is missing a sheet or some rows that were physically corrupted. That is often the best outcome possible when data was genuinely damaged rather than merely mispackaged. Keep what you recovered, then fill the gaps from a backup, an emailed copy, or the source system that produced the numbers. Recovering the data is the priority, so a partial workbook of correct values is a real win, not a failure.

When the File Is Too Damaged: Rescue the Values

If a rebuild cannot reconstruct the workbook at all, the raw cell text may still exist inside the XML parts even though the structure is unusable. Extracting those values to plain CSV rescues them from the broken container as simple rows of text that open in any program. The Excel to CSV tool performs that extraction, and once you have clean rows you can rebuild a proper workbook from them with the CSV to Excel tool. Our guide on recovering Excel data with a CSV export covers this salvage path step by step. It sacrifices formatting and formulas, but it saves the numbers, which is what matters most.

What a Repair Cannot Do

Being clear about the limits saves you from chasing the impossible.

It cannot restore missing bytes. Data that was never written during a truncated save or download is gone; only a fresh save or download can bring it back.
It cannot remove a password. A repair rebuilds structure but does not decrypt a protected workbook. You need the password.
It may simplify complex features. Badly damaged charts, macros, or intricate formatting can be dropped so the data itself saves cleanly.

Knowing these boundaries lets you pick the right route immediately. If the cause was a failed transfer, see recovering Excel after a failed download, where re-downloading usually beats any repair.

Stopping It From Happening Again

Once your data is back, a few habits keep future files opening. Always let saves and downloads finish before you touch a file. Never edit a workbook straight off a failing USB stick or an unreliable network share; copy it local first. Eject drives properly. Keep automatic backups or version history switched on. Our guide on preventing Excel corruption turns those into a short checklist, and why Excel files get corrupted explains the underlying causes so you can spot risky situations before they cost you a file.

Conclusion

An xlsx that will not open is usually a packaging problem, not a data problem: the ZIP archive or one of its XML parts is damaged while your cells sit intact inside. Check for a backup first, then run a copy through the repair XLS tool, which re-parses the readable parts and re-serialises the workbook into a clean, opening file. When recovery is partial, keep what came back and source the rest; when the file is too damaged to rebuild, rescue the raw values to CSV so the numbers survive. Repair cannot restore bytes that were never written or remove a password, so match the route to the cause. Start your recovery now, and explore every other free spreadsheet tool on the xls.repair homepage.

How to Recover an XLSX File That Won't Open