# Fastener Torque Spec Conversion Log Worksheet

> Source: https://netray.co/tools/fastener-torque-spec-conversion-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Record each fastener torque once in ft-lb and get N-m, in-lb and kgf-m for work instructions across plants and suppliers.

## Category

engineering-plm

## Industry

Assembly

## Audience

- Manufacturing engineer
- Assembly supervisor
- Quality engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Joint or station

**Key:** joint

**Type:** text

#### Fastener

**Key:** fastener

**Type:** text

#### Source document

**Key:** source

**Type:** text

#### Torque

**Key:** ftlb

**Type:** number

**Unit:** ft-lb

#### Torque

**Key:** nm

**Type:** number

**Unit:** N-m

**Expr:** ftlb * 1.3558179

**Format:** decimal

#### Torque

**Key:** inlb

**Type:** number

**Unit:** in-lb

**Expr:** ftlb * 12

**Format:** decimal

#### Torque

**Key:** kgfm

**Type:** number

**Unit:** kgf-m

**Expr:** ftlb * 1.3558179 / 9.80665

**Format:** decimal

#### Tolerance

**Key:** tol

**Type:** number

**Unit:** %

#### Minimum

**Key:** nm_min

**Type:** number

**Unit:** N-m

**Expr:** ftlb * 1.3558179 * (1 - tol / 100)

**Format:** decimal

#### Maximum

**Key:** nm_max

**Type:** number

**Unit:** N-m

**Expr:** ftlb * 1.3558179 * (1 + tol / 100)

**Format:** decimal

**Rows:**

**Joint:** Wheel hub

**Fastener:** M12 x 1.5 class 10.9

**Source:** DWG-1021 Rev C

**Ftlb:** 85

**Tol:** 10

**Joint:** Cover plate

**Fastener:** M8 x 1.25 class 8.8

**Source:** WI-044

**Ftlb:** 18

**Tol:** 10

**Joint:** Gearbox flange

**Fastener:** 5/8-11 grade 8

**Source:** DWG-2205 Rev B

**Ftlb:** 170

**Tol:** 5

**Joint:** Sensor bracket

**Fastener:** M5 x 0.8 class 8.8

**Source:** WI-051

**Ftlb:** 4.4

**Tol:** 15

**Joint:** Pump mount

**Fastener:** 3/8-16 grade 5

**Source:** DWG-3310 Rev A

**Ftlb:** 33

**Tol:** 10

**Totals:**

#### Joints logged

**Key:** ftlb

**Agg:** count

**Format:** integer

#### Highest torque (N-m)

**Key:** nm

**Agg:** max

**Format:** decimal

**Notes:** Conversion factors: 1 ft-lb = 1.3558179 N-m, 1 N-m = 0.101972 kgf-m. Always follow the torque value and lubrication condition stated on the engineering drawing.

## Content

**Intro:** Torque values arrive in mixed units from drawings, supplier manuals and customer specs. This log keeps one source value per joint and shows the matching values in the units your wrenches and work instructions use.

**Sections:**

#### How to use the log

**Body:** Add a row for each controlled joint. Enter the source value in foot-pounds and the tolerance as a percentage. The sheet shows the same torque in N-m, in-lb and kgf-m, plus the minimum and maximum in N-m for wrench setting and audit checks. Record the source document so that the engineer who updates a drawing knows which row to change.

**Bullets:**

- Log the document and revision for every value
- Use the tolerance from the drawing
- Export to Excel for the work instruction package
- Review whenever a drawing is revised

#### Conversion factors used

**Body:** One foot-pound equals 1.3558179 newton-meters. One foot-pound is also 12 inch-pounds. One kilogram-force meter is 9.80665 newton-meters, so dividing newton-meters by 9.80665 gives kgf-m. For example, 85 ft-lb is 115.2 N-m, 1020 in-lb and 11.75 kgf-m. Use the full factor rather than a rounded 1.36, since rounding errors add up when you convert high-torque joints with tight tolerances.

#### Practical notes for the shop floor

**Body:** A torque number means little without the joint condition. Dry, oiled, plated or anti-seize treated threads give different clamp force for the same torque, so note the lubrication assumption in the source document. Choose a wrench whose range puts the target value in the middle of its scale, and keep the calibration status visible. If torque is controlled by angle or tension, this log is only a companion and not the controlling specification.

**Bullets:**

- Do not round the target before applying tolerance
- Mark torque-angle joints separately
- Confirm wrench calibration before use

**Cta:** If torque specs live in drawings, PLM and ERP routings with different units, we can build an agent that finds mismatches across them.

**Faq:**

#### How do I convert ft-lb to N-m?

**Answer:** Multiply foot-pounds by 1.3558179. For example 50 ft-lb is 67.8 N-m. To go the other way, divide newton-meters by 1.3558179 or multiply by 0.737562.

#### What is the difference between N-m and kgf-m?

**Answer:** A newton-meter is the SI unit. A kilogram-force meter is a legacy gravitational unit, equal to 9.80665 N-m. Some Asian and older European manuals still use kgf-m, so conversion matters on imported equipment.

#### Should I apply tolerance to the converted value?

**Answer:** Apply the tolerance stated on the drawing to the target value, in whichever unit you control. This sheet does it on the exact converted value, which avoids stacking rounding errors.

#### Can this replace the engineering drawing?

**Answer:** No. The drawing is the controlling document. This log is a convenience that holds converted values for work instructions and must be updated whenever the drawing revision changes.

## Search terms

torque conversion table excel, ft lb to nm torque log, torque spec sheet template, assembly torque specification list, fastener torque conversion worksheet, in lb to nm conversion sheet, work instruction torque values, torque wrench setting log

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json