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.
Create a PDF file of your spreadsheet and optionally password-protect it
- Choose Share > Export and click PDF.
- Choose an image resolution from the Image Quality pop-up menu.
- Choose which sheets to export from the Layout pop-up menu.
- Click the Security Options disclosure triangle to password-protect the PDF.
- Click Next to specify a name and location for the PDF.
- Click Export to create the PDF.
Good: Images are downsampled to 72 dpi.
Better: Images are downsampled to 150 dpi.
Best: Images aren’t scaled down.
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.
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.
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
- Choose Share > Export, and then click Excel. 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.
- Choose File > Save As, select “Save copy as,” and choose Excel Document from the pop-up menu.
Some of the formula calculations may differ in Excel.
Create a file of your spreadsheet for applications that can open CSV files
- Choose Share > Export.
- Click CSV.
- Choose an option from the Text Encoding pop-up menu.
- Click Next to specify a file name and location.
- Click Export to create the file.
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.