If Excel says a file format or file extension is invalid, or a workbook will not open, the file may be damaged—but the message can also mean its extension does not match its actual format. In Excel for Microsoft 365 on Windows, first make a copy of the file, then try File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair.
What “corrupted” means in an Excel file
An Excel workbook is a structured file, not just a page of cells. Modern formats such as .xlsx and .xlsm are packages containing multiple related components, including worksheets, formatting, formulas, and workbook settings. Older .xls files use a different binary format. If a component is missing, incomplete, or inconsistent, Excel may refuse to open the workbook, show a warning, or open it with some content missing.
Corruption does not always mean that every value is gone. A workbook might open but have a damaged sheet, broken charts, missing formatting, or formulas that no longer calculate as expected. Conversely, an error mentioning an invalid format does not prove that the file is corrupted: a renamed file, incomplete download, or unsupported file type can produce a similar message.
It helps to distinguish a damaged workbook from a damaged Excel installation. If several unrelated workbooks fail, investigate Excel, an add-in, permissions, or the storage location. If only one file fails while other workbooks open normally, the problem is more likely specific to that file or its path.
Common causes and clues
Workbooks can become incomplete when Excel or the computer shuts down while the file is being saved. A network interruption, cloud-sync conflict, full disk, failing storage device, or abrupt disconnection of a removable drive can also interrupt a read or write. None of these events guarantees corruption, but each is a reason to check that the saved file is complete and that another copy exists.
- Interrupted transfer: A download, email attachment, or copy operation may have stopped before all the bytes arrived. A file that is unusually small compared with its source is a useful clue, though file size alone cannot confirm damage.
- Wrong extension: A file may be named with an Excel extension even though it contains a different format. Renaming a CSV file to .xlsx, for example, does not convert it into an Excel workbook.
- Sync or version conflict: A cloud service may leave multiple versions or a conflict copy. Compare timestamps and check the service’s version history rather than assuming the newest-looking filename is the best copy.
- Storage or permission issue: Excel may be unable to read a file on a disconnected drive, restricted folder, or unreliable network share. An access problem can resemble a damaged-file problem.
- Unexpected application or export: A third-party tool may create a file with an extension that does not accurately describe its contents, or export a workbook feature in a format that cannot preserve it.
Record the exact error text and note where the file came from. “The file format and extension don’t match” points toward a format or naming mismatch; an error that appears after an interrupted save may make a damaged file more plausible. These clues guide troubleshooting, but neither message identifies the cause with certainty.
Protect the original before trying repairs
Do not repeatedly save over the only copy of a file that may be damaged. Repair attempts can recover useful content while omitting some workbook features, and saving the result can make it harder to return to the original state. Make a duplicate in File Explorer and perform recovery attempts on that copy. If possible, keep one untouched copy on a separate drive or in a trusted backup location.
If the file is on OneDrive or SharePoint, check that the upload or sync has finished before troubleshooting a local copy. Use the service’s version history to inspect earlier versions and restore one to a separate location if available. For a file on a network share or removable drive, copy it to a local folder first, provided the copy operation completes successfully. Do not keep experimenting on a drive that is showing other signs of failure; prioritize copying important files and seeking help with the storage device.
Be cautious with online repair sites and unfamiliar recovery programs. Uploading a workbook may expose personal, business, or confidential data, and a service’s claims do not establish that it can recover the file. Prefer Excel’s built-in options or an organization-approved recovery tool. Avoid enabling macros or lowering security settings just to open a suspicious attachment.
Try Excel’s Open and Repair option
In Excel for Microsoft 365 on Windows, use this sequence on the duplicate file:
- Open Excel and choose File > Open > Browse.
- Navigate to the folder, select the workbook, and click the small arrow next to the Open button.
- Choose Open and Repair. If Excel offers a choice, select Repair first.
- If repair does not work, repeat the process on a fresh copy and choose Extract Data, if that option is offered.
- Review the result carefully, then use File > Save As to save it as a new workbook with a different name.
Repair attempts to restore the workbook structure. Extract Data is a fallback intended to recover values and formulas when a full repair fails; it may not preserve charts, formatting, objects, or other workbook features. The exact result depends on what remains readable, so compare sheets and important calculations with a trusted source or earlier version before relying on the recovered copy.
Excel for Mac also has an Open and Repair option in some releases, but the route and available choices can differ from Windows. If you do not see it, check the current Excel for Mac help for your version rather than assuming that changing the extension will repair the file. Excel for the web does not provide the same desktop repair workflow; download a safe copy and use the desktop app if it is available.
Check the extension and file type
Make sure the filename’s extension reflects the file’s real format. Common workbook extensions include .xlsx for a standard workbook, .xlsm for a macro-enabled workbook, .xlsb for a binary workbook, and .xls for an older Excel workbook. A .csv file contains delimited text data, not the full structure of an Excel workbook; it cannot retain multiple sheets, cell formatting, charts, or macros.
If a file came from a known, trusted source and the extension appears wrong, ask the sender to confirm what format they created and, ideally, resend or re-export it from the original application. Do not simply rename an unknown file to .xlsx. Renaming changes the filename, not the contents. Similarly, changing a file from .xls to .xlsx by renaming it does not perform a proper conversion. If Excel can open the original format, use File > Save As and select the intended workbook type.
Some files are protected or encrypted, which is different from corruption. A password prompt may be expected for an encrypted workbook. If you know the password but Excel still reports a format problem, verify that the file was completely transferred and that the sender used a supported format. Do not try to bypass protection on a file you are not authorized to access.
Look for an earlier or unsaved copy
A previous version may be more complete than a damaged current file. For a workbook stored on OneDrive or SharePoint, open the file in Excel and look under File > Info > Version History. You can inspect available versions and open or restore an earlier one, depending on your access and the service’s settings. Save a recovered version under a new name before replacing anything.
If Excel closed unexpectedly before the last save, check File > Info > Manage Workbook > Recover Unsaved Workbooks. The list can be empty if AutoRecover was not available or no recoverable version was saved. Excel’s AutoRecover preferences are under File > Options > Save on Windows; those settings can affect how often recovery information is saved, but they are not a substitute for saving the workbook or keeping backups.
Also check the folder where the file was stored for a separately named copy, a conflict copy created by a sync service, or an organizational backup. Compare dates and contents, not just filenames. If the workbook contains business-critical records, follow your organization’s backup and incident procedures before restoring a version over a shared file.
When the workbook opens but looks damaged
A workbook that opens successfully can still have lost content. Check every worksheet, including hidden sheets if you know they should exist, and inspect key formulas, named ranges, charts, and external links. A repair may remove or alter features it cannot reconstruct. If Excel reports that it repaired or removed records, read the repair log or message and treat the result as a recovered copy, not proof that the workbook is identical to the original.
If only formulas appear wrong, confirm that calculation is enabled and that references still point to the intended cells. If values are missing, compare the workbook with a source file, exported report, or earlier version; do not assume blank cells were caused by corruption. A CSV import, for instance, may preserve rows of text while losing workbook-only features. Recreating formatting or charts may be possible, but rebuilding missing data requires a reliable source.
When Excel itself behaves unpredictably across many files, test whether the issue is limited to one folder or storage location. On Windows, you can start Excel in Safe Mode by pressing Windows key + R, entering excel /safe, and pressing Enter. If the problem disappears there, an add-in or startup setting may be involved; this does not repair a particular corrupted workbook. On Mac, Windows’ Run command and excel /safe do not apply; troubleshoot add-ins and Excel settings using the Mac version’s controls.
Preventing future workbook damage
For valuable files, prevention is more dependable than repair. Save regularly, keep a separate backup, and let cloud synchronization finish before shutting down or disconnecting a device. Avoid editing the same workbook simultaneously in multiple locations unless your storage and collaboration setup supports it. If a workbook is large or business-critical, establish a versioned backup process rather than relying on a single synchronized copy.
- Use the file format that fits the content: .xlsx for most workbooks, .xlsm when macros must be retained, and .csv only when plain tabular text is sufficient.
- Keep the original export or source data separately when the workbook is important.
- After a major edit, save a clearly named version or confirm that your organization’s version history is available.
- Do not unplug external storage or interrupt a transfer while a file is being written.
- Keep Microsoft 365 and the operating system updated through normal, trusted update channels.
AutoSave can help with supported files stored in OneDrive or SharePoint, but it depends on the file, storage location, and account configuration. It should not be treated as a complete backup: accidental changes can also synchronize, and service access or retention settings may vary.
Frequently Asked Questions
Can I fix a corrupted Excel file by changing its extension?
No. Renaming a file changes its label, not its internal format or damaged contents. Use the extension that matches the actual file type, and use Excel’s Save As command to convert a workbook that Excel can open.
Will Open and Repair recover every worksheet and formula?
No. It may restore the whole workbook, recover only some content, or fail. The Extract Data option can sacrifice formatting and other features. Check the recovered file against an earlier copy or trusted source before using it as authoritative.
Why does Excel say the file format and extension do not match?
The filename may have the wrong extension, or the file may be incomplete or damaged. Confirm the format with the person or application that created it, and obtain a fresh copy if possible. Do not assume the warning is safe to ignore, especially for an unexpected attachment.
Can I recover an Excel workbook I never saved?
Possibly. In Excel for Microsoft 365 on Windows, check File > Info > Manage Workbook > Recover Unsaved Workbooks. Recovery depends on whether Excel saved usable recovery information; it cannot guarantee that an unsaved file exists.
Is an online Excel repair website safe?
It depends on the provider and its data-handling practices. Uploading a workbook can disclose everything in it, including hidden sheets or sensitive information. For confidential files, use Excel’s built-in recovery tools or a recovery method approved by your organization.
Related
- Excel Data Validation for Multiple Lists: Setup and Tips
- Excel Data Validation From a Named Range: How It Works
- Excel Data Validation From a Table Column: How to Set It Up
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Changing Indent in Word: A Practical GuideTo change an indent in Microsoft Word for Microsoft 365 on Windows, select the paragraph or paragraphs, then…
- How to Unblock a Sender in Outlook Email on Any DeviceTo unblock a sender in Outlook, remove their email address or domain from your blocked senders list. In…
- Outlook Share Calendar Button Does Nothing? Fixes That WorkIf Outlook’s Share Calendar button does nothing, first check whether a sharing window opened behind Outlook, then try…
- Excel Column A Hidden? How to Unhide ItIf column A is missing in Excel, select the column header immediately to its right, then choose Home…
- Excel Freezing? Causes, Fixes, and PreventionIf an Excel file keeps freezing, first wait briefly to see whether Excel is calculating or loading; if…
- How to Insert a Fillable Checkbox in Microsoft WordTo add a fillable checkbox in Word, turn on the Developer tab, place your cursor where the box…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.