Excel Repair Kit: Fix Corrupted Workbooks

Errors & fixes · Updated November 22, 2026

An Excel repair kit is a combination of built-in recovery tools, manual techniques, and third-party utilities used to fix a corrupted .xlsx or .xls workbook. The fastest first step is to use Excel’s own Open and Repair feature, which can often recover the file automatically. If that fails, you can extract data manually, use the Recover Unsaved Workbooks option, or turn to a dedicated repair program.

What Causes Excel File Corruption?

Corruption happens when the file’s internal structure (the XML-based parts inside the .xlsx container) becomes unreadable. Common triggers include:

  • Power failure or system crash while Excel is saving the file.
  • Network interruptions when the file is stored on a shared drive or cloud sync folder.
  • Opening a file from a USB drive that is removed mid-transfer.
  • Third-party add-ins that write incorrect data.
  • Antivirus software locking or partially reading the file.

An .xlsx file is actually a ZIP archive containing several XML files. If one of those XML files is damaged (e.g., sheet1.xml or workbook.xml), Excel may refuse to open the whole workbook. Understanding this helps you choose the right repair method.

Built-in Excel Repair Tools

Microsoft Excel includes three native recovery features that should be your first line of defense:

  1. Open and Repair – Go to File > Open, select the corrupted file, click the arrow next to Open, and choose Open and Repair. In the dialog, pick Repair to attempt a full fix, or Extract Data to pull values and formulas out without formatting.
  2. Recover Unsaved Workbooks – If you never saved the file but Excel crashed, go to File > Info > Manage Workbook > Recover Unsaved Workbooks. This opens the AutoRecover folder where temporary copies are stored.
  3. Open in Safe Mode – Hold Ctrl while launching Excel (or run excel.exe /safe) to disable add-ins that might be causing the corruption. On a Mac, hold Option while opening Excel.

If Open and Repair fails, try changing the file extension to .zip and extracting the contents manually (see next section).

Manual Data Extraction from a Corrupted File

Because .xlsx is a ZIP archive, you can bypass Excel entirely. This works even when Excel says the file is unreadable.

  1. Copy the corrupted file and rename the copy from filename.xlsx to filename.zip.
  2. Right-click the .zip file and choose Extract All.
  3. Open the extracted folder. The main data is in xl/worksheets/sheet1.xml, sheet2.xml, etc.
  4. Open a sheet XML file in a text editor (like Notepad++). You’ll see raw XML with <c> (cell) elements. The t="s" attribute means the value is a string stored in xl/sharedStrings.xml.
  5. Copy the data you need, or use a script to convert the XML to a readable table.

This method is technical but often recovers data when all other tools fail. For non-technical users, a third-party repair tool automates this process.

Third-Party Excel Repair Tools

Several commercial utilities specialize in repairing Excel files. They work by scanning the damaged ZIP structure and rebuilding the XML parts. Popular options include:

  • Stellar Repair for Excel – Recovers tables, charts, and formulas; supports .xlsx, .xls, and .xltx.
  • DataNumen Excel Repair – Claims high recovery rates and batch processing.
  • Recovery Toolbox for Excel – Simple interface, extracts data to a new workbook.

These tools are not free (typically $30–$100), but they can save hours of manual work. Before paying, try the built-in tools and the ZIP method. Also, note that free online “repair” websites often require uploading your file, which is a security risk for sensitive data.

How to Choose a Repair Kit

If you decide to buy a third-party repair tool, consider these factors:

  • File format support – Ensure it handles both .xlsx and older .xls files.
  • Recovery scope – Does it restore formulas, formatting, macros, and charts? Some tools only extract raw values.
  • Preview before saving – A good tool lets you see recovered data before committing to a purchase.
  • Batch processing – If you have many files, batch mode saves time.
  • Operating system – Most run on Windows; Mac users have fewer options.

Read reviews on independent sites (not the vendor’s page) and check if the tool offers a free trial that shows recovery success before you pay.

Prevention and Best Practices

The best repair kit is a good backup strategy. Corruption is rarely sudden; it often follows a warning sign like “Excel found unreadable content.” To minimize damage:

  • Save frequently with Ctrl+S (or Cmd+S on Mac).
  • Enable AutoSave if you use OneDrive or SharePoint.
  • Keep backups in a different location – an external drive or cloud storage.
  • Avoid storing active files on USB drives or network shares that drop connections.
  • Use Excel’s File > Save As to create a new version periodically.

If you get a corruption warning, immediately copy the file to another location and try opening it in Excel for the web – sometimes the online version can read files that the desktop app cannot.

Frequently Asked Questions

Can I repair a corrupted Excel file for free?

Yes. The built-in Open and Repair feature is free, and the manual ZIP extraction method costs nothing but time. You can also try opening the file in Google Sheets by uploading it to Google Drive – Sheets often recovers data that Excel rejects.

Why does Excel say “unreadable content” but still open the file?

This warning appears when Excel detects minor structural issues. It may open the file after removing the problematic part. Click Yes to continue, but immediately save a copy under a new name and verify that all data is present.

Will a repair tool recover my formulas and formatting?

It depends. Built-in Open and Repair tries to preserve everything, but if the XML is severely damaged, only raw values may survive. Third-party tools vary; check their feature lists. Formulas are stored separately from values, so if the formula XML is intact, they can be recovered.

Is it safe to upload my Excel file to an online repair service?

Not if the file contains sensitive data (personal info, financial records, trade secrets). Free online services may store or misuse your file. Use offline tools or the built-in methods for confidential workbooks.

What if my file is a .xls (Excel 97-2003) format?

The built-in repair works for .xls too, but the ZIP extraction method does not (because .xls uses a binary format, not XML). For .xls, try Open and Repair first, then third-party tools that specifically support the older format.

Can I prevent corruption by saving as .xlsb instead of .xlsx?

The .xlsb (binary) format is more robust to partial writes because it doesn’t rely on ZIP compression. However, it’s still susceptible to crashes. Switching to .xlsb can reduce corruption risk, but it’s not a guarantee.

Final Thoughts

An Excel repair kit is not a single product but a set of strategies. Start with Open and Repair, then try the ZIP method, and only consider paid tools if those fail. Always keep backups – the real fix is never needing a repair kit in the first place.

Related

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.