Automated Product Structure Creation in CATIA V5 Using Excel

Automated Product Structure Creation in CATIA V5 Using Excel + Smart Property Update

In this video, we demonstrate a complete workflow for generating a product structure in CATIA V5 using a simple Excel table. By entering the part number, description, revision, and assembly level, the macro automatically builds the correct hierarchical structure inside CATIA.

We then create a basic part, define its dimensions, assign material and sheet metal thickness, and use a custom macro to update part properties like material, thickness, and revision directly from the Excel input.

The video also shows how parameter changes are reflected instantly through automated updates — keeping your design, documentation, and data fully synchronized.

🎯 Ideal for design engineers working with large assemblies and standardization workflows.

🔧 Key Features:

Auto-generation of CATIA product structures from Excel

Sheet metal part creation with parameter definition

Automated metadata (properties) update

Live synchronization of parameter changes