How to Successfully and Easily Recover Excel Files on Mac

recover excel file mac

The Mac version of Microsoft Excel has always been slightly behind the Windows version, which may explain why so many users are eager to learn how to recover Excel files on Mac.

But it’s not just the not-exactly-perfect stability of the Mac version of Excel that can cause important spreadsheets to become unavailable. Users sometimes lose focus and delete the wrong file, storage devices can become corrupted, and there’s always the looming threat of physical damage.

Luckily, learning how to recover Excel files on Mac is not difficult, and there are even multiple approaches Mac users can choose from based on their specific circumstances and needs.

Why Has My Excel File Disappeared?

Before we explain how to recover Excel files that have disappeared, let’s take a closer look at some of the reasons why that might happen, several of which we’ve already mentioned in the introduction to this article:

ReasonDescription
💥 Sudden crashA sudden Excel crash that occurs before you save your file can make it disappear in the blink of an eye. Fortunately, the spreadsheet software is designed to protect its users against sudden crashes by automatically saving opened files in a special temporary location.
🤦‍♂️ User errorUsers can be their own worst enemies, especially when they are distracted and don’t pay attention. A single mistake can lead to the disappearance of multiple Excel files, and there’s always the risk of it becoming permanent unless you recover them in time.
💾 Storage device corruptionModern storage devices are truly remarkable because they allow us to store multiple lifetimes’ worth of memories and other data without costing an arm and a leg. Still, they’re not perfect, and corruption remains one of the leading causes of data loss.
🔨 Physical damageOpening an Excel file stored on a computer that’s been run over by a truck or otherwise physically damaged is usually not possible without some serious rescue work. Professional data recovery centers are best equipped to recover data from physically damaged devices, making their services well worth paying for if your lost Excel files are extremely valuable.
🦠 Malware infectionThere are some pretty nasty strains of malware floating in the dangerous waters of the internet. Some of them can cause Excel files to disappear or even become deleted.

In many of the above-described situations, the recovery of the lost Excel file is still possible—at least if you act quickly and use the right recovery method.

How Do I Find an Excel File That Has Disappeared?

Has an important Excel file recently disappeared from your Mac? Then you should search for it by following the steps below:

  1. Launch Finder.
  2. Click the magnifier glass icon 🔍 in the top-right corner.
  3. Type the name of your file and press Return. If you don’t remember how the file was called, you can search for all files with the .xls or .xlsx extension instead. finder search excel file
  4. Click the “This Mac” search option to search your entire Mac. finder search this mac excel file
  5. Look for the missing Excel file and move it to a safe location.

No luck finding the missing file? Then it’s time to try the recovery methods described in the next section.

How to Recover a Deleted Excel File on Mac

There are several different ways how to recover an Excel file on Mac, and you need to choose the one that best fits your data loss scenario.

Method 1: Recover a Permanently Deleted Excel File with Disk Drill

Best for: Restoring Excel documents that were deleted from a drive, from Finder, and from the Trash folder.

When most Mac users discover that they’ve accidentally deleted or otherwise lost an Excel file that they don’t have backed up anywhere else, they assume the file is gone for good. Fortunately, that’s not usually the case.

Even permanently deleted Excel files can be successfully recovered using specialized data recovery software like Disk Drill as long as they are still physically present on the storage device and haven’t been partially or completely overwritten yet.

We recommend Disk Drill because it can be downloaded for free and used to recover Excel files from all Mac file systems and storage devices with a simple click on the Recover button.

To recover a permanently deleted Excel file with Disk Drill: 

  1. Download and install Disk Drill for Mac. Install Disk Drill
  2. Click the Recover button next to the drive on which your deleted Excel file was stored.
  3. Wait until Disk Drill finishes analyzing the drive.
  4. Look inside the recovery folders and locate the permanently deleted Excel file.
    preview xlsx files
  5. Select it and click the Recover button.Recover excel files
  6. Specify where you want Disk Drill to recover the deleted Excel file and click Next.
Because the free version of Disk Drill can only preview recoverable files (not actually recover them), you will be asked to purchase a Disk Drill PRO license. 

Method 2: Undelete the Excel File from Trash Bin

Best for: Recovering accidentally deleted Excel files that are still present in the Trash folder.

When you accidentally delete the wrong file in macOS, you can easily recover it from the Trash folder, which is a special hidden folder where the operating system temporarily stores deleted files. All files that end up in the Trash folder remain there until the folder is emptied, which can happen automatically (after 30 days) or manually.

To recover a deleted Excel file from Trash Bin: 

  1. Open Trash by clicking on its icon, located on the right side or bottom of the Dock.Open Trash from the Dock
  2. Select the Excel file you want to recover.
  3. Right-click on any selected XLS file and select the Put Back option.Put back selected excel files

