How to Recover Deleted or Lost Excel Files

Profile Jordan J. Profile Yevgeniy T.
 and 

Last update:

875

Excel is a powerful spreadsheet program that’s widely used in both professional and personal settings. If you accidentally delete your Excel file, or Excel crashes before you get a chance to save your work, you may be frozen in fear for a few moments and wonder if all that work has really gone down the drain.

Well, your Excel file may not actually be gone for good. There are a few ways you can go about getting the file back. Read on to learn how you can recover deleted Excel files.

How to Recover Deleted Excel Files Without Software

Thankfully, there are quite a few ways you can recover lost Excel files without the need for software. Of course, there are situations where software may be required, but give these methods a shot first.

Method 1: Restore Deleted Excel File from the Recycle Bin

When you delete your Excel file, it will be sent to Recycle Bin, giving you a chance to retrieve the deleted Excel file before it’s permanently deleted. Before emptying Recycle Bin to free up some space on your drive, make sure you check it first to see if the Excel file is there.

There are some cases where your Excel file will skip Recycle Bin. For instance, if the file was deleted using Shift+Delete, the file was too big, or Recycle Bin was disabled, the file would have been permanently deleted automatically and will require data recovery software.

These instructions will show you how to recover deleted files from Recycle Bin on Windows:

  1. Open Recycle Bin. Recycle Bin can be found on your Desktop.Opening Recycle Bin.
  2. Select your file(s) and click Restore the selected items. This will restore them to their original location. Alternatively, drag and drop them out of Recycle Bin to a new folder.Restoring selected items from Recycle Bin.

Method 2: Check AutoRecover Folder

Excel actually has two ways of protecting your files: AutoSave and AutoRecover. Although somewhat closely named, the two differ in functionality. Here’s a quick breakdown of what each does:

  • AutoSaveOnly available to Microsoft 365 users. Excel files that are saved to OneDrive or SharePoint are automatically saved when changes are made, eliminating the need to manually save them all the time. You’ll only find Excel AutoSave files in your OneDrive or Sharepoint.
  • AutoRecover – A light recovery option that automatically saves a copy of your work every 10 minutes (by default), giving you a chance to restore your work if Excel has crashed.

When the Keep the last AutoRecovered version if I close without saving option is enabled with AutoRecover, Excel will keep a copy of your work saved even if the application crashes. You can find this backed-up copy of your work, open it, then save it to a new location.

Here’s how you can find Excel files that were saved by AutoRecover:

  1. Open Excel.
  2. Click File.Clicking File in Excel.
  3. Click Options.Clicking Options in Excel.
  4. Click Save.Reviewing Excel's Save options.
  5. Copy the location of your AutoRecover file location.Copying the AutoRecover file location.
  6. Press Windows Key+R and paste the folder location. Press Enter.Opening the AutoRecover location with Run.
  7. Find the Excel file and open it. You can then save it as a new file.Opening the AutoRecover file.

Method 3: Recover Lost Excel Files Using File History

You can recover Excel files that have been deleted using File History. File History is the primary backup utility for Windows, allowing you to recover deleted files in Windows 10 and 11 even if they can’t be found in Recycle Bin.

File History must have been active before the Excel file was deleted, otherwise you will not be able to use this method.

A huge benefit of File History is the fact that it stores multiple versions of the same file. This allows you to restore a specific version of the file instead of the one that was most recently backed up.

There are two ways you can restore files from File History. We’ll show you how to do both.

From Global Backup

You can restore your files from the main File History interface which allows you to explore all your backed up files and folders.

  1. Open Start and search File History. Open it.Opening File History.
  2. Click Restore personal files.Choosing to restore personal files with File History.
  3. Navigate to where your Excel file was located. Use the left and right navigational arrows to go through the backup versions and find the files you want to restore.Selecting the Excel files to restore.
  4. Select your Excel file, then click the green Restore button to send it back to its original location. Alternatively, right-click the Restore button and click Restore to if you want to choose a custom destination.Choosing how to restore the Excel files.

From Specific Folder

If you know which folder contained the Excel file before it was deleted, you can simply restore that folder to a previous version instead of finding it in File History.

  1. Open File Explorer.
  2. Shift right-click the folder that contained the Excel file, then click Restore previous versions.Restoring the folder to a previous version.
  3. Select the folder version you wish to restore. Clicking Restore will restore the entire folder, overwriting any existing contents in the folder. If you want to restore it elsewhere, click the arrow instead and click Restore to.Choosing which version to restore.

Method 4: Get Back Deleted Excel File Data from Previous Versions

If you’ve made changes to your Excel file and accidentally saved it before closing it, you won’t be able to simply undo those changes using Ctrl+Z the next time you open it. But, if the Excel file was saved in OneDrive, you can restore a version of the file before the recent changes were made.

While you can do this with File History, not everyone has File History set up before their data is lost. Other cloud storage solutions, like Google Drive and Dropbox, also have a versioning feature. See the documentation for your cloud storage service for specific instructions.

Here’s how to restore an Excel file to a previous version in OneDrive:

  1. Open your OneDrive folder.Opening OneDrive.
  2. Shift right-click your Excel file and click Version history.Checking the OneDrive version history for the Excel file.
  3. Click the vertical ellipses on the version you want to restore, then click Restore or Download.Restoring a previous OneDrive version of the Excel file.

How to Recover Permanently Deleted Excel Files With a Data Recovery Tool

When your Excel file has disappeared and you’re unable to retrieve it using one of the methods we’ve listed, it’s time to turn to data recovery software. But, you should be aware that not all data recovery software is equal. There are some recovery tools out there that cannot deliver on the promises they make, leaving you frustrated and potentially further hindered than before.

