How to Recover Numbers File on Mac 2024 (Unsaved, Disappeared, Deleted)

avatar
Connie Yu
Updated on November 27, 2024 Preview 27.3K Preview 1
share it facebook share it Twitter

As a Microsoft Excel alternative, the canvas-style Apple Numbers provides an unique way to create spreadsheets or organize data. Mac users rely more and more on this tool, however, they face challenges from time to time. The most common examples of challenges includes: leave a Numbers file unsaved, Numbers spreadsheet goes disappeared, or accidentally delete the document.

In response, here we will walk you through several ways to recover a Numbers file on Mac, no matter you has a backup or not, or how the file is lost.

 

How to Recover Unsaved Numbers File on Mac?

When we were editing a Numbers file on Mac, the program may crash or you had a power failure unexpectedly, then the Numbers file was left unsaved. There is no pain quite like the one of losing your hours of work in Apple Numbers, especially you add a lot of data, formulas, tables... 

But don’t worry, there are several ways you can try to recover an unsaved Numbers file on Mac.

Method 1: The Easiest Way to Recover Unsaved Numbers Spreadsheet

Do you want to regain a quick access to an unsaved Numbers spreadsheet with ease? Using a dedicated data recovery program brings in a higher-rate recovery in a shorter time. 

Cisdem Data Recovery for Mac  is a trustworthy program to recover all kinds of files (iWork Pages, Numbers, Keynote) from all major Mac-supported storage devices, such as USB drive, HDD, SSD, digital camera, SD card, CF card, MP4 player and more. This highly rated and dependable tool provides professional recovery solutions for data loss under different situations: deletion, format, system crash, virus attack, power off, system update or downgrade, human error, etc. And it has the iCloud mode to recover files directly from your iCloud backup.

Why Cisdem Data Recovery for Mac?

  • Support 1000+ file recovery: video, audio, image, document, archive, email, etc.
  • Recover files from both internal and external storage devices
  • Apply to virtually all data loss scenarios: deletion, formatting, corruption, system crash, software/hardware failure, etc.
  • Recover files from iCloud
  • Find and retrieve unsaved documents
  • Repair damaged videos, photos and even documents
  • Recover files from crashed Mac
  • Preview files before recovery process
  • Fast scanning, easy file filtering, high recovery rate
  • Additional features: disk backup, installer creation, quick access to files, etc.

Steps to Recover Unsaved Numbers Spreadsheet on Mac

  1. Download and install Cisdem Data Recovery on your Mac, then launch it.
    Free Download macOS 10.9 or later
  2. Select the location.
    Go to Hardware Disk, choose the location where you left the Numbers file unsaved on your Mac.cisdem data recovery 01
  3. Scan unsaved Numbers file on Mac.
    Click "Search for lost files" to start the scanning. Then go to Type > Unsaved Files, find the unsaved Numbers spreadsheet files. Also you go to Type > Documents > Numbers and check if the unsaved spreadsheet is listed there. cisdem data recovery 02
  4. Preview and recover Unsaved Numbers spreadsheet on Mac.
    Once the scanning finishes, double click on the Numbers file to preview, then click "Recover" button to get the deleted or unsaved Numbers file back.cisdem data recovery 03

 

Method 2: Recover Unsaved Numbers File from Mac AutoSave

As you may have heard, macOS comes with a powerful feature called AutoSave, helping users to auto save the documents under editing. This feature works particularly perfect on saving Apple-proprietary documents, such as Preview files, iWork files, etc., which includes Numbers spreadsheet.

By default, this AutoSave feature is ON, you can go to System Preferences > General, check if the box before "Ask to keep changes when closing documents" is ticked or unticked. If ticked, the AutoSave feature is ON.check autosave feature

Steps to recover unsaved Numbers file with AutoSave:

  1. Click on Finder app, go to Go from the menubar.recover numbers autosave 01
  2. Type Users/username/Library/Containers/com.apple.iWork.Numbers/ and press Enter.recover numbers autosave 02
  3. Then go to Data > Library > Autosave Information and check if your unsaved Numbers file is present here.recover numbers autosave 03

 

