5 Best known ways to recover an Excel file on Mac
Thanks to the father of Excel, Charles Symonyi, we can easily use the tool for various tasks — from project management to data analysis. Since it was first made for Windows, the Mac version of Microsoft Excel has always felt a bit behind the curve. Because of this, trying to recover deleted files on macOS can be pretty tricky.
Unlike simple document recovery, Excel files often contain complex formulas and macros that can be harder to retrieve. Being ready is key, so having a few tricks up your sleeve can boost your chances of a successful recovery.
That’s why I’ll show you how to recover an Excel file on a Mac using built-in tools and third-party apps.
What are the best methods to recover unsaved Excel files on a Mac?
Before we dive into the details, let’s briefly examine the best solutions to recover unsaved or deleted Excel files:
Excel file recovery method | Best for |
Trash | Restoring accidentally deleted files |
Disk Drill | Instantly restoring files from any storage device |
Excel’s AutoRecover feature | Restoring crashed Excel files |
Time Machine | Users setting up Time Machine backup in advance |
macOS Versions | Restoring previous versions of Excel files |
To broaden your file recovery options, explore Mac's top 10 recovery tools to recover lost Excel files and other essential data.
How to recover an Excel file on a Mac that has disappeared?
I did a quick poll with my friends and coworkers, and it turns out the biggest reasons they had to recover their Excel spreadsheets were accidental deletions and file corruption — especially after their computers crashed or shut down unexpectedly. I totally get it because I can be a little clumsy when I'm working, too!
Some of the ways to recover lost or unsaved Excel files might seem pretty straightforward, but that’s the trick. Let’s check out how to get those files back.
Method 1: Recover deleted Excel files from Trash
As you understand, I use this method a lot ha-ha. If you just did some spring cleaning on your Mac, there's a chance you accidentally tossed your Excel file into the Trash. No need to freak out — take a moment to check out this recovery method first.
To recover files from accidental deletion:
- Click the Trash icon from Dock to open it.
- Find the XLS file you want to recover and right-click on it.
- Click Put Back.
Method 2: Recover deleted or lost files using Disk Drill
If you permanently delete any kind of file, it’s still somewhere on your device, so it's a good idea to try some professional recovery software to get it back.
Disk Drill has proven to be a reliable data recovery tool that locates all lost files on your hard drive quickly, which is why it’s one of the best methods for recovering XSL and other data types.
To recover data with the tool:
- Install and open Disk Drill.
- Choose a storage device where your XSL was stored earlier.
- Click Search for lost data.
4. After the search is complete, click Documents.
5. Look for the file by typing xsl in the search bar and click Recover.
A big plus of this tool is that it can also recover unsaved workbooks or Word documents from your Mac and USB, flash drives, iPhones, and Android.
Method 3: Recover corrupted files using Microsoft Excel's AutoRecover feature
Picture this: you're deep into your quarterly analysis spreadsheet when the power goes out. That’s when the AutoRecover feature can help.
Excel’s AutoRecover feature creates a backup of your file at regular intervals of every 10 minutes. If your Mac crashes or you lose power and electricity, the next time you open Excel, it will offer to recover your last session.
But to be sure the feature is enabled on your Microsoft Excel:
- Click Excel in the menu bar > Preferences > Save.
- Make sure “Save AutoRecover information every X minutes” is selected.
If Excel doesn't automatically recover the file, you can manually check the AutoRecover folder at ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery to find temporary backup files and restore your spreadsheet.
For more information, check out the Microsoft Support page.
Method 4: Recover lost files using Time Machine
Time Machine is another built-in macOS feature that lets you recover XLS files. However, it works only if you set up a Time Machine backup before losing a file.
To recover XLS with Time Machine:
- Connect a Time Machine backup drive. If not, check out the article on how to set up Time Machine.
- Open the folder where your lost XSL files were located.
- Click Time Machine from the menu bar > Enter Time Machine.
- Use the timeline on the right to find and recover the Excel file.
- Click Restore.
How do I restore a previous version of an Excel File on a Mac?
On a Mac, many apps save versions of your files while you work on them — and not just work — they also save every new version after you open, duplicate, rename, lock, or save a document on every Apple Mac.
If you want to restore the XLS, do the following:
- Open the Excel document on your Mac.
- Click File in the menu bar > Choose Revert To > Browse All Versions.
- Choose the version to restore (if you worked with the document before) and click Restore.
Can I restore deleted Excel files on a Mac? Absolutely!
No matter what happened to your Excel files on Mac, there are ways to restore them — from Trash recovery to advanced Time Machine backup restore.
The best way to recover lost Excel files is to keep a few recovery methods and handy tools, just in case:
- Use Disk Drill, a data recovery software, to recover lost XLS and other file types from any storage device.
- Use Get Backup Pro to backup files on the go.
- Use Dropshare to keep essential docs online from your menu bar.
You can get all these apps and 250 more on Setapp. The platform has some cool macOS and iOS apps for recovery cases and other things like productivity or creativity. Get a chance to test all apps within a 7-day free trial.
FAQ
How to recover unsaved Excel file?
To instantly recover an Excel file on a MacBook, use the Disk Drill tool. Install and open Disk Drill, choose the storage device, and click Search for lost data.
Where are Excel AutoSave files stored on Mac?
On a Mac, AutoSave files for Excel are typically stored in a temporary folder or the AutoRecovery folder:
- Open Finder and click Go in the menu bar.
- Choose Go to Folder.
- Type ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery.
How to recover overwritten Excel files?
To recover overwritten files, use Time Machine:
- Connect a Time Machine backup drive.
- Open the folder where you lost Excel files.
- Click Time Machine from the menu bar > Choose Enter Time Machine.
- Use the timeline on the right to recover the Excel file.
- Click Restore.