Using Inventor's Hole tool, you can create counterbore, countersink, spotface, and drilled holes with user-defined variables such as thread designation and drill point angle. You can also specify a simple hole, a tapped hole, a tapped tapering hole, or a clearance hole.
Using the Thread and Clearance Spreadsheets
Two external files are related to the Hole tool. These are Thread.xls and Clearance.xls. Both files load at the time of installation to a Design Data folder in the install directory location, such as C:\Program Files\Autodesk\Inventor 2012\Design Data. If the Design Data folder has been relocated, you can determine its location ...