Recover Deleted Excel Files: Full Guide

Yes, deleted Excel files can often be recovered using built-in Excel features, Windows tools, or third-party recovery software. The best method depends on how the file was lost—whether it was deleted from your hard drive, lost after an unsaved shutdown, or overwritten by a newer version.

How Excel File Deletion Happens

Excel files disappear in a few common ways, and each scenario has a different recovery path:

• Accidental deletion: You press Delete or Shift+Delete, and the file moves to the Recycle Bin or is permanently removed.
• Unsaved workbook: You close Excel without saving, or the program crashes before you hit Save.
• Overwritten file: You save a new version over the old one, losing the previous data.
• Corrupted file: The file becomes unreadable due to a crash or disk error.
• Drive formatting or system restore: The entire storage device is wiped or restored to an earlier state.

Understanding the cause narrows down which recovery method will work. For example, a file in the Recycle Bin is trivial to restore, while a file lost after a full disk format requires more advanced software.

Built-In Recovery Options in Excel

Excel itself has several features that can bring back lost data without any third-party tools.

1. Recover Unsaved Workbooks

If Excel crashed or you closed without saving, open Excel and go to File > Open > Recent. At the bottom, click Recover Unsaved Workbooks. Excel stores temporary copies of unsaved files in a specific folder, and this option opens that folder. Look for a file with your workbook name and an .xlsb or .xlsx extension, then open and save it.

2. Version History (OneDrive/SharePoint)

If your workbook is saved to OneDrive, SharePoint, or Microsoft 365, Excel automatically keeps a version history. Go to File > Info > Version History and browse through the list. You can preview an older version and restore it, which is perfect for overwritten files.

3. AutoRecover File Location

Excel’s AutoRecover feature saves temporary copies every few minutes. To find them, go to File > Options > Save and note the path under AutoRecover file location. Navigate to that folder in File Explorer and look for files with .xlsx, .xlsb, or .tmp extensions. Copy the file to a safe location and open it in Excel.

Using Windows Built-In Tools

If the file is not in Excel’s recovery folders, Windows itself offers a few options.

• Recycle Bin: Double-click the Recycle Bin on your desktop, find the file, right-click it, and choose Restore. This works for files deleted with the Delete key, but not for Shift+Delete or files deleted from a command prompt.
• File History: If you had File History enabled, go to the folder where the file used to be, right-click, and select Restore previous versions. Windows will show a list of available backups.
• Previous Versions: This is similar to File History but also uses System Restore points. Right-click the folder, choose Restore previous versions, and pick a version from the list.

These tools require that you had previously set up backup features. If you never enabled File History, you may only see versions from System Restore points, which are not always available.

Third-Party Recovery Software

When built-in options fail, dedicated file recovery software can scan the hard drive for remnants of deleted files. These programs work by reading raw disk sectors and looking for patterns that match Excel file signatures.

Popular categories include:

• Free tools: Recuva, PhotoRec, and Glary Undelete offer basic recovery for recently deleted files.
• Commercial tools: EaseUS Data Recovery Wizard, Stellar Data Recovery, and Disk Drill provide deeper scans and more features.

How to use them generally:

1. Install the software on a different drive than the one where the file was lost (to avoid overwriting).
2. Run a deep scan on the drive.
3. Filter results by file type (.xlsx, .xls, .csv).
4. Preview the file if possible, then recover it to a different drive.

Success rates drop dramatically if you continue using the drive after deletion, because new data can overwrite the old file’s clusters.

How to Choose the Right Tool

Not all recovery software is equal, and the right choice depends on your situation.

• Time since deletion: For files deleted minutes ago, a quick scan with a free tool usually works. For files deleted weeks ago, you need a deep scan from a commercial product.
• File system: NTFS drives (common on Windows) are more complex than FAT32. Some tools handle NTFS better than others.
• Budget: Free tools often have file size limits or lack advanced features like disk imaging. Commercial tools cost money but offer better support and higher success rates.
• Ease of use: If you are not tech-savvy, choose a tool with a wizard interface that guides you step by step.

Read reviews from independent sources before purchasing. Avoid tools that promise impossible results—no software can recover data that has been overwritten multiple times.

Common Mistakes That Ruin Recovery

Many people accidentally destroy their chances of recovery by doing the wrong thing right after deletion.

• Continuing to use the computer: Every file you create, download, or install writes new data to the disk, potentially overwriting the deleted file. Stop using the computer immediately.
• Installing recovery software on the same drive: The installation itself can overwrite the file you want to recover. Install on a different drive or use a portable version.
• Saving recovered files to the same drive: Always save recovered files to a different drive, such as a USB stick or external hard drive.
• Ignoring the Recycle Bin: Some users don’t check the Recycle Bin because they think the file is too old. It’s always worth a quick look.
• Defragmenting the drive: Disk defragmentation rearranges data and can permanently erase deleted file remnants. Never defragment after data loss.

Prevention: Better Than Recovery

Recovery is never 100% guaranteed, so the best strategy is to prevent data loss in the first place.

• Enable AutoSave: In Excel, turn on AutoSave for OneDrive/SharePoint files. It saves every few seconds.
• Set AutoRecover interval: Go to File > Options > Save and set the AutoRecover time to 1 minute.
• Use File History: Turn on Windows File History and point it to an external drive.
• Back up regularly: Use cloud storage like OneDrive, Google Drive, or Dropbox. Or copy important files to an external drive weekly.
• Use version control: Save major versions with different names (e.g., Budget_v1.xlsx, Budget_v2.xlsx).

A small investment in backup habits saves hours of recovery attempts and potential data loss.

Frequently Asked Questions

Can I recover an Excel file that was overwritten?

Yes, if you have Version History enabled (for OneDrive/SharePoint) or if you have a previous version from File History or System Restore. In Excel, go to File > Info > Version History and select an older version. If you don’t have any of those, third-party software might recover the old file from disk clusters, but success is not guaranteed.

Where does Excel store unsaved files?

Excel stores unsaved files in a temporary folder. To find it, go to File > Options > Save and look at the “AutoRecover file location” path. Typically it’s something like C:\Users\[YourName]\AppData\Roaming\Microsoft\Excel\. You can also access it via File > Open > Recent > Recover Unsaved Workbooks.

Is it possible to recover a permanently deleted Excel file?

Yes, but only if the file’s data has not been overwritten. When you delete a file, the space is marked as free but the data remains until new data is written. Third-party recovery software can scan for these remnants. The sooner you stop using the drive, the better your chances.

What is the best free Excel file recovery software?

Recuva is a popular free option that supports Excel files. It offers both quick and deep scans and is easy to use. PhotoRec is another free tool that works from the command line and is very effective, though less user-friendly. For a simple GUI, Recuva is a solid choice.

Does Excel have a built-in recovery feature?

Yes, Excel has several: AutoRecover (temporary copies), Recover Unsaved Workbooks, and Version History for cloud files. These can recover files lost due to crashes or accidental closes, but they do not help if the file was deleted from disk and never saved.

How long does recovery take?

It depends on the method. Recycle Bin restoration takes seconds. Excel’s unsaved recovery takes a few minutes. Deep scans with third-party software can take hours, especially on large drives. The scan time is proportional to the drive size and the amount of data.

Related

• Recover Files or Windows from a Macrium Reflect 8 Image
• Outlook Show Two Time Zones: How to Set It Up
• Decentralized: What It Really Means