Excel File Extension Corrupted? Causes and Safe Fixes

How-to basics · Updated November 21, 2026

An Excel file-extension error usually means the filename suffix, such as .xlsx, does not match the file’s actual format; it can also appear when a download is incomplete or a workbook is damaged. If the file came from a trusted source, make a copy, confirm its real format, then try Excel’s repair tools; do not bypass the warning for an unexpected attachment.

What the Excel file-extension warning means

A file extension is the short ending after a filename’s final dot. It helps Windows and Excel identify what kind of file they are handling, but changing that ending does not convert the file itself. For example, renaming notes.txt to notes.xlsx does not turn a text document into an Excel workbook.

Excel may show a message that the file format and extension do not match when it sees that the contents do not appear to agree with the suffix. The mismatch might be harmless—for instance, someone saved a file in an older format and then renamed it—but it can also signal a damaged, truncated, disguised, or incorrectly downloaded file. The warning is a reason to check the file, not proof that it is safe or proof that it is irretrievably broken.

Keep the original unchanged while troubleshooting. If Excel can open the file, save a recovered copy under a new name rather than overwriting the only version. If the workbook contains business-critical information, preserve the original for later recovery attempts.

Common Excel extensions and what they contain

Knowing the expected format helps distinguish a simple naming error from a damaged workbook. Common extensions include:

  • .xlsx: The standard modern Excel workbook format. It does not store VBA macros.
  • .xlsm: An Excel workbook format that can store VBA macros. Changing this to .xlsx can remove macro content when saving in that format.
  • .xlsb: An Excel binary workbook format, often used for workbooks that benefit from a binary file structure.
  • .xls: The older Excel 97–2003 workbook format. It has format limitations compared with newer workbook types.
  • .csv: A text file containing delimited data, usually one table. It does not preserve a workbook’s multiple sheets, formulas as formulas, charts, or most formatting.

These formats are not interchangeable just because Excel can open several of them. A CSV may open in Excel as rows and columns, but saving it as CSV does not preserve the full workbook experience. Similarly, an .xlsx file is internally a package of structured files, but renaming it to .zip is not a repair method and does not make its contents a valid workbook.

Check the full filename and the source

First, make sure you can see the complete filename. Windows may hide known extensions, so a name that appears to end in .xlsx could actually be something like report.xlsx.html. That might be a web page downloaded instead of the intended workbook. A temporary download ending, such as .part or .crdownload, can mean the download has not completed.

In Windows 11 File Explorer, select View > Show > File name extensions. In Windows 10, use the View tab and select File name extensions. On a Mac, Finder can show extensions using Finder > Settings > Advanced > Show all filename extensions. Menu wording can vary slightly between operating-system releases.

Then check where the file came from and how it was transferred. If it arrived by email, ask the sender to confirm the expected file type and resend it. If you downloaded it, compare the file size and name with the source or download it again from the original site. A file with a very small size when a large workbook was expected may be incomplete, but size alone cannot establish whether a file is valid.

Do not guess the correct extension by repeatedly renaming the file. If the sender confirms that the contents are an Excel workbook saved with a different suffix, renaming a copy may resolve a simple mismatch. If the format is unknown, ask for a fresh copy in a known format such as .xlsx, or have the sender open the workbook and use Save As to create the right file type.

Try Excel’s Open and Repair tool

For a trusted workbook that still will not open, use the built-in repair option in Excel for Microsoft 365 on Windows. Work on a duplicate where possible:

  1. Open Excel, then select File > Open > Browse.
  2. Browse to the workbook and select it once. Do not double-click it.
  3. Select the arrow beside the Open button, then choose Open and Repair.
  4. Choose Repair first. If Excel cannot repair the workbook, try Extract Data to retrieve values and formulas that may still be readable.

Repair may restore the workbook, but it is not guaranteed to preserve every feature. Extracting data is a fallback for recovering usable content, not a way to reconstruct the original layout, charts, macros, or every formula. After a successful recovery, check sheet names, important formulas, dates, totals, charts, links, and formatting. Save the recovered file with a new name and a suitable workbook format.

If Excel reports a format mismatch but opens the file, do not immediately treat that as a clean repair. Confirm the contents are what you expected, then use File > Save As to save a new copy in the appropriate format. If the file is from an unknown source or its contents are unexpected, close it rather than proceeding.

Recover another copy before repeated repair attempts

