If Excel says a file contains corrupted data, it cannot reliably read some part of the workbook, but that does not automatically mean all of your information is lost. In Excel for Microsoft 365 on Windows, make a copy of the file first, then try File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair.
What the corrupted-data message means
An Excel workbook is more than a grid of visible cells. An .xlsx file is a package of related components that can include worksheets, formulas, styles, charts, images, tables, and other workbook features. Excel has to interpret those components to display and edit the file. If a component is damaged, missing, or inconsistent, Excel may warn that it found unreadable content, report that the file contains corrupted data, or refuse to open it.
The wording varies with the Excel version, file type, and point at which the problem occurs. A warning about unreadable content can mean Excel found something it can remove or repair. A message that the file format or extension is not valid may instead mean the file is mislabeled, incomplete, or not actually an Excel workbook. Neither message alone proves that the data is permanently gone.
Corruption can follow an interrupted download or save, a sudden computer shutdown, a storage-device problem, or a sync conflict. A workbook can also be damaged before it reaches your computer. Sometimes the apparent problem is not corruption at all: the file may have the wrong extension, be blocked by a security setting, or have been created by software that exports an unusual workbook structure.
First steps before attempting a repair
Protect the original before troubleshooting. Repairs and repeated saves can change a file, and a repair may remove a damaged feature or content. Keep the original untouched so you can retry with another copy or compare it with a recovered version.
- Close Excel and make a duplicate of the affected file in File Explorer. Give the copy a different name so it is easy to distinguish from the original.
- Move a copy to a local folder, such as Documents, if the file is on a network share, removable drive, or cloud-synced folder. This helps rule out an interrupted connection or sync activity.
- Check that the file has finished downloading or syncing, and confirm that its size is not zero. If you received it from someone, ask them to send it again or provide a fresh export.
- Note the exact error message and the file extension, such as .xlsx, .xls, or .csv. These details help distinguish a workbook repair issue from a file-type or access issue.
Do not repeatedly rename the extension in an attempt to repair the content. Changing a filename from .csv to .xlsx, for example, does not convert comma-separated text into a genuine Excel workbook.
Use Excel’s Open and Repair tool
In Excel for Microsoft 365 on Windows, open Excel first rather than double-clicking the damaged file. Choose File > Open > Browse. In the Open dialog, select the file, click the arrow beside the Open button, and select Open and Repair. If Excel offers a choice, try Repair first. This asks Excel to recover as much workbook content as it can.
If Repair does not work, repeat the process on a fresh copy and choose Extract Data if that option is offered. Extract Data is intended to retrieve values and formulas when a full workbook repair is not possible; it may not preserve the workbook’s appearance, charts, or other features. Review the result carefully and save any recovered content under a new filename, leaving the original intact.
Open and Repair is not a guarantee. A workbook may be too badly damaged to open, or a particular feature may not be recoverable. Excel can also open a repaired workbook while omitting an element it could not interpret. Look for a repair notice or log when Excel provides one, and check important sheets, formulas, named ranges, and charts rather than assuming the file is complete just because it opens.
The Open and Repair command described here is for Excel on Windows. Excel for the web does not provide the same desktop repair dialog. On a Mac, the available recovery choices can differ by Excel version; try opening a duplicate in the desktop app, and use a Windows copy of Excel if you specifically need the Windows Open and Repair workflow. Menu names and available options may vary in other editions.
Check the file type, extension, and source
Make sure the extension matches what the file actually is. Common Excel formats include .xlsx for a standard XML-based workbook, .xls for an older Excel workbook, .xlsm for a macro-enabled workbook, and .csv for plain-text, delimited data. A CSV file does not preserve multiple sheets, formatting, charts, or formulas as workbook features. It stores data as text in a single table-like file.
If a file arrived as an email attachment or download, check whether it was fully transferred. Compare its size with the sender’s copy if possible. Ask the sender to open their original and save a new copy in a suitable Excel format, then send that copy. If the file came from another application, export it again using that application’s Excel workbook option rather than merely changing the filename.
A security warning is a separate issue from corruption. For example, Excel may open an internet-downloaded file in Protected View or warn that macros are disabled. Those warnings concern safety and editing permissions; they do not establish that the workbook is damaged. Do not enable macros or bypass a security warning just to see whether a file opens unless you trust its source and understand what it contains.
Try recovery from a previous version
If repair fails, look for another copy rather than repeatedly modifying the damaged one. If the workbook was stored in OneDrive or SharePoint, use the file’s version history to find an earlier version. In File Explorer, right-clicking a file and choosing Properties may show Previous Versions when Windows backup or another versioning system has been configured. Availability depends on the storage and backup setup; it is not a feature that can restore every file automatically.
Excel may also have a recovery copy after a crash. In Excel for Windows, check File > Info for Manage Workbook and any listed recovered or unsaved versions. The options and items shown depend on whether AutoRecover or document recovery captured a usable copy. Open a candidate version and use Save As to create a separate workbook before making changes.
If the workbook was on a USB drive or other storage device that is failing, stop writing new files to that device. Repeated attempts to copy, repair, or save data onto failing storage can complicate recovery. If the information is important and no backup exists, consider asking your organization’s IT team or a reputable data-recovery professional before using utilities that modify the device.
What may be lost in a repaired workbook
A repair can restore readable data without restoring every feature. Depending on what is damaged, Excel may omit formatting, formulas, charts, images, pivot-table details, links, or other workbook components. There is no universal list of what a repair will remove because the result depends on the file’s specific problem.
After recovery, compare the repaired file with a trusted copy or report if one exists. Check sheet names and row counts, inspect formulas in key totals, and verify dates, decimal values, and text that may have been imported or interpreted differently. If formulas appear as values, or values appear unexpectedly blank, do not assume the workbook’s calculations are correct. Recalculate only after confirming that the formulas and source data are intact.
When the repaired workbook opens, save it using a new name and an appropriate format. Keep the original and any repair output until the recovered file has been checked. If Excel removed a feature that matters, returning to a prior version or asking the sender for a fresh copy may be a better solution than rebuilding the feature from memory.
How to reduce the chance of future corruption
No precaution prevents every file problem, but a few habits reduce the risk and make recovery easier:
- Save important workbooks to a reliable location and keep a separate backup or use a service with version history.
- Wait for a save or sync to finish before shutting down a computer, disconnecting a drive, or closing a remote connection.
- Use a suitable workbook format. For example, save a workbook that needs macros as .xlsm; saving as .xlsx does not retain VBA macros.
- Keep Excel and storage-device software up to date, and investigate recurring problems with a particular drive or network location.
- For files shared by email or downloaded, verify the transfer completed and keep the sender’s original when possible.
Cloud storage can provide useful version history, but syncing is not the same as maintaining an independent backup. A damaged or unwanted change may sync too, so check that version recovery is available and retain a separate copy for especially valuable workbooks.
Frequently Asked Questions
Does File contains corrupted data mean my Excel file is gone?
No. The message means Excel cannot read some part of the file as expected. Open and Repair, a previous version, or a fresh copy from the sender may recover it. Some content can still be missing, so verify the recovered workbook before relying on it.
Can I fix a corrupted Excel file without opening Excel?
You can first try obtaining a new download, copying a backup, or restoring a version from your storage service. However, Excel’s Windows Open and Repair option requires the desktop Excel application. Renaming the file extension does not repair its internal contents.
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 file may not be a valid Excel workbook. Check the source and extension, request a fresh copy, and have the original application export the file again in a supported format.
Will Open and Repair preserve my formulas and formatting?
It may preserve them, but it cannot promise to recover every component. If Excel cannot read a damaged feature, it may omit it. Inspect important formulas and formatting, compare key results with a trusted source, and keep the original file.
Can Excel for the web repair a corrupted workbook?
Excel for the web does not offer the same Windows Open and Repair dialog. Download or copy the workbook, then try opening a duplicate in the desktop Excel app. If the problem remains, restore a prior version or request a clean copy from the source.
Related
- Excel Text to Columns: Find It and Split Data Correctly
- Excel Text to Columns: Advanced Options and Uses
- Excel Text to Columns: Split Alt+Enter Line Breaks
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Share a Calendar in Outlook and Choose Access LevelsTo share a calendar in Outlook, open Calendar, choose the calendar, select Share Calendar or Share, enter the…
- Google Sheets: Duplicate a Data Validation RuleTo duplicate a data validation rule in Google Sheets, copy a cell that already has the rule, select…
- How to Lock Cells in Excel on SharePoint Step by StepTo lock cells in an Excel workbook stored on SharePoint, open it in the Excel desktop app, unlock…
- How to Create a Private Distribution List in OutlookTo create a personal distribution list in Outlook, open People, choose New contact list (or New Contact Group…
- How to Search in Google SheetsTo search in Google Sheets, press Ctrl+F on Windows or Command+F on Mac, enter a word or number,…
- Microsoft Excel Budget Tracking Template: How to Use ItYes—Microsoft Excel for Microsoft 365 offers budget templates you can open from File > New: search for “budget,”…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.