Numbers '09: Exporting a spreadsheet to other document formats

Summary

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.

 

Products Affected

Numbers '09

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.

  3. Choose which sheets to export from the Layout pop-up menu.

    4. 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.

  4. Click the Security Options disclosure triangle to password-protect the PDF.

    5. 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.

  5. Click Next to specify a name and location for the PDF.
  6. 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.

  2. Choose File > Save As, select “Save copy as,” and choose Excel Document from the pop-up menu.

    3. 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.

  4. Click Next to specify a file name and location.
  5. Click Export to create the file.
Not helpful Somewhat helpful Helpful Very helpful Solved my problem
Ask other users about this article
in Apple Support Communities
See all questions on this article See all questions I have asked