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:
- Open Excel, go to File > Open and browse to the corrupted file.
- Click the dropdown arrow next to the Open button and select Open and Repair.
- Choose Repair to attempt recovery, or Extract Data to pull values and formulas without fixing the structure.
- 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:
- 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.
- Use the Open and Repair option with Extract Data to at least get the raw numbers.
- Look for previous versions: right-click the file in File Explorer, select Properties, and check the Previous Versions tab (if enabled).
- Check your OneDrive or SharePoint recycle bin—cloud versions may have a recent copy.
- 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
- Excel Income and Expense Tracking Spreadsheet: How to Build One
- Excel Import and Align with Existing Times
- Excel How to Ungroup Cells: Rows, Columns & Sheets
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- MATCH Not Working in Excel? Fix Common Formula ErrorsIf MATCH is not working in Excel, first check the third argument: use 0 for an exact match,…
- Excel Not Running Formula? Fix Calculation and Cell IssuesIf Excel is not running a formula, first check Formulas > Calculation Options > Automatic, then confirm the…
- Excel Table Colours: Change, Customize, and Fix ThemExcel table colours come from the table’s style: select a cell in the table, open Table Design, and…
- Excel Page Break on Row: How to Set and Fix ItTo put a page break above a specific row in Excel for Microsoft 365 on Windows, select that…
- Excel Table New Row Not Following Formatting? Fix ItIf a new row in an Excel table is not following the formatting, first confirm the row is…
- XLOOKUP Not Working With Text? Fix the MatchYes—XLOOKUP can look up text, and it uses an exact match by default. When it fails, the usual…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.