How to Recover Unsaved/Deleted/Corrupted Excel File (XLS/XLSX)

Excel files often contain important data and information, which could be lost when an excel document is deleted, unsaved or corrupted. However, that should never be a tragical end. In this tutorial, you will learn how to recover excel files that were unsaved, deleted or corrupted.

Excel File (XLS/XLSX) Recovery

Part 1. How to Recover Unsaved Excel File on Windows and Mac

It is a pity to lose important works due to closing an excel document without saving. Luckily, Microsoft has implanted auto backup feature in its Office suit so that users can recover unsaved excel file easily.

1. AutoRecover

Usually, when you re-open the excel file where the unsaved part was lost, the program will alert you for available recovery options. This is how AutoRecover works. AutoRecover is enabled by default on Excel, but you can go to File > Options > Save to alter the frequency of auto backup.

2. Recover Unsaved Workbooks

In case AutoRecover does not work, then you can also try restoring unsaved excel file from auto backup manually.

3. Recover Unsaved Excel File on Mac

The AutoRecover feature of Excel file on Mac is also very easy to access.

All of the above options in this method reply on the auto backup of Excel program. If there is any valid backup existing, then it will work like a magic. Otherwise, you may still need to start the work again.

Part 2. How to Recover Deleted Excel File on Windows and Mac

Comparing with the recovery of unsaved excel, it seems more difficult to recover accidentally deleted excel files. Actually, that’s not the case. As long as you use a reliable data recovery software to scan the storage device soon enough, it is highly possible to undelete excel files on Windows and Mac computer.

iReparo for PC is such a great excel file recovery software, which can retrieve deleted xls/xlsx as well as other files from computer hard disk, memory card and USB flash stick.

Download iReparo for PC Windows Download iReparo for PC Mac

The excel file recovery software also provides a function for backing up storage device as image files. It works great for backing up SD card data.

Part 3. How to Recover Corrupted Excel File in Two Methods

Excel files can be corrupted due to an interrupted transfer or when partially overwriting happens. It is indeed hard to repair corrupted excel documents, but here are two methods that worth a try.

Method 1. Repair Corrupted Excel File Free with Microsoft In-built Feature

Though the repair function provided by Microsoft is very handy, it only works occasionally.

Method 2. Recover Corrupted Excel File with Third-Party Tool

There are a lot of tools online claiming the capability of repairing corrupted excel files, but it is not easy to choose a trusted one. You’re suggested always try before pay. Most excel repair tools should allow free preview.

Here we take Stellar Phoenix Excel Repair Tool as an example:

The above 3 parts can almost cover all the solutions for restoring excel data which is inaccessible due to various reasons. Kindly tell us if you have any questions or more interesting findings about Excel.

/ Public by Jihosoft

Follow Jihosoft