Recover a Corrupted Excel File From Your PC

How-to basics · Updated November 21, 2026

To collect and recover a corrupted Excel file from your PC, find the workbook in File Explorer, make a separate copy, then try Excel’s Open and Repair option on the copy. If the file is missing or will not open, check Excel’s recovery list, OneDrive version history, or Windows’ available file backups. Preserve the original throughout so a repair attempt cannot make the only copy worse.

What You’ll Need

  • A Windows PC with Microsoft Excel for Microsoft 365 installed. Excel for the web does not offer the same Open and Repair command.
  • The name of the workbook, or a likely folder where it was saved. If you do not know the name, you can search for Excel workbook extensions.
  • Enough free space to make a second copy of the file, preferably on a different drive or trusted storage location.
  • Access to the folder or storage account containing the workbook. If it is on a work computer, network drive, or managed OneDrive account, you may need help from your administrator.

Step-by-Step

  1. Stop editing and check whether Excel is still open. If the workbook is open, do not keep trying to save it over the damaged file. If Excel responds, use File > Save As and save a copy under a new name in a different folder. If Excel has frozen, wait briefly in case it is processing a large workbook. If it remains unresponsive, close it from Task Manager only as a last resort; unsaved changes may be lost. Do not repeatedly force-close Excel and reopen the original.
  2. Search your PC for the workbook. Open File Explorer with Windows key + E. Select This PC and use the search box to look for the workbook’s name. If you cannot remember it, search for *.xlsx; also try *.xls for older Excel files and *.xlsm for macro-enabled workbooks. Search can take a while across the whole PC. Check likely locations such as Documents, Desktop, Downloads, and folders used for work or school. Sort results by Date modified to help identify the right copy.
  3. Confirm that you have the right file. In File Explorer, turn on View > Show > File name extensions so the extension is visible. Check the folder, filename, modified date, and file size. A workbook with a size of zero bytes may be empty or incompletely saved, while a very small file may be a temporary or shortcut file rather than the workbook you need. Do not rename a file’s extension to try to make it open; changing .xlsx to .xls, for example, does not repair its contents.
  4. Make a protected working copy. Close Excel if it has the workbook open. Right-click the file and select Copy, then paste it into a new folder or another drive. Give the duplicate a clear name such as Budget-repair-copy.xlsx. Keep the original unchanged and note where it is. If the file is on a USB drive or network location, copy it to the PC before repairing it; a weak connection or failing storage device can interrupt a repair. If you suspect the drive itself is failing, minimize further use and copy important files to healthy storage first.
  5. Try Open and Repair on the duplicate. Start Excel, then select File > Open > Browse. In the Open dialog, select the copied workbook once. Select the arrow beside the Open button and choose Open and Repair. In the prompt, choose Repair first. Excel may take time to inspect the workbook, particularly if it contains many sheets, formulas, charts, or external links. If Excel opens the repaired file, immediately use File > Save As to save it with a new name. Do not save over the original.
  6. Try extracting data if repair fails. If Open and Repair cannot restore the workbook, repeat the same steps on the protected copy and select Extract Data when Excel offers that option. Excel may be able to recover cell values and formulas even when it cannot restore the full workbook. Review the result carefully: formatting, charts, objects, links, or some formulas may be missing. Save the extracted result as a new workbook and compare key sheets and totals with another source if one exists.
  7. Check Excel’s recovery options if the file is missing or unsaved. Open Excel and look for recovered files in the Document Recovery pane, if it appears. You can also select File > Info > Manage Workbook > Recover Unsaved Workbooks. Open a promising entry and use Save As to create a normal workbook in a safe folder. This is most useful after Excel closed unexpectedly or a new workbook was never saved. Recovery availability depends on whether Excel had time to create recovery data and on its AutoRecover settings.
  8. Check cloud and Windows backups. If the workbook was in OneDrive or SharePoint, open the same location in File Explorer or the web service and look for Version history. Open or restore a version from before the problem; if possible, download or copy it under a new name rather than replacing the current file. For a local file, right-click the file or its containing folder, select Properties, then Previous Versions. This tab only helps when a suitable Windows backup or restore feature was already configured. Review the date and location before restoring, because restoring may replace the current version.
  9. Validate and store the recovered workbook. Open the newly repaired or recovered file and check every important sheet, especially the first and last rows, formulas, dates, totals, charts, and named ranges. Look for warning banners about links or macros. Save a verified copy in a separate folder and make another backup before continuing to edit it. If the workbook contains sensitive information, use approved company storage rather than an unknown online repair website.

Common Mistakes

The most damaging mistake is repeatedly opening, editing, and saving the only copy. Repair can remove damaged elements, and saving over the source makes it harder to compare results or try another recovery route. Always work on a duplicate and give each recovered version a distinct filename.

