Import and export different file formats with Numbers

Learn which file formats you can use with Numbers, how to open them, and how to convert your Numbers spreadsheet into another format.

Numbers for iOS

Numbers for iOS lets you open, work on, and share your spreadsheets or graphs from your iPhone, iPad, or iPod touch, even if you worked on them outside of Numbers.

Numbers for iOS can open

  • All Numbers versions
  • Microsoft Excel - Office Open XML (.xlsx) and Office 97 or later (.xls)
  • Comma Separated Values (CSV)
  • Tab-delimited text files
     

Numbers for iOS can export

  • Microsoft Excel (.xlsx only)
  • PDF
  • Comma Separated Values (CSV)
     

Open a file in Numbers for iOS

You can open a file in the Numbers for iOS app on your iPhone, iPad, or iPod touch by selecting a file from the spreadsheet manager when the app opens. To open a file from a different app, go to that app and select the attachment. When it opens, tap the file and then tap Share icon. Tap Copy to Numbers. 

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 for iOS.

Export a file with Numbers for iOS

A spreadsheet in Numbers for iOS remains as a .numbers file until you want to send it. Follow these steps to send a spreadsheet in a specific file format:

  1. Open the spreadsheet, then tap More icon.
  2. Tap Export.
    Numbers for iOS More screen
  3. Choose a format for your spreadsheet.
  4. Choose how you want to send your spreadsheet (for example, Mail or Messages).
  5. Complete the sending process you selected.

Numbers for Mac

Numbers for Mac makes it easy to import and work with your files, even if you worked on them outside of Numbers.

Numbers for Mac can open

  • All Numbers versions
  • Microsoft Excel - Office Open XML (.xlsx) and Office 97 or later (.xls)
  • Comma Separated Values (CSV)
  • Tab-delimited text files
     

Numbers for Mac can export

  • Numbers ’09
  • Microsoft Excel (.xlsx and .xls)
  • PDF
  • Comma Separated Values (CSV)

Open a file in Numbers for Mac

To import any spreadsheet file from Finder, right-click on the file, then click "Open with... > Numbers." If Numbers is the only spreadsheet application on your Mac, you can simply double-click.

If you are already in the Numbers for Mac app, choose File > Open, then click on the file you want to work on. If a file is grayed out, it isn't in an acceptable format.

After you import the file, you might see warnings. Learn more about warnings you might see when you open spreadsheets created in older versions of Numbers.

Export a file with Numbers for Mac

  1. Make sure you have the file you want to export open in Numbers.
  2. Choose File > Export To, then select the format.
  3. From the Export Your Spreadsheet window, you can choose a different format or set up any additional options. For example, you can select Image Quality for a PDF, or save as an older file format of Excel. With some formats, you can also password protect your file.
    Numbers Export screen
  4. Click Next. 
  5. Enter a name for your file and select a folder to save it to.
  6. Click Export.

Make sure you save your file before closing. If you make any changes after exporting the file to a different format, they only appear in the Numbers file you are working in.

You can also click Share > Send a Copy to send a file in a specific format through Mail, Airdrop, Notes, Messages, or Reminders.

Numbers for iCloud

Numbers for iCloud lets you open, work on, and share your files from any Mac or PC on the Web.

Numbers for iCloud can open

  • All Numbers versions
  • Microsoft Excel - Office Open XML (.xlsx) and Office 97 or later (.xls)
  • Comma Separated Values (CSV)
  • Tab-delimited text files
     

Numbers for iCloud can export

  • Microsoft Excel (.xlsx only)
  • PDF
  • Comma Separated Values (CSV)
     

Upload a file to Numbers for iCloud

If you have a file that you want to save to iCloud, and you don't want to turn on iCloud Drive on that Mac or PC, you can upload it through iCloud.com.

  1. Sign in to your iCloud account at iCloud.com.
  2. Click Numbers.
  3. Drag the file you want to upload into the spreadsheet manager, or click Upload to iCloud icon.
  4. Locate the file on your Mac or PC. Click Choose.
  5. Your file will appear in Numbers for iCloud.

Download a copy of a file from Numbers for iCloud

  1. Sign in to your iCloud account at iCloud.com.
  2. Click Numbers.
  3. Right-click on the spreadsheet you want to download, or click iCloud More icon, then choose Download a Copy.
  4. Click on the download format. The file will start downloading.

Learn more

  • Numbers for Mac (3.0 and later) and Numbers for iOS (2.0 and later) use the same file format. Spreadsheets created or edited in Numbers on one platform can open in Numbers on 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 on your Mac, use the App Store app on your Mac.

Information about products not manufactured by Apple, or independent websites not controlled or tested by Apple, is provided without recommendation or endorsement. Apple assumes no responsibility with regard to the selection, performance, or use of third-party websites or products. Apple makes no representations regarding third-party website accuracy or reliability. Risks are inherent in the use of the Internet. Contact the vendor for additional information. Other company and product names may be trademarks of their respective owners.

Published Date: