Excel File Corrupted? Repair and Recover Your Workbook

If an Excel file is corrupted, first make a copy of it, then try Excel for Microsoft 365 on Windows: choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. Select Repair first; if that fails, try Extract Data to recover readable values and formulas.

What a corrupted Excel file can look like

Workbook damage is not always obvious. Excel may show a message that it cannot open or read a file, report an invalid file format or extension, stop responding while loading, or open the workbook with missing sheets, formatting, charts, or formulas. In some cases it opens but displays a warning that parts of the workbook were repaired or removed. The problem can affect the file itself, or it can be caused by Excel, an add-in, a network location, or a file that was not fully downloaded.

Modern .xlsx and .xlsm workbooks are packaged files containing workbook data and other components, such as worksheet information, styles, and charts. Damage to one component may prevent normal opening even when some of the data remains readable. Older .xls workbooks use a different file format, so recovery options and the amount of recoverable content can vary. A file extension alone does not prove which format the contents use.

Before trying repairs, note the exact message Excel displays and whether the file came from email, a cloud service, a USB drive, or a network folder. That context can help distinguish a damaged workbook from a download or access problem.

Protect the original before troubleshooting

Do not use the only copy of a workbook as a repair experiment. Close Excel if it is still attempting to open the file, then make a duplicate in File Explorer. Give the copy a clear name and keep the original unchanged. If the workbook is on a network share or removable drive, copy it to a local folder before trying to repair it; interruptions during reading or writing can complicate recovery.

Check the copy’s file size. A zero-byte file or a file much smaller than expected may indicate that a transfer or save did not complete. Re-download it or ask the sender to provide it again before attempting repair. If it is stored in OneDrive or SharePoint, check that syncing has completed and that you are working with the intended copy rather than a conflicting or incomplete download.

Keep recovered material separate from the damaged file. If Excel opens a repaired workbook, use Save As to save it under a new name and in a known location. This preserves the original for another recovery attempt and makes it easier to compare what Excel restored.

Use Excel Open and Repair

Open and Repair is Excel’s built-in first choice for a workbook that Excel recognizes but cannot open normally. In Excel for Microsoft 365 on Windows, follow these steps:

Start Excel, then choose File > Open > Browse. Use Browse to open the Windows file picker rather than double-clicking the damaged file.
Select the workbook once. Click the small arrow next to the Open button and choose Open and Repair.
In the prompt, choose Repair. If Excel opens the workbook, inspect the sheets and save the result under a new filename.
If Repair does not work, repeat the process on a fresh copy and choose Extract Data, if that option is offered. Follow the prompt to recover available content.

Repair attempts to restore the workbook structure, while Extract Data is a fallback for retrieving content when a normal repair is unsuccessful. The result may not preserve every feature. Review formulas, formatting, named ranges, charts, PivotTables, macros, external links, and embedded objects before relying on the recovered copy. A successful opening is not proof that every part of the workbook is intact.

The Open and Repair command described here is for Excel desktop on Windows. Excel for Mac does not provide the same Windows Open and Repair menu command. On a Mac, preserve a copy, try opening it in Excel, and check backups or version history; if necessary, use a Windows computer with desktop Excel for the built-in repair option. Excel for the web may open some workbooks, but it is not a substitute for the Windows repair command.

Recover data when repair does not work

If Open and Repair cannot restore the workbook, try recovery methods that do not alter the original. Start with a copy or earlier version, then see whether Excel can open the workbook in another context. For example, if the file was downloaded from a browser, download it again. If it was emailed, ask the sender to resend it or create a fresh copy. A transfer interrupted before completion can look like corruption.

If the workbook opens in Excel but one worksheet is damaged, create a new blank workbook and try copying intact sheets or ranges into it. Work sheet by sheet and save often. For a workbook that will not open but whose data is essential, a specialist may be able to inspect or extract readable content from the file; results are not guaranteed, and confidential business or personal data should not be uploaded to an unknown website.

Opening a damaged file in another spreadsheet program can sometimes reveal data, but it may change formulas, formatting, macros, or Excel-specific features. Treat this as a recovery attempt on a copy, not as a guaranteed repair. If the workbook contains macros, an alternative program may not preserve their behavior. A CSV can preserve plain tabular values for one sheet, but it does not preserve a complete Excel workbook, its formulas as formulas, formatting, multiple sheets, or macros.

Check backups and earlier versions

An earlier clean copy is often more useful than repeatedly attempting to repair the latest damaged save. If the workbook is stored in OneDrive or SharePoint, use File > Info > Version History in desktop Excel to view available versions. Open or restore a suitable earlier version only after checking what it contains; saving over a newer version can discard later edits. The exact history available depends on the storage location, account, and retention settings.

