Mac Data Recovery
Last updated: September 22, 2022
Recover Unsaved or Deleted Excel File on Mac

How to Easily Recover Deleted/Unsaved Excel File on a Mac

Home->Mac Data Recovery->How to Easily Recover Deleted/Unsaved Excel File on a Mac

You’ve spent hours and hours editing an Excel spreadsheet, but now the spreadsheet is gone—what do you do? You learn how to recover a lost Excel file on a Mac by following the instructions provided in this article. With our help, you will be able to get the missing file back in no time.

I need to recover deleted Excel file on Mac I need to recover an unsaved Excel file on Mac

Check if the Excel File Is Really Gone

You don’t want to exhaust all the recovery methods described below just to find out that your Excel file has never been deleted in the first place. That’s why you should first check if the file is really gone.

Method #1: Check the Trash Folder

When you delete a file on your Mac, the file is first moved to the Trash folder before it becomes permanently deleted. You can open the Trash folder by clicking its Dock icon.

To recover a missing file from the Trash folder, you can simply drag the file to a different folder, or you can select the file and choose File > Put Back.

trash recover put back excel file

If the Trash folder has been emptied, then you need to learn how to recover accidentally emptied Trash.

Method #2: Use the Search Feature in Finder

Finder has a built-in search feature that can find an Excel file located in any folder on your Mac by name or file extension (useful when recovering disappearing desktop files on a Mac)

If you know the name of the missing file, then you can:

  1. Open Finder.
  2. Click the Search icon in the top-right corner.
  3. Type the name of the file. Finder will start searching automatically.finder search excel file name

If you don’t know the name of the lost Excel file, then you can tell Finder to display all Excel files that are stored on your Mac:

  1. Open Finder.
  2. Click the Search icon in the top-right corner.
  3. Type “.xls” or .”xlsx” and select Microsoft Excel Workbook or Microsoft Excel 97-2004 worksheet under Kinds.finder search excel kind

Method #3: Check Your Received/Sent Messages

Have you shared the missing Microsoft Excel file with anyone? If so, then you might be able to retrieve it from your inbox or your message history. And if the file isn’t available anymore, then you can just ask the person who sent it to you or received it from you to share it with you.

How to Recover Deleted Excel File on a Mac

Is the Excel file really gone because it has been deleted? Then you can try recovering it. There are third-party data recovery tools that can help you recover a deleted Excel file on a Mac, and you can also use native backup and recovery features.

Method #1: Recover Permanently Deleted Excel File With a Data Recovery Tool

Using special data recovery tools, you can recover a lost Excel file on a Mac even if the file has been permanently deleted and is no longer present in the Trash or any other folder.

We recommend Disk Drill for macOS (you can read a full review here) because its easy-to-use user interface and powerful data recovery algorithms allow even less experienced Mac users to achieve professional results.

Here’s how little effort it takes to recover a permanently deleted Excel file on a Mac with Disk Drill:

  1. Download and install Disk Drill on your Mac.
  2. Launch Disk Drill and give it the required permissions so that it can scan your storage devices.
  3. Select the storage device on which the permanently deleted Excel file was stored.
  4. Click Search for lost data.disk drill select drive macos13
  5. Wait until Disk Drill is done scanning your storage device.
  6. Go through the scan results to find the missing Excel file. You can use Disk Drill’s filters and search feature to narrow down the list of recoverable files.
  7. Select the missing Excel file.
  8. Click the Recover button.disk drill recover macos13
  9. Choose a suitable recovery destination.
  10. Confirm to recover the missing Excel file.disk drill select destination macos13

Excel recovery using Disk Drill for macOS and other similar data recovery tools can only recover a permanently deleted file if the file is still physically present on the storage device from which it was deleted.

Files deleted from older system drives and external storage devices typically remain recoverable until they become overwritten by new data, which can happen in a matter of seconds after their deletion, but it can also take days, weeks, and months.

Most newer Macs (2016/2020/2022 models included) ship with TRIM-enabled SSDs with encryption enabled. Unfortunately, the TRIM command and encryption make it impossible to perform data recovery, but there are still other methods you can try to get your data back.

Method #2: Search for the Deleted Excel File in the Mac Temp Folder

When editing an Excel file, your Mac may decide to store a temporary copy of the file in the so-called temp folder. This folder is hidden, but you can open it with a simple command:

  1. Launch Terminal.
  2. Enter the following command: open $TMPDIRterminal open tmpdir
  3. Browse the temp folder and look for your deleted Excel file. If you find it, then you can simply move it to a safe location.

Keep in mind that files don’t stay in the temp folder forever, so you want to look there as soon as possible, and you definitely don’t want to restart your Mac before that.

Method #3: Recover Excel Files from iCloud Drive

