5+ ways to recover an Excel file that was not saved on Mac

Working on an Excel spreadsheet only to leave the work unsaved could cause some panicking moments.

There could be a lot of reasons for not saving the file. Your device could close unexpectedly due to a system crash, power failure, etc.

Don’t wory though, regardless of why this has happened, we can help you recover your unsaved Excel on Mac.

In this article we will offer you more detailed information, so make sure to keep on reading.

How can I recover an unsaved Excel file on Mac?

1. Restore the files from the Temporary Folder

1. Go to Applications and select Utilities from the menu.
2. Next, click on the Terminal option.
3. Type open $TMPDIR and press Return. This will open the Temporary files folder. 
4. Select the TemporaryItems folder.
5. Search for your unsaved Excel file and click on Restore.

Make sure to copy the auto-saved Excel file in a different one than the Temporary folder.

Because the temporary file doesn’t have file extensions it can happen that their names are non-descriptive.

With that in mind, the best thing to do in order to find your file would be to look at the file creation date and then check all the files that were created near the date when losing the Excel file took place.

2. Use the AutoSave option

1. Go to Applications and select Utilities.
2. Next, click on Terminal to open it.
3. Type defaults write com.apple.Finder AppleShowAllFiles true.
4. Next, press Enter.
5. Click Finder and once you localized your excel file press on Return.
6. Once you find the unsaved spreadsheet file you can select it and press on Recover.

The AutoSave option saves the changes to your document every two seconds which helps reduce data loss.

With this amazing feature, you can rest assured that your document’s data has been saved even though you did not press the Save button.

The AutoRecover option on the other hand will allow you to find and restore the last AutoSave version of your Excel file.

Follow these steps in order to enable the AutoRecover option:

1. Open the Excel menu and click on Preferences.
2. Click on the Save button located under the Sharing and Privacy option.
3. Tick the Save AutoRecover info and make sure to enter the frequency of file saving.
4. Next click Ok to save these changes.

Also, if you open Excel after an unexpected crash due to system failure or other reasons, the automatically recovered file will show up on Document Recovery.

This list is located on the left-hand side. You can simply click and open the most recent version of your Excel file from there.

3. Use the Save List option

1. Open an Excel spreadsheet on your Mac.
2. Go to File and select the Open recent option.
3. Select from the list your Excel file and press Save.

4. Look in the Mac Trash folder

1. Launch Trash and click on the Change the item arrangement option.
2. Arrange the files to be shown based on Date Added.
3. Locate the deleted file and right-click on it.
4. Next, choose the Put back option.

5. Use the Time Machine option

1. Go to Finder and select the Application option.
2. Next, click on Time Machine.
3. Go to Finder and select All my files.
4. Now, select the version you want to recover for your unsaved Excel file.
5. Finally, click on Restore to retrieve the lost file.

6. Use an Online Backup service

In iCloud

1. Login into your iCloud account using your username and password.
2. Go to Settings and select Advanced.
3. Next, click on Restore Files.
4. Select the Excel file you want to recover, then click Restore File.

In Google Drive

1. Log into your Google account and go to Google Drive.
2. Go to Trash, find your deleted Excel files.
3. Right-click on the deleted Excel file, then click on the Restore option to retrieve the Excel file on your Mac.

In OneDrive

1. Go to OneDrive and type in your username and password.
2. Go to the Recycle bin and find the deleted Excel file.
3. Right-click on the file and choose the Restore option to recover the deleted Excel file.

We hope that this guide has proven useful in your situation and that you managed to recover the Excel file that wasn’t saved.

Feel free to share your experience with us by using the comment section below.