You can import and export Hole Wizard data with help Excel files in the Configuration tool with SOLIDWORKS 2018. 

Now you can import and export data to the Hole Wizard in the configurator tool SOLIDVORKS Toolbox 2018.

This is helpful when you edit an entire standard or create a few new sizes of holes.
Do the following steps

  • 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.

Hole Wizard-LeninSW

Click Hole Wizard

DIN Standards-LeninSW

Browse to the type of hole to import (export) data for, such as DIN

Export Hole Data Tables LeniSW

Export Hole Data Tables

Exporting LeninSW


Import the resulting file backward into the Solidworks Toolbox


Error importing

Open the file and delete the "Sheet1", save it.
Delete "Sheet1"

Delete "Sheet1"

Import the resulting file backward into the Solidworks Toolbox

An Excel file can be exported first to obtain the proper setup and existing sizes. This Excel file has 3 sheets at the bottom, analogous to the Standard Properties of a Hole Wizard type:
  • Sizes
  • Thread Data (besides Straight Holes)
  • Screw Clearances (besides for Tapped Holes)

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


SOLIDWORKS 2018 Hole Wizard Export – Sheet "Sizes"

Hole-Wizard Export–Thread Data-LeninSw

SOLIDWORKS 2018 Hole Wizard Export – Sheet "Thread Data"

Hole-Wizard-Export–Screw Clearances-LeninSW

SOLIDWORKS 2018 Hole Wizard Export – Sheet "Screw Clearances"

Sometimes when you launch SOLIDWORKS and try to load SOLIDWORKS Toolbox Library or Utilities add-in, SOLIDWORKS delivers a message stating “You appear to have experienced problems the last time you loaded the SOLIDWORKS Toolbox add-in”. This issue is only experienced in SOLIDWORKS 2017 SP3.0

Error loading Toolbox Library 

  • If you pick yes, continue to load Toolbox, SOLIDWORKS possibly stops responding!
  • However, if you pick No, disabling Toolbox, everything seems to work fine.
To fix this error you should delete the ‘tb_default.sldedb’ from ‘<C:\Users\<user>\AppData\Roaming\SOLIDWORKS\SOLIDWORKS 2017\Toolbox\data’.
In Windows 7/Vista a  user can open his/her application data folder by running the command ‘appdata’ from Run window.

Navigate to the specified path and delete ‘tb_default.sldedb’.

Then launch SOLIDWORKS, you should have no issues adding the Toolbox Library or Utilities add-in.
This issue has been fixed in SOLIDWORKS 2017SP4.

SolidWorks help
You can view models through one, two, or four viewports.
To open four viewports:

  • Click Four View   (Standard Views toolbar) or Window > Viewport > Four View.
SolidWorks Viewports -Other Display Style

You can choose the following viewport arrangements from the Window menu or the Standard Views toolbar:

Views Displayed
Single View
Two View - Horizontal
Front and Top
Two View - Vertical
Front and Right
Four View
Front, Right, Top, and Trimetric (Third Angle), or Front, Left, Top, and Trimetric (First Angle). Specify First Angle or Third Angle in Tools > Options > System Options > Display .

The lower left corner of each viewport displays the current orientation.
To choose a different orientation, click the View Orientation   (Heads-up View toolbar).
When you switch from multiple viewports back to a single viewport, the model displays the orientation of the active viewport. If you then switch back to multiple viewports, the orientations are the defaults again.
You can change the orientation or rotation of a model in any viewport independently as long as the viewports are not linked.

These requirements apply to all SOLIDWORKS products except where noted. Use this information to ensure you are always working with a SOLIDWORKS supported and optimized system for hardware, operating system and Microsoft products.

Operating Systems
Windows Vista>
Windows 7 64-bit (SP1 required for
Windows 7 32-bit (SP1 required for
Windows 8.1 (64-bit only)
(2014 SP1)
Windows 8 (64-bit only)
Windows 10, 64-bit
(2015 SP5)
8GB or more recommended<
Video Card
Intel or AMD with SSE2 support. 64-bit operating system required
Install Media
DVD drive or broadband internet connection
Microsoft Products
Internet Explorer
IE 8, 9, 10
IE 8, 9, 10 ,11
IE 9, 10 ,11
IE 10,11
IE 11
IE 11
Excel and Word
2007, 2010,
2007, 2010, 2013
2010, 2013
2010, 2013,
2016 (SW2016 SP3)
2010, 2013,
2010, 2013,

Effective work in Solidworks

Search This Blog

Избранное сообщение

How Import and Export Hole Wizard Data with Excel

You can import and export Hole Wizard data with help Excel files in the Configuration tool with SOLIDWORKS 2018.  Now you can import and ...

Popular posts