Excel Open Corrupted File? Recovery Steps That Work

To open a corrupted workbook in Excel for Microsoft 365 on Windows, make a copy of the file, then choose File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. Try Repair first; if that fails, repeat the steps and choose Extract Data. Excel for Mac does not offer the same Open and Repair command, so use a backup or AutoRecover copy, or try opening a duplicate in Excel for the web.

What Excel means by a corrupted file

A corrupted workbook is a file Excel cannot read normally because some of its contents or structure are damaged, incomplete, or in an unexpected format. Excel may show a message such as “Excel cannot open the file because the file format or file extension is not valid,” or it may open the workbook with missing sheets, formulas, formatting, or other content. The message alone does not prove that the file is permanently lost.

Modern Excel workbooks ending in .xlsx or .xlsm are packaged files containing several related parts, including worksheets, styles, formulas, and workbook settings. A damaged part can prevent the whole workbook from opening correctly. Older .xls files use a different format, but they can also become unreadable. In either case, the safest first move is to preserve the original and attempt recovery on a separate copy.

Before you try to repair it

Do not repeatedly open, edit, or save over the only copy. If Excel does manage to open a damaged file, saving it may preserve only the content Excel was able to read. A separate copy gives you another chance to try a different recovery method or compare results.

In File Explorer, copy the workbook to a local folder such as Documents, and give the copy a new name. Keep the original unchanged.
If the file is on a network drive, USB device, or cloud-synced folder, make a local copy before troubleshooting. A failed transfer or synchronization can resemble workbook corruption.
Check that the file has finished downloading or syncing and that its size is not zero or unexpectedly small. If another person sent it, ask them to resend it.
Confirm the extension matches the actual file type. Renaming a file from .csv to .xlsx, for example, does not convert its contents into an Excel workbook.

If the file contains confidential information, avoid uploading it to an unfamiliar online repair service. The workbook may include hidden sheets, customer details, or other data that is not obvious when you view it.

Use Open and Repair in Excel for Windows

Open and Repair is Excel’s built-in recovery option for some damaged workbooks. Use it on the duplicate rather than the original. The labels below apply to Excel for Microsoft 365 on Windows; the command may also be available in other desktop versions of Excel, though menu details can differ.

Open Excel, then select File > Open > Browse. In some layouts, Browse appears after you choose Open.
In the Open dialog, find and select the copied workbook. Do not double-click it.
Click the small arrow next to the Open button and select Open and Repair.
When prompted, select Repair. Excel will attempt to restore as much of the workbook structure and content as it can.
If Repair does not work, repeat the process and choose Extract Data. This option may recover values and formulas even if Excel cannot restore the workbook normally.

After a successful repair, inspect the result before relying on it. Check every sheet, important formulas, charts, tables, named ranges, links, and macros. Excel may remove or alter damaged elements to make the workbook readable. Save the recovered result under a new name using File > Save As, and keep the original copy until you are satisfied with the recovery.

If Repair does not work

A failed repair does not necessarily mean there is no usable data. Try these options in order, using copies where possible:

Try Extract Data. This is the alternate choice in the Open and Repair prompt. It may retrieve cell values or formulas while leaving out features that cannot be recovered.
Open a duplicate in another Excel environment. Excel for the web may handle a workbook differently from desktop Excel, but it is not a dedicated repair tool and may not accept a seriously damaged file. Upload only if your organization’s privacy and storage rules allow it.
Try another computer with Excel. If the file opens there, save a fresh copy. This can help distinguish a problem with the workbook from a local Excel installation or add-in issue.
Ask the file owner to create and send a new copy. If the original is available on their computer, a fresh save or transfer may avoid damage that occurred during copying or downloading.
Use a previous version or backup. Check your organization’s backup system, Windows File History if it was configured, or the version history of the cloud service where the workbook is stored.

For an .xlsx file, advanced users sometimes inspect a copy as a ZIP archive to see whether individual workbook parts remain accessible. This is not a dependable repair method: editing or removing internal files can make the workbook less recoverable, and it is easy to lose formulas, formatting, or relationships between sheets. Preserve the untouched original and prefer Excel’s recovery options or a known-good backup.

Excel for Mac and Excel for the web

