OdysseyGPT

Free template

Weld map and weld log template (Excel and CSV)

For fabricators of spools and vessels: one row per weld, from the weld map number and drawing to the WPS, welder, weld date, visual and NDE results, repairs, PWHT record and release.

By Ademola Afolabi, Founder, New Odyssey Ltd · Last reviewed:

The short answer

A weld map shows where each numbered weld is on a drawing, and a weld log records what happened to each one. This free Excel template indexes every weld on the map and logs its drawing and sheet, joint, size, material, WPS, welder, weld date, visual and NDE results, repair cycle, PWHT record and release.

Key Takeaways

  • Use the same weld number on the drawing, in the log and on every NDE report. Never reuse a number.
  • A repair gets its own row with the next repair cycle. The original row stays as the record.
  • The NDE required for each weld, and whether PWHT applies, come from the code, the drawing and the purchase order.
  • The example has 5 rows for four welds on an invented order (PO-EX-4410), with one hold and one repair.

Download the weld map index and weld log

Both files are free under CC BY 4.0, with no form to fill in. The XLSX opens in Excel, Google Sheets, LibreOffice and Numbers. The CSV carries the table only; the header block is in the XLSX.

What it is for and who uses it

A weld map is a drawing or isometric with every weld numbered. The template does not draw the map: mark the weld numbers on your own drawing, then list them here. The first columns are the weld map index, which says where each weld is and what it joins. The rest are the weld log, which says who welded it, to which procedure, when, and what the examinations found.

  • Welding coordinators and supervisors, who fill in the log as welds are made.
  • Quality engineers, who release each weld and file the log in the record book.
  • NDE coordinators, who enter report numbers and results against each weld.

To check that each weld's procedure and welder are qualified, use the WPS/PQR/WPQ cross-check matrix template; the example there covers the same four welds. The method is in how to check WPS, PQR and WPQ against a weld map. See also pipe spool fabricators.

Header block

Header block fields, with the invented example values
FieldExample
ProjectExample Process Skid (fictional)
CustomerExample EPC Contractor Ltd (fictional)
Purchase orderPO-EX-4410 (fictional)
Equipment / packagePressure vessel and piping spool (fictional)
Welding code named in the POAs stated in the PO (for example ASME Section IX or ISO 15614-1 / ISO 9606-1)
Weld mapWM-EX-4410 Rev A
DrawingsGA-EX-4410 Rev C; isometric ISO-EX-4410-01 Rev B
Weld log no.WL-EX-4410
Status date2027-02-10
Maintained byWelding coordinator
Checked byQuality engineer

Example rows: four welds on a vessel and a spool

Invented example rows for PO-EX-4410 (some columns omitted)
WeldDrawing / sheetJointWPSWelderWeld dateVisualNDENDE resultRepairReleaseRemarks
W1GA-EX-4410 Rev C, sheet 1Shell longitudinal seam, buttWPS-EX-012 Rev 1WX-072027-01-22AcceptedRT RT-EX-041Accepted0Released
W2GA-EX-4410 Rev C, sheet 1Shell to head circumferential, buttWPS-EX-012 Rev 1WX-092027-01-25AcceptedRT RT-EX-042Pending0OpenRT-EX-042 awaiting review. Continuity record for WX-09 to be found (see matrix WQX-EX-4410).
W3GA-EX-4410 Rev C, sheet 2Nozzle N1 to shell, set-onWPS-EX-015 Rev 0UT + MTPending0HoldNot welded. WPS-EX-015 is not yet approved by the customer, and WX-07 holds a SAW qualification only: assign a welder qualified for GTAW and SMAW.
W4ISO-EX-4410-01 Rev B, sheet 1Spool butt weld, pipe to flangeWPS-EX-021 Rev 2WX-122027-01-27AcceptedRT RT-EX-043Rejected0HoldIndication reported in RT-EX-043. Repaired: see the R1 row.
W4ISO-EX-4410-01 Rev B, sheet 1Spool butt weld, pipe to flange: local repairWPS-EX-021 Rev 2WX-122027-02-05AcceptedRT RT-EX-044AcceptedR1ReleasedRepair accepted. The R1 row releases the weld; the original row stays as the record.

The file also has columns for size and thickness, material and the PWHT record. Weld W3 is on hold because its procedure is not yet approved and no qualified welder is assigned. Weld W4 was rejected and repaired, so it has two rows. Every example value is invented: the project, customer, bidders, purchase order, prices and every document, certificate, serial and report number do not exist. Standards are named but not quoted.

Release values

