How to Find Backup Files in Excel (5 Easy Methods)

While working with Microsoft Excel, there are a variety of unanticipated events that might result in our data being completely lost, such as a system crash, a computer being stolen, a hard drive failing, or even a natural disaster. Backing up files and folders is the greatest approach to keeping data secure. Whenever we make a file backup, you’re storing duplicates of an essential system. In this article, we will demonstrate different effective methods to find Excel backup files.

How to Find Backup Files in Excel: 5 Easy Methods

The primary goal of data backup is to protect essential information in the case of a system crash or hard disk malfunction. If the initial backups result in data damage or hard disk failure, further data backups should be made.

Let’s pretend I have created a fresh Excel worksheet (Book1). In Sheet1 of the spreadsheet, we stored some information about data of some students’ marks. Now, assume that our computer is turned off for some reason or we shut down the computer without saving the Excel file. But we need that mark record. So, we need to find the Excel backup Files. Let’s see the approach to do this.

5 Easy Methods to Find Backup Files in Excel 

1. Get Excel Backup Files from ‘Recover Unsaved Workbook’ Feature

To find the Excel backup files to recover an unsaved Excel file, we need to follow some procedures. Let’s look at the procedures.


  • First, make a new workbook in Excel.
  • Secondly, navigate to the File tab.
  • Thirdly, select Open from the drop-down menu.
  • Then, click on the Recent Workbook option at the top left.
  • Scroll to the bottom of the page, and click the Recover Unsaved Workbook button.

5 Easy Methods to Find Backup Files in Excel 

  • This will appear in a Document Recovery window.
  • As a result, Excel will display the files that have not been saved.

5 Easy Methods to Find Backup Files in Excel 

  • And, that’s it! By just following the above steps, we will be able to find the backup files in Excel.

2. Use ‘Manage Workbook’ Option to Find Excel Backup Files

Workbook Manager creates a database of all open Excel documents so we may simply browse through them. We can find Excel backup files from the Manage Workbook option in Excel. For this let’s see the steps down.


  • Similar to before, first, open Excel.
  • Then, go to the File tab from the ribbon.

5 Easy Methods to Find Backup Files in Excel 

  • Next, click on the Info option.
  • Then, click OK on the Manage Workbook drop-down menu bar.
  • And, select Recover Unsaved Workbooks.

5 Easy Methods to Find Backup Files in Excel 

  • Likewise the previous method in the Document Recovery window, the file will appear.

5 Easy Methods to Find Backup Files in Excel 

  • That’s all! You will be able to find the backup Excel files by following the steps.

3. Excel ‘Version History’ Feature to Find Backup Files

Excel Version History keeps track of the modifications made to our documents over the course of their existence. Version History, in particular, allows us to access older copies of our files and displays the amount of each edition, the volume of each version, and also who and when each edition was made. We can maintain track of all the many versions of workbooks you’ve stored over time with Excel Version History. Let’s see how we can find Excel backup files with this.


  • In the first place, as similar as before, open the Excel document.
  • Next, go to the File tab.

5 Easy Methods to Find Backup Files in Excel 

  • Then, go to the Info option.
  • Scroll down a bit, you will see Version History.
  • Now, click on that Version History.

  • This will navigate the Version History window.

  • And, finally, by just following the above steps, you will detect your backup files in Excel from Version History.

Read more: How to Recover Previous Version of Excel File

4. Search for Backup Files in Excel File History

We can also obtain the Excel backup files from our File History. Let’s see how we can use our File History to obtain Excel backup files.


  • To begin with, go to your window search bar.
  • Then, type restore file.
  • Press Enter to proceed.
  • After that, you will see Restore your files with the File History option.
  • Click on that and you will be able to perceive the backup Excel files.

  • In the end, we can discover the backup files in Excel by simply following the procedures above.

5. Find Excel Backup Files on OneDrive

If you have your personal OneDrive logged in on your Excel file. You will be able to discover the Excel backup files from there. Let’s see where we can locate the backup files on OneDrive.


  • To begin, open Excel and create a new worksheet.
  • The second step is to go to the File tab.
  • After that, from the drop-down option, choose Open.
  • Now, from the Shared with Me option, you will see OneDriveB Personal.
  • Click on OneDrive.

  • This will take you to the file location where your backup file is located.

  • Finally, we can discover the backup files in Excel by simply following the procedures above.

Download Practice Workbook

You can download the workbook and practice with them.


The above steps will assist you in finding Excel Backup files. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section.

Related Articles

<< Go Back to Recover Excel File | Excel Files | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sabrina Ayon
Sabrina Ayon

Sabrina Ayon, a Computer Science and Engineering graduate from United International University, has been an integral part of the ExcelDemy project for two years. She authored 150+ articles, excelling in instructing through visually engaging Excel tutorials. With a passion for teaching, Sabrina conducted sessions on Excel VBA, sharing her knowledge and insights with others. Currently holding the position of Project Manager for the ExcelDemy Visual Development Project, she oversees various aspects of the project, ensuring its smooth operation... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF