How to Recover a Deleted Excel File: Methods, Variables, and What Actually Works
Deleting an Excel file — or losing one to a crash — feels catastrophic in the moment. The good news is that Excel files are recoverable more often than most people expect. The bad news is that success depends heavily on how the file was lost, when you noticed, and what tools or services you had running at the time.
Here's what you need to understand before you start clicking through recovery options.
Why Deleted Files Are Often Still Recoverable
When you delete a file, your operating system doesn't immediately erase the data. It marks that storage space as available for reuse. Until new data overwrites that space, the original file typically remains intact on the drive — just hidden from the file system. This is why recovery is often possible, but time is a factor: the longer you wait and continue using the device, the higher the chance that space gets overwritten.
For Excel files specifically, there are also application-level recovery features built into Microsoft Excel itself, which operate independently of your operating system's file system.
Method 1: Check the Recycle Bin (Windows) or Trash (Mac)
This sounds obvious, but it's worth stating clearly: files deleted with the Delete key or right-click delete go to the Recycle Bin or Trash before they're gone for good. Open it, search for your .xlsx or .xls file, right-click, and choose Restore.
If the Recycle Bin has been emptied, move on to the methods below.
Method 2: Use Excel's Built-In AutoRecover Feature
Microsoft Excel includes AutoRecover, a feature that periodically saves temporary versions of open files. If Excel crashed or you closed without saving, this is your first stop.
To access AutoRecover files:
- Open Excel and go to File → Info → Manage Workbook → Recover Unsaved Workbooks
- Alternatively, navigate manually to the AutoRecover folder (typically found at
C:Users[Username]AppDataRoamingMicrosoftExcel)
AutoRecover files are saved as .xlsb or .xlsx temp files and are usually retained for a short window — the default is 10 minutes between saves, and files are typically kept for 4 days after a session ends.
Important variable: If AutoRecover was turned off in Excel's settings, these files won't exist. Check under File → Options → Save to see if it was enabled.
Method 3: Restore a Previous Version (Windows)
If you're on Windows and had File History or System Restore enabled, you may be able to roll back to an earlier version of the file.
Right-click the folder where the Excel file was stored and select Restore previous versions. Windows will display available snapshots if backups were running.
This only works if:
- File History was actively enabled before the deletion
- The file had been saved at least once
- The snapshot predates the deletion
🗂️ If you're using OneDrive, this becomes significantly easier — OneDrive maintains a version history for files, accessible through the OneDrive web interface under Version History. Files deleted from OneDrive also go into the OneDrive Recycle Bin, which retains them for up to 93 days.
Method 4: Check Cloud Storage and Sync Services
If your Excel files were stored in or synced with a cloud service, you may have version history available:
| Service | Recycle Bin Retention | Version History |
|---|---|---|
| OneDrive (personal) | 30 days | Yes (limited by plan) |
| OneDrive (Microsoft 365) | 93 days | Yes |
| Google Drive | 30 days | Yes (30 days) |
| Dropbox (free) | 30 days | Yes (30 days) |
| Dropbox (paid plans) | Up to 180 days | Extended |
If your file was synced to any of these services, log in through a browser and check the Trash or Deleted Files section before trying anything else.
Method 5: Use File Recovery Software
If none of the above applies — the Recycle Bin is empty, no backups exist, no cloud sync was running — third-party file recovery software can scan your drive for deleted file fragments.
These tools work at the storage level, looking for recoverable data that the file system has abandoned. Recovery success depends on:
- Drive type: HDDs retain deleted data longer than SSDs. Many SSDs use TRIM, which actively clears deleted data blocks, making recovery significantly harder or sometimes impossible.
- Time elapsed: The sooner you run recovery software, the better.
- Drive activity since deletion: If the system has written new data to the drive, recovery chances drop.
- File system: NTFS (Windows) and APFS (Mac) handle deletion differently, which affects what recovery tools can find.
Well-known categories of tools include free options with limited scan depth and paid tools with deeper scan capabilities. Results vary significantly by situation. ⚠️
The Variables That Determine Your Outcome
Understanding the recovery method is only half the picture. What actually matters is the intersection of several factors specific to your situation:
- Was the file ever saved? Unsaved files only exist in AutoRecover temp storage — there's nothing on the file system to recover.
- What type of storage drive do you have? SSD vs. HDD changes recovery probability significantly.
- Were any sync or backup services running? Cloud sync and File History create recovery paths that don't exist otherwise.
- How long ago was the file deleted? Minutes versus days makes a real difference.
- Have you used the device since deleting the file? Even basic use can overwrite deleted data.
- What version of Excel and Windows/macOS are you running? AutoRecover behavior and version history features vary across versions.
Someone with Microsoft 365, OneDrive sync enabled, and AutoRecover on has multiple layers of protection working automatically. Someone running Excel locally on an SSD with no backup solution and a cleared Recycle Bin is in a genuinely harder position — where third-party recovery tools may be the only remaining option, and success isn't guaranteed.
The method that makes sense for you depends entirely on which of those variables applies to your setup.