Unforeseen accidents like unexpected shutting down and malware attack can happen while we're working on Excel spreadsheet and many people may get fret about the data loss, i.e. the Excel files get lost. But don't worry, there are still ways to recover the unsaved as well as deleted Excel files. Now read on to learn more about the effective methods and try them by yourselves.
Recovering unsaved or permanently deleted Excel files is definitely possible and this has been proven with the use of data recovery software. AnyRecover for Mac is such an all-in-one Microsoft Excel files recovery tool designed to help you out with just a few clicks no matter which situation you are in. Thanks to the deep-scan feature and unique data recovery algorithm, AnyRecover recovers your files with an extremely high success rate and at a fast rate.
Key features of AnyRecover:
Step 1 Download, install and launch AnyRecover on your Mac. Select a location from which you want to recover the Excel files and click the Start button.
Step 2 AnyRecover will then begin an all-round and deep scan on your selected location. You just need to wait patiently for a moment.
Step 3 When the scan is complete, you can preview the files first or directly click on Recover to recover unsaved/deleted Excel file Mac.
Unsaved Excel files can also be recovered from the Recent list, the temporary folder of your Excel worksheet or the AutoRecover folder.
The simplest way to recover unsaved Excel file Mac is using the "Save List" option.
Step 1: Open a new Excle spreadsheet and click File tab.
Step 2: Choose Open Recent and find your file from the list, finally click Save button.
Step 1: On Mac, Go to Applications > Utilities > Terminal.
Step 2: Once the Terminal opens, type "open $TMPDIR" and press the Return key to open the temporary folder.
Step 3: Navigate through all the folders and select the folder with the name "TemporaryItems".
Step 4: Find the unsaved file you need under the "TemporaryItems" folder and then restore it.
However, not all unsaved excel files can be found in the temporary folder.
AutoRecover is a wonderful feature available in some office applications which attempts to recover unsaved Excel file on Mac in the event of a program or system crash. It resists risks of data loss by regularly saving a copy of the file in the background.
Step 1: Click on Finder, then press the Return key on your Mac.
Step 2: Once you've done the above steps, type "/Users/username/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery" and click the Go button to open up Excel's AutoRecovery folder.
Step 3: Find the unsaved Excel file you need, then recover it to another folder on your Mac.
This method requires that you save the Excel file initially. It won't work if you haven't saved the Excel sheet once.
Although AutoRecovery is a built-in feature that is turned on by default on Mac, you might still need to check and configure it to make sure everything is set without any mistake. See the steps below:
From the menu bar of Excel, select Preference.
In the Privacy and Sharing section, click on Save.
Check Save AutoRecover info.
Then enter/adjust the frequency with which you want AutoRecover to save files.
If you have deleted your Excel files by accident or lost them unknowingly, there are also other 3 ways to get them back.
The most direct and easiest way to recover deleted Excel files is to looking for them in the Trash. All files in the Trash remain there until the folder is emptied, which can happen either automatically after 30 days or manually.
Step 1: Double-click the icon to open Trash.
Step 2: Search for and locate the Excel file you want to recover. Right-click it and select Put back to restore it.
Time Machine is another option to recover deleted/lost Excel files on Mac. But you need to note that this method works only if you have the corresponding backup data of the lost Excel files.
Step 1: Connect your Time Machine backup disk to your Mac.
Step 2: Open the folder that contained the deleted Excel file. Click the Time Machine icon in the Menu Bar and choose Enter Time Machine.
Step 3: Browse all the files using the Timeline or Up and Down arrows to find the Excel file you need exactly. Select and click Restore.
Finally, you could use online backup service to recover deleted Excel file if you have backed them up via iCloud, Google Drive, Onedrive, etc.
Recover Deleted Excel File on Mac with iCloud
Recover Deleted Excel File on Mac with Google Drive
Recover Deleted Excel File on Mac with OneDrive
If you have accidentally closed an Excel file without saving it on Mac or deleted it by mistake, or Mac shutting down causes your Excel files to get lost, don't panic yet. After reading the guide, you now learn about various methods to recover unsaved/deleted Excel files, among which AnyRecover for Mac is probably the best choice as it provides an all-in-one solution to get the job done efficiently. Try it and gets back your lost Excel files in an instant!
By Simon Marcus , to Document Recovery
Updated: Jul 19, 2021