On Windows, File Explorer may also show earlier copies through a file’s Properties > Previous Versions tab if File History, backup software, or another suitable backup feature was enabled. This option will not appear with usable versions on every computer. Check any organization-managed backup system or ask the IT administrator if the workbook is on a work device.

Excel’s recovery of unsaved work is different from repairing an existing damaged file. If Excel closed unexpectedly before the workbook was saved, open Excel and look for recovered files or choose File > Open > Recover Unsaved Workbooks. Availability depends on whether Excel created recovery information and how the application was configured. AutoRecover can help after an unexpected closure, but it is not a guaranteed backup and may not contain the most recent edits.

Rule out problems that look like corruption

Some opening errors have a simpler cause. Check the filename and extension, but do not rename a file to .xlsx just to make Excel accept it: changing the extension does not convert the contents. If the file is actually a CSV, an older Excel format, or another file type, use the application or import method appropriate to that format. If Excel says the extension does not match the file format, ask the sender what format they exported.

Other causes to check include:

Access or sync issues: Copy the file to a local folder and confirm you have permission to open it. Wait for cloud syncing to finish, then try a fresh download.
Password protection: A password prompt is not evidence of corruption. You need the correct password to open an encrypted workbook; repair is not a way to bypass it.
Excel or add-in trouble: If many unrelated workbooks fail, the problem may be Excel rather than one file. On Windows, you can test Excel in Safe Mode by pressing Windows key + R, entering excel /safe, and pressing Enter. If the file behaves differently, investigate add-ins or Excel settings; Safe Mode does not repair a damaged workbook.
Protected View: A security warning for a file from the internet or email is not the same as a corruption warning. Only enable editing if you trust the source and have checked that the file is expected.

On Mac, the Windows Safe Mode shortcut and command above do not apply in the same way. Mac troubleshooting should use the options available in that Excel installation, and a Windows-specific repair path should not be assumed to exist.

Why not rename, unzip, or use a repair website?

Renaming a workbook from one extension to another does not repair its internal contents. It can make the file harder to identify and may lead to the wrong import or opening behavior. Likewise, changing the extension to .zip is not a general repair method. Some modern Excel files are packaged internally in a ZIP-based format, but manually editing or deleting package components can break links between sheets, styles, formulas, and other workbook parts.

Third-party repair tools vary in capability and trustworthiness. Before using one, consider whether the workbook contains customer information, payroll, health data, business plans, or other confidential material. Uploading it may disclose that data. Review the tool provider’s privacy and retention terms, and avoid paying for a promised recovery before understanding what it can actually retrieve. For important or sensitive files, a reputable local IT professional or your organization’s support team may be safer than an unknown online service.

Prevent workbook damage in the future

No single setting prevents every failure, but practical habits reduce the chance of losing work and make recovery easier:

Save important workbooks in a location with managed backup or version history, and confirm that cloud synchronization has completed.
Use descriptive filenames and save a separate copy before major structural changes, bulk edits, or conversions to another format.
Avoid shutting down the computer or removing a USB drive while Excel is saving. For files on a network, make sure the connection is stable.
Keep Microsoft 365 and Windows updated through normal update channels, especially if Excel has trouble with many files rather than one.
For macro-enabled workbooks, retain the correct .xlsm format and keep a clean copy of the original. Saving in a format that does not support macros can remove them.

AutoSave can reduce lost edits for supported files stored in OneDrive or SharePoint, but it is not a substitute for version history or an independent backup. Availability depends on the file location and configuration. For a workbook that supports a critical process, periodically verify that a backup can actually be opened.

Frequently Asked Questions

Can I repair a corrupted Excel file without losing data? Sometimes. Open and Repair may restore the workbook, but it cannot guarantee that every sheet, formula, or feature will survive. Work on a copy, try Repair first, and use Extract Data if offered. Check the recovered content carefully and compare it with a backup if one exists.

Where is Open and Repair in Excel? In Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the workbook, click the arrow beside Open, and choose Open and Repair. The command is not available in the same place in Excel for Mac or Excel for the web.

Can I recover an Excel file that was not saved? Possibly. In Excel for Microsoft 365 on Windows, check File > Open > Recover Unsaved Workbooks and look for files Excel recovered after a crash. Recovery depends on whether temporary recovery data exists. Also check OneDrive or SharePoint version history if the file was stored there.

Does changing .xls to .xlsx fix a damaged workbook? No. Renaming changes the filename extension, not the file’s internal format. If the format is wrong, obtain a correctly exported copy or open and save it using an application that recognizes its actual format. Renaming alone does not repair damaged data.

Why does Excel say the file extension is not valid? The extension may not match the file’s actual format, the download may be incomplete, or the file may be damaged. Confirm the sender’s intended format, download or copy the file again, and try Open and Repair on a duplicate if it is a workbook Excel should recognize.

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.