Apple Numbers '09 - Manual (Page 30)

Here are ways to import a document:
Drag the document to the Numbers application icon. A new Numbers spreadsheet
m
opens, and the contents of the imported document are displayed.
In Numbers, choose File > Open, select the document, and then click Open.
m
You can import Address Book data to quickly create tables that contain names, phone m
numbers, addresses, and other information for your contacts. See “Using Address Book
Fields” on page 231 for instructions.
If you want to import CSV or OFX data, see “
m Using CSV or OFX Files in a
Spreadsheet” on page 30.
If you can’t import a document, try opening the document in another application and
saving it in a format Numbers can read, or copy and paste the contents into an existing
Numbers spreadsheet.
You can also export Numbers spreadsheets to Microsoft Excel, PDF, and CSV files. See
“Exporting a Spreadsheet to Other Document Formats” on page 237 for details.
Using CSV or OFX Files in a Spreadsheet
To add CSV or OFX data to an open spreadsheet:
1 Select a sheet.
2 Do one of the following:
To create one or more new tables, drag a CSV or OFX file from the Finder onto the Â
sheet’s canvas.
To add CSV or OFX data to an empty table, drag the CSV or OFX file onto the table.
Â
The data is added; additional columns are created if necessary.
To add CSV or OFX data to a table that contains data, drag the CSV or OFX file onto
Â
the table.
If the columns don’t match, choose an option from the sheet that appears. You can
cancel the import, add columns to the table, ignore extra columns, or create a new
table from the CSV or OFX data.
Opening an Existing Spreadsheet
You can open an iWork ’08 or iWork ’09 spreadsheet. To take advantage of new
features, save iWork ’08 spreadsheets in iWork ’09 format. To let iWork ’08 users access
your spreadsheet, save it in iWork ’08 format.
When you open an iWork ’09 spreadsheet that’s password-protected, you need to type
the password in the Password field before you can view the spreadsheet contents.
30 Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet