Knowing how to recover deleted excel files is one of the most critical skills any Excel user can develop, whether you are managing personal budgets, corporate financial models, or complex data dashboards. Accidentally deleting a workbook โ or overwriting hours of work โ can feel catastrophic, but Microsoft Excel and your operating system both provide multiple recovery pathways that most users never discover until a crisis strikes. This guide walks you through every available method, from built-in AutoRecover features to third-party tools, so you can restore your data quickly and confidently.
Knowing how to recover deleted excel files is one of the most critical skills any Excel user can develop, whether you are managing personal budgets, corporate financial models, or complex data dashboards. Accidentally deleting a workbook โ or overwriting hours of work โ can feel catastrophic, but Microsoft Excel and your operating system both provide multiple recovery pathways that most users never discover until a crisis strikes. This guide walks you through every available method, from built-in AutoRecover features to third-party tools, so you can restore your data quickly and confidently.
Excel's AutoRecover feature automatically saves a temporary copy of your open workbook at intervals you can configure โ typically every 10 minutes by default. These autosave files are stored in a hidden folder on your computer and remain accessible even after an unexpected crash or power failure. Understanding where these files live and how to retrieve them is the first line of defense against data loss, and it is something every Excel user should know before they ever need it.
Beyond AutoRecover, Windows and macOS both maintain a Recycle Bin or Trash where deleted files sit temporarily before permanent deletion. If you accidentally deleted an Excel file through File Explorer or Finder, there is a strong chance it is still recoverable through these system-level safety nets. The key is to act quickly, because emptying the Recycle Bin or running disk cleanup tools can permanently erase those files from the system index.
For users who regularly work with important spreadsheets, learning skills like how to recover deleted excel files and setting up systematic backups can save thousands of dollars in lost productivity. Whether you work with VLOOKUP Excel formulas, pivot tables, or financial models that took weeks to build, losing that work without a recovery path is avoidable with the right habits and knowledge. This guide covers both reactive recovery and proactive prevention strategies.
Cloud storage services like OneDrive, SharePoint, and Google Drive add another layer of protection by maintaining version histories that let you roll back to earlier saved states. If your organization uses Microsoft 365, you almost certainly have access to version history features that can restore a file to any previously saved state within the last 30 to 180 days, depending on your subscription tier and administrator settings.
Even when standard recovery methods fail, professional data recovery software can often reconstruct deleted Excel files from disk sectors that have not yet been overwritten. Tools like Recuva, Disk Drill, and EaseUS Data Recovery Wizard scan storage drives at a low level, finding file fragments that Windows or macOS no longer references in the active file system. Success rates vary depending on how long ago the file was deleted and what disk activity has occurred since then.
Throughout this guide, you will find actionable steps organized by recovery scenario, practical checklists, and expert tips drawn from IT professionals who handle data recovery regularly. Whether you lost a file seconds ago or days ago, there is a recovery method worth trying โ and knowing which one to attempt first can dramatically improve your chances of getting your workbook back intact.
Open Excel and go to File > Info > Manage Workbook > Recover Unsaved Workbooks. Browse the UnsavedFiles folder (typically in AppData\Local\Microsoft\Office\UnsavedFiles) and look for .xlsx or .xlsb temp files matching your lost workbook's name or timestamp.
Navigate to File > Options > Save to find your AutoRecover file location path. Open that folder in File Explorer, sort by Date Modified, and look for files with a .asd or .tmp extension created around the time of the data loss event.
Double-click the Recycle Bin on your desktop, search for the filename or filter by .xlsx extension, right-click the file, and choose Restore. The file returns to its original folder location. On Mac, open Trash, locate the file, and drag it back to the desired folder.
Right-click the folder where the file was saved, select Restore Previous Versions (Windows) or browse Time Machine snapshots (Mac). Windows File History must be enabled in advance, but Previous Versions via Volume Shadow Copies may work even without prior configuration.
If the file was stored in OneDrive or SharePoint, right-click it in OneDrive web interface and choose Version History. Select any earlier version to preview or restore it. Microsoft 365 Business plans retain versions for up to 180 days with granular restore points.
If all else fails, install Recuva (free) or Disk Drill (freemium), scan the drive where the file was stored, filter results by .xlsx or .xls extensions, and attempt recovery. Run this step as soon as possible โ every new file written to disk reduces the chance of successful recovery.
The Recycle Bin is the simplest and most overlooked recovery tool available to Windows users who accidentally delete an Excel file. When you press the Delete key or right-click and choose Delete in File Explorer, Windows moves the file to the Recycle Bin rather than erasing it from disk immediately. The file stays there until you manually empty the Recycle Bin or until the bin reaches its configured size limit, at which point the oldest files are purged to make room. Checking the Recycle Bin should always be your first step when you realize a file is missing.
Windows Previous Versions, powered by Volume Shadow Copy Service, gives you access to historical snapshots of files and folders even without third-party backup software. To use it, right-click the folder where your Excel file was saved, select Properties, and click the Previous Versions tab. Windows will display available snapshots organized by date. You can open a snapshot to browse its contents, copy individual files from it, or restore the entire folder to an earlier state. This feature requires that System Protection is enabled for the drive in question.
For users who work with skills like how to merge cells in Excel or how to freeze a row in Excel on files saved to network drives, IT administrators often configure shadow copies or backup schedules at the server level. In these environments, contacting your IT helpdesk can unlock recovery options that are invisible to end users, including tape backups, cloud archiving, or enterprise-grade snapshot systems that retain file versions for months or years.
Microsoft 365's built-in version history is particularly powerful for teams collaborating on shared workbooks through SharePoint or OneDrive for Business. Every time a file is saved, Microsoft creates a new version entry in the version history log. You can access this log by opening the file in Excel Online, clicking the file name in the title bar, and selecting Version History. From there, you can preview or restore any previous version without overwriting the current file, giving you a safe way to compare and choose the right restore point.
When a file has been saved over โ rather than deleted โ the version history approach is often the only viable path for recovery. If you opened a workbook, made changes, and saved without creating a backup copy, the original data no longer exists as a standalone file. Version history sidesteps this problem by maintaining a chronological record of every saved state, allowing you to pinpoint exactly when the unwanted changes were introduced and restore from the version immediately before that point.
Temporary files created by Excel during editing sessions can also serve as a recovery source. Excel creates hidden temp files with names like ~$filename.xlsx in the same directory as the open workbook. These lock files are normally deleted when the workbook is closed properly, but they may persist after a crash. To find them, open File Explorer, enable Show Hidden Items in the View menu, and look for files prefixed with a tilde (~) or dollar sign in the folder where your workbook was located.
Understanding how Excel's file-saving architecture works gives you a significant advantage when you need to recover data. Excel doesn't write directly to the original file during most edit operations โ it writes to a temporary buffer and only commits to the source file on an explicit Save command. This design means that even if the original file is corrupted or deleted, recovery tools may find intact temporary copies scattered across the temp directory, the AutoRecover path, and the working directory, any of which could contain a usable version of your lost work.
To configure AutoRecover in Excel, navigate to File > Options > Save. Here you can set the AutoRecover save interval as low as 1 minute for critical workbooks, and you can specify a custom AutoRecover file location on a network drive or cloud-synced folder. Enabling the option to keep the last autosaved version if you close without saving is especially important โ it creates a permanent recovery point every time you exit Excel without explicitly saving.
The AutoRecover folder path differs by Windows version and user profile, but it typically follows the pattern C:\Users\[Username]\AppData\Roaming\Microsoft\Excel. If Excel crashes, these .asd files remain in that folder and are presented automatically the next time you open Excel through the Document Recovery pane on the left side of the screen. You should manually verify this folder path in your Excel settings and confirm it is pointing to a location with adequate disk space and appropriate permissions.
OneDrive's version history is accessible through both the desktop app and the OneDrive web portal at onedrive.live.com. Right-click any file in OneDrive online, select Version History, and you will see a timestamped list of every version saved to the cloud. Personal OneDrive accounts retain versions for 30 days, while Microsoft 365 Business subscribers can access versions going back up to 180 days. Each version shows the file size and modification time, helping you identify the correct restore point without guessing.
OneDrive also offers a Recycle Bin that functions independently from the Windows Recycle Bin. If you delete a file from OneDrive โ either through the web interface or the synced desktop folder โ it moves to the OneDrive Recycle Bin and stays there for 93 days on personal accounts. To access it, log into OneDrive online, click Recycle Bin in the left sidebar, locate your Excel file, and click Restore. The file returns to its original location in your OneDrive folder and resyncs to all connected devices automatically.
Mac users running macOS with Time Machine configured have one of the most reliable file recovery systems available. To use Time Machine for Excel file recovery, open the folder where the file was stored, activate Time Machine from the menu bar icon or System Preferences, and use the timeline on the right edge of the screen to scroll back through hourly, daily, and weekly snapshots. When you find the version you need, select the file and click Restore โ it reappears in the original folder without affecting the current folder contents.
Without Time Machine, Mac users can check the AutoRecover folder that Excel for Mac creates in the user's Library folder. The path is typically ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery. Because the Library folder is hidden by default on macOS, you need to hold the Option key while clicking the Go menu in Finder to access it, or type the path directly into Go > Go to Folder. Files saved here carry the extension .xlsx and the workbook name, making them easy to identify and open directly in Excel.
Every file you download, save, or create after deleting an Excel file risks overwriting the deleted file's disk sectors, permanently destroying any chance of recovery. As soon as you realize data is lost, minimize all computer activity until you have either recovered the file or determined it cannot be recovered. This single habit dramatically increases recovery success rates with third-party tools.
Third-party data recovery software operates at a level below the file system, scanning raw disk sectors for file signatures and fragment patterns that match Excel file formats. When Windows marks a file as deleted, it only removes the file's index entry from the Master File Table โ the actual data remains on disk until that sector is reused for new content. Recovery tools exploit this window of opportunity by scanning every sector on the drive and reconstructing files from the fragments they find, making it possible to recover Excel workbooks that were permanently deleted from the Recycle Bin weeks ago.
Recuva, developed by Piriform (the makers of CCleaner), is the most widely recommended free tool for recovering deleted Excel files on Windows. After installation, launch Recuva and select the file type (Office Documents) and the location where the file was stored. Run a deep scan for best results, then filter the results by .xlsx or .xls extension. Recuva color-codes recovered files by recovery likelihood: green for excellent, orange for poor, and red for unrecoverable. Always save recovered files to a different drive than the one you are scanning to avoid overwriting the data you are trying to recover.
Disk Drill by CleverFiles offers a more polished interface and works on both Windows and macOS, making it a popular choice for cross-platform teams. The free version allows you to preview recoverable files before committing to a recovery, which is useful for confirming that a file's content is intact before restoring it. Disk Drill's vault feature can also proactively protect specified folders by creating invisible backup copies of files as they are deleted, functioning as an automatic safety net for high-value workbooks.
EaseUS Data Recovery Wizard is another professional-grade option that supports both quick scan and deep scan modes. The deep scan can take several hours on large drives but delivers the most thorough results, often recovering files that quick scans miss entirely. EaseUS supports FAT12, FAT16, FAT32, NTFS, and exFAT file systems, making it compatible with USB drives, external hard drives, and SD cards in addition to internal computer drives โ useful when your Excel files are stored on portable media.
For enterprise environments, Ontrack EasyRecovery and R-Studio offer features designed for IT professionals, including the ability to create sector-by-sector disk images before attempting recovery. Imaging the drive first is a best practice because it lets you perform multiple recovery attempts on the image rather than the original drive, eliminating any risk of further data damage during the recovery process. These tools also support RAID array recovery, which matters for businesses where Excel files are stored on network-attached storage devices.
One underutilized recovery approach involves checking email attachments. If you emailed the Excel file to a colleague, client, or yourself โ even days or weeks ago โ that version may be recoverable from your Sent Items folder in Outlook or Gmail. Similarly, if you shared the file through Microsoft Teams, Slack, or another collaboration platform, check those platforms' file histories, as uploaded files are typically retained in the platform's storage for months or years depending on the organization's configuration and data retention policies.
After recovering a file, always open it in a new Excel session and verify the content before overwriting any existing files. Recovered files sometimes contain partial data, corrupted formulas, or missing worksheets, depending on how much of the original file was recoverable from disk. Excel may also prompt you to repair the file on opening, which you should accept โ Excel's built-in repair function can often reconstruct damaged cell data, formatting, and formula references from the partial file structure that recovery software retrieved.
Preventing future data loss is ultimately more valuable than mastering recovery techniques, because prevention eliminates the stress, downtime, and potential for incomplete recovery that data loss events inevitably create. The most effective prevention strategy combines multiple redundant approaches: enabling AutoRecover with a short interval, storing files in a cloud-synced folder, and maintaining a separate backup on an external drive or network share. No single method is foolproof, but layering two or three reduces the probability of unrecoverable data loss to near zero for most users.
Configuring AutoRecover to save every 1 to 2 minutes is a low-cost, high-impact change that takes less than 30 seconds to implement. In Excel, go to File > Options > Save, set the AutoRecover save interval to 1 minute, and check the box labeled Keep the last autosaved version if I close without saving. This ensures that even if Excel crashes mid-session, you lose at most 60 seconds of work rather than everything since your last manual save. For workbooks you are actively editing for hours, this setting is invaluable.
Storing Excel files in OneDrive or SharePoint rather than on a local drive eliminates the risk of local hardware failure, theft, or accidental deletion without cloud backup. When files are cloud-synced, every manual save creates a new version entry in Microsoft's version history system, and deletions route through an online Recycle Bin rather than a local one. Users who understand skills like how to freeze a row in Excel and how to merge cells in Excel as part of their daily workflow should equally understand how to configure their save locations for maximum data protection.
Creating manual backup copies before major editing sessions is a habit that experienced Excel users develop after their first significant data loss experience. Before making large structural changes to a workbook โ such as running a VLOOKUP Excel operation that modifies hundreds of rows, restructuring worksheets, or deleting sections of data โ use File > Save a Copy to create a timestamped backup in a designated backup folder. This takes five seconds and provides an instant recovery point that requires no special software or system configuration.
Windows File History is a built-in backup feature that continuously monitors specified folders and saves copies of changed files to an external drive or network location. To configure it, connect an external drive, open Settings > Update & Security > Backup, and turn on Automatically back up my files. File History saves copies of files in your Documents, Desktop, Downloads, and other key folders every hour by default, creating a rolling archive that lets you recover any version of a file from the past month or longer depending on available storage space.
For organizations managing sensitive financial data in Excel, implementing a formal backup policy is essential for both data protection and regulatory compliance. Many industries require demonstrable data backup procedures as part of their operational standards, and a well-configured backup system provides audit trails that prove data integrity over time. Whether you are building financial models for a small business or managing enterprise-level data sets, the principles of 3-2-1 backup โ three copies, two different media types, one offsite โ apply equally to Excel workbooks.
Regular practice with Excel's full feature set, including understanding how to create a drop down list in Excel, how to use VLOOKUP and advanced functions, and how to protect workbooks with passwords, complements your recovery knowledge by reducing errors in the first place. Users who are confident with Excel's features make fewer mistakes that lead to accidental overwrites or deletions, and they are more likely to implement protective measures like cell locking, formula protection, and structured data validation that prevent data integrity issues before they occur.
Developing a systematic approach to Excel file management pays dividends every time you work with important data. Start each project by creating a dedicated folder structure with separate subfolders for working files, backup copies, and archived versions. Name files with date stamps in the format YYYY-MM-DD so they sort chronologically in File Explorer, and increment version numbers when you make significant changes. This discipline makes it trivial to identify the most recent working version and roll back to earlier states without relying on any recovery tools at all.
Excel's built-in workbook protection features work hand-in-hand with file backup strategies. Locking specific cells or worksheets prevents collaborators from accidentally overwriting critical formulas or reference data, reducing the need for recovery in collaborative environments. You can protect a worksheet by right-clicking its tab, selecting Protect Sheet, and setting a password. Combined with file-level password protection under File > Info > Protect Workbook, these measures create a robust layer of defense against accidental modification that complements your external backup strategy.
For users who work with Excel as part of a broader Microsoft 365 workflow, the integration between Excel, Teams, and SharePoint creates opportunities for automatic versioning that many users do not leverage. When you save an Excel file to a Teams channel's Files tab, SharePoint automatically maintains version history in the background without any additional configuration. Every time a team member edits and saves the file โ even through simultaneous co-authoring โ a version entry is created, giving the entire team a shared safety net against accidental data loss.
Learning keyboard shortcuts for saving and creating backup copies can dramatically reduce the window of vulnerability between saves. The Ctrl+S shortcut saves the current workbook in under a second, and binding a macro to Ctrl+Shift+S that runs a Save a Copy command to a backup folder can automate the backup process with minimal interruption to your workflow. Excel's macro recorder makes it easy to create this kind of automation without any programming knowledge โ record the File > Save a Copy action once, assign it a keyboard shortcut, and run it at the start and end of each editing session.
Understanding the difference between Save and Save As in Excel is fundamental to avoiding accidental overwrites. Save (Ctrl+S) writes changes to the existing file, overwriting the previous version without confirmation. Save As (F12) creates a new file at a location you specify, leaving the original file intact. When you are uncertain about changes you are about to make, use Save As to create a working copy first, then experiment freely knowing the original is preserved. This simple habit eliminates the entire category of overwrite-related data loss that recovery software cannot fully address.
Excel's compatibility with cloud platforms extends to Google Drive as well, where uploaded .xlsx files can be opened, edited, and version-controlled through Google Sheets. If you use both Excel and Google Workspace in your workflow, uploading critical workbooks to Google Drive provides an additional off-platform backup that is immune to issues affecting your Microsoft 365 account. Google Drive retains version history for 30 days on standard accounts and indefinitely on Google Workspace Business plans, making it a viable secondary backup for important workbooks.
Finally, periodically testing your backup and recovery processes is as important as setting them up in the first place. Schedule a quarterly review where you deliberately attempt to restore a test file from your backup system, verify that AutoRecover files are being created in the expected location, and confirm that OneDrive version history contains recent save points for your most important workbooks. A backup system you have never tested is a backup system you cannot trust when it matters most โ and data loss events rarely arrive at a convenient moment.