Design Tables for SOLIDWORKS allow users to build and change Parts and Assembly parameters in different configuration using Microsoft Excel worksheet.
Prerequisite to use this tool = Have Microsoft Excel installed on user machine.
Caution of using this tools is the table will create multiple configurations and it can lead to increase file size. This may contribute to performance issue.
In this example, the parts is a block.
User will able to create Design Table to manage all important dimensions related to this model.
We will create the block using Model A parameters as our starting point.
Fully define all sketch and add the names for the dimension accordingly.
Once the model is completed, head to ConfigurationManager.
The first configuration is always Default, but according to our specification, the first configuration is Model A.
Rename Default configuration to Model A.
Go to Insert > Tables > Design Table.
Set it to Auto-Create and ” Allow model edits to update the design table”.
Click OK, SOLIDWORKS will auto generate the design table and ask what parameters to include. In this case, select all dimension listed and press OK.
The table will be generated and and Tables flyout will be created in Configuration tree.Because we already have specification table, simply copy the data to the Design Table. You can do text formatting to ensure easy-to-read table.
Once complete, click Save and close the Design Table. SOLIDWORKS will prompt to confirm the configuration created from the data input earlier.
Select OK and all the configuration will be listed up in the tree. Take note on the “x” mark next to each configuration name, indicating that the configuration is managed using Design Table.
Editing the Design Table
To edit the table ( e.g material), simply add material to the design or any other parameters that need to be controlled.
Click Yes if the popup asking you’d like to link the display states to the different materials.
Return to Configuration manager tab, right click Design Table and click Edit Table. SOLIDWORKS will detect that there are new parameters added to the file, and will prompt user if they want to add to the Design Table.
Click OK and SOLIDWORKS will automatically add new column to the Design Table accordingly. In this case, we able to use drop-down list to add material to other configuration. 
Close the Design Table, and activate each of the configurations to see the change on the model.
