Free download · Excel

Weld register template for pipe fabrication

One row per weld, with the columns a QC inspector actually fills in: drawing and spool IDs, WPS and welder, visual, NDT sampling and results, and repairs that point back to the weld they replace.

Download the template (.xlsx)

XLSX · 4 sheets · 27 columns · no sign-up

What the register tracks

Columns are grouped in the order a weld moves through the shop, so the sheet reads left to right like the job.

  1. 01 · Identity

    • Weld No.
    • Spool
    • Isometric
    • Rev
    • Line No.
  2. 02 · Joint

    • Joint type
    • Shop / Field
    • Size (NPS / DN)
    • Schedule / WT
    • Material
  3. 03 · Welding

    • WPS
    • Welder ID
    • Date welded
  4. 04 · Visual

    • Visual result
    • Visual date
  5. 05 · NDT

    • NDT method
    • NDT %
    • NDT selected
    • NDT result
    • NDT report No.
    • NDT date
  6. 06 · Repair

    • Repair of
    • Repair No.
    • Repair date
    • Retest result
  7. 07 · Notes

    • Hold point
    • Notes

A repair stays on the same chain

The Example sheet shows W07 rejected on RT and cut out. The repair is its own row, W07-R1, and its “Repair of” column points back to W07, so the NDT report, the reject and the retest still line up.

Weld No.SpoolIsometricRevLine No.Joint typeShop / FieldSize (NPS / DN)Schedule / WTMaterialWPSWelder IDDate weldedVisual resultVisual dateNDT methodNDT %NDT selectedNDT resultNDT report No.NDT dateRepair ofRepair No.Repair dateRetest resultHold pointNotes
W01SP-101ISO-1001B6"-P-1001-A1ABWShop6" / DN150SCH 40A106 Gr.BWPS-01W-122026-11-02Accepted2026-11-02RT10YesAcceptedRT-00422026-11-04————None—
W02SP-101ISO-1001B6"-P-1001-A1ABWShop6" / DN150SCH 40A106 Gr.BWPS-01W-122026-11-02Accepted2026-11-02RT10No———————NoneNot in the 10 % sample
W07SP-102ISO-1002A4"-P-1002-A1ABWShop4" / DN100SCH 80A106 Gr.BWPS-02W-082026-11-03Accepted2026-11-03RT100YesRejectedRT-00472026-11-05————Before paintPorosity — cut out, see W07-R1
W07-R1SP-102ISO-1002A4"-P-1002-A1ABWShop4" / DN100SCH 80A106 Gr.BWPS-02W-082026-11-06Accepted2026-11-06RT100YesAcceptedRT-00512026-11-07W07R12026-11-06AcceptedBefore paintRepair of W07, same WPS
F03SP-103ISO-1003A2"-P-1003-B1ASWField2" / DN50SCH 160A105WPS-04W-032026-11-08Pending—MT10YesPending——————Before hydrotestAwaiting MT

Four sheets in the file

  • XL

    Weld register

    200 blank rows with filters on every column. Start typing on row 2.

  • XL

    Example

    Five filled rows: sampled and unsampled RT, a cut-out with its repair, and a field weld waiting on MT.

  • XL

    Lists

    Allowed values for joint type, NDT method, results and hold points, so everyone codes the same way.

  • XL

    Read me

    How to number repairs, when to bump the revision, and what NDT % and “NDT selected” mean.

When the sheet falls behind the drawings

A spreadsheet works on small scopes. On a live job, the isometric gets marked in the bay and the register gets retyped on Friday. MapWeld puts each weld on the PDF isometric and exports this same register when reporting is due.

Why Excel registers fall apart on real projects →