You can import component data from an .xlsx file format only.
It is recommended to export the existing component data to Excel and use that to import the data.
-
Click Import Data in the [component category name] window.
-
In the Import into [component category name] window, type or browse to the source workbook file path.
-
Select the worksheet to be imported.
If the source workbook file contains unique identifiers (UIDs), the corresponding column header should be named UID and should be in the top row of the worksheet.
The grid displays only the first few rows from the Excel file.
-
Map the component category columns to the loaded data.
-
If the source workbook file contains UIDs, you only need to map the component properties to the Excel columns using Import to in the Import dialog box.
-
If the source workbook file does not contain UIDs, you need to map the identifier and the component properties to the Excel columns using Identifier and Import to respectively in the Import dialog box.
-
Using Save Mapping As, you can save the mapping information for future use.
-
The mapping type defaults to Custom when a worksheet is selected. You can also select previously saved mapping types.
-
Using Skip Top, you can skip a defined number of rows from the top of the worksheet.
-
-
Click Import.
A summary of the processed information is saved as [Workbook file name].log in the same location from which the file was imported.