The damaged file may not be the only available version. Check the location where it was stored before trying complicated recovery steps. For a file in OneDrive or SharePoint, use the service’s version history to see whether an earlier version can be restored or downloaded. This can be safer than trying to rebuild a workbook from a damaged copy.

If the workbook was recently closed or Excel stopped unexpectedly, check Excel’s recovery options. In Excel for Windows, select File > Info and look for workbook-management or recovery options that are available for that file. The Recover Unsaved Workbooks option can also be available from File > Open, depending on the situation and Excel’s settings. Recovery availability depends on whether Excel had a recoverable copy; it is not a substitute for a saved backup.

For a workbook stored on a local drive, check Windows File History or another backup system if one was configured. For files stored on a network drive, ask the administrator whether snapshots or backups are available. On a Mac, look for a previous version in the relevant cloud service or backup system; the Windows Open and Repair steps may not be presented in the same way in Excel for Mac.

Separate a damaged file from a security risk

A mismatch can happen accidentally, but attackers can also disguise a file by giving it a misleading name. An attachment that looks like spreadsheet.xlsx may actually be a different file type, especially if extensions are hidden. Check the full name and confirm unexpected attachments with the sender through a separate, trusted channel.

Do not enable macros or editing simply to get past a warning. Excel’s Protected View and other security prompts are intended to limit risks from files that might be unsafe. Protected View settings are under File > Options > Trust Center > Trust Center Settings in Excel for Windows, but disabling protection globally is not a sound repair step. If a file is trusted and must be edited, follow your organization’s security process and only enable content when you understand why it is needed.

Also be cautious about uploading a confidential workbook to an online repair website. The service may receive the file’s contents, including hidden sheets, personal information, or business data. Prefer Excel’s own tools, an approved company service, or help from the file’s owner when the workbook is sensitive.

Save the repaired workbook in the right format

After recovering the contents, choose a format that matches how the workbook will be used. Use .xlsx for a regular modern workbook and .xlsm if VBA macros need to remain in the file. Excel may warn that saving a macro-enabled workbook as .xlsx will remove macros; do not accept that change if the macros are required. Use .xls only when compatibility with older software is necessary, since saving to an older format can discard features.

Use .csv only when you need a plain data table for another system. A CSV file generally represents a single sheet and does not retain workbook features such as multiple tabs, cell formatting, charts, or formulas in their editable form. If you need to preserve those features, save as an Excel workbook instead. After saving, close the recovered copy and reopen it to confirm that it works and that the important data is present.

How to prevent extension and corruption problems

Most prevention is straightforward: keep the extension that the application creates, avoid interrupting file transfers, and maintain another copy of important workbooks. Use a meaningful filename, but do not rename the suffix unless you know the actual file format. If you need a different format, use Excel’s Save As command rather than changing the name in File Explorer.

  • Wait for downloads and cloud synchronization to finish before opening or moving a workbook.
  • Use a reliable storage location and keep version history or backups for important files.
  • Ask senders to resend files that have incomplete names, unexpected extensions, or suspiciously small sizes.
  • When collaborating, use a shared OneDrive or SharePoint copy with version history rather than creating many confusing renamed versions.
  • Before a risky recovery attempt, make a separate copy and keep the original untouched.

These steps cannot prevent every storage failure or unexpected shutdown, but they make it easier to tell whether the problem is a wrong suffix, an unfinished transfer, or actual workbook damage.

Frequently Asked Questions

Can I fix a corrupted Excel file by changing its extension?
No. Renaming changes the label, not the file’s contents. It may correct a simple mismatch if you already know the real format, but it cannot repair damaged data or convert a file into a different format.

Is it safe to click Yes when Excel says the extension does not match?
Only consider continuing when you trust the source and have a good reason to expect a mismatch. The warning does not verify that the file is safe. For an unexpected attachment or unknown download, stop and confirm the file with its source instead.

What should I do if Open and Repair does not work?
Try Extract Data, locate an earlier version in OneDrive, SharePoint, or a backup, and ask the sender for a fresh copy. Avoid saving over the original. If the workbook is valuable, preserve it and use an approved specialist or support channel rather than repeatedly modifying it.

Will saving a repaired file as .xlsx remove macros?
Yes, .xlsx does not store VBA macros. If macros must be retained, save a trusted workbook in .xlsm and review Excel’s format warning before confirming a different file type.

Why does my file appear to have the right extension but Excel will not open it?
The visible ending might not be the complete filename, or the file may be incomplete, damaged, encrypted, or not an Excel workbook at all. Show filename extensions, verify the source, and request a new copy if the actual format remains unclear.

Related

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.