To assign part numbers to your Toolbox parts, you can export a configuration list to a Microsoft® Excel file, type part numbers in the file, and then import the edited file into SolidWorks Toolbox.
To export and import a configuration list:
-
From Windows, click .
- Click 2 - Customize Your Hardware.
- On the Customize Hardware page, select an individual component.
- At the upper right of the configuration list, click Import/Export
and click Export Data.
- Select a location for the spreadsheet file and click OK.
- In Microsoft Excel, open the spreadsheet.
-
In the row for each configuration, type part numbers, descriptions, and comments in the appropriate columns.
Important: Do not change other values or add columns. The other property values must not change for the import to succeed.
- Save and close the spreadsheet.
- In Toolbox, on the Customize Hardware page, click Import/Export
and click Import Data.
- Browse to the spreadsheet file and click OK.