Download the weld map index and weld log
XLSX
Weld map index and weld log (Excel)
Header block, 16 columns, drop-downs for visual result, NDE result and release, rejected rows in red and hold rows in amber, frozen header row, filters and a How to use sheet.
CSV
Weld map index and weld log (CSV)
The example rows as plain CSV (UTF-8), for Google Sheets or any other tool.
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
| Field | Example |
|---|---|
| Project | Example Process Skid (fictional) |
| Customer | Example EPC Contractor Ltd (fictional) |
| Purchase order | PO-EX-4410 (fictional) |
| Equipment / package | Pressure vessel and piping spool (fictional) |
| Welding code named in the PO | As stated in the PO (for example ASME Section IX or ISO 15614-1 / ISO 9606-1) |
| Weld map | WM-EX-4410 Rev A |
| Drawings | GA-EX-4410 Rev C; isometric ISO-EX-4410-01 Rev B |
| Weld log no. | WL-EX-4410 |
| Status date | 2027-02-10 |
| Maintained by | Welding coordinator |
| Checked by | Quality engineer |
Example rows: four welds on a vessel and a spool
| Weld | Drawing / sheet | Joint | WPS | Welder | Weld date | Visual | NDE | NDE result | Repair | Release | Remarks |
|---|---|---|---|---|---|---|---|---|---|---|---|
| W1 | GA-EX-4410 Rev C, sheet 1 | Shell longitudinal seam, butt | WPS-EX-012 Rev 1 | WX-07 | 2027-01-22 | Accepted | RT RT-EX-041 | Accepted | 0 | Released | |
| W2 | GA-EX-4410 Rev C, sheet 1 | Shell to head circumferential, butt | WPS-EX-012 Rev 1 | WX-09 | 2027-01-25 | Accepted | RT RT-EX-042 | Pending | 0 | Open | RT-EX-042 awaiting review. Continuity record for WX-09 to be found (see matrix WQX-EX-4410). |
| W3 | GA-EX-4410 Rev C, sheet 2 | Nozzle N1 to shell, set-on | WPS-EX-015 Rev 0 | UT + MT | Pending | 0 | Hold | Not 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. | |||
| W4 | ISO-EX-4410-01 Rev B, sheet 1 | Spool butt weld, pipe to flange | WPS-EX-021 Rev 2 | WX-12 | 2027-01-27 | Accepted | RT RT-EX-043 | Rejected | 0 | Hold | Indication reported in RT-EX-043. Repaired: see the R1 row. |
| W4 | ISO-EX-4410-01 Rev B, sheet 1 | Spool butt weld, pipe to flange: local repair | WPS-EX-021 Rev 2 | WX-12 | 2027-02-05 | Accepted | RT RT-EX-044 | Accepted | R1 | Released | Repair 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
| Release | Use it when |
|---|---|
| Released | The weld is complete, every examination the drawing and code require is accepted, and the quality engineer has released it. |
| Hold | Something stops the weld being made or accepted: an unapproved procedure, a welder without the qualification, or a rejected examination. Say what in Remarks. |
| Open | The weld is made or in progress, and a record or result is still to come. |
Columns and what to write
| Column | What to write |
|---|---|
| Weld no. | Weld number, exactly as it is marked on the weld map. Never reuse a number. |
| Drawing / isometric and sheet | The drawing or isometric the weld is on, with revision and sheet. |
| Joint type | Joint type and what it joins. |
| Size and thickness | Diameter or length, and the thickness welded. |
| Material | Base material specification and grade on each side of the joint. |
| WPS no. / rev | The 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 date | Date the weld was completed (YYYY-MM-DD). |
| Visual | Result of the visual examination: Accepted, Rejected or Pending (drop-down). |
| NDE method | The 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 result | Accepted, Rejected, Pending or Not required (drop-down). Rejected rows turn red. |
| Repair cycle | 0 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 record | Heat treatment chart or report number, or Not required. Whether PWHT is required comes from the code, the WPS and the PO. |
| Release | Released, Hold or Open (drop-down). Hold rows turn amber. |
| Remarks | What is open or on hold, and the action. |
How to use the template
- Fill in the header with the welding code the PO names, the weld map and drawing revisions, and the weld log number.
- 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.
- 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.
- When the weld is made, enter the welder ID or IDs and the weld date, then the visual result.
- 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.
- 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.
- Enter the PWHT chart or report number where heat treatment is required, then set the release. Hold rows turn amber and rejected rows red.
- 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.
