1 Recover Unsaved/Lost/Deleted Excel File on Mac with AnyRecover. AnyRecover for Mac is a great tool developed by iMyFone company to help users recover useful data from their Mac. If you've mistakenly deleted your excel file, you can recover that file using this power tool. It has a unique data recovery algorithm that makes it easy to recover any excel file with just a few clicks. With Microsoft 365, work within an Excel file from mobile, desktop, and web. 2 Make analog spreadsheets digital with a camera click You now can add data to Excel directly from a photo.
- Recover Excel File Mac
- Excel File Format Or Extension Not Valid
- Download Excel Files
- Excel Files For Tableau
- Excel Files For Mac Versions
Program crash or sudden Mac shutting down can cause the unsaved or saved Excel files loss. When the accident happens, do not worry. You can recover the unsaved Excel files on Mac from Temporary or AotuoRecover folder. If you need to recover the permanently deleted or lost Excel files, you can use EaseUS Data Recovery Wizard for Mac to do it effectively.
This page offers 3 reliable methods to help you recover unsaved Excel file on Mac. If you happen to lose unsaved excel file or deleted it by mistake on Mac, stay calm and pick up any method to bring your lost excel file back now:
| Workable Solutions | Step-by-step Troubleshooting |
|---|---|
| Method 1. Recover TMP Folder | Go to 'Applications' > 'Utilities' > 'Terminal' > Type $TMPDIR and hit Return...Full steps |
| Method 2. Recover from AutoSave | Go to 'Applications' >' Utilities' > 'Terminal' > Type 'defaults write com.apple.Finder...'...Full steps |
| Method 3. Use Recovery Software | Run EaseUS file recovery software > Scan device > Recover deleted or lost excel...Full steps |
On the whole, Excel files may get lost due to the program crash, Mac shutting down unexpected, accidental deletion, hard drive formatting, or virus attack. If the Excel files already gone are unsaved, you can use the two solutions in Part 1 to recover them in large part. While if you have mistakenly permanently deleted the Excel files or the saved documents are disappeared caused by other reasons, there is no way but use professional and free data recovery software - EaseUS Data Recovery for Mac recommended in Part 2 to get them back. Read on and see the details.
Part 1. How to Recover Unsaved Excel File on Mac
How many of you have ever met this problem that the Excel is suddenly stuck and fails to respond to Mac? Then you have to follow the instruction to close the program and lose the unsaved file you have been working on for a few hours unsurprisingly. And the unexpected Mac shutting down can also bring the same result. Whatever led the accident, you have a chance to recover Excel file not saved on Mac.
Method 1. Restore Unsaved Excel File from the Temporary Folder
Follow steps provided below to restore unsaved Excel file on Mac from Temporary/Temp folder.
1. Go to 'Applications' > 'Utilities' > 'Terminal'.
2. Type open $TMPDIR and press 'Return' to open the Temporary files folder. Select the folder named 'TemporaryItems'.
3. Find the unsaved Excel file under 'TemporaryItems' and restore.
Method 2. Recover Lost or Unsaved Excel File from AutoSave on Mac
Excel provides you with useful features as AutoSave and AutoRecover to protect file after an accident, like Excel/Mac crash or closure.
- AutoSave: It automatically saves a new Excel document that has been created but not saved yet.
- AutoRecover: It can help users retrieve unsaved Excel files on Mac.
If the two are enabled, you can probably make unsaved file recovery on Mac in Excel 2016 - 2010. Because the AutoRecovery file has been hidden, you need to make it visible to recover unsaved Excel file.
1. Go to 'Applications' >' Utilities' > 'Terminal'.
2. Type defaults write com.apple.Finder AppleShowAllFiles true into Terminal and hit 'Return' to make all the items visible.
3. Click 'Finder' > press 'Return' on your Mac.
4. Type /Users/username/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery and click 'Go' to open Excel's AutoRecovery folder.
5. Find the unsaved spreadsheet files. Then recover it to another safe location on Mac.
Part 2. How to Restore Deleted/Lost Excel File on Mac in 3 Steps
You may get the unsaved Excel file back with the above two approaches. But you can't use them to recover lost Excel file from due to accidental deletion, hard drive formatting, system crash, or storage device corruption. Then, what to do at this kind of circumstances? Don't worry. Here comes EaseUS Mac File Recovery Freeware. As a leading data recovery tool, it allows you to do Office document recovery, email recovery, photos recovery, as well as other data recovery.
Now, install it and follow the following tips to restore deleted or lost Excel file on Mac in 3 simple steps.
Step 1. Select the location where your important Excel files were lost and click Scan button.
Step 2. EaseUS Data Recovery Wizard for Mac will start immediately a quick scan as well as a deep scan on your selected disk volume. Meanwhile, the scanning results will be presented in the left pane.
Step 3. By Path and Type, you can quickly filter the Excel files you've lost earlier. Select the target files and click Recover Now button to get them back at once.
After this, you'll get the lost Excel file back and continue your job with the file again. You can also apply this Mac data recovery software to restore deleted photos, music, videos or other data on Mac for free.
'How to recover unsaved Excel file on Mac? I spent more than 6 hours to collect the names of our club. But I clicked 'Don't Save'. OMG! I can't lose it!'
It would be so terrible if you found that the excel file was not saved on Mac. Devastated? No, you don't have to be! Here're 6 ways that can help you get out of the woods. You are lucky!
Now let's go through the methods to recover unsaved Excel file on your Mac book.
Part 1. Effectively Recover Unsaved Excel File to Mac via AnyRecover
Firstly, I'd like to introduce a convenient and reliable software - AnyRecover. It's able to scan and find the excel files that are lost for various reasons, such as Mac crashes, Microsoft Excel crashes, and accidental deletion, etc.
With it, recovering deleted file on Mac is merely a click-through mission. What? You say your excel file is permanently deleted? Don't worry, it even allows you to recover deleted files from emptied trash on Mac.
And it's fabulous that AnyRecover is compatible with all versions of Excel documents, such as excel 2003, 2007, 2010, 2013, 2016. Next, follow the specific steps for how to use it:
Step 1. Download and install AnyRecover to your Mac, then select 'All-Around Recovery' on the home page.
Step 2. Select the location you want to search for, and then click 'Next' in the lower right corner.
Step 3. Select the 'Document' file type and click the 'Scan' button.
Step 4. All files that match the search criteria will be displayed in chronological order on the interface. If the unsaved Excel file is not displayed, you can click on 'Deep Scan' in the lower-left corner to find more.
Step 5. You can double-click a file to preview its content. Then select the Excel file you want to restore and click 'Recover' button.
Tip: don't save the recovered Excel file to the location where it was lost.
Recover Excel File Mac
AnyRecover is not only capable of retrieving Excel document that not saved on Mac but also can quickly recover unsaved PPT on Mac, retrieve Word document Mac, and retrieving deleted photos from Mac.
Any methods to recover unsaved Excel without software? Of course, check out the following solutions.
Part 2. Recover Excel File Not Saved Mac from Trash Bin
Before you dive into not-so-easy methods for recovering unsaved Excel files Mac, don't forget to check the Trash folder to see if your Excel document still lies in it. The Trash folder will save your deleted files for 30 days and then automatically clear them up.
Step 1. Open the Trash Bin on Mac desktop to see if there are the lost file.
Step 2. Find and select the Excel file you want to restore. If there are too many files, you can do a targeted search through the search box in the top left corner.
Step 3. You can drag the file to a specific location or right-click to select 'Put Back' to recover it to its original location.
Part 3. Recover Unsaved Excel Mac in Recent Workbooks
If you did not manually delete the Excel document, you may not be able to find unsaved files in the trash folder. But you may find it in the Recent Workbooks.
Here are specific steps on how to recover unsaved Excel files for Mac
Step 1. Open Microsoft Excel to click 'File' and select 'Open'.
Step 2. Now click 'Recent Workbooks'.
Step 3. Then select the 'Recover Unsaved Workbooks' at the bottom of the list.
Step 4. Find the unsaved file in this folder.
Step 5. Double-click the unsaved Excel document (or right-click it and select 'Open').
Step 6. Click the 'Save As' button in the open Excel to save it to a particular location.
Part 4. Recover Lost Excel File Mac from Temporary Folder
Additionally, you can try your luck to find the Excel document not saved Mac in the Temporary folder. Excel is smart. Even if the user does not click the 'Save' tab, Excel still temporarily saves the content that a user has deleted, moved, and copied.
Step 1. On your Macbook, go to 'Applications' and select the 'Utilities', and then open 'Terminal' next.
Step 2. When the 'Terminal' opens, type 'open $ TMPDIR' and press 'Enter'
Step 3. After that, the 'Temporary' folder will appear. Next, click to open 'Temporaryitems' folder.
Step 4. Select the folder named 'Temporaryitems'. Under it, find the Excel file you want to restore.
Part 5. Restore from Excel Autosave Location in Mac
Excel files are lost due to Mac system crash, accidental deletion, Microsoft Excel crash? Check the AutoRecover folder! AutoRecover Excel on Mac is enabled by default, saving a file every 10 minutes.
Therefore, for files that have been saved once, you can retrieve the edited content of the lost excel. Next, let's see how to recover Excel file not saved Mac in the AutoRecovery folder.
Open the 'Finder'.
Locate the AutoRecovery folder according to the following path.
Go to: /Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/
Open, save, and recover unsaved excel file to another folder on Mac.
Part 6. Recover Excel File on Mac via Restore to Old Version
This method retrieves the new unsaved Excel document by restoring to a previous version. (This method only supports Excel 2010 and 2013)
The steps on recovering lost Excel files Mac:
Step 1. Select 'Info' from the 'File' tab.
Step 2. There are all auto-saved versions of Excel document next to the 'Manage Versions' button of the interface. The name of each version contains the date, time, and comment.
Step 3. Double-click to open the Excel file you want to recover, then click the 'Restore' button in the yellow bar.
Tips: Set Up Excel Automatic Save Frequency
For later use (recovery of Excel files on Mac), you can set up a more frequent 'automatic save'. Follow the steps below:
Step 1. Click 'FILE' in Excel and select 'Options' from the drop-down menu
Step 2. Click 'Save' in the 'Excel Options' dialog.
Step 3. Make sure to save the auto-recovery info every X minute and change the save location.
Excel File Format Or Extension Not Valid
Step 4. Click 'OK' to confirm the change
.
Download Excel Files
The Bottom Line
This article introduces the top 6 ways to recover Excel file not saved on Mac. The first method is efficient but requires installing software. And the others work for different cases. Recall how you lost your excel files and pick the most appropriate workaround.
Excel Files For Tableau
In addition, I sincerely recommend you always click on the 'Save' button before you leave your Mac computer so that your Excel edits won't be lost.
Excel Files For Mac Versions
If you have any better ways or methods, please leave a message and share with us. Thanks very much!