To get back a corrupted Excel file, first make a copy of it, then try Excel for Microsoft 365 on Windows: choose File > Open > Browse, select the copy, click the arrow beside Open, and choose Open and Repair. If repair fails, try Extract Data, then look for a version in OneDrive or SharePoint version history, or an AutoRecover copy. These options may restore the workbook or its contents, but no method can guarantee every formula, chart, or formatting detail will survive.
What You’ll Need
- A Windows computer with Excel for Microsoft 365, if possible. The Open and Repair command described below is a Windows feature; Mac and web alternatives are covered in the steps.
- The damaged workbook, or the folder, USB drive, email, or cloud location where it was stored.
- Enough free storage to make a separate copy. Keep the original untouched while you work.
- Access to the OneDrive or SharePoint account if the workbook was saved there. If it belongs to someone else, you may need permission to view its version history.
Step-by-Step
-
Stop editing the damaged file and make a working copy. If Excel still has the workbook open, avoid saving over it. Close it, and use File Explorer to copy the file to another folder or an external drive. Give the copy a clear name, such as Budget-recovery-copy.xlsx. Check that the copy has the same file extension as the original. Do not rename an .xls or .xlsb file to .xlsx; changing the extension does not convert or repair its contents.
If the file is on a USB drive, network share, or failing disk, copy it to a healthy local drive before attempting repairs. If copying produces an error or the drive disconnects, stop repeated attempts and focus on making a safe copy of the storage or asking your IT support for help. Repeated reads from failing hardware can make recovery harder.
-
Check that the file is a real workbook and not an incomplete download. In File Explorer, confirm that it has a plausible Excel extension, such as .xlsx, .xls, or .xlsm, and that its size is not zero. If it came as an email attachment or download, download it again or ask the sender to resend it. A file ending in .crdownload or another temporary extension may not have finished downloading. Do not remove a security warning or enable macros just to make a damaged file open.
-
Run Open and Repair on the working copy. Start Excel, select File > Open > Browse, and navigate to your copy. Select the file once; do not double-click it. Click the small arrow on the Open button, then select Open and Repair. In the prompt, choose Repair first. Excel will try to recover the workbook structure and contents. If it opens, review several sheets, formulas, dates, charts, and any important named ranges rather than assuming everything is intact.
Save a successful recovery under a new name using File > Save As. Keep the damaged original and working copy until you have checked the recovered workbook. If the original was a macro-enabled .xlsm file, preserve that format if you need its macros; saving as .xlsx removes VBA macros.
-
Try Extract Data if Repair does not work. Repeat File > Open > Browse, select the working copy, use the arrow beside Open, and choose Open and Repair. In the repair dialog, select Extract Data. This option aims to recover cell values and formulas when a full repair is not possible. It may not retain layout, formatting, charts, objects, or other workbook features. Save extracted results as a new file and compare them with any source documents or previous reports you have.
-
Look for a cloud version from before the damage. For a workbook stored in OneDrive or SharePoint, open the folder in a browser, find the file, and use its context menu to choose Version history. Open or restore a version from before the problem began. You can also open the workbook in Excel and look under File > Info for Version History when that option is available. Prefer opening or downloading an older version first; restoring it may replace the current cloud version. If possible, save the older version as a separate copy and compare it before replacing anything.
Version history requires the file to have been saved in a supported cloud location and versioning to be available. A workbook saved only on a local drive will not have OneDrive or SharePoint history.
-
Check Excel’s unsaved-workbook recovery. In Excel for Windows, select File > Info > Manage Workbook > Recover Unsaved Workbooks. Look for a copy with a date and time close to when you last worked on the file. Open it, then use Save As immediately to store it under a new name in a safe folder. The list may be empty if AutoRecover was turned off, the recovery copy expired, or Excel did not create one.
For future work, check File > Options > Save and confirm that Save AutoRecover information is enabled. This setting can reduce lost work, but it is not a substitute for saving and does not guarantee recovery of a corrupted file.
-
Try Excel for the web or another trusted computer. If desktop Excel cannot open the copy, upload a duplicate to OneDrive and try opening it in Excel for the web, provided the file is not confidential or restricted from cloud storage. The web app may open a workbook that desktop Excel struggles with, or it may show that the file is damaged. Do not treat a successful web opening as proof that all features are preserved; download a separate copy and check it in desktop Excel. You can also try a current Excel installation on another trusted computer.
Excel for the web does not provide the Windows Open and Repair command. On a Mac, look for AutoRecovery or cloud version history and try opening a duplicate in Excel for the web or on Windows. Menu names and recovery options differ by Excel version, so do not assume Windows instructions apply exactly to Mac.
-
Check whether an add-in or startup setting is interfering. If other workbooks also fail to open normally, close Excel and press Windows key + R, type
excel /safe, and press Enter. Try opening the working copy from Excel’s File > Open screen. Safe Mode starts Excel with many add-ins and customizations disabled; it does not repair a damaged workbook by itself. If the file opens only in Safe Mode, investigate add-ins under File > Options > Add-ins, rather than repeatedly repairing or saving the original. -
Verify what was recovered before putting it back into use. Check key sheets, totals, formulas, external links, pivot tables, charts, images, and macros as relevant. Compare important figures with a trusted source or an earlier report. Save the verified version separately, then make another backup. If only values survived, you may need to rebuild formulas or formatting from an older copy or another source.
Common Mistakes
- Saving over the only copy. A repair attempt can change or discard damaged parts. Always work on a duplicate and save any recovery under a new name.
- Changing the extension to force a conversion. Renaming .xls, .xlsb, or .xlsm to .xlsx does not change the file format and can make diagnosis more confusing. Use Save As only after Excel opens the workbook.
- Choosing Extract Data and expecting a complete workbook. It may preserve useful values or formulas but can omit presentation and workbook features. Check what matters before relying on the result.
- Restoring a cloud version without checking its date. A version from before the corruption may also be missing newer edits. Open or download it separately when possible and compare changes before restoring.
- Trusting recovery software with sensitive files. Avoid uploading payroll, customer, or financial workbooks to an unknown service. Check your organization’s security rules and use approved tools.
- Enabling macros or ignoring warnings to get past an error. A damaged file is not automatically safe. Enable macros only when you trust the workbook’s source and need its code.
Tips
- Keep at least one backup separate from the computer that holds the working workbook. For important files, use an approved cloud location or a regularly updated external backup.
- Use descriptive filenames with dates or version labels, such as Sales-2026-10-31-before-repair.xlsx, so you can tell copies apart.
- After recovery, use File > Save As to create a clean copy, close Excel, and reopen that copy. This confirms that the saved file—not just the current open session—can be read again.
- If the workbook is shared, tell collaborators not to edit or overwrite it during recovery. Their open copies or automatic syncing may create conflicting changes.
- For future work, save regularly with Ctrl+S on Windows. On Mac, use Command+S. AutoSave can help with eligible files saved to OneDrive or SharePoint, but it does not replace backups.
Troubleshooting
Open and Repair is missing or unavailable
Make sure you used File > Open > Browse in Excel for Windows, selected the file once, and clicked the arrow beside Open. The command is not part of Excel for the web, and the Mac interface can differ. If you are on a Mac, work from a duplicate and try AutoRecovery, cloud version history, or opening the duplicate in Excel for the web or Windows desktop Excel.
Excel says the file format or extension is not valid
Check that the file finished downloading and that its extension matches the format it was saved in. Ask the sender to resend it if the size is unexpectedly small. Do not use an extension change as a repair. If you know the file was renamed accidentally, restore its original extension, then try Open and Repair on a copy.
Repair opens the workbook, but sheets or data are missing
Try Extract Data on another copy, then compare its results with a cloud version, AutoRecover file, emailed attachment, or prior backup. If a sheet is visible but its contents are incomplete, avoid rebuilding over the recovered file; first save a separate version and document what is missing. Some deleted or corrupted content may not be recoverable from that file alone.
The file opens on another computer but not yours
Update Office through File > Account > Update Options > Update Now, if your organization permits updates, and retry with a copy. Safe Mode can help identify an add-in conflict. If only this workbook fails and the same file opens elsewhere, copy it to a local folder and check whether access permissions, antivirus controls, or a network issue are involved.
Nothing works and the workbook is important
Stop experimenting on the original. Preserve the file and any backups, note the exact error message, and ask your IT administrator or a reputable data-recovery specialist for guidance. If the source drive may be failing, avoid installing recovery utilities onto it or saving new files there. No recovery service can promise that every workbook element will be restored.
Frequently Asked Questions
Can I recover a corrupted Excel file without a backup?
Sometimes. Open and Repair, Extract Data, AutoRecover, or a cloud version may recover some or all of the workbook. If none exists and the file itself is badly damaged, some content may be permanently lost. Keep the original untouched while trying the available options.
Does Open and Repair work on every Excel file?
No. It can repair some workbook problems, but not every cause of corruption, and it may remove damaged elements. It is a Windows desktop Excel feature; Excel for the web does not offer the same command. Always make a copy first.
Will Extract Data keep my formulas and formatting?
It may recover values and formulas, but it is not a full workbook restoration. Formatting, charts, objects, and other features may be missing. Review the result carefully and compare important calculations with a reliable source.
Where does Excel save AutoRecover files?
Excel manages recovery copies according to its AutoRecover settings, so there is not one dependable folder for every installation. On Windows, start with File > Info > Manage Workbook > Recover Unsaved Workbooks. If no suitable copy appears, check your organization’s backup or cloud version history.
Can I recover an Excel file after I saved over it?
Possibly. Check OneDrive or SharePoint Version history, Windows File History or other approved backup systems, and any AutoRecover copy. Whether an earlier version exists depends on where the file was stored and which backup or versioning settings were enabled.
Should I use an online Excel repair website?
Be cautious. Uploading a workbook can expose sensitive or confidential data, and a repair site may not preserve all features. Use a service only if it is approved for your data and you understand its privacy and security terms; try local copies and trusted backups first.
Related
- Goal Seek in Excel: Find the Input for a Target
- Gold Data in Excel: Build a PivotTable
- Goal Seek in Excel: Definition, Steps, and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting When a Cell Is Blank in ExcelTo highlight blank cells in Excel for Microsoft 365 on Windows, select the cells, then choose Home >…
- Actual vs Forecast in Excel: Compare ResultsActual vs forecast in Excel means comparing what happened with what was expected. Put the forecast in one…
- Abby Organizes a Debt Snowball Spreadsheet?There isn’t enough context to verify whether a particular Abby organizes or publishes a debt snowball spreadsheet; a…
- How to Add Automatic Page Numbers in Microsoft WordTo add automatic page numbers in Word, open the Insert tab, choose Page Number, select where the numbers…
- How to Make Columns in Word Different Sizes EasilyTo make columns different sizes in Word, open Layout > Columns > More Columns, clear Equal column width,…
- Data Validation Excel Shortcut and How to Use ItIn Excel for Microsoft 365 on Windows, press Alt, then A, V, and V—one key at a time—to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.