How to Configure SOLIDWORKS Parts Using Excel Design Tables?

CONFIGURATION USING EXCEL

DESIGN EXCEL TABLE:
Design tables are a way to create different parts or assembly configurations by defining parameters in cells, rows, and columns of an integrated Microsoft Excel spreadsheet.

NOTE: To use design Excel table, must have Microsoft Excel 2016-2021 on computer for SOLIDWORKS 2022-2025.

Desing table for part:
1. Used to edit any dimensions of a 3D part.
2. Also used to create multiple configurations of the same part.

STEP 1: Creating part in SWX
Part has been developed using SOLIDWORKS 2025 shown on Fig1.

Fig 1

Step 2: Creating Excel Design table
Insert -> Tables -> Excel Design Table

Fig 2

Step 3: Creating auto design table

Fig 3

Please make sure the resources listed above are enabled, since modifications made to the design table or model will be updated automatically.

Step 4: Creating consideration in table
Each of the following parameters and dimensions has been chosen to be featured in the table. Considering this is a simple part file, the dimension names are not customized.

Fig 4

Step 5: Saving the design table.
Now the design table have saved to desired location.

Fig 5

Step 6: Mapping the table with part

• Once the table has been saved delete the configuration table in the SOLIDWORKS configuration manager.
• Once again, we need to add the table to the part as from file option so that the part file no need to opened and make changes.

  Note: Make sure to enable the link to file option.
  
  

  
  Fig 6
  
  

  Step 7: Building configurations.
  
  • The SOLIDWORKS part has been saved and closed.
  • The saved excel table has been opened and the excel data has been added with 40,50,60mm etc … configuration.
  • After all the updates the excel has been saved and closed.
  • The SOLIDWORKS part has been saved and closed.
  • The saved excel table has been opened and the excel data has been added with 40,50,60mm etc … configuration.
  • After all the updates the excel has been saved and closed.
    
    
    
    Fig 7
    
    

     Step 8: Changes in Part file
    The part file has been opened on SOLIDWORKS.
    
    By default, the Pop up appears with two different options which would be selected by user as shown below.
    
    

    
    Fig 8
    
    

    
    Fig 9
    
    

    The Part has been configured as per the data updated on the excel.
    
    
    Contact Us: Have questions or need assistance? Feel free to reach out!
    
    Email: mktg@egs.co.in
    Phone: +91 94454 24704