About the Thread Data Spreadsheet

The Thread.xls file, which is located in the Design Data folder, provides data for hole and thread commands.

The Application Options and/or project settings can affect the spreadsheet file's location.

The Clearance.xls file, located in the same folder as the Thread.xls file, manages clearance data. Editing of both xls files follows the same rules.

The Thread.xls spreadsheet contains various worksheets in one of two formats: Parallel Thread Type or Taper Thread Type. The worksheets contain some common industry standard thread types and standard tapped hole sizes. You can edit the worksheets to:

We recommend that you do not delete thread types or rows. If an iPart or Content Center tries to instantiate a part that requires the deleted data, the operation can fail.

Note: Microsoft Excel is required to create threaded or clearance holes and to add a new thread or clearance type within Autodesk Inventor.

Format of parallel thread type worksheet

The top three rows contain column headers and other general data. The significant cells in this area are:

A1

This cell identifies how hole and thread features use this worksheet.

  • I indicates that distance data in the worksheet is in inch units. Either I or M is required.
  • M indicates that distance data in the worksheet is in mm units. Either I or M is required.
  • N indicates that the worksheet contains only internal thread data. X or N can be used. When X and N are omitted, the worksheet is available for external and internal.
  • P indicates that column E is pitch distance of the thread. Either P or Q is required.
  • Q indicates that column E is threads per inch (TPI). Either P or Q is required.
  • X indicates that the worksheet contains only external thread data. X or N can be used. When X and N are omitted, the worksheet is available for external and internal.

B1/C1

These merged cells contain the custom thread type name that appears in the hole and thread dialog boxes. Unlike the name on the worksheet tab, you can customize this thread type name to satisfy language or company differences without affecting the ability to exchange design data.

D1

This cell contains the sort order number, which is used to determine the thread type list order in the dialog boxes. The number does not have to be sequential. A lower number places the thread type above the types with higher sort order numbers.

The area containing thread data begins on the fourth row. Columns for thread data are divided into three sections:

The following lists each column and its contents:

A

Specifies the nominal diameter size of the thread as a decimal value.

B

Specifies the nominal diameter size of the thread as an optional string value that is appended to the value in column A and shown in the Hole dialog box.

C

Specifies the thread designation that is a key to identify a particular thread.

D

Specifies the custom thread designation that appears in dialog boxes and can be optionally displayed in hole and thread notes. You can customize this value without affecting the hole or thread feature. However, if multiple rows contain the same thread designation, they all must have the same custom thread designation.

E

Specifies the axial distance of the thread. If cell A1 contains the letter P, this column shows pitch distance values; if cell A1 contains the letter Q, this column shows thread per inch (TPI) values.

F

Specifies the tolerance class, which represents dimensional variability, for the external thread. Class is also a key.

G and H

Specify the maximum and minimum values, respectively, of the major diameter of the external thread, which is the diameter of a virtual cylinder that touches the crest of the external thread.

I and J

Specify the maximum and minimum values, respectively, of the pitch diameter of the external thread, which is the diameter of a virtual cylinder where the width of the thread and width of the gap are equal.

K and L

Specify the maximum and minimum values, respectively, of the minor diameter of the external thread, which is the diameter of a virtual cylinder that touches the root of the external thread.

N

Specifies the tolerance class, which is a key, for the internal thread.

O and P

Specify the maximum and minimum values, respectively, of the major diameter of the internal thread, which is the diameter of a virtual cylinder that touches the root of the internal thread.

Q and R

Specify the maximum and minimum values, respectively, of the pitch diameter of the internal thread, which is the diameter of a virtual cylinder where the width of the thread and the width of the gap are equal.

S and T

Specify the maximum and minimum values, respectively, of the minor diameter of the internal thread, which is the diameter of a virtual cylinder that touches the crest of the internal thread.

U

Specifies the tap drill diameter for the internal thread, which is the suggested drill diameter for the hole.

Format of taper thread type worksheet

The top three rows contain column headers and other general data. The significant cells in this area are

A1

This cell identifies how the hole and thread features use this worksheet.

  • I indicates that distance data in the worksheet is in inch units. Either I or M is required.
  • M indicates that distance data in the worksheet is in mm units. Either I or M is required.
  • N indicates that the worksheet contains only internal thread data. X or N can be used. When X and N are omitted, the worksheet is available for external and internal.
  • T indicates that the worksheet contains taper threads. All taper worksheets must have this character.
  • X indicates that the worksheet contains only external thread data. X or N can be used. When X and N are omitted, the worksheet is available for external and internal.

B1/C1

These merged cells contain the custom thread type name that appears in the dialogs. Unlike the name on the worksheet tab, you can customize this thread type name to satisfy language or company differences without affecting the ability to exchange design data.

D1

This cell contains the sort order number, which is used to determine the thread type list order in the dialogs. The number does not have to be sequential. A lower number places the thread type above those with higher sort order numbers.

The area containing thread data begins on the fourth row. The following lists each column and its contents:

A

Specifies the thread designation, also known as the nominal size of the thread. It is a key for identifying thread selection.

B

Specifies the custom thread designation, which can be useful in obtaining correct thread callouts in drawings.

C

Specifies the outside pipe diameter.

D

Specifies the threads per inch (TPI) value.

E

Specifies the pitch distance, which is the distance from a point on one thread to a corresponding point on the next thread, measured along the thread axis.

F

Specifies the beginning value of the external pitch diameter.

G

Specifies the handtight engagement length, which is the normal length of engagement between external and internal taper threads when screwed together by hand.

H

Specifies the pitch diameter at a handtight engagement position.

I

Specifies the effective external thread length.

J

Specifies the effective (pitch) diameter of the external thread at the large end.

K

Specifies the wrench makeup length of the internal taper thread.

L

Specifies the pitch diameter of the small end of the wrench makeup length of the internal taper thread.

M

Specifies the vanishing length of the external taper thread.

N

Specifies the overall length of the external taper thread.

O

Specifies the length of the nominal perfect external taper thread.

P

Specifies the pitch diameter of the nominal perfect external taper thread.

Q

Specifies the thread height.

R

Specifies the basic minor diameter at the small end of the pipe.

S

Specifies the tap drill diameter for the internal taper thread.

T

Specifies the taper angle, in degrees, as an included angle.