ReleaseUse it when
ReleasedThe weld is complete, every examination the drawing and code require is accepted, and the quality engineer has released it.
HoldSomething stops the weld being made or accepted: an unapproved procedure, a welder without the qualification, or a rejected examination. Say what in Remarks.
OpenThe weld is made or in progress, and a record or result is still to come.

Columns and what to write

ColumnWhat to write
Weld no.Weld number, exactly as it is marked on the weld map. Never reuse a number.
Drawing / isometric and sheetThe drawing or isometric the weld is on, with revision and sheet.
Joint typeJoint type and what it joins.
Size and thicknessDiameter or length, and the thickness welded.
MaterialBase material specification and grade on each side of the joint.
WPS no. / revThe welding procedure specification assigned on the weld map.
Welder ID(s)Stamp of each welder or operator who worked on the weld. Note who made the root and who made the fill and cap, if different.
Weld dateDate the weld was completed (YYYY-MM-DD).
VisualResult of the visual examination: Accepted, Rejected or Pending (drop-down).
NDE methodThe NDE methods the drawing, code or PO requires for this weld, for example RT, UT, MT or PT. Write None if none is required.
NDE report no.Report number for each method, once it exists.
NDE resultAccepted, Rejected, Pending or Not required (drop-down). Rejected rows turn red.
Repair cycle0 for the original weld, R1 for the first repair, R2 for the second. Add a new row for each repair; keep the original row.
PWHT recordHeat treatment chart or report number, or Not required. Whether PWHT is required comes from the code, the WPS and the PO.
ReleaseReleased, Hold or Open (drop-down). Hold rows turn amber.
RemarksWhat is open or on hold, and the action.

How to use the template

  1. Fill in the header with the welding code the PO names, the weld map and drawing revisions, and the weld log number.
  2. Add one row per weld on the weld map, with the same weld number as the map, the drawing or isometric and sheet, the joint type, size, thickness and material. This part is the weld map index.
  3. Enter the WPS assigned to each weld. Check that it is approved, and that each welder is qualified for it, before the weld is made.
  4. When the weld is made, enter the welder ID or IDs and the weld date, then the visual result.
  5. Enter the NDE methods the drawing, code or PO requires for the weld, then the report number and result for each. The extent of NDE comes from the code and the drawing; the template does not work it out.
  6. For a rejected weld, add a new row for the repair with the next repair cycle (R1, R2) and its own welder, date and NDE report. Keep the original row.
  7. Enter the PWHT chart or report number where heat treatment is required, then set the release. Hold rows turn amber and rejected rows red.
  8. Before the pressure test and before the record book is issued, filter Release for anything that is not Released. Ask a qualified welding engineer or coordinator to review the log.

Checking the welding records against each other

In OdysseyGPT's Manufacturing QA module, Welding Qualification Review (beta) reads the weld map, weld log, WPS, PQR and welder qualification records and shows where they do not line up, such as a weld with no approved procedure or a welder whose qualification does not cover the process. NDE Coverage Review (beta) compares the NDE reports with the welds that need examination. Every finding cites the page it came from, and a qualified welding engineer decides what to do with it. Tools marked beta are open on request, and we onboard each team ourselves.

Want us to run the check for you?

Send up to 20 material certificates and the purchase order. We send back a certificate check report, each finding cited to its page.

Get the free certificate check

New templates by email (optional)

Your download does not depend on this.

We use your email only for this. See our privacy policy.

Frequently asked questions

What is a weld map?

A drawing or isometric on which every weld has a unique number. It lets each weld be traced to the procedure used, the welder who made it and the examination reports that cover it.

What is the difference between a weld map and a weld log?

The weld map shows where the welds are. The weld log is the table that records, for each numbered weld, the procedure, welder, date, examination results and release. Many shops keep both in one file, as this template does.

How should a weld repair be recorded?

Add a new row for the repair, with the same weld number and the next repair cycle, its own welder, date and NDE report. Keep the original row with its rejected result. Check your code and purchase order for limits on repairs and for who must approve them.

Which welds need NDE, and how much?

The design code, the drawing and the purchase order decide the methods and the extent. The log records what is required for each weld and the report that covers it; it does not work the extent out. Check the governing code or contract.

Is there a free weld map or weld log template in Excel?

Yes. This XLSX template has a blank log, a filled-in example with invented welds and welders and a How to use sheet. A CSV of the same columns is also free under CC BY 4.0. It is a table, not a drawing.

References

Creative Commons Attribution 4.0 International

Creative Commons

Visit source

Related Pages