Exporting Configuration Lists

Before assigning part numbers to a Toolbox component, you must first export a configuration list for the component to a Microsoft^® Excel file.

1. In Windows, click Start > SOLIDWORKS Tools version > Toolbox Settings version.
2. In SOLIDWORKS, click Configure in the SOLIDWORKS System Options - Hole Wizard/Toolbox dialog box.
3. Click 2 - Customize Your Hardware.
4. On the Customize Hardware page, select an individual component.
5. At the upper left of the configuration list, click Import/Export and click Export data .
6. In the Save as dialog box:
   1. Select a location for the spreadsheet file.
   2. For Save as type, select Excel Workbook (*.xlsx) or Excel 97-2004 Workbook (*xls).
   3. Click Save.
7. In Microsoft Excel, open the spreadsheet.
8. In the row for each configuration, type part numbers, descriptions, and comments in the appropriate columns.
   Do not change other values or add columns. The other property values must not change for the import to succeed.
9. Save and close the spreadsheet.
10. In Toolbox, on the Customize Hardware page, click Import/Export and click Import data .
11. Browse to the spreadsheet file and click OK.