Numbers - Using CSV or OFX Files in a Spreadsheet

background image

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.