Using Solidworks Design Tables

Using Solidworks Design Tables

1: What is a Design Table and Why to Use One

A design table allows you to link your Solidworks dimensions to an external excel file, this means that your Solidworks file can automatically update as you make changes in the excel doc. This should only really be used for more complex models where many dimentions depend on each other, and one dimension change forces a cascade of other sizing changes (eg rc plane sizing).

image-20260704-160204.png
image-20260704-160223.png
Cascade of changes due to changing one input

 

 

 

2: Master Doc?

Before you start making the design table, it is wise to have a different document with all of the calculations, this can be your master doc that other design tables reference off of. Since each design table can only be linked to one Solidworks file, each different design table you make will be pulling data from this one large master doc.

3: Building Your Design Table.

Design tables can be imported into solidworks in 3 different ways, all stemming from insert → table → excel design table

image-20260704-160755.png

You can either create a blank design table, have solidworks create the design table from the dimentions already within the sheet, or have the design table pre-made.

image-20260704-160845.png

For this guide I will assume you are using the Auto-Create as it allows Solidworks to figure out the formatting and original dimension naming.

Right after you create your design table you will be prompted for which dimensions you want to import into the design table, select all of them and then hit ok.

You will then see a screen that looks somewhat like this, lets breakdown what each part means.

image-20260704-161255.png

 

On the top it will say “design table for: [your filename].

in a3 and them continuing down the a column will be your different configurations, if you want to add a different configuration simple add a new name in the “A” column, and a value in each of your dimensions. Starting at B2 and going along the “2” row are your dimention names, by default they will all be d[x]@[sketchname] but can be edited INSIDE THE SOLIDWORKS FILE

IF YOU ATTEMPT TO CHANGE THE NAME WITHIN THE EXCEL DOC, IT WILL SIMPLY UNLINK FROM THE DIMENTION

image-20260704-161804.png
Where to change the dimension name

Finally, the numbers going along the row after your configuration name correspond to the values of those dimensions in that configuration.

 

4: Updating Your Solidworks File (and Design Table)

After creating the design table you can add new dimensions to it by going to edit table inside the configurations sections, and double clicking on the dimention while having an unused cell selected inside the design table (it should put you on the next unused cell by default)

image-20260704-162926.png

You can either choose to have your excel doc as master, and only be able to update your Solidworks file through the excel sheet, or have them linked and have updates in one be passed to the other.

When making changes to dimensions you should try to link everything to the cloud version of the master doc, THIS ONLY WORKS IF YOU HAVE THE CLOUD PART OPEN LOCALLY. You can then reference the cells as normal.

5: Saving Your Design Table

By default design tables are saved internally to solidworks, meaning you can only access the file within the Solidworks file, to prevent this you can right click on the design table and save it externally. by hitting “Save Table.” After this initial save the design table will save automatically along with your Solidworks file

image-20260704-162952.png

 

FAQ:

If you have questions ping Jackson Barber in discord and ill try to help, and then update this faq with your question