You can import data from Excel (.xls and .xlsx) or CSV (.csv and .txt) format files to your model. You are able to specify the import mapping options between file columns and element properties of the model. Additionally, you can save your maps, collect them in groups, manage those groups, and use an entire group instead of a single map for data import. Before importing data from Excel or CSV files to model, create new or open an existing project.
Import Using Existing Map Group - to import data from Excel or CSV file by selecting the map group that collects as many Import Maps as you added. How to import data by using existing map group >>
All Excel/CSV file import commands from the File menu.
Preparing Excel or CSV file to import
To import data from Excel or CSV files, the files must met the following prerequisites:
Heading is located in the first row.
When creating relationships, the spreadsheet must contain the source and target columns. The source and target columns contains the names/qualified names of elements respectively that are the client and supplier of the relationship.
Recommended prerequisites:
Eliminate merged cells.
Every column has a unique column name.
Every row has the same number and name of columns.
Every cell has the element name or qualified element name.
Importing data by using a new map
To import data from an Excel or CSV file to model by using a new map
Create new or open an existing project.
Make sure: - the auto usages of Excel Import Plugin are removed. How to >> - the Excel or CSV file met the basic prerequisites. Basic Prerequisites >>
In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using New Map. The Excel/CSV Import dialog opens.
Select the file and specify mapping options. How to >>
Tip
You must select the file in the Select Excel/CSV file area and specify the Element Type, Properties to Map, and Target Scope mapping option values to import data.
In the Mapping area, create mapping between the Excel/CSV file data and modeling tool properties. How to >>
(Optional) Click the Save Map button to save your map options as the Import Map. How to >>
Click the Import button. The data from the Excel or CSV file is imported to the model according to the specified options.
Importing data by using an existing map
To import data from Excel or CSV file to model by using an existing map
Create new or open an existing project.
Make sure: - the auto usages of Excel Import Plugin are removed. How to >> - the Excel or CSV file met the basic prerequisites. Basic Prerequisites >>
In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using Existing Map.
In the Select Import Map dialog, select existing Import Map.
Tip
If you cannot see any Import Maps, you need to save it first. How to >>