Do not assume a file is corrupted just because Excel cannot find it in the folder you expected. It may have been saved to a different account, a synced folder, or a location selected in the Save As dialog. Search by extension and modified date before concluding that it is gone. Also avoid changing the extension, deleting files because their names begin with a tilde, or moving unfamiliar temporary files before checking whether Excel is still using them.

Another common error is treating Extract Data as a complete repair. It can return useful content, but it may not preserve the workbook’s layout or features. Check formulas and results rather than assuming everything was recovered. Finally, do not upload confidential payroll, customer, health, or business data to a public repair service without authorization; the service may receive the entire workbook.

Tips

Use a simple recovery naming system, such as Sales-original.xlsx, Sales-repair-attempt-1.xlsx, and Sales-recovered.xlsx. Keep the original read-only in practice: do not edit or overwrite it, even if Excel appears to open it after a later attempt. This makes it easier to identify which copy contains the best result.

If the file is on a removable drive, copy it to a reliable local disk before repair and do not unplug the drive during copying. If it is stored in OneDrive or SharePoint, check that syncing has finished and compare file versions before opening. A synchronization conflict can produce more than one file with a similar name, so inspect the dates and locations rather than choosing the first search result.

For future protection, save important workbooks to a backed-up location and keep version history or an independent backup. In Excel for Microsoft 365 on Windows, you can check AutoRecover settings through File > Options > Save. AutoRecover can help after an unexpected shutdown, but it is not a substitute for saving the workbook and maintaining backups. Excel for Mac has different settings and menu layouts; Excel for the web also relies on the file’s cloud storage and version history rather than the Windows Open and Repair dialog.

Troubleshooting

Open and Repair is missing. Confirm that you are using the desktop Excel application on Windows, then use File > Open > Browse and select a file before opening the arrow beside Open. The web version does not provide this Windows repair command. On a Mac, try opening a duplicate from Excel’s File > Open menu and check the recovery options available in that edition; the Windows Open and Repair steps may not appear. If possible, use a Windows desktop copy of Excel for the repair attempt.

Excel reports that the file format or extension is not valid. Check that the filename has the correct extension and that the file is a workbook rather than a web page, shortcut, or temporary download. Do not change the extension to bypass the message. If the file came from email or a browser download, save it again from the original source if available. Then test Open and Repair on a copy. A partial download or zero-byte file may not contain enough data to repair.

The recovered file opens but sheets or content are missing. Save it under a new name, inspect all tabs, and try Extract Data on another copy if you have not already done so. Compare the results with a cloud version, backup, printed report, or copy from a collaborator. Some damaged workbook features cannot be reconstructed from the remaining file alone.

You cannot locate the workbook or access its folder. Search This PC by extension, check the Recycle Bin, and look in the OneDrive or SharePoint account where the file may have been saved. If Windows says access is denied, sign in with the correct account or ask the folder owner or IT administrator for access. Avoid changing permissions on a work device unless you are authorized to do so.

The PC or drive shows signs of failure. Clicking noises, repeated disconnects, read errors, or very slow copying can indicate a storage problem. Do not run repeated repair attempts from the failing drive. If the workbook is important, stop using that drive and contact IT or a reputable data-recovery professional. A repair operation cannot recover data that the storage device can no longer read.

Frequently Asked Questions

Can I recover a corrupted Excel file without opening it?
Yes. First copy it using File Explorer. Then use Excel’s Open and Repair command on the copy. If it still will not open, check unsaved-workbook recovery, cloud version history, and any available backups.

Where does Excel keep recovered unsaved workbooks?
Start with File > Info > Manage Workbook > Recover Unsaved Workbooks in Excel for Microsoft 365 on Windows. The list depends on AutoRecover settings and whether recovery data was created, so it may not contain the file.

Does Open and Repair always restore everything?
No. It may restore the workbook, or Excel may only be able to extract some data. Formulas, formatting, charts, macros, and external links should be checked after recovery because damaged elements may be lost.

Can I use Excel for the web to repair a damaged workbook?
Excel for the web does not provide the Windows Open and Repair option. You can use it to check a OneDrive or SharePoint workbook’s version history, then download or open an earlier copy in desktop Excel for recovery attempts.

Is it safe to use an online Excel repair site?
It may expose the contents of the workbook to that service. Do not upload confidential or regulated information unless your organization approves the service and its data handling. Prefer Excel’s built-in recovery tools and trusted backups.

What if the recovered workbook is still incomplete?
Keep the recovered version and compare it with earlier cloud versions, backups, or copies held by colleagues. If the only copy is damaged and the missing information is essential, stop making changes to the source and seek qualified IT or data-recovery help.

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.