How to Recover Unsaved or Deleted Excel Files (Step-by-Step)

Published 2026-09-13

How to Recover Unsaved or Deleted Excel Files (Step-by-Step)

Losing an important Excel spreadsheet—whether due to a sudden power outage, an accidental system restart, or a moment of misplaced clicking—can instantly derail your workday. Fortunately, Microsoft Excel includes several built-in safety nets, and modern operating systems offer multiple ways to restore lost data.

Follow this step-by-step guide to recover your unsaved or deleted Excel files quickly.

1. Recovering Unsaved Excel Files Built-in Tools

If Excel closed unexpectedly before you could hit “Save,” your work might still exist in temporary auto-save directories.

Method A: Use the Document Recovery Pane

  1. Relaunch Microsoft Excel.
  2. In most cases of a crash, a Document Recovery pane will automatically open on the left side of the screen.
  3. Review the files listed under “Available Files.”
  4. Click on the file you wish to retrieve, then immediately go to File > Save As to store it in a secure location.

Method B: Use “Recover Unsaved Workbooks”

If the recovery pane doesn’t appear automatically:

  1. Open a blank workbook in Excel.
  2. Click the File tab in the top-left corner.
  3. Select Info, then click the Manage Workbook button.
  4. Choose Recover Unsaved Workbooks from the dropdown menu.
  5. A file explorer window will open showing Excel’s hidden draft folder. Select your missing file and click Open, then save it immediately.

2. Restoring Previous Versions of Saved Files

If you accidentally overwrote valuable data, saved unwanted changes, or need an earlier draft of a spreadsheet, you can roll back time using version history.

If Your File is Saved to Cloud Storage (OneDrive / SharePoint)

  1. Open the file in Excel.
  2. Click the file title at the very top of the window.
  3. Select Version History.
  4. A panel will open on the right showing previous versions by timestamp. Click Open version to preview an older copy, then select Restore if it contains the data you need.

If Your File is Stored Locally (Windows File History)

  1. Open File Explorer and navigate to the folder where the Excel file was saved.
  2. Right-click the file (or the parent folder if the file was deleted) and select Properties.
  3. Click the Previous Versions tab.
  4. Select a version dated prior to the unwanted changes and click Restore.

3. Retrieving Deleted Excel Files

If you intentionally or accidentally deleted an Excel file, it might not be gone permanently.

Check System Trash

Check Cloud Provider Trash

If your file was synced to cloud platforms (such as Microsoft OneDrive, Google Drive, or Dropbox), check the cloud platform’s online web portal. Most cloud services retain deleted files in an online Recycle Bin or Trash folder for 30 days before permanent deletion.

4. Advanced Recovery: Third-Party Tools and Backups

If the steps above do not recover your spreadsheet, consider these secondary strategies:

Prevent Future Data Loss

To safeguard your data going forward, ensure Excel’s AutoRecover features are active:

  1. Go to File > Options > Save.
  2. Verify that Save AutoRecover information every X minutes is checked (set it to 1–5 minutes for maximum safety).
  3. Ensure Keep the last AutoRecovered version if I close without saving is enabled.

Need more tech tips to optimize your workflow? Subscribe to our newsletter or share this guide with a colleague who might be dealing with a spreadsheet emergency today!

🛒 Recommended gear

Handpicked categories to explore (affiliate links):

Disclosure: As an Amazon Associate and affiliate (dipankarsstor-21), this site earns from qualifying purchases at no extra cost to you.