Excel Built-In Repair Tool: What It Does and How to Use It

How-to basics · Updated November 22, 2026

Yes, Microsoft Excel has a built-in repair tool: it is the Open and Repair feature, which you access from the Open dialog in Excel (File > Open > Browse, then select the file and click the arrow next to Open). It attempts to recover corrupted workbooks by repairing the file or extracting data from it. This article explains how it works, when to use it, its limitations, and what to do when it fails.

Where to Find Open and Repair

The repair tool is not a separate program; it is a built-in option in Excel’s file open dialog. To use it:

  1. Open Excel and go to File > Open > Browse (or press Ctrl+O on Windows, Cmd+O on Mac).
  2. Navigate to the folder containing the corrupted workbook.
  3. Select the file, but instead of clicking Open, click the small arrow next to the Open button.
  4. Choose Open and Repair from the dropdown menu.
  5. A dialog appears with two options: Repair (attempts to fix the file) and Extract Data (recovers formulas and values without repairing the structure).

On Excel for the web, this feature is not available; you would need to download the file and open it in the desktop app. On Mac, the steps are the same (File > Open, then the arrow next to Open).

What Does the Repair Tool Actually Do?

When you click Repair, Excel scans the workbook’s underlying XML structure (the format used by .xlsx files) and attempts to fix inconsistencies, such as broken references, corrupted styles, or damaged cell data. It does not rewrite your data; it patches the file’s internal structure to make it readable again. If the repair fails, the Extract Data option tries to pull out the raw values and formulas into a new workbook, though it may lose formatting, charts, and other non-data elements.

The tool is effective for minor corruption—for example, when a file won’t open and you see an error like “Excel found unreadable content in your file.” However, it is not a magic fix for severely damaged files, and it cannot recover data that was never saved.

When to Use the Repair Tool vs. Other Recovery Methods

Before you panic, consider the order of recovery attempts:

  • First: Try opening the file normally. If it opens with a warning, click Yes to repair it automatically.
  • Second: Use Open and Repair with the Repair option.
  • Third: Use Open and Repair with Extract Data if Repair fails.
  • Fourth: Check Excel’s Recover Unsaved Workbooks (File > Info > Manage Workbook) if you had unsaved changes.
  • Fifth: Look for automatic backup files (File > Info > Manage Workbook > Recover Unsaved Workbooks, or the file location where Excel saves autorecover files).

If none of these work, you may need third-party recovery software, but use it with caution—some tools are unreliable.

Common Problems and Misconceptions

A frequent misconception is that the repair tool will restore a file that was never saved. It cannot. It only works on an existing file that has become corrupted. Another misconception is that the tool will preserve everything perfectly; in reality, it may lose macros, formatting, or embedded objects during extraction.

Also, if you have a file that opens but shows garbled content, the repair tool might not help because the corruption may be in the display layer, not the file structure. In such cases, copying the data to a new workbook manually may be the only option.

One common error is “Excel cannot open the file because the file format or file extension is not valid.” This often means the file is not actually an Excel file (e.g., it was renamed from a .txt or .csv). The repair tool won’t fix that; you need to change the extension or use the Import feature.

How to Prevent Corruption in the First Place

Prevention is better than repair. To minimize the risk of file corruption:

  • Always close Excel properly, and avoid force-quitting while a file is open.
  • Save frequently (Ctrl+S on Windows, Cmd+S on Mac) and enable AutoSave if you use OneDrive or SharePoint.
  • Keep your Excel application updated—Microsoft releases patches that fix known corruption bugs.
  • Store files on a reliable drive and avoid saving directly to a USB stick that may be unplugged mid-write.
  • Use the built-in Document Inspector (File > Info > Check for Issues) to remove hidden data that can sometimes cause issues.

Alternatives to the Built-In Repair Tool

If the built-in tool fails, you have a few options:

  • Open in another application: Try opening the file in Google Sheets or LibreOffice Calc. Sometimes these programs can read a file that Excel cannot. If it opens, save it as a new .xlsx file and reopen in Excel.
  • Use a hex editor (advanced): For tech-savvy users, you can inspect the file’s XML directly, but this is risky and not recommended for non-experts.
  • Third-party recovery tools: Software like Stellar Repair for Excel or Kernel for Excel can sometimes recover more data, but they are paid and not guaranteed. Always test on a copy of the file.
  • Restore from backup: If you have File History (Windows) or Time Machine (Mac), you can retrieve an earlier version of the file.

Cost and Safety Considerations

The built-in repair tool is free—it’s part of Excel. There are no hidden costs. However, third-party tools can range from $50 to $100 or more. Before using any third-party software, be aware that they may not be safe; some could contain malware or make the file worse. Always download from reputable sources and scan with antivirus software.

Also, when you run Open and Repair, Excel may ask to create a backup copy. It’s wise to say yes, so you have a copy of the original corrupted file in case the repair makes things worse. You can also manually copy the file before attempting repair.

Frequently Asked Questions

Will Open and Repair recover my unsaved work?

No. Open and Repair works only on an existing file on disk. If you never saved the file, you cannot repair it. For unsaved work, check File > Info > Manage Workbook > Recover Unsaved Workbooks, or look for AutoRecover files in the folder where Excel saves them (usually in %AppData%\Microsoft\Excel\ on Windows).

Does the repair tool work on .xls files (old format)?

Yes, Open and Repair works on both .xls and .xlsx files. For .xls files, the repair process is similar, but the underlying structure is different (binary vs. XML). The tool still attempts to fix corruption and can extract data.

What if the repair tool says it can’t fix the file?

If you see an error like “Excel cannot repair the file,” you can try the Extract Data option, which might still recover the data. If that also fails, your last resort is third-party software or a professional data recovery service, but those can be expensive.

Can I use Open and Repair on a file that opens but shows errors?

Yes, you can force the repair by using Open and Repair even if the file opens with warnings. Sometimes the file opens but has broken links or missing references; running repair can clean those up. However, if the file opens normally, it’s often better to just fix the specific issue manually.

Is there a keyboard shortcut for Open and Repair?

No, there is no direct keyboard shortcut. You must go through the File > Open dialog. On Windows, you can press Ctrl+O, then use the arrow next to Open. On Mac, Cmd+O and then the arrow.

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.