Use iCloud with Numbers on Mac
When iCloud Drive is turned on for your device, it stores your spreadsheets and keeps them up to date on your computers, iOS devices and iPadOS devices that are signed in with the same Apple ID. You always see the latest versions of your spreadsheets, no matter where you made your last edits.
For seamless syncing of spreadsheets, use iCloud Drive and devices that meet these minimum system requirements: macOS 11, iOS 14 or iPadOS 14. On your iPhone or iPad, items stored in iCloud Drive appear in the spreadsheet manager.
You can also use Numbers for iCloud to create and edit Numbers spreadsheets using a supported web browser on a Mac or Windows computer.
Set up iCloud Drive on your Mac
Choose Apple menu > System Settings (or System Preferences), then do one of the following:
If you’re already signed in on your Mac with an Apple ID: Click Apple ID (to the right of your name).
If you’re not signed in with an Apple ID: Click Sign In, enter your Apple ID and password, then follow the instructions.
If you don’t have an Apple ID: Click Create Apple ID to get one, then sign in.
Important: If you forget your Apple ID or its password, you can recover it on the Apple ID website. Though you can have more than one Apple ID, it’s not recommended. Purchases made using one Apple ID can’t be merged with those made using another Apple ID.
Select the iCloud Drive tickbox.
With macOS Catalina 10.15 or later, if you can’t see the tickbox, click iCloud in the column on the left.
Click Options next to the iCloud Drive tickbox, then select the Numbers tickbox.
When iCloud Drive is turned off for Numbers on your Mac, new spreadsheets you create or edits you make aren’t saved to iCloud. Similarly, new spreadsheets you create or edits you make to spreadsheets on your devices or on your other computers aren’t available in Numbers on your Mac.
Open the Numbers for iCloud web app
Spreadsheets you create using Numbers for iCloud are automatically available in Numbers on your Mac, iPhone and iPad that are set up to use iCloud and use the same Apple ID. Similarly, if you create a spreadsheet using Numbers on iPhone, iPad or a Mac, the spreadsheet appears automatically in Numbers for iCloud.
Make sure you’re signed in with your Apple ID and are using iCloud Drive. To check, do one of the following:
macOS Ventura 13 or later: Choose Apple menu > System Settings > Apple ID > iCloud Drive, click Options, then make sure the Numbers tickbox is selected.
macOS 12 or earlier: Choose Apple menu > System Preferences > Apple ID, click Options next to the iCloud Drive tickbox, then make sure the Numbers tickbox is selected. (If you don’t see Options, make sure the iCloud Drive tick box is selected.)
On your Mac or Windows computer, go to iCloud.com, then sign in using the same Apple ID.
See Numbers for iCloud Help for more information about using Numbers for iCloud.
Tips for managing spreadsheets across devices
Here are a few things to keep in mind about using iCloud to manage your spreadsheets across devices:
If you edit and then close a spreadsheet when you’re not connected to the Internet, you see a cloud icon next to the spreadsheet thumbnail in the Open dialogue on your Mac. The next time you connect to the Internet, the edited spreadsheet is saved in iCloud Drive.
If you edit a spreadsheet on multiple computers or devices and don’t allow time for your edits to sync, you will see conflicts. If you do get a conflict, you can choose to preserve any or all of the versions. (This applies only to spreadsheets not shared with others.)
If you delete a spreadsheet that someone shared with you, it’s deleted from your iCloud Drive and from Numbers on all your devices. You can click the shared link again to add the spreadsheet back to your iCloud Drive, where it’s again available on all your computers and devices with iCloud turned on.
If you use folders to organise your spreadsheets on one device, the same folder organisation applies on all your devices.
If you add a password to a spreadsheet on one device, it’s required to open the spreadsheet on all your devices.