Excel Repair Tool: What It Is & How to Use It

How-to basics · Updated November 22, 2026

The best way to repair a corrupted Excel file is to use Excel’s built-in Open and Repair feature (File > Open > Browse, select the file, click the arrow next to Open, and choose Open and Repair). This free tool attempts to recover the workbook’s contents when Excel crashes, fails to open a file, or shows a “file is corrupt” error. If that fails, you can try third-party repair software, but the built-in option should always be your first step.

Why Excel Files Get Corrupted

Corruption rarely happens for no reason. Common causes include:

  • Abrupt shutdowns (power loss, system crash, or forced quit) while the file is open and unsaved.
  • Network or cloud sync interruptions, especially with files stored on OneDrive, SharePoint, or a shared drive.
  • Disk errors or bad sectors on the hard drive or USB stick.
  • File size bloat from excessive formatting, images, or embedded objects.
  • Macro or add-in conflicts that cause Excel to write incomplete data.

Understanding the cause helps you prevent future corruption, but it doesn’t change how you repair the file.

How the Built-In Open and Repair Works

Open and Repair is part of Excel itself (Microsoft 365, Excel 2021, 2019, 2016, and earlier). It reads the file structure and tries to salvage as much as possible. When you run it, you get two options:

  • Repair – attempts to fix the file and open it. This is the first choice.
  • Extract Data – if Repair fails, this pulls out values and formulas (without formatting) into a new workbook.

Note: On a Mac, the path is File > Open, select the file, then click the arrow next to the Open button and choose Open and Repair. The interface looks slightly different but works the same.

Step-by-Step: How to Use Open and Repair

  1. Open Excel (a blank workbook is fine).
  2. Go to File > Open > Browse (or press Ctrl+O on Windows, Cmd+O on Mac).
  3. Navigate to the corrupted file, but do not double-click it. Instead, click once to select it.
  4. Click the small drop-down arrow next to the Open button.
  5. Choose Open and Repair.
  6. If prompted, click Repair. If that fails, repeat and choose Extract Data.

If the file opens after repair, immediately save it under a new name (File > Save As) and check for missing data, formulas, or formatting.

When Open and Repair Fails: Third-Party Tools

If the built-in tool can’t recover the file, you might consider a dedicated Excel repair utility. These programs scan the binary structure of the .xlsx file (which is a ZIP archive of XML files) and attempt to rebuild damaged parts. Popular options include Stellar Repair for Excel, DataNumen Excel Repair, and Kernel for Excel Repair. Prices typically range from $50 to $100 for a single license, though many offer free trials that show a preview of recoverable data.

Before paying, try a few free alternatives:

  • Change the file extension from .xlsx to .zip, then extract the contents. Inside the xl folder, you may find workbook.xml and sharedStrings.xml. You can sometimes open these in a text editor and salvage data manually, though this is technical and not for casual users.
  • Use Excel’s Recover Unsaved Workbooks (File > Info > Manage Workbook) if the file was autosaved before corruption.
  • Open the file in Google Sheets (upload to Google Drive) – it may render a partially corrupted file that Excel refuses to open.

How to Choose a Third-Party Repair Tool

If you decide to buy software, look for these features:

  • Preview before purchase – a reputable tool shows what it can recover before you pay.
  • Preserves formatting and formulas – some tools only extract raw values, which loses your work.
  • Supports .xls, .xlsx, .xlsm – older and macro-enabled files have different structures.
  • Batch repair – useful if you have multiple corrupted files.
  • No file size limits – some free tools choke on large workbooks.

Always download from the official vendor site and read recent user reviews. Avoid “free” tools that ask for credit card details or promise impossible results.

Common Problems and Misconceptions

Misconception: “Open and Repair always works.” It doesn’t. If the file header is completely destroyed, Excel may not even recognize it as a spreadsheet. In that case, recovery becomes a data-forensics task.

Problem: The file opens but shows garbage or missing sheets. This often means the repair recovered only part of the file. Check the sheet tabs – they may be hidden. Right-click any tab and choose Unhide to see if hidden sheets exist.

Problem: “File is locked for editing” after repair. Excel may leave a temporary lock file. Close Excel, delete the hidden ~$ file in the same folder, and try again.

Problem: Repair works but formulas return #REF! errors. The repair process may lose references to external workbooks or named ranges. Check formulas that reference other files and re-link them if needed.

Costs and Safety Considerations

The built-in Open and Repair is free and safe. Third-party tools cost money, and you should be cautious:

  • Never run a repair tool on your only copy of the file. Always make a backup first.
  • Some tools modify the original file. Use a copy to test.
  • Be wary of tools that require internet access or upload your file – your data could be at risk.
  • If the file contains sensitive data (financial, personal), check the vendor’s privacy policy.

For critical files, consider professional data recovery services, but they are expensive (hundreds of dollars) and rarely needed for Excel files.

Preventing Future Corruption

Once you recover your file, take steps to avoid a repeat:

  • Save frequently (Ctrl+S).
  • Enable AutoSave if you use OneDrive/SharePoint.
  • Keep Excel and your operating system updated.
  • Avoid storing large files on unreliable USB drives.
  • Use File > Info > Check for Issues to inspect the workbook for problems before sharing.
  • Maintain regular backups – use File History (Windows) or Time Machine (Mac).

Frequently Asked Questions

Q: Can I repair a corrupted Excel file without any software?
A: Yes, the built-in Open and Repair is the first option. You can also try changing the extension to .zip and extracting the XML files, or uploading to Google Sheets. These free methods often work for minor corruption.

Q: Why does Open and Repair say “The file is corrupt and cannot be opened”?
A: This message appears when the file’s header or structure is severely damaged. Excel cannot even read the file format. Try the Extract Data option, or use a third-party tool that can scan the raw bytes.

Q: Will repairing a file lose my formatting or macros?
A: The built-in Repair often preserves most formatting, but macros (VBA code) may be lost if the module is corrupted. Extract Data always loses formatting and only recovers values. Third-party tools vary – check their documentation.

Q: How do I repair a file that is too large to open?
A: If the file is hundreds of megabytes, Excel may run out of memory. Try opening it on a computer with more RAM, or use the 64-bit version of Excel. You can also try breaking the file into smaller parts using a zip utility before repairing.

Q: Is it safe to use free Excel repair tools online?
A: Generally no. Uploading a file to an unknown website risks data theft. Stick to reputable desktop software or the built-in tool. If you must use an online service, ensure it has a clear privacy policy and delete the file after download.

Q: Can I recover an unsaved Excel file that was never saved?
A: Yes, Excel has a feature called Recover Unsaved Workbooks (File > Info > Manage Workbook). It stores temporary copies of files that were closed without saving. This is different from repairing a corrupted saved file.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.