Method 3: Restore the Excel File Using Time Machine

Best for: Users who set up a Time Machine backup beforehand.

Time Machine is Apple’s data backup and recovery solution, and it’s included in all recent versions of macOS. If you deleted an important Excel file but had activated Time Machine beforehand, you should be able to get the file back with a few clicks even if it’s no longer present in the Trash folder.

To recover a lost Excel file using Time Machine: 

  1. Connect your Time Machine backup disk if it’s not already connected to your Mac.
  2. Open the folder that contained the deleted Excel file. For example, if the files were in your Documents folder, open Finder and select Documents from the sidebar on the left.
  3. Click the Time Machine icon located in the Menu Bar and choose Enter Time Machine.Click time machine icon
  4. Locate the Excel file you want to recover using the timeline on the right edge of the screen.
  5. Click Restore to restore the selected Excel file.Restore selected excel files

How to Recover an Unsaved Excel File on Mac

The three methods described above can help you recover an Excel file that was accidentally deleted or lost to corruption, but how do you recover an Excel file that was not saved because Excel crashed or a sudden power outage occurred?

The good news is that recovering unsaved Excel files on Mac isn’t any more complicated than the methods for restoring saved but lost Excel files. Let’s take a closer look at three methods that you can use to recover unsaved Excel files.

The methods described below can be used to recover unsaved Excel files on Mac regardless of if you use Excel 2022, Excel 2016, Excel 2019, Excel 2007, or Excel 365. 

Method 1: Recover the Unsaved Excel File from Temporary Files

Best for: Restoring Excel files that were recently lost due to closing the app without saving.

macOS has a special folder where the operating system and applications can temporarily store files that may or may not be needed at some point in the future. If you act quickly enough and have luck on your side, you may be able to find the unsaved Excel file there and recover it.

To find temporary files on Mac: 

  1. Open Finder and go to Applications -> Utilities.
  2. Launch Terminal.Open terminal in utilities
  3. Type “open $TMPDIR” and hit Enter. Look through temporary files

With temporary files open, you need to find autosaved Excel files and copy them to a different folder. Unfortunately, temporary files typically don’t have file extensions, and their names tend to be non-descriptive. Your best bet is to look at file creation dates and manually check all files that were created around the time when the data loss incident took place.

Where are temporary files stored on Mac?

Temporary files on Mac are stored in the Temporary Folder, which is located inside each user’s home directory. Just don’t go looking for it there because you won’t be able to find it. The Temporary Folder is hidden, and you need to unhide it first.

Method 2: Retrieve Lost Excel File from the AutoRecover Folder

Best for: Excel documents lost due to app crash or unexpected Mac shutdown.

The AutoRecover tool is a common feature in many document apps, including Excel. When enabled, this feature saves a copy of your file (and any changes made to it) at a certain interval; the default is every 10 minutes, which you can change. It uses the last saved version along with other AutoRecover information to restore your Excel document.

This tool is useful in cases where Excel crashes or your Mac shuts off unexpectedly while you’re working on your document. If you closed Excel without saving your file, this method won’t work; AutoRecover will just assume that you closed the app on purpose.

If you have enabled AutoRecover, Excel will automatically recover your Excel files that are left unsaved on Mac when you open Excel again, all you need to do is save the file immediately.

Method 3: Get Back Excel Spreadsheets with AutoSave

Best for: Restoring Excel files that were saved or created using Microsoft 365 tools.

Microsoft 365 subscribers can take advantage of a cloud-based backup feature called AutoSave to save their work in real-time. This feature is available only for documents saved on OneDrive, OneDrive for Business, or SharePoint Online, which is why we haven’t mentioned it until now. However, AutoSave is by far the most reliable way to recover Excel files after a hard drive failure since it doesn’t depend on locally stored files.

To get back an Excel spreadsheet with AutoSave: 

  1. Go to: https://onedrive.com/
  2. Log in with your Microsoft 365 account. Log in with Microsoft account
  3. Go to the Recent folder and look for your Excel spreadsheet.
  4. Select the spreadsheet and click Download. Download file from recent folder

How to Open Corrupted Excel Files

It’s easy for Excel files to become absurdly large, sometimes containing hundreds of thousands of rows across multiple sheets, all automated and interlinked with complex functions and macros. It shouldn’t then come as a surprise that Excel files can become corrupted and impossible to open.

