Numbers '09: Exporting a spreadsheet to other document formats

You can share your Numbers spreadsheets on different platforms and with various applications by exporting them to a file in PDF, Excel, or comma-separated values (CSV) format.


This article has been archived and is no longer updated by Apple.

Create a PDF file of your spreadsheet and optionally password-protect it

  1. Choose Share > Export and click PDF.
  2. Choose an image resolution from the Image Quality pop-up menu.
  3. Good: Images are downsampled to 72 dpi.

    Better: Images are downsampled to 150 dpi.

    Best: Images aren’t scaled down.

  4. Choose which sheets to export from the Layout pop-up menu.
  5. Sheet View: Exports each sheet to a single page in the PDF.

    Page View:  Exports the selected sheet using the pagination currently configured in Print View. To learn about Print View, see Dividing a Sheet into Pages.

  6. Click the Security Options disclosure triangle to password-protect the PDF.
  7. Passwords are limited to 32 ASCII characters. Select one or more of the following options.

    Open Document:  Specify a password required to open the PDF.

    Print document:  Require a password to print the PDF. If you select this option, also select Open Document and specify a password.

    Copy content from the document:  Specify a password required to copy content from the PDF.

  8. Click Next to specify a name and location for the PDF.
  9. Click Export to create the PDF.

Create a file of your spreadsheet that can be opened and edited in Microsoft Excel on a Mac OS X computer or on a Windows computer

  1. Choose Share > Export, and then click Excel.
  2. Select Summary if you don’t want a summary worksheet included for multi-worksheet exports. Select Next to specify a name and location for the file, and then click Export to create it.

  3. Choose File > Save As, select “Save copy as,” and choose Excel Document from the pop-up menu.
  4. Some of the formula calculations may differ in Excel.

Create a file of your spreadsheet for applications that can open CSV files

  1. Choose Share > Export.
  2. Click CSV.
  3. Choose an option from the Text Encoding pop-up menu.
  4. Unicode (UTF-8): This option is supported by almost all applications.

    Western (Mac OS Roman) or Western (Windows Latin 1):

    These options are for applications that require them.

  5. Click Next to specify a file name and location.
  6. Click Export to create the file.
Last Modified:

Additional Product Support Information

Start a Discussion

in Apple Support Communities
See all questions on this article See all questions I have asked
United States (English)