If an Excel file is corrupted, first make a copy of it, then try Excel’s built-in repair: in Excel for Microsoft 365 on Windows, choose File > Open > Browse, select the file, click the arrow beside Open, and choose Open and Repair. Choose Repair first; if that fails, repeat the steps and choose Extract Data. These options may restore a workbook, but they cannot guarantee recovery of every formula, format, or missing value.
What a corrupted Excel file means
A workbook is commonly called corrupted when Excel cannot read it normally, displays an error, opens only partially, or shows missing or damaged content. The problem can affect the workbook’s file structure, a worksheet, formatting, formulas, or embedded objects. A file that refuses to open is not necessarily corrupted, however: an incomplete download, a wrong file extension, a permission issue, or a temporary problem with a network or cloud location can produce similar symptoms.
Files can become unreadable after an interrupted save, an unexpected shutdown, a computer or storage-device fault, or a sync conflict. Moving a file while it is still being saved can also leave an incomplete copy. Excel may report that the file format or extension is not valid; show a blank sheet; freeze while opening; or display a warning that it found unreadable content. The exact message helps narrow down the cause, but none of these symptoms alone identifies it with certainty.
AI is not a special repair switch built into an Excel workbook. An AI assistant may explain an error message or suggest troubleshooting steps, but it cannot recreate data that was never saved or reliably repair a file merely from its name. The safest first move is to preserve the original and use Excel’s recovery options.
Protect the original before troubleshooting
Do not repeatedly overwrite the only copy. Make a duplicate in File Explorer, or copy the file to another folder or drive, and perform repair attempts on that duplicate. If the workbook is on OneDrive, SharePoint, a shared drive, or an external disk, copy it to a local folder before testing. This helps distinguish a damaged workbook from a connection or synchronization problem.
- Keep the original unchanged and give the copy a clear name, such as recovery-copy.xlsx.
- Check that the file is not zero bytes or unexpectedly tiny. A very small size can indicate an incomplete save or download, though size alone does not prove corruption.
- If the file came from email or a website, download it again and compare the new copy. Avoid opening or editing the same workbook simultaneously from multiple locations.
- Record the full error message and note when the problem began. That information is useful if you need to ask an administrator or Microsoft support for help.
Do not rename an unrelated file extension just to make Excel accept it. Changing a name from, for example, .csv to .xlsx does not convert its contents into an Excel workbook.
Use Excel’s Open and Repair feature
On Windows, Open and Repair is the first built-in recovery method to try. Open Excel itself rather than double-clicking the damaged file, then follow these steps:
- Select File > Open > Browse.
- In the Open dialog, select the affected workbook. Do not open it yet.
- Click the arrow beside the Open button and choose Open and Repair.
- When prompted, choose Repair. Wait for Excel to finish, then inspect the worksheets and save a recovered copy under a new name.
If Repair does not work, repeat the process and choose Extract Data. Excel may be able to retrieve cell values and formulas even when it cannot rebuild the workbook’s full structure. Depending on the damage, some formatting, charts, objects, or other workbook features may be lost. Review the result carefully rather than assuming a successful opening means every sheet is complete.
Open and Repair is not available in every Excel interface. Excel for the web does not provide the same desktop repair dialog, so download a copy and try the Windows desktop application. On a Mac, the available recovery commands can differ by Excel version; if you do not see Open and Repair, try the file in desktop Excel for Windows, if available, or move to the backup and version-history options below.
Check AutoRecover, unsaved files, and version history
If Excel closed unexpectedly, it may have retained a recoverable draft. Reopen Excel and look for a Document Recovery pane. Open any candidate file, verify its contents, and immediately save it under a new name. Recovery entries may represent different points in time, so check the timestamps and compare the sheets before choosing one.
For a workbook that was never saved, Windows Excel may offer File > Info > Manage Workbook > Recover Unsaved Workbooks. The wording or availability can vary with the application version and account settings. If a recovered copy appears, save it to a normal folder before continuing. AutoRecover is not the same as a permanent backup: it saves recovery information on a schedule, and it may not contain the latest edits.
For files stored on OneDrive or SharePoint, check Version History. In Excel, look under File > Info for Version History, or use the file’s context menu in the associated OneDrive or SharePoint location. Open an earlier version and confirm that it contains the needed data before restoring it. If possible, save or download that version as a separate copy first. Version-history availability depends on where the file is stored and the organization’s retention settings.
You can also check Windows backups or an organization’s backup service if one is configured. On a Mac, check the relevant cloud service’s version history or a Time Machine backup if it was set up. These are independent of Excel’s repair process and may recover an intact earlier copy rather than trying to fix the damaged one.
If the workbook still will not open
Work through basic causes before using third-party recovery software. Confirm that Excel is updated, that the file is fully downloaded, and that you have permission to access it. If the workbook is on a network share, copy it locally and try again. If Excel shows a Protected View or security warning, read the message and confirm that you trust the file’s source before enabling editing; security warnings are not proof of corruption.
If another workbook opens normally, the issue is more likely specific to this file. If multiple workbooks fail, investigate Excel or the computer instead. You can try opening Excel in Safe Mode on Windows by holding Ctrl while starting Excel and confirming the prompt. Safe Mode can help identify add-in or startup problems, but it does not repair damaged workbook contents. Close Excel and restart normally after the test.
As a last-resort way to salvage values, try opening a duplicate in another spreadsheet program, such as LibreOffice Calc. Different programs may interpret workbook features differently, so formulas, charts, formatting, macros, or data connections can change or be omitted. Do not save over the source. If the file contains confidential or business-critical information, consult your IT administrator before sending it to a repair service.
A recovered file needs a careful audit. Compare sheet names, row and column counts, key totals, formulas, charts, and any hidden sheets with a known-good copy or the expected report. Check formulas that refer to other sheets or external workbooks, because a repair or extraction may leave references broken. If only some values return, use other records, exports, or backups to verify them rather than treating guessed reconstructions as original data.
Can an AI tool repair the file?
An AI chatbot can help interpret a non-sensitive error message, explain where a recovery option is located, or suggest a checklist based on your Excel version. It cannot promise to reconstruct a workbook from a description, and pasting cell contents into a chat is not equivalent to repairing the original file. Some specialist products advertise automated recovery, but capabilities, privacy terms, and results vary. Excel’s own repair and backup options should usually come first.
Think carefully before uploading a workbook to any online AI or file-repair site. Spreadsheets often contain names, customer details, payroll figures, unpublished financial results, or proprietary formulas. Check your organization’s data rules and the service’s privacy and retention terms. If the file is sensitive, use locally approved software or ask the person responsible for IT instead of uploading it to an unapproved service.
Reduce the chance of future workbook damage
Prevention is mainly about keeping recoverable copies and avoiding interrupted saves. Store important workbooks in a location with a suitable backup or version-history policy, and confirm that synchronization has finished before shutting down or disconnecting a drive. Avoid editing one file from two devices at the same time unless the storage service and workflow support it.
- Save important work regularly with Ctrl+S on Windows; on Mac, use Command+S.
- In Windows Excel, review File > Options > Save to see the AutoRecover settings. The Mac settings are in Excel > Preferences or Settings, with labels that vary by release.
- Keep dated copies before major changes, especially before importing data, running a macro, or changing workbook structure.
- Use a stable power source and storage device, and wait for cloud synchronization to finish before moving or renaming the file.
- For critical records, maintain a separate backup rather than relying only on AutoRecover or the same synced folder.
Saving a repaired workbook in the current Excel format can make it easier to continue working, but first keep an untouched copy of both the damaged source and the recovered result. If the original used macros or special connections, confirm that the chosen file format and recovery method preserve the features you need.
Frequently Asked Questions
Can I repair a corrupted Excel file without losing data?
Sometimes. Try Repair first, then Extract Data, and check AutoRecover or Version History for an intact earlier copy. Repair may preserve more workbook features, while extraction can omit formatting or objects. Always work on a copy and verify the recovered contents.
Why does Excel say the file format or extension is not valid?
The file may be incomplete, damaged, mislabeled, or not actually an Excel workbook. Download it again or ask the sender to provide a fresh copy. Changing the extension alone does not convert the file or restore missing content.
Can I fix an Excel file online?
Excel for the web can open supported workbooks, but it does not offer the same Windows Open and Repair dialog. Try a downloaded copy in desktop Excel, and use cloud Version History if the workbook is stored on OneDrive or SharePoint.
Will Open and Repair restore formulas and formatting?
It may restore them, but the result depends on what is damaged. Extract Data may recover values or formulas while leaving formatting, charts, or other features behind. Inspect the recovered workbook and compare important calculations with a reliable source.
Is it safe to upload a damaged workbook to an AI repair website?
Not automatically. The workbook may contain private or confidential information, and services have different data-handling terms. Use an approved local method for sensitive files, and check your organization’s policies before uploading anything.
Related
- How to Add Subtotal Rows in Excel by Category or Date
- How to Bold Subtotal Rows in Excel
- Excel Subtotal Visible Rows: Sum Filtered Data Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- PowerPoint Audio Controls: Add and Customize PlaybackTo add audio controls to a PowerPoint slide, insert an audio file with Insert > Audio, select the…
- Google Sheets Filter Views: Create, Use, and Share ThemA Google Sheets filter view is a saved way to sort or filter a table without changing the…
- How to Name a Dropdown List in Excel with a Named RangeTo name a dropdown list in Excel, give its source cells a name, then use that name as…
- Creating Labels in Word: Mail Merge, Setup, and PrintingTo create labels in Microsoft Word for Microsoft 365 on Windows, open Mailings > Start Mail Merge >…
- How to Add Page Numbers to an Essay in Microsoft WordTo add page numbers to an essay in Microsoft Word, open the Insert tab, choose Page Number, select…
- Media Excel Shortcuts for Images, Links, and ObjectsExcel has no single keyboard shortcut for all media. In Microsoft 365 for Windows, use Ctrl+V to paste…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.