Method 3: Recover Unsaved Numbers Document from Temporary Folder

If you still cannot find the unsaved Numbers document back, you will need to check if the file is saved in Temporary Folder.

  1. Go to Finder > Applications > Utilities.
  2. Run Terminal on your Mac.
  3. Input "open $TMPDIR" in Terminal, then press "Enter". 

recover from temp folder

  1. Find the Numbers document you leave unsaved on Mac, then open and save the file.

 

Numbers Spreadsheet Disappeared? Why and How to Recover?

Another situation is that you believe your Numbers spreadsheet has been saved onto your Mac, but you just can’t find them. Why has the Numbers spreadsheet disappeared from our Mac? Here are the possible reasons:

  • The Numbers file has been moved to other folders
  • The Numbers file is untitled 
  • The Numbers spreadsheet is hidden due to virus attack
  • The Numbers document is deleted by anti-virus software by mistake
  • Defective hardware issues
  • Human errors such as mistakenly delete

Basing above, you should check your Mac health with an anti-virus application and make sure it is configured properly. Also, you can recover a disappeared Numbers file as follows.

Solution 1. Find from Recent List

Recently opened Numbers files will be showed in the Recent List, if your Numbers disappear, check the list and recover.

  1. Open Numbers app > choose File and then Open Recent from the top of your Mac screen.open recent numbers 01
  2. Numbers will show the last ten documents you opened recently. Choose the spreadsheet you’re looking for and open it.
  3. Then go to File > Save and store this file to a preferred location on your Mac.open recent numbers 02

 

Solution 2. Search Untitled Numbers File

Maybe you have saved the file, but didn’t give it a name and thought it disappeared. All the files that do not have a file will be named as Untitled, you can search on your Mac with the keyword Untitled and recover a missing Numbers file.

  1. Press Command + F to open the spotlight tool.
  2. Enter Untitled in the search box, also choose Kind as Other > Numbers.recover disappeared numbers 01
  3. Then all the untitled Numbers files will be showed up, click on the file name and check where it is saved.recover disappeared numbers 02

 

How to Recover Deleted Numbers File on Mac?

In the case that your Numbers document are deleted from the Mac, there are 4 ways to recover it, no matter it is recently or permanently deleted, no matter if you have a backup or not.

Method 1. Recover Deleted Numbers File on Mac from Trash Bin

As we all know, when we delete a file on Mac, the file is just moved to the Trash bin, it is still there on our Mac.

  1. Go to Trash bin. 
  2. Click on the following toolbar to find your Numbers file by name, kind, date or others. mac trash find01
  3. Right click on the file, choose "Put Back" to recover deleted Numbers file from your Mac Trash bin. mac trash find02

 

Method 2. Recover Deleted Numbers File from iCloud Backup

If you have signed into iCloud account on your Mac and have the habit of backing up files to iCloud Drive regularly, then you can restore a deleted Numbers spreadsheet via iCloud Backup. 

  1. Sign into https://www.icloud.com/.
  2. Open Drive or Numbers app that stores the backup of the deleted Numbers file.recover numbers icloud 01
  3. Select the backup Numbers spreadsheet, then click the 3-dot icon to download a copy to your Mac. recover numbers icloud 02
  4. If you cannot find the backup file, check the Recently Deleted folder, click the 3-dot icon and Restore.recover numbers icloud 03

 

Method 3. Recover Deleted Numbers File from Time Machine Backup

You can also use Time Machine to recover the deleted Numbers document, as long as you’ve set up Time Machine backup on your Mac.

  1. Connect the Time Machine backup drive to the Mac.
  2. Click the Time Machine icon and Enter from the menu bar.enter time machine
  3. Go to the folder that you once stored the deleted Numbers files, select a backup version from timeline.select backup version
  4. Select the deleted Numbers file, choose a version and click Restore.restore numbers time machine

 

Method 4. Recover Deleted Numbers File without Backup

