-
In Microsoft Excel, create a spreadsheet containing your enumerated list entries.
In an authoring tool map schema, you can also import enumerated list entries into a tool map enumerated list and units of measure into a tool map unit of measure list using this procedure.
-
In Excel, select the rows containing your enumerated list entries, and click Edit > Copy.
-
In the Schema Editor, create the enumerated list type to which you want to add the list entries. For more information, see Create an Enumerated List or Create a Map Enumerated List Definition.
-
In the New Enumerated List dialog box, click Import Entries from Clipboard.
To import entries into a tool map enumerated list or map UoM list, click Import Clipboard Entries instead.
-
Verify that the default mapping between the columns in your copied spreadsheet and properties of enumerated list entries is correct. If this mapping is correct, you can skip to step 7 to import the entries.
-
If the default mapping is not correct, click the number for the column that you want to change the mapping for in the Column list. Numbering for the columns starts with zero, which is the first column in your spreadsheet.
-
In the Maps to property list, select the property that corresponds to the selected column in your copied spreadsheet.
-
When the mapping is correct, click OK to import the enumerated list entries.
-
Click OK in the New Enumerated List dialog box to save the new entries.