Importing spreadsheets
The import spreadsheet tool imports comma-separated value
(CSV) and tab separated value (TSV) files that have been created with
packages such as Microsoft Excel
or Microsoft Access.
Before you begin
About this task
When a spreadsheet
is imported into a module, an object is created for each line of data
in the file. You can use an attribute list or column labels to assign
data in the file to attribute values in the module. If the attributes
do not exist, the tool creates them. The attribute types are normally
derived from the type of data found in the columns. Alternatively,
you can choose the type you want from a list of defined types.
- If you use an attribute list, you create a list of existing attributes that correspond with the columns in the file you want to import. The attribute types must be appropriate for the data in each column, or the import fails. If there are empty fields, the default attribute value is assigned by the importer.
- If you use column labels, the contents of the fields in the first
line are interpreted as the column labels. The column labels determine
the attribute that is used for each column. Note: The first column in the spreadsheet must have a column label, otherwise the attributes are not allocated correctly by the importer.
Data items in a CSV or TSV file can have integer, real, date, or string values. Strings are typically contained within quotation marks, and can contain commas, tabs, and line breaks. Quotation marks can be imported if they are duplicated. For example, looking at the CSV file with a text editor, the string: "This string has a comma, which is not imported and a quotation mark "" too" is imported as: This string has a comma which is not imported and a quotation mark " too .
Procedure
- Click .
- Select the file that you want to import and the options that you want to apply. For more information about the import options, click Help.
- Click Import.