About importing structures from Excel

You can import structure data into Teamcenter from a Microsoft Excel spreadsheet and create new structures with new or existing components. This activity is useful for integrating data from external sources or vendors.In Teamcenter, you can import a structure from a Microsoft Excel spreadsheet. This feature is useful when you need to import data from an external source, for example, from a design contractor who does not have Teamcenter. You can import relatively simple and small structures, such as structure data provided by vendors. Importing from Excel might not be suitable for very large and complicated structures.The following scenarios explain how you can import structures in Teamcenter.Scenario 1

You want to create a new Crosskart structure with all new components. To do this, you can create an Excel spreadsheet similar to the following and then import it in Teamcenter:

After the import, the following structure is created in Teamcenter:

Even if you did not specify an ID for some of the elements in the input spreadsheet, Teamcenter generates the IDs for those elements automatically. Scenario 2

You want to create a new structure called Test Crosskart by reusing some of the existing elements in Teamcenter. Therefore, in the input spreadsheet, you add the name for the new structure and only the names and IDs of the existing subassemblies. Your input spreadsheet appears as follows.

After the import, Teamcenter creates the new Test Crosskart by reusing the existing elements from the sub-assemblies. You only need to specify the required properties of the subassemblies and not of the existing elements.