Open a spreadsheet in Numbers on Mac
You can open spreadsheets saved on your Mac, in iCloud Drive, on connected servers and in third-party storage providers. If you can’t open a Numbers spreadsheet, make sure that you have the latest version of Numbers from the Mac App Store. If a spreadsheet is dimmed and can’t be selected, it means the spreadsheet can’t be opened by Numbers.
You can open Microsoft Excel spreadsheets (files with a .xls or .xlsx filename extension), delimited text files or fixed-width text files into Numbers and make changes to them. See Import an Excel or text file.
Open an existing spreadsheet in Numbers
Go to the Numbers app
on your Mac.Do any of the following:
Open a spreadsheet on a Mac: For a Numbers spreadsheet, double click the spreadsheet name or thumbnail or drag it to the Numbers icon in the Dock or in the Applications folder. For an Excel spreadsheet, drag it to the Numbers icon (double clicking the file opens Excel if you have that app).
Open a spreadsheet you recently worked on: In Numbers, choose File > Open Recent (from the File menu at the top of your screen). Numbers shows up to the last ten spreadsheets you opened. Choose one to open it.
Open a spreadsheet stored somewhere other than your Mac (such as iCloud Drive): In Numbers, choose File > Open (from the File menu at the top of your screen). In the dialogue, click a location in the sidebar on the left or click the pop-up menu at the top of the dialogue, then choose the location where the spreadsheet is saved. Double click the spreadsheet to open it.
When you open a spreadsheet that uses fonts not installed on your computer, a missing font notification appears briefly at the top of the spreadsheet. To see which fonts are missing and to choose replacements, click the notification or (if the notification is no longer visible) choose Format > Font > Replace Fonts. To learn more, see Replace fonts.
You can use Font Book, available in the Applications folder on your Mac, to install fonts you purchase or download. See the Font Book User Guide for instructions.
Open spreadsheets in tabs
You can have more than one Numbers spreadsheet open at a time. When you work in multiple spreadsheets, it’s helpful to open them in tabs rather than in separate windows — that way, you can move between them by clicking the tabs in the tab bar.
On your Mac, choose Apple menu
Go to Windows, click the pop-up menu next to “Prefer tabs when opening documents”, then choose Always or In Full Screen.
This setting applies not just to Numbers, but also to documents in other applications such as TextEdit, Pages and Keynote.
Go to the Numbers app
on your Mac, then open two or more spreadsheets.Do any of the following:
View a different spreadsheet: Click the tab with the spreadsheet’s title.
Close a spreadsheet: Move the pointer over the spreadsheet’s tab, then click the
in the corner of the tab.Add an open spreadsheet to the tab bar: Drag the spreadsheet onto the tab bar.
Move an open spreadsheet out of the tab bar: Drag a tab to the side of the Numbers window to open the spreadsheet in its own Numbers window.
Note: If you already have multiple spreadsheets open in separate windows and you want to merge them into a single window with tabs, choose Window > Merge All Windows.
Close a spreadsheet
Close a spreadsheet but keep Numbers open: Click the red close button in the top-left corner of the Numbers window or press Command-W.
Close the spreadsheet and quit Numbers: Choose Numbers > Quit Numbers (from the Numbers menu at the top of your screen). All your changes are saved.
Some templates aren’t downloaded to your computer until you choose them or open a spreadsheet that uses one. If your connection is slow or you’re offline when this happens, images in the spreadsheet may appear at a lower resolution until you’re online again or the template finishes downloading.