If you don’t have an iCloud backup or a Time Machine backup, Cisdem Data Recovery will be an ultimate tool to recover permanently deleted Numbers file without backup.

  1. Download and install Cisdem Data Recovery on your Mac.
    Free Download macOS 10.11 or later
  2. Select the drive where you deleted the Numbers file, click on Search for lost files.recover deleted numbers cisdem 01
  3. Then go to Type > Documents > Numbers, or you can search or filter files quickly with the built-in tools.recover deleted numbers cisdem 02
  4. Select the Numbers files, double click to preview and click Recover button to regain your access to the deleted files.recover deleted numbers cisdem 03

Bonus: Steps to Recover Numbers Spreadsheets from iCloud in Cisdem

In the case that you have backed up and synced the Numbers spreadsheets to your iCloud, Cisdem lets you recover from iCloud account or iCloud directory.

  1. Go to Data Recovery, choose iCloud and choose an option, then click Next.recover numbers icloud cisdem 01
  2. Sign in to iCloud by entering user name and password.recover numbers icloud cisdem 02
  3. Select iCloud Drive and Numbers category, then click Next.recover numbers icloud cisdem 03
  4. All the recovered Numbers files will be displayed in Cisdem, including files from Browse and Recently Deleted Folder. recover numbers icloud cisdem 04
  5. Preview the Numbers spreadsheet, select and click Recover button. recover numbers icloud cisdem 06

 

FAQ about Numbers File Recovery

Where are Numbers Files Stored on Mac?

Numbers files can be stored anywhere on your Mac, because you are allowed to choose the location when creating a new Numbers file.

numbers location

 

Where is The Spreadsheet Manager in Numbers?

The spreadsheet manager only shows when you create a new file.

  1. Launch the Numbers app on Mac.
  2. Click New Document.spreadsheet manager 01
  3. Then find the spreadsheet manager on the left panel. If you have already opened a spreadsheet, go to File > New to open the manager.spreadsheet manager 02

 

How to recover deleted Numbers files on iPhone or iPad?

On iPad or iPhone, there is no Trash bin available for us to store the removed files, but the application - Numbers for iPad/iPhone itself provides the space to store deleted files for some time.

  1. Open Numbers file on your iOS device.
  2. Tap "Document" and find the "Location list" in the left column.
  3. Tap "Recently Deleted".ipad trash
  4. Tap "Select" to choose the deleted Numbers file you want to recover, then tap “Recover” to restore the deleted Numbers Spreadsheet on iPad/iPhone. 

 

How to restore an earlier version of Numbers Spreadsheet?

Numbers allows users to browse all versions of a file and revert to an earlier one if you have make some changes to the same file.

  1. Open the Numbers file in Numbers app.
  2. Go to File > Revert To > Browse All Versions.restore previous numbers01
  3. Select an earlier version and click Restore.restore previous numbers02

 

How to undo delete in Numbers?

If you delete some data in a Numbers spreadsheet and want to undo the delete action before closing the file, here is how:

  1. Go to Edit > Undo Delete.undo delete numbers
  2. Repeat this until all the deleted data is back.
  3. Then go to File and Save the document.

 

Conclusion

In a nutshell, even though we accidentally delete or lost a Numbers file, there are professional tools and free native methods to get them back, even it is possible to restore an unsaved Numbers document. But as always, the best way is finding an expert, such as Cisdem Data Recovery.

avatar
Connie Yu

Connie Yu has been a columnist in the field of data recovery since 2011. She studied a lot of data loss situations and tested repeatedly to find a feasible solution tailored for each case. And her solutions are always updated to fix problems from the newest systems, devices and apps.

Loved the article, share!
Comments (1) Leave a Reply

Name *

Comment *

  • Echo

    I lost one important Numbers spreadsheet from my iPhone. FoneLab recommended here helps me out. Many thanks!

    1 years ago commonReply

    Name *

    Comment *

Hot Articles

How to Recover Data (Deleted Photos) from xD Card iBoysoft Mac Data Recovery Review: Pros, Cons and How to Use 4 Ways to Recover Deleted Videos from Android without Root/Computer
Home > How to Recover Numbers File on Mac 2024 (Unsaved, Disappeared, Deleted)