Well, almost impossible because Excel has a built-in repair feature that you can use to open corrupted Excel files. The only problem is that this feature is included only in the Windows version of Excel. Still, there’s nothing stopping you from copying the corrupted file to a Windows computer and repairing it there by following the instructions below:

  1. Launch Excel.
  2. Click Open on the File tab.
  3. Click Browse.Browse function in excel menu
  4. Select the corrupted file that you want to open.
  5. Click the arrow next to the Open button, and then click Open and Repair.Repair corrupted Excel file
  6. Choose either Repair or Extract Data depending on if you want to attempt the file or simply extract data from it.

Alternative Solution:

If your Excel file is still unusable after using the repair tool, an alternative solution exists specifically for XLSX files. You can try converting your XLSX file to an XLS file, which is an older extension that is a lot less complex than its younger cousin. This process may also resolve compatibility issues that may be causing the corruption.

Fortunately, you don’t need any third-party tools to do this. Everything you need is in Finder.

  1. Open Finder and locate your corrupted Excel file.
  2. Right-click your Excel file > Get Info.Get Info
  3. Under name & extension, replace xlsx with xls (make sure to keep the period before the extension). Then, hit Return.replace xlsx with xls

Your XLSX file should now be an XLS file – try opening it to see if it works.

Conclusion

Excel files, like any other data, are prone to accidental deletion, corruption, and suddenly going missing. Fortunately, fixing and restoring Excel files is possible to do on your own (expect in cases of physical damage). However, you’ll need to use the correct solution for the root cause of your data loss.

To quickly find the right method for your scenario, make sure that you’ve carefully diagnosed the root of the corruption or less. We also highly recommend securing your data before attempting to repair the file to minimize any chances of data loss.

FAQ

You can recover a previous version of an Excel file on Mac using the following steps.

  1. Open the Excel file.
  2. Click on the File menu then Restore > Restore to Last Saved.
  3. Locate the spreadsheet version you want to recover from the displayed list.
  4. Click Restore to overwrite the current version of the file. Use the Restore a Copy option to save a new version without overwriting the open file.

Once an Excel file has been overwritten on your Mac, the recovery options are limited. You will not be able to use data recovery software to retrieve files that have been overwritten by new data. Use the following procedure to restore the file from a Time Machine backup.

  1. Connect the storage device with the Time Machine backups to your Mac.
  2. Open a Finder window in the folder that held the Excel files.
  3. Click the Time Machine icon on the Mac menu bar to open Time Machine.
  4. Scroll through the snapshots and backups to find the Excel file you want to restore.
  5. Select the file to be recovered and click the Restore button. The Excel file will be restored to its original location.

You can find the Excel AutoRecovery folder in the following location on your Mac:

/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft
Right now, the Mac version of Excel doesn’t have the Open and Repair option you may be familiar with from the Windows version. Instead, we recommend you use the First Aid tool in Disk Utility to repair your corrupted Excel file.
If the Excel file is still open, you should be able to recover lost data from it using the CTRL/CMD + Z keyboard shortcut. Alternatively, you can try restoring a previous version of the file.

Use Microsoft Word for Mac’s AutoRecovery feature to recover an unsaved Word document with the following procedure.

  1. Open a Finder Window on your Mac.
  2. Choose the entire computer as the search location.
  3. Search for AutoRecovery.
  4. A list of files will be displayed. Look for a filename that starts with AutoRecovery save of and has the name of the file you want to recover.
  5. Double-click on the file to open it in Word.
  6. Select File > Save As and save it to a new location.
David Morelo is a seasoned technology writer with a decade of professional experience and a Bachelor's degree in English Linguistics. He also holds a Google Cybersecurity Certificate. At Macgasm, he mainly writes product reviews and in-depth guides, with a focus on macOS and iOS. David's tech journey began at the age of 11, when he assembled his first Windows PC and later used it to explore the Linux world. His curiosity eventually led him to the Hackintosh community and, soon after that, to the nearest Apple store. Today, he's an avid Mac and iPhone user who enjoys the coziness of the Apple software ecosystem because it helps him stay productive. His contributions have also been featured on platforms like CleverFiles, Make Tech Easier and Insanely Mac, and many others.
Alejandro is Macgasm’s Chief Writer and Apple ecosystem enthusiast. He pens the majority of troubleshooting guides and software reviews for this website, tapping into his love for technology and extensive background in technical writing. He started his career by helping multi-regional manufacturing companies in his home country communicate their products and operations to prospective B2B partners. After growing his writing business, he has since worked for top SaaS companies and finance/fintech resources like AgentFire and moneyGenius. He also helped market tech products to angel investors as well as on platforms like Indiegogo and Kickstarter. He is currently learning Swift on his MacBook Pro M1 so he can develop his own pomodoro app for his iPad Pro 11 and 2nd generation 256GB iPhone SE. He also has a gaming PC where he still plays Skyrim with 250+ mods and a Samsung Galaxy smartphone so he can keep using the aux cord in his '95 Nissan.