Many Mac users rely on Apple’s iCloud backup service to back up important files to the cloud. If you’re among them, then you can follow these steps to recover your Excel file:

  1. Go to: https://www.icloud.com/
  2. Log in to your iCloud account.
  3. Click Account Settings.icloud account settings
  4. Click Restore Files under Advanced.icloud restore files
  5. Select the Excel file you want to recover and click Restore.

Other cloud backup services, such as Google Drive and Dropbox, make it similarly easy to restore deleted files.

Method #4: Recover a Deleted Excel File Using Time Machine

Mac computers come with built-in backup software called Time Machine. When enabled, Time Machine automatically backs up your personal data, including apps, music, photos, email, and documents, so there’s a pretty good chance that your deleted Excel file will be included in a recent Time Machine backup. To recover it, you need to:

  1. Connect your Time Machine backup drive to your Mac.
  2. Open Time Machine (using Launchpad, Spotlight, or by launching it directly from the Applications folder).time machine open spotlight
  3. Navigate to the folder where the Excel file was stored before its deletion.
  4. Use the arrows and timeline to see previous backups.
  5. Select the most recent backup of the Excel file and click Restore.excel time machine recover

The Excel file should now be back in the folder where it was stored before its deletion.

How to Recover Unsaved Excel File on a Mac

It’s one thing to know how to recover deleted files on Mac, but what about files that have never been saved in the first place? That’s exactly the issue many Excel users who are Googling questions like “how to recover Excel file that is not saved” are trying to solve after accidentally closing the spreadsheet software or experiencing a system crash, and the methods below are here to help.

Method #1: Use Excel’s AutoRecover Feature

To help users recover an Excel file that haven’t been saved on a Mac, Microsoft has implemented the AutoRecover feature, which automatically saves copies of opened documents at a user-specified interval.

When the AutoRecover feature is enabled, you can recover an unsaved Excel file on a Mac after a crash or accidental closing just by launching Excel again and choosing the file from the list of recoverable documents.

You can check if the Excel AutoRecover feature is enabled by:

  1. Opening Excel Preferences.
  2. Selecting the Save category.
  3. Checking if the checkbox next to “Enable AutoRecover” is ticked.enable autorecover excel

Method #2: Check the AutoRecover Folder

Excel should automatically give you the option to recover the automatically saved copy of your spreadsheet after a crash or accidental closing, but there have been cases when that didn’t happen.

If Excel doesn’t display the last opened file, then you can check the AutoRecover folder manually:

  1. Open Finder.
  2. Select the Go to Folder option from the Go menu.
  3. Paste the following location (make sure to replace <username> with your actual username):
/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft

You can then manually recover the unsaved Excel file to a safe location on your Mac.

Don’t confuse the AutoRecover feature with the AutoSave feature, which works only with files that have been saved to the following Excel AutoSave locations: OneDrive, OneDrive for Business, or SharePoint Online.

Method #3: Look in Your Mac’s Temp Folder

We’ve already described how to recover deleted Excel files from the temp folder on a Mac, and you can follow the same instructions to recover an unsaved Excel file.

FAQ

Yes, you can recover a deleted Excel file using data recovery software like Disk Drill:

  1. Download and install Disk Drill.
  2. Launch the application
  3. Scan your storage device.
  4. Select the missing Excel file.
  5. Recover the selected file to a safe location.
Fortunately, Macs come with data backup software called Time Machine that makes it easy to recover a previous version of an Excel file. You can launch Time Machine using Launchpad, Spotlight, or by launching it directly from the Applications folder.
You can quickly undo a deleted sheet in Excel by closing the active workbook without saving and then reopening it. Alternatively, you can recover an older version of the workbook from a local or cloud backup.
The AutoRecovery folder for Microsoft Excel can be found in the following location:

/Users//Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft
You can find temporary files on your Mac by entering the following command in the Terminal app:

open $TMPDIR

Conclusion

Losing an important Excel spreadsheet can be traumatizing, but the loss doesn’t have to be permanent. In this article, we’ve described multiple methods you can use to recover deleted/unsaved Excel files, and there’s a good chance that at least one method will save the day. Best of all, the same methods can be used to recover lost Word documents.

David Morelo is a tech-focused content writer with the ability to turn complex topics into easily digestible pieces of information. When he’s not writing for onMac, he spends his time creating content for SMBs and enterprises across the IT sector, focusing primarily on data backup and disaster recovery, cybersecurity, cloud computing, and the Internet of Things.
Andrey Vasilyev is an Editorial Advisor at onMac. Andrey is a software expert with extensive experience in data recovery, computer forensics, and litigation. Andrey has over 12 years of experience in software development, database administration, and hardware repair.
Scroll to top