sd
For this reason, Pandora Recovery seeks out the various data recovery solutions that are available online and puts them through a highly detailed and strenuous testing process. This standardized testing process allows us to objectively compare each data recovery tool we review to highlight its strengths and flaws, then pass that info on to you, our readers.

In this case, we chose a data recovery tool that was capable of the following:

  • 📁 Recovering Excel file types – Not only should the data recovery software tool be able to recover Excel files, but it must be able to recover them well. Data recovery tools that have a signature scanner that supports Excel file types (XLS and XLSX) are a huge benefit.
  • 👀 Previewing recoverable data – Being able to quickly preview your Excel file inside the software can go a long way, especially if you have hundreds of Excel files to sift through and the naming convention has broken as a result of a damaged file system.
  • 🔍 Using multiple scanning methods – There’s more than one way to scan for files. The more scanning methods a software supports, the higher your chances are of finding lost Excel files and recovering them.

In terms of what is needed to recover Excel files effectively, Disk Drill ticks all the boxes. During our tests, it was able to recover all of our XLS and XLSX Excel files. It uses a fast (but efficient) all-in-one scanner that utilizes quick, smart, and signature scanning methods to pull as much data as possible. Moreover, browsing the recovery results screen was super easy, as the built-in preview panel allowed us to quickly scan the contents of each Excel file. Overall, we were more than pleased with the results.

Gain more valuable insights about the software by delving into our detailed review of Disk Drill.

Here’s how you can recover permanently deleted Excel files using Disk Drill:

  1. Download and install Disk Drill.
  2. Select the drive that contained the Excel file and click Search for lost data.Scanning the drive for Excel files.
  3. Click Review found items. You can also click one of the colored file icons to automatically filter the results. Or, recover everything by clicking Recover all.Reviewing the found files.
  4. Select the deleted or lost Excel files you want to recover. You can use the File Type dropdown menu to select the file formats you want to recover. In this case, you can select XLSX (or XLS for older Excel files). You can also use the built-in preview function to preview your Excel (XLSX and XLS) files and ensure you’re selecting the correct ones.Filtering the Disk Drill search results by Documents.
  5. Click Recover once you have selected all the Excel files you want to recover.Recovering the Excel files with Disk Drill.
  6. Choose a safe recovery location. Avoid saving the recovered Excel files to the drive they’re being recovered from. When ready, click Next.Completing Excel recovery.

Disk Drill isn’t the only capable data recovery tool out there. If you want to explore other options, we’ve taken the time to compile a list of the best data recovery software that we’ve tested so far. Be sure to check it out.

Frequently Asked Questions

How do you recover a deleted Excel spreadsheet?

You can recover deleted Excel spreadsheets using data recovery software. We recommend using Disk Drill. Here’s how:

  1. Download and install Disk Drill.
  2. Select and scan the drive that contains the deleted Excel files.
  3. Browse the scan results for your lost Excel data.
  4. Select the Excel files you wish to recover.
  5. Choose an appropriate recovery location to restore the Excel files.

Start by checking any backups you have for the lost Excel file. If File History was enabled before the file was deleted, you may be able to restore it from the File History backup. If it wasn’t, you can use data recovery software, like Disk Drill, to scan the drive for the Excel file and restore it to a safe location.

Excel files that you closed without saving may be recovered using AutoRecover if you didn’t have AutoSave turned on.

  1. Open Excel.
  2. Click File.
  3. Click Options.
  4. Click Save.
  5. Copy the location of your AutoRecover file location.
  6. Press Windows Key+R and paste the directory location. Press Enter.
  7. Find the Excel file, open it, then save it as a new file.

The frustrating thing about Excel sheet tabs is that they cannot be easily restored using Ctrl+Z. Instead, you must restore a previous version of the Excel file, either from File History or using the versioning function of the cloud storage solution which you use to store the Excel file.

This is how you restore a previous version of the Excel file using File History:

  1. Open Start and search File History. Open it.
  2. Click Restore personal files.
  3. Navigate to where your Excel file was located.
  4. Select your Excel file, then click the green Restore button to restore it to its original location.

You can restore accidentally deleted Excel data after the file has been saved by restoring the file to a previous version. Bear in mind that this is only possible if the Excel sheet was stored in OneDrive (or another cloud-based storage solution that supports versioning).

  1. Open your OneDrive folder.
  2. Shift right-click your Excel file and click Version history.
  3. Click the vertical ellipses on the version you want to restore, then click Restore.

Conclusion

The accidental deletion of an important Excel file is enough to invoke cold sweats after you realize the mistake you’ve made. Luckily, the position you’re in may not be as bad as it seems, as there are a few ways you can recover a deleted or lost Excel file.

The first thing you should do is check Recycle Bin to see if you can easily restore the file. If that doesn’t work, check out your AutoRecover folder to see if a copy of the file is stored there. Failing that, you can check your File History backup if it was enabled at the time. Otherwise, your last resort is data recovery software, like Disk Drill, which you can use to scan the drive for the Excel file and recover it to a safe location.

Help Us Improve This Article
Was the provided information useful? Your vote is important to use!
25385
Jordan Jamieson-Mane
Author
  • 46 publishings
  • Auckland, New Zealand
  • LinkedIn

Jordan Jamieson-Mane is a content writer with a focus on technology-related content. He has spent much of his life studying and working with all types of technology. During his time as a writer, he has written countless articles in the field of data recovery, breaking down complex topics into articles that are easy to understand.

When he's not writing articles on data recovery, Jordan enjoys traveling the world, reading books, and building websites.

Jordan’s recent reviews
Jordan’s recent publishings
Yevgeniy Tolkunov
Yevgeniy Tolkunov
Approver

Yevgeniy Tolkunov is Hardware Engineer at ACE Data Recovery. Yevgeniy has a Master's Degree in Physics, Information Technology; 15+ years of experience.