How do I repair a corrupted Excel file?

Copy the file first, then upload it to a repair tool that re-parses the workbook and rebuilds the ZIP package. It re-serialises every readable sheet into a fresh, valid xlsx, which recovers most corrupted files. Verify your sheets and totals afterward.

Will repairing keep all my formatting and macros?

Recovering your data is the priority, so a badly damaged file may lose some complex formatting, charts, or macros when it is rebuilt. The cell values come back cleanly, and you can re-apply styling afterward. A plain sheet of correct numbers beats a file that will not open.

Can every corrupted Excel file be fixed?

No. Files with broken structure around intact cells rebuild well, but files that were truncated or half-saved cannot have missing bytes restored, and password-protected workbooks cannot be decrypted by a repair tool. Repair recovers only the data that is actually present in the file.

What if the workbook is too damaged to rebuild?

When a rebuild cannot reconstruct the whole file, extract the readable cells to CSV instead. That strips away the fragile packaging and rescues the raw values as plain rows, which you can then load into a new clean workbook.

How to Repair a Corrupted Excel File

A corrupted Excel file turns an ordinary morning into a small emergency. The workbook you need will not open, or it opens to an error, a blank grid, or a warning that some content is unreadable. The reassuring truth is that most Excel corruption is more superficial than it feels. It usually damages the file's internal packaging rather than the numbers and text inside your cells, and rebuilding that packaging often brings the whole workbook straight back.

This guide walks through repairing a corrupted Excel file from start to finish. You will learn what an xlsx really is under the hood, how to work out which kind of damage you have, the exact steps to rebuild the file, and how to recognise when a workbook is genuinely beyond repair so you can switch to a backup instead of wasting time. You can follow along with the repair XLS tool, which does the structural rebuild in your browser.

What an Excel File Actually Is

A modern Excel file with an .xlsx or .xlsm extension is not a single blob of data. It is a ZIP archive: a compressed package that holds a small folder tree of XML files. One XML part describes each worksheet, another holds the shared strings used across cells, others store styles, the workbook relationships, and a content-types manifest that tells Excel what every part is. When you open a workbook, Excel unzips this package and reads the XML parts in order.

Corruption is any damage that breaks this package. The ZIP container's directory might be scrambled, an XML part might be truncated or contain an illegal character, or a relationship might point to a part that is no longer valid. Because the cell values themselves live inside those XML parts, they are often perfectly intact while only the wrapper around them is broken. That is exactly why a rebuild works: the tool re-parses whatever it can read, re-serialises the workbook, and writes a fresh, valid ZIP package from the recovered pieces.

Diagnosing the Kind of Corruption

Different symptoms point to different causes, and the cause decides how much you can get back.

File will not open at all: Usually a broken ZIP directory or a missing core part. Very often recoverable by rebuilding.
Opens with a content warning: Excel found one damaged part but the rest is readable. A rebuild usually cleans this up.
Opens but a sheet is blank or garbled: A damaged worksheet XML part. The other sheets recover; the damaged one may recover partly.
Format or extension error: The file may not be a valid xlsx, or its header bytes are damaged. A rebuild may help, or the file may be the wrong type entirely.

The most important question is whether your data is broken or missing. Broken structure wrapped around intact cells rebuilds beautifully. Missing data, such as the tail of a file that never finished saving, cannot be recovered by any tool, because those bytes were never written to disk in the first place.

How to Repair a Corrupted Excel File: Step by Step

This is the dependable process. It runs entirely in the browser with nothing to install.

Make a copy first. Duplicate the corrupted workbook so you never lose the original while you experiment.
Open the repair tool. Go to the repair XLS page.
Upload the file. Drag it into the upload area or browse to select it.
Run the rebuild. The tool re-parses the workbook, rebuilds the ZIP package, and re-serialises every readable sheet into a clean xlsx.
Download the result. Save the rebuilt copy under a new name.
Verify the data. Open it and check that the sheets, rows, and totals you need are present and correct.

For the majority of corrupted workbooks, this single pass restores a working file. If it does not, the file likely has missing rather than broken data, and the sections below explain your options.

If the Rebuilt File Loses Some Formatting

Recovering your data is the priority, and a rebuild honours that priority above all else. When a workbook is badly damaged, the tool may simplify some complex formatting, drop a broken chart, or leave a macro behind in order to save the cell values cleanly. This is a deliberate trade: a plain sheet full of correct numbers beats a beautifully styled file that will not open. Re-apply styling afterward, and treat the recovered data as the win.

When a Rebuild Is Not the Right Tool

Repair is powerful but specific. It is the wrong tool in a few situations, and spotting them early saves time.

Password-protected workbooks: A repair rebuilds structure but cannot remove encryption. You need the password, not a repair.
Truncated or half-saved files: If the file was cut off mid-save or mid-download, the missing bytes are gone. See our guide on recovering Excel after a failed download.
Wrong file entirely: If the file is not really a spreadsheet, no repair will help.
You have a clean original: If you can restore from a backup or re-export from the source system, that is faster and gives a perfect file.

When a File Is Too Damaged: Rescue the Raw Values

Sometimes a workbook is damaged badly enough that a full rebuild cannot reconstruct every sheet. When that happens, the goal shifts from saving the whole file to saving the numbers inside it. Extracting the readable cells to plain CSV strips away the fragile packaging and rescues the raw values as simple rows of text. The Excel to CSV tool pulls the surviving data out into a format that opens anywhere, and once you have clean rows you can pour them back into a fresh workbook with the CSV to Excel tool. Our guide on recovering Excel data with a CSV export walks through this salvage route in detail.

Preventing Corruption Going Forward

Once your workbook is back, a few habits keep it healthy. Let saves and downloads finish completely before you open or move a file. Do not edit a workbook that lives on a failing USB stick or a flaky network share. Eject removable drives properly. Keep important spreadsheets backed up in the cloud or a version history, so a single corrupted copy is an inconvenience rather than a loss. Our guide on preventing Excel corruption turns these into a simple checklist, and if you want to understand the root causes, why Excel files get corrupted explains them.

Comparing Your Recovery Options

When a workbook goes bad, you generally have three routes, in rough order of preference:

Restore from a backup or cloud version: Fastest and gives a perfect file, if one exists.
Re-export from the source system: Also produces a clean file, if the data lives in a database or another app.
Rebuild the corrupted file: The right choice when no backup or source exists, and it recovers whatever data survived.

The rebuild route is your safety net precisely because it needs nothing but the damaged file itself. That makes it the first thing to try when a workbook arrives broken from a colleague and you have no other copy. It also costs you nothing to attempt: working on a copy means a failed rebuild leaves you no worse off, while a successful one hands back a workbook you might otherwise have written off entirely. The only real cost is a minute of your time, a small price against rebuilding a spreadsheet from scratch or losing it for good.

Conclusion

Repairing a corrupted Excel file starts with understanding that an xlsx is a ZIP of XML parts, and that corruption usually breaks the packaging rather than your data. A structural rebuild re-parses the workbook, reconstructs the ZIP package, and re-serialises every readable sheet, which is enough to recover most damaged files. Copy your original, run it through the repair XLS tool, and verify the cells. When a file is truncated or encrypted, reach for a backup instead, and when it is too far gone, rescue the raw values to CSV. Start your repair now, and explore every other free spreadsheet tool on the xls.repair homepage.

How to Repair a Corrupted Excel File: A Practical Guide