The Welder Continuity Log: an Excel template built by an AWS Certified Welding Inspector that tracks every welder, every process, and every expiration date for you.
Your welders passed their tests. You’ve got the paperwork in the cabinet to prove it. But under AWS D1.1, D1.5, D1.6 and ASME Section IX, that qualification only stays good as long as the welder keeps using the process. Six months without running it and it’s gone, whether anybody noticed or not.
Most shops find out the hard way. An inspector asks for continuity records, nobody can produce them, and now a welder is pulled off the job, his welds are in question, and you’re paying for retests and maybe tear-outs.
This log makes sure that never happens to you. Log the work as it happens, and the spreadsheet tells you who’s current, who’s about to lapse, and who already has.
What It Does
- Calculates every expiration for you. Enter when a welder runs a process on a job. The log finds his most recent date, adds the continuity period, and shows the exact day his qualification expires and how many days he has left.
- Color-coded status at a glance. Every welder and process is marked green for CURRENT, amber for DUE SOON, or red for LAPSED. Open the file and you know where you stand in five seconds.
- Warns you before it’s too late. DUE SOON kicks in 30 days out by default, so you have time to get that welder on a production weld before he lapses. You can change the warning window to whatever you want.
- Tracks each process separately. A welder qualified on GMAW and FCAW gets a line for each, because the code treats them separately. That’s where most shops get caught.
- Keeps a complete activity history. Every entry is saved with the date, job number, WPS and who verified it. When an auditor wants to see the trail, filter by welder and hand it over.
- One-page summary. See how many qualifications you’re tracking, how many are current, due soon and lapsed, your percent current, and the next expiration coming up.

- Audit-ready printouts. Prints landscape with your company name, a signature block for monthly review, and page numbers.
- Fully editable. No locked cells and no macros. Change the continuity period, add your own processes and codes, and make it yours.
How It Works
- Set it up once. Enter your company info, then add each welder with his ID or stamp, process, governing code, WPS and qualification test date. Dropdowns keep the entries consistent.

2. Log the work. Whenever a welder runs a process on a job, add a line to the Activity Log: date, welder ID, process, job number and who verified it. That’s about ten seconds per entry.

3. Let it do the rest. The Continuity Log updates itself. Once a month, filter for DUE SOON and LAPSED, deal with those welders, sign the review block, and file the printout with your qualification records.

No formulas to write and no dates to calculate by hand. If you can fill out a time card, you can run this log.
Who It’s For
- Structural steel fabricators and erectors working to AWS D1.1
- AISC-certified shops that need clean records for their annual audit
- Pressure vessel and piping shops qualifying welders under ASME Section IX
- QC managers, welding coordinators and CWIs managing welders for one shop or several
Whether you run five welders or fifty, it holds up to 200 welder-process lines and 2,000 activity entries.
What’s Included
- The Welder Continuity Log Excel workbook (.xlsx)
- Five tabs: Continuity Log, Activity Log, Summary, Settings & Lists, and step-by-step Instructions
- Preloaded dropdowns for common processes (SMAW, GMAW, FCAW, GTAW, SAW and more) and codes (AWS D1.1 through D1.8, ASME Section IX, API 1104 and more)
- Sample entries showing all three statuses so you can see it working before you enter your own
Requirements
Microsoft Excel 2019, Excel 2021, or Excel for Microsoft 365, on Windows or Mac. Older versions of Excel aren’t supported.
Built by an Inspector, Not a Software Company
This log was built by the owner of ProArc Consulting, an AWS Certified Welding Inspector and ICC Master Special Inspector. I verify welder qualifications on structural steel jobs for a living, and I’ve watched a countless number of good shops get burned by continuity records that were missing or months behind.
So I built the log I wish every shop had: one that tracks what inspectors and auditors actually check, in plain language, with no subscription and no learning curve.
Frequently Asked Questions
Does it work for ASME Section IX as well as AWS D1.1? Yes. Both use a six-month continuity period, and you can change the period on the Settings tab if your code, edition or contract says otherwise.
Is there a monthly fee? No. You buy it once and it’s yours.
Does it use macros? No. No security warnings, and it works on both Windows and Mac.
Can I change it? Yes. Nothing is locked. Rename columns, add processes and codes, and put your own logo on it.
Does this replace my welder qualification records? No. It’s a recordkeeping tool that works alongside your WPQ records. Your governing code, contract documents and engineer of record still control the requirements.
Get Your Welders’ Records Audit-Ready Today
One requalification test costs more than this template. One tear-out costs a whole lot more.
Welder Continuity Log – $100
USD 100.00
Need welders qualified or requalified, or want help setting up your continuity program? ProArc Consulting does that too. Contact us.
