You can convert and open spreadsheets in Numbers on iPhone, iPad, Mac, or online at iCloud.com.
Convert and open spreadsheets in Numbers on iPhone or iPad
You can work with a variety of file formats in Numbers on your iPhone or iPad. Check which formats are compatible with Numbers on iPhone and iPad.
Convert a Numbers spreadsheet in Numbers on iPhone or iPad
If you want to open a Numbers spreadsheet in another app like Microsoft Excel, use Numbers to convert the spreadsheet into the appropriate format.
- In Numbers, open the spreadsheet that you want to convert.
- On iPhone, tap the More button
. On iPad, tap the spreadsheet name in the toolbar. If the spreadsheet name is not shown in the toolbar, tap the More button.
- Tap Export.
- Choose a format for your spreadsheet. For example, to open your Numbers spreadsheet in Microsoft Excel, choose Excel.
- Choose any additional options in the window that appears. For example, when exporting to Excel you can choose whether to create a worksheet for each table or for each sheet. If you create a separate worksheet for each table, you can choose whether to include a summary worksheet with links to all the tables.
- Choose how you want to send your file, like with Mail or Messages. Or to save the file on your device or to iCloud Drive, choose Save to Files, then choose a location.
Open a file in Numbers on your iPhone or iPad
To open a file like an Excel spreadsheet on your iPhone or iPad, tap the file in the spreadsheet manager. If you don’t see the spreadsheet manager, tap the Back button , then tap the file that you want to open. If a file is dimmed, it’s not in a compatible format.
You can also open a file in Numbers from a different app like the Files app, or from an email:
- Open the other app, then select the spreadsheet or attachment.
- Tap the Share button
.
- Tap Copy to Numbers. The original file remains intact.
After the file opens, you might get a message that the file was last edited in an app other than the most recent version of Numbers. Tap Done to open the file in Numbers.
When you open an Excel file with a pivot table in Numbers 11.2 or later, the pivot table might look different in Numbers than it does in the Excel file.
Convert and open spreadsheets in Numbers for Mac
You can work with a variety of file formats in Numbers for Mac. Check which formats are compatible with Numbers for Mac.
Convert a Numbers spreadsheet in Numbers for Mac
If you want to open a Numbers spreadsheet in another app like Microsoft Excel, use Numbers to convert the spreadsheet to an appropriate format.
- In Numbers, open the Numbers spreadsheet that you want to convert.
- Choose File > Export To, then select the format.
- In the window that appears, you can choose a different format or set up any additional options. For example, you can require a password to open an exported PDF, or choose the format for an exported Excel spreadsheet.
- Click Next.
- Enter a name for your file and select a folder to save it to.
- Click Export.
Open a file in Numbers for Mac
You can open a file from the Finder or from the Numbers app:
- From the Finder, Control-click the file, then choose Open With > Numbers. If Numbers is the only spreadsheet app on your Mac, you can just double-click the file.
- From the Numbers for Mac app, choose File > Open, select the file, then click Open. If a file is dimmed, it’s not in a compatible format.
When the file opens, you might get a message that the spreadsheet will look different. For example, Numbers notifies you when fonts are missing. You might see also see warnings when you open spreadsheets created in older versions of Numbers.
When you open an Excel file with a pivot table in Numbers 11.2 or later, the pivot table might look different in Numbers than it does in the Excel file.
Convert and open spreadsheets in Numbers for iCloud
Numbers for iCloud lets you open, edit, and share your files from a supported browser on a Mac or PC. Check which formats are compatible with Numbers for iCloud.
Convert a Numbers spreadsheet in Numbers for iCloud
- Sign in to iCloud.com with your Apple ID.
- Click Numbers.
- In the spreadsheet manager, click the More button
on the file you want to convert, then choose Download a Copy. If you have the spreadsheet open, click the Tools button
in the toolbar, then choose Download a Copy.
- Choose a format for the spreadsheet. The file begins to download to your browser’s download location.
Open a file in Numbers for iCloud
- Sign in to iCloud.com with your Apple ID.
- Click Numbers.
- Drag the file you want to upload into the spreadsheet manager in your browser. Or click the Upload button
, select the file, then click Choose.
- Double-click the file in the spreadsheet manager.
When you open an Excel file with a pivot table in Numbers for iCloud, the pivot table might look different in Numbers than it does in the Excel file.
Check file format compatibility
Formats you can open in Numbers
You can open these file formats in Numbers on iPhone, iPad, Mac, and online at iCloud.com:
- All Numbers versions
- Microsoft Excel Office Open XML (.xlsx)*
- Comma Separated Values (.csv)
- Tab-delimited or fixed-width text files
Formats you can convert Numbers spreadsheets into
Numbers on iPhone or iPad:
- Microsoft Excel Office Open XML (.xlsx)*
- Comma Separated Values (.csv)
- Tab Separated Values (.tsv)
Numbers for Mac:
- Numbers ’09
- Microsoft Excel Office Open XML (.xlsx)*
- Comma Separated Values (.csv)
- Tab Separated Values (.tsv)
Numbers for iCloud:
- Microsoft Excel Office Open XML (.xlsx)*
- Comma Separated Values (.csv)
* If you need to export to Microsoft Office legacy formats like .doc, .xls, or .ppt, you can export to the current XML format instead, then open the file in the equivalent Office app to export to the older format.
Learn more
- Numbers on iPhone, iPad, Mac, and online at iCloud.com use the same file format. If you create or edit a spreadsheet in Numbers on one platform, you can open it in Numbers on any of the other platforms.
- You can update to current versions of Numbers on your iPhone, iPad, or iPod touch from the App Store. To update Numbers for Mac, use the App Store app on your Mac.
- If you convert a Numbers spreadsheet into a Numbers ’09-compatible spreadsheet, learn more about changes that happen when you export to iWork ’09.