Excel Repair Log: How to Fix Corrupted Files

Errors & fixes · Updated November 22, 2026

An Excel repair log is a record that Excel creates when it attempts to repair a corrupted workbook, listing what was found and fixed. If your file won’t open or shows errors, Excel’s built-in repair tool can often recover it, and the log tells you what happened.

What Is an Excel Repair Log?

When you open a corrupted .xlsx or .xls file, Excel may automatically detect the problem and offer to repair it. If you accept, Excel runs a recovery process that rebuilds the file structure, salvaging as much data as possible. The repair log is a text summary of that process—it lists the specific issues found (like broken formulas, missing links, or damaged formatting) and what Excel did to fix them. You usually see this log as a pop-up window after the repair finishes, and it can also be saved as a separate file if you choose.

How to Trigger a Repair and View the Log

To manually start a repair in Excel for Microsoft 365 on Windows:

  1. Open Excel, go to File > Open and browse to the corrupted file.
  2. Click the dropdown arrow next to the Open button and select Open and Repair.
  3. Choose Repair to attempt recovery, or Extract Data to pull values and formulas without fixing the structure.
  4. After the process, Excel shows a dialog box with the repair log. Click Close to continue, or save the log if you want a record.

On Mac, the option is under File > Open—hold the Option key and click the file, then select Open and Repair. In Excel for the web, the repair feature is limited; you may need to download the file and use the desktop app.

What the Log Actually Contains

The repair log is a plain-text summary, not a detailed forensic report. It typically includes:

  • The name of the file and the date/time of the repair.
  • A list of errors found, such as “Repaired Records: Cell information” or “Removed Part: /xl/worksheets/sheet1.xml”.
  • Any data that was discarded because it was unrecoverable.
  • Actions taken, like recalculating formulas or removing invalid features.

For example, a common entry might read: “Repaired Records: Cell information from /xl/worksheets/sheet1.xml part.” This means Excel fixed some cell data in that sheet. The log doesn’t tell you which specific cells were changed, so you should verify the repaired file carefully.

Common Causes of Corruption and How to Avoid Them

Corruption usually happens when the file is interrupted during saving or transferring. Common causes include:

  • Power failure or system crash while Excel is writing the file.
  • Network issues when saving to a shared drive or cloud sync (e.g., OneDrive or SharePoint).
  • Improper shutdown of the computer or force-quitting Excel.
  • File size limits or too many complex features (like macros or external links).
  • Virus or malware infection that damages the file.

To reduce the risk, always save frequently, use File > Save As to create backups, and enable AutoRecover (File > Options > Save) to keep versions. Also, avoid storing Excel files on USB drives that are removed without safely ejecting.

How to Choose Between Repair and Extract Data

When you use Open and Repair, you get two options:

  • Repair: Attempts to fix the file and keep as much original formatting and functionality as possible. Use this first—it’s the least destructive.
  • Extract Data: Ignores the structure and pulls out raw values and formulas into a new workbook. Use this if Repair fails or if you only need the data, not the formatting.

If you choose Extract Data, you can select Convert to Values (removes formulas) or Recover Formulas (keeps them). Note that Extract Data may lose charts, images, and other objects.

What to Do If Repair Fails

If the built-in repair doesn’t work, try these steps in order:

  1. Open the file in a different application, like Google Sheets or LibreOffice Calc, and save it as a new Excel file. This sometimes bypasses the corruption.
  2. Use the Open and Repair option with Extract Data to at least get the raw numbers.
  3. Look for previous versions: right-click the file in File Explorer, select Properties, and check the Previous Versions tab (if enabled).
  4. Check your OneDrive or SharePoint recycle bin—cloud versions may have a recent copy.
  5. If the file is macro-enabled (.xlsm), try removing the macros by opening it in a hex editor—but this is advanced and risky.

Always keep backups. If you have a recent backup, you may lose only a few minutes of work.

Frequently Asked Questions

Can I see the repair log after I’ve closed it?
No, the repair log is only shown in the dialog box after the repair. If you didn’t save it, it’s gone. To keep a record, click the Save button in the dialog (if available) or copy the text before closing.

Will repairing a file delete my data?
Repair tries to keep everything, but sometimes it removes parts that are too damaged to read. The log tells you what was removed. Always compare the repaired file against your last known good version.

Why does Excel say “file is corrupt and cannot be opened”?
This usually means the file header is damaged or the file isn’t actually an Excel file (e.g., it’s a renamed .zip or .txt). Try changing the extension back to .xlsx, or use a file recovery tool.

Is there a way to prevent corruption entirely?
No, but you can minimize risk: save often, use AutoRecover, avoid abrupt shutdowns, and don’t store files on unreliable media. For critical files, consider using Excel’s Save As > Tools > General Options to set a backup copy.

Does Excel for the web have a repair log?
Excel for the web has limited repair capabilities. If a file fails to open, it may show a generic error. You’ll need to download the file and use the desktop app to attempt a repair and see the log.

Final Thoughts

The repair log is a useful diagnostic tool, but it’s not a guarantee of full recovery. Understanding what it tells you—and having a backup strategy—is the best way to deal with corrupted Excel files. If you frequently encounter corruption, consider using the .xlsb binary format, which is more robust, or store files on a reliable local drive.

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.