Restore Overwritten/Replaced/Saved-over XLS/CSV Files

Tracy King updated on Sep 18, 2019 to File Recovery | How-to Articles

Summary

Relax if your Excel file XLS or CSV got overwritten, replaced or saved-over by a new version of Excel. Apply the two effective ways to restore overwritten, replaced, or saved-over XLS/CSV file without losing any data. Besides, an excel file recovery tool is provided to help you recover deleted, lost, or formatted XLS/CSV in Windows 10/8/7 with ease.

PAGE CONTENT:
Method 1. Restore overwritten XLS/CSV from TMP file
Method 2. Recover replaced/saved over XLS/CSV file from the previous version
Bonus Tip. Recover lost/lost XLS/CSV with file recovery software

Have you ever got Excel files such as important XLS or CSV file saved-over, replaced, or overwritten by new file with the same file name? If so, what will you do if such a problem happens to you?

Usually, when an Excel file got overwritten or replaced in Windows PC, ordinary users would think that it's impossible to get their files restored. If you are having the same problem and finding no way to restore them, don't give up. Here, this article will provide you with two reliable methods to help you restore saved over, overwritten or even replaced XLS/CSV files. Besides, data recovery software - EaseUS Data Recovery Wizard can help you to recover deleted, lost, or formatted XLS/CSV effortlessly. 

Tip
If you've just saved Excel file without closing the app, you can directly press Control + Z to cancel the operation and revert your XLS/CSV files to the previous editing state.

Method 1. Restore Overwritten XLS/CSV from TMP File

As we all know that Microsoft Office has AutoRecover feature which will save all Excel files under editing as a temp file and save them to a specific location in Windows C drive. The particular location may be Unsaved Files or Temp folder of your Windows depending on the OS version you use. So if your Excel file got lost, replaced or even overwritten, you might directly restore it from TMP files with below tips. 

1. Follow the temp file folder location on your PC and find the Excel temp files.

  • For Windows 7 users: 

C:\Users\username\AppData\Roaming\Microsoft\Excel\ 

  • For Windows 8/10 users: 

C:\Users\username\AppData\Local\Microsoft\Office\UnsavedFiles\

2. Locate and select the right Excel temp file by date, then copy and save to another safe spot by changing the extension.

recover overwritten excel file

After this, do remember to save the restored XLS/CSV files into a safe location in case of an unexpected problem happening again.

Method 2. Restore Replaced/Saved-Over XLS/CSV File from the Previous Version

If your Excel file XLS or CSV files got replaced or saved over, relax. You may follow guidelines and get your saved-over XLS/CSV files back now.

1. Try to create a new Excel file with the same name as the overwritten file or find the overwritten saved file. Right-click on the Excel XLS/CSV file and select "Properties";
2. Go to Previous Versions, find and select the latest version or the last version before Excel replaced or saved, click "Restore". Then you can get your Excel file XLS or CSV restored without losing any saved data. 

If you are a Mac user and lost Excel files without saving, you can read how to recover unsaved excel file on Mac.

Bonus Tip. Recover Lost/Deleted/Formatted XLS/CSV with File Recovery Software

If you got your XLS/CSV removed from your PC by deletion, formatting, virus attack, or emptying recycle bin, don't worry, EaseUS data recovery software will help you out. This versatile data recovery program supports deleted files recovery, formatted recovery, recycle bin emptied data recovery, lost partition recovery, OS crash recovery, RAW partition recovery, etc. 

Now, download and use this Excel file recovery software to recover deleted or lost XLS/CSV file from HDD, SSD, USB flash drive, Pen drive, external hard drive, and so on. 

Simple steps for Excel file recovery are as follows:

Step 1. Specify a location

Run EaseUS Data Recovery Software, firstly, you're asked to choose a location to start. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else, and then click "Scan".

select the excel file location

Step 2. Scan data

During the scan, you'll see more and more data showing up very quickly in the "Deleted files" result. That's part of what the software has found and displayed.

scan excel files

Step 3. Preview and recover

To quickly find the Excel files in the massive data in the scan results, click on the "Filter" on the top area and choose "Documents". Or, search .xls or .xlsx in the Search box. Select the desired files and click "Recover".

select excel files and recover
 
 

100% of people found this article 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 to better 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.