Import and Export Hole Wizard Data with Excel (SOLIDWORKS 2018)

How import and export Hole Wizard data with Excel files in the Configuration tool with SOLIDWORKS.

Formerly this could only be done with SOLIDWORKS Toolbox Hardware. This is an easier way to add custom Hole Wizard sizes within the Excel interface.

Do one of the following:

• In SOLIDWORKS, click Tools > Options > System Options > Hole Wizard/Toolbox > Configure.
• From the Windows Start menu, click All Programs > SOLIDWORKS 2018 > SOLIDWORKS Tools > Toolbox Settings 2018> Configure.

SOLIDWORKS 2018 Import and Export Hole Wizard Data

An Excel file can be exported first to obtain the proper setup and existing sizes. This Excel file has 3 tabs at the bottom, corresponding to the Standard Properties of each Hole Wizard type:

Sizes

Thread Data (except for Straight Holes)

Screw Clearances (except for Tapped Holes)

Once you have customized the exported Excel file, save as a separate filename (so you have a copy of the original Excel setup) and then use Import Hole Data Tables.

SOLIDWORKS 2018 Hole Wizard Export – Sizes

SOLIDWORKS 2018 Hole Wizard Export – Thread Data

SOLIDWORKS 2018 Hole Wizard Export – Screw Clearances

For Thread Data, be sure to have a matching “full-size” to the “size” in the Sizes tab.




By Scott Durksen