Excel for Mac does not provide the Windows Open and Repair command through the same File > Open dialog. Start by making a duplicate in Finder and checking whether macOS or your cloud storage has an earlier version. If Excel offers to recover a document after an unexpected shutdown, review the recovered copy carefully and save it with a new name.

Excel for the web can be useful if the workbook is intact enough to upload and open, but it cannot be treated as a guaranteed recovery route. It may show a warning or fail to load the workbook, and features such as macros are not supported for running in the browser. If the file opens, download or save a separate recovered copy and verify that important content remains. The desktop Windows Open and Repair route is preferable when it is available.

Corruption, blocked files, and wrong extensions

Not every “cannot open” message indicates corruption. Excel may block a file because it came from the internet, open it in Protected View, or reject it because its extension does not match its actual format. These are different problems, and changing security settings or renaming the file blindly can create unnecessary risk.

Protected View: If Excel opens the workbook in a yellow warning bar, the file has opened in a restricted mode. Enable Editing only if you trust where it came from and expected the file.
Wrong or misleading extension: A CSV file is plain text data, not a full workbook. A file renamed to .xlsx is not converted by changing its name. Ask for the correct export or open the file through Excel’s import options.
Permission or location issue: A read-only file, unavailable network location, or sync conflict can prevent normal access without indicating damaged workbook contents. Check permissions and try a local copy.
Password protection: A password prompt is not evidence of corruption. You need the correct password to open an encrypted workbook.

Common reasons workbooks become damaged

Corruption can occur when a computer or Excel closes while a workbook is being written, when a transfer is interrupted, or when a storage device or synchronization process fails. A workbook may also be affected by an application crash, a problematic add-in, or a damaged section within the file. Often, the exact cause cannot be identified from the error message alone.

Some warning signs point toward a transfer or storage issue rather than a workbook-specific fault. For example, if several files from the same USB drive fail, investigate the drive or copying process. If only one workbook fails and its sender can open their copy, request a new transfer. If Excel fails with many unrelated workbooks, updating or repairing the Office installation may be more relevant than trying to recover each file individually.

Preventing data loss next time

Recovery is uncertain because Excel can only restore data that remains readable. A few routine practices make a damaged workbook less costly to deal with:

Keep versioned backups of important workbooks, rather than relying on a single file that is continually overwritten.
Wait for cloud synchronization or file transfers to finish before shutting down, removing a drive, or opening the file on another device.
Use a stable local working copy for large or frequently edited workbooks, then move or sync it after saving.
Save under a new name before major changes to a critical workbook, especially before changing formats or using third-party tools.
For workbooks with macros, preserve a trusted .xlsm copy. Saving as .xlsx removes VBA macros, so it is not an equivalent backup.

AutoSave and cloud version history can help, but neither replaces a deliberate backup. Availability depends on where the file is stored, how it was saved, and the account or organization settings. Check that version history is actually available for the location you use.

Frequently Asked Questions

Can Excel repair a corrupted file automatically?
Sometimes. Excel may detect a problem and offer recovery, but it cannot guarantee that every sheet or feature will be restored. Use Open and Repair on Windows, then check the recovered workbook before treating it as complete.

Will Open and Repair delete data?
It may omit damaged content or features that Excel cannot recover. That is why you should repair a copy and retain the original. Compare sheets and verify important formulas, charts, links, and macros afterward.

Can I recover an Excel file I did not save?
Possibly. In Excel for Windows, check File > Info for Manage Workbook or the available recovery options, and look for AutoRecover files. What appears depends on whether AutoRecover was enabled and whether Excel retained a recoverable version. Save any recovered file immediately under a new name.

Why does Excel say the file format or extension is not valid?
The extension may not match the file’s actual format, the download may be incomplete, or the workbook may be damaged. Confirm the sender’s original file type and obtain a fresh copy before attempting more invasive fixes.

Is it safe to use an online Excel repair website?
It depends on the service and the workbook’s contents, but uploading gives that service access to the file. Do not upload confidential or regulated data unless your organization has approved the service and its handling terms.

Can I fix a corrupted Excel file on a Mac?
There is no matching Windows-style Open and Repair command in Excel for Mac. Try a backup, a prior cloud version, or a recovered AutoRecover copy. You can also try a duplicate in Excel for the web or on a Windows computer, while keeping the original untouched.

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.