How to Recover Excel XLSX/XLS Files

Roxanne updated on Jan 07, 2021 to Data Recovery | How-to Articles

This page gives a comprehensive solution to help you recover deleted, lost or formatted excel worksheet - .xlsx or .xls files from recycle bin, temp file and apply EaseUS free XLSX recovery software for help. Follow to see how easy it could be to recover your lost Excel - .xlsx or .xls file on your own.

Restore deleted/lost Excel from recycle bin
Recover lost .xlsx/.xls file from .tmp
Download and apply free xlsx recovery tool for help

How to recover lost Excel .xls/.xlsx files

Did you ever think that one day you will need to recover lost .xlsx/.xls files? This is important for users that keep their work in the Microsoft Excel workbook and have not make a backup.

There are a variety of problems that can lead to excel file data loss. This can happen due to power failure or file system corruption, it means, that all of your documents, including Microsoft Excel files, may not be accessed.

If your .xlsx or .xls files are lost due to any one of the above reasons, now you should find an excel data recovery solution to recover your lost files.

Note: If you lost an unsaved Excel file, please refer to How to recover unsaved excel for a guide.
If both Method 1 and Method 2 fail you or you'd like to choose a straightforward tool, free xlsx recovery tool provided by EaseUS software in Method 3 will fulfill your task.

Method 1. Restore deleted/lost Excel from recycle bin

If you accidentally deleted your excel file - .xlsx or .xls file into Recycle Bin, you can directly undelete them from the recycle bin on your own:

Step 1. Open Recycle Bin and find deleted .xlsx or .xls files inside it.

Open Recycle Bin and find lost Excel file.

Step 2. Right-click on lost XLSX/XLS files and select Restore.

Restore deleted Excel file.

Then the deleted .xlsx or .xls file will be restored to the original location on your PC.

Method 2. Recover lost .xlsx/.xls from .tmp folder

Since due to Microsoft Office data security protection policy, Microsoft Office, Word, PowerPoint, etc. are all added with an AutoRecovery feature. Once it's turned on, Microsoft Office will create a TEMP folder to save temporary excel or word files saved or unsaved.

So the .tmp folder is your second chance if you find nothing in the Recycle Bin. Here are the steps for you to follow and recover lost .xlsx or .xls files:

Step 1. Find the Excel temp files with .TMP extension of your lost files.

For Windows 10/8/8.1 users: C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles

For Windows 7/XP users: C:\Users\name\AppData\Roaming\Microsoft\Excel\ 

Step 2. Find the temporary excel files which begin with "$" or "~" and end with ".TMP" extension.

Step 3. Copy these files and save to another secure location, changing the extension from ".TMP" to ".XLS" or ".XLSX".

Method 3. Download and apply free xls/xlsx file recovery tool for help

EaseUS Data Recovery Wizard Free is one of the best free office recovery tools for recovering excel file regardless of it was lost. It also supports word document recovery as well as powerpoint file recovery. 

Apart from recovering lost .xls or .xlsx files, EaseUS Data Recovery Wizard also supports recovering variety of multimedia files like video and audio files.

You can download this free tool here and follow the detailed instructions to do excel file recovery.

If your lost excel files and data are more than 2GB, please activate this free tool to a pro version - EaseUS Data Recovery Wizard Pro to gain unlimited data recovery capacity with the activate button here:

Step 1. Specify a location.

Run EaseUS Data Recovery Software. Choose the drive X: or a specific folder on Desktop or somewhere else where you lost the excel files, and then click "Scan".

select a location and click scan

Step 2. Scan for data.

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. Wait for the scanning process finishes. To quickly find the Excel files from the scan results, click on the "Filter" on the top area and choose "Excel". Or, search .xls or .xlsx in the Search box. 

scan excel files

Step 3. Preview and recover.

You can double click on the Excel file to preview its integrity. Finally, select the desired Excel files and click "Recover".

preview and recover excel files

For Your Information

To prevent excel file loss issue from happening again, here are some recommended tips that may be helpful:

1. Turn on the AutoRecover feature to automatically save Excel: 

  • Open an Excel file, click File at the left top corner > Options.
  • In the Save category, check Save AutoRecover information every box under Save workbooks, and enter a number of minutes of how frequent you wan to save Excel automatically.
  • In the AutoRecover file location box, enter the location where you want to save the recovery file.
  • Uncheck Disable AutoRecover for this workbook only box.

2. Backup Excel regularly

It also matters a lot if you have created an excel file backup when an accident or error occurs.

3. Turn to the right solution to different excel loss issue.

If you are facing such a problem, relax. Scroll up and those provided methods on this page can resolve most excel .xlsx or .xls file recovery tasks for you.

Was This Page Helpful?


Frequently Asked Questions

1. Why choose EaseUS Data Recovery Wizard?

"EaseUS Data Recovery Wizard is the best we've seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past, but it's fast and efficient..."PCMag

"The first thing you'll notice about EaseUS Data Recovery Wizard Pro is that its interface is very clear and uncluttered, with only a small collection of self-explanatory controls. You won't find lots of extra options hidden in a system of hidden menus, either; what you see really is what you get."techradar

"Recover lost files, even after deleting a partition or formatting your drive."Macworld

2. Why cannot I recover 2GB data for free?

It is recommended to check the version installed is Free or Trial because they are different versions.

Trial has data preview function but cannot save any files, while the Free version enables to recover 2 GB files. The default free space is 500 MB and you may share the product on social media to get another 1.5 GB.

3. Why cannot the recovered files be opened?

A file is saved as 2 parts on the storage device: directory info (which is comprised by file name, time stamp and size info, etc.) and data content.

If the files with original file names and folder structures cannot be opened, one possible reason is the corrupted directory info. There is still a chance to recover the data content with the RAW Recovery method in our software.

4. Why isn't it suggested to recover the files back to the original drive?

The storage structure of the lost files would be altered or damaged by any changes on the drive. If you save the recovered files back to the same drive, the original data structures and data content would be corrupted or overwritten, which causes permanent data loss. So you should prepare another disk to save the files.

5. How can I check whether my data is recoverable or not before purchase?

The Free version helps you save 2GB files, so verify the recovery quality of our product before purchase.

6. How long does it take to scan the drive?

It strongly depends on the capacity of your hard drive and the performance of your computer. As reference,most drive recoveries can be completed in around 10 to 12 hours for a 1-TB healthy hard drive in general conditions.

About Data Recovery Wizard

It's super easy to recover 250+ types of files after deletion, disk formatting and virus infection. Click the links and compare the difference of each version.