DailyConvertTools

Excel File Recovery: How to Recover Lost, Corrupted, or Deleted Excel Files

Lost an important spreadsheet? Step-by-step ways to recover unsaved, deleted, overwritten or corrupted Excel files using Excel's own tools, Windows and OneDrive, plus how to stop it happening again.

Few things at work are as alarming as losing a spreadsheet you've spent hours on. The good news is that Excel, Windows, macOS and OneDrive all keep more safety copies than most people realise. Work through the sections below that match your situation, starting with the simplest fixes.

First: Stop and Don't Make It Worse

  • Don't save over the file or create new files in the same folder, if you've deleted something. New data can overwrite what you're trying to recover.
  • Don't keep reopening a corrupted file and clicking "Save". Make a copy and work on the copy.
  • Note any error message exactly. It helps you choose the right fix.

Situation 1: You Closed Without Saving, or Excel Crashed

Check the Document Recovery pane

After a crash, Excel usually shows a Document Recovery pane when you reopen it. Click each version to open it, then immediately use File → Save As with a new name.

Recover unsaved workbooks

If you closed a new workbook without ever saving it:

  • Open Excel and go to File → Info → Manage Workbook (called Manage Versions in some versions).
  • Click Recover Unsaved Workbooks.
  • Open the file you need and save it straight away.

You can also go to File → Open and click Recover Unsaved Workbooks at the bottom of the recent files list.

On a Mac, Excel keeps AutoRecover files in a hidden folder. In Finder, choose Go → Go to Folder and enter ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery.

Situation 2: You Saved Over the File With the Wrong Version

OneDrive or SharePoint version history

If the file is stored in OneDrive or SharePoint, every save creates a version:

  • In Excel, go to File → Info → Version History, or right-click the file in OneDrive on the web and choose Version history.
  • Open an earlier version to check it.
  • Click Restore or save it as a separate copy.

Windows Previous Versions

If File History or a system backup is turned on, right-click the file (or its folder) in File Explorer, choose Properties → Previous Versions, select a date and click Restore or Open to check it first.

Mac Time Machine

Open the folder in Finder, click the Time Machine icon in the menu bar and choose Browse Time Machine Backups, then go back to the date you need.

Situation 3: You Deleted the File

  • Check the Recycle Bin (Windows) or Trash (Mac). Right-click the file and choose Restore or Put Back.
  • Check OneDrive's recycle bin on the OneDrive website if the file was in OneDrive. Deleted files are usually kept for 30 days for personal accounts, often longer for work accounts.
  • Check backups: File History, Time Machine or your organisation's backup system. IT departments can often restore files from network drives.
  • Recovery software: if none of these work, file-recovery tools can sometimes find deleted files on a hard drive. On SSDs, which most modern laptops use, deleted data is often cleared quickly by a feature called TRIM, so recovery is much less likely.

Situation 4: The File Is Corrupted and Won't Open

Try these in order, always on a copy of the file.

1. Open and Repair

  • In Excel, go to File → Open → Browse and select the file. Don't double-click it.
  • Click the arrow next to the Open button and choose Open and Repair.
  • Click Repair to recover as much as possible. If that fails, repeat and choose Extract Data to get the values (and, optionally, the formulas) out.

2. Open it a different way

  • Turn off automatic calculation before opening: in a blank workbook, go to Formulas → Calculation Options → Manual, then open the file. This helps if a formula is what's crashing Excel.
  • Open Excel in Safe Mode by holding Ctrl while starting it. This disables add-ins, which sometimes cause problems.
  • Try another program: LibreOffice Calc (free) or Google Sheets can sometimes open files that Excel rejects. Once opened, save a fresh copy as .xlsx.

3. Link to the data from another workbook

In a new workbook, type a formula such as ='C:\Folder\[Damaged.xlsx]Sheet1'!A1 (adjust the path, file and sheet names), then fill it across and down to pull the values out of the damaged file.

4. Look inside the file (advanced)

An .xlsx file is really a zip folder of XML files. Make a copy, change its extension from .xlsx to .zip and open it. Your cell values are in xl/worksheets/sheet1.xml, and text is often in xl/sharedStrings.xml. This can rescue data when nothing else works, but it takes patience.

5. Repair software and professional services

Commercial Excel repair tools exist, and some offer a free preview of what they can recover; only pay once you've seen that your data is there. For files on a physically damaged drive, stop using the drive and contact a reputable data recovery service. Many work on a "no data, no fee" basis.

How to Avoid Losing Excel Files Again

Turn on the safety settings

In File → Options → Save:

  • Save AutoRecover information every: set it to 5 minutes (the default is 10).
  • Keep the last AutoRecovered version if I close without saving: tick it.

For files stored in OneDrive or SharePoint, switch on AutoSave (the toggle at the top left of Excel). Every change is saved automatically, and version history lets you go back.

Keep backups

Follow the 3-2-1 rule: three copies of important files, on two different types of storage, with one copy off-site or in the cloud. Turn on File History (Windows) or Time Machine (Mac), and test restoring a file occasionally.

Good habits

  • Save as you go with Ctrl+S (Cmd+S on a Mac).
  • Use "Save As" with a new version name, such as Budgetv2.xlsx, before making big changes.
  • Close files properly before unplugging a USB drive or shutting down.
  • Keep a PDF snapshot of important finished reports, for example with our Excel to PDF converter, so there's always a readable copy of the figures.

Conclusion

Most "lost" Excel files can be found again: in the Document Recovery pane, the unsaved workbooks folder, the Recycle Bin, OneDrive's version history or your backups. For corrupted files, Open and Repair rescues most problems. Spend five minutes setting up AutoSave, shorter AutoRecover intervals and regular backups today, and the next accident will be a minor inconvenience instead of a disaster.