Apple Numbers '09 - Manual (Page 238)

Exporting a Spreadsheet in Excel Format
Files in Excel format can be opened and edited in Microsoft Excel on a Mac OS X
computer or on a Windows computer.
Each table is converted to an Excel worksheet, and all other objects are placed on
separate worksheets if there’s more than one table.
Here are ways to create an Excel version of your spreadsheet:
Choose Share > Export, and then click Excel.
m
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
m
pop-up menu. See “Saving a Spreadsheet” on page 32 to learn about the other options
available when using this approach.
Some of the formula calculations may differ in Excel.
Exporting a Spreadsheet in CSV Format
Many spreadsheet applications can open a file in CSV format. In a CSV file, cell values in
each row are separated by commas. Rows are separated by end-of-line characters.
Each table is placed in its own CSV file, and all the files are placed in a folder. No
graphics are exported. The last calculated values are exported.
To create a CSV version of your spreadsheet:
1 Choose Share > Export.
2 Click CSV.
3 Choose an option from the Text Encoding pop-up menu.
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.
238 Chapter 11 Sharing Your Numbers Spreadsheet