Here's a free structural steel takeoff template for Excel — no email gate, no macros, no watermark. It has a line-item takeoff tab with BOM columns, automatic weight-per-foot lookups against a built-in database of 4,500+ steel sections across six standards, and a summary tab that rolls everything up to tonnage and a priced bid total.

Download the template (.xlsx, ~110 KB) — opens in Excel, Google Sheets, or LibreOffice. Type W12X26 in the Section column and the weight fills itself in.

Most "free" steel takeoff templates you'll find are either a screenshot on Scribd, a $12 Etsy listing with someone else's weights hand-typed into it, or a lead-capture form that trades your inbox for four columns and a SUM formula. This one is just a working spreadsheet. Use it, copy it, hand it to your apprentice.

What's Inside the Template

Four tabs:

| Tab | What it does | |---|---| | ReadMe | One-page instructions and data-source notes | | Takeoff | 200 line-item rows: Mark, Section, Qty, Length, auto Wt/ft, auto Total Wt, Grade, Finish, Sheet ref, Notes | | Summary | Total pieces, total weight (lbs and tons), material cost, shop labor, contingency, bid total — plus two error counters | | Sections | The lookup database: 4,500+ designations with weight per foot, tagged by standard |

The Takeoff tab is the one you live in. Each row is one line item from the drawings — same structure you'd use in a bill of materials. Two columns calculate themselves:

Wt/ft — a VLOOKUP against the Sections tab. It normalizes what you type (strips spaces, ignores case), so hss 6x6x1/4 resolves the same as HSS6X6X1/4. If a designation isn't in the database, you get NOT FOUND instead of a silent zero.
Total Wt — Qty × Length × Wt/ft. It stays blank until all three inputs exist, so half-entered rows can't leak partial weight into your tonnage.

The Summary tab has two sanity counters most templates skip: a count of NOT FOUND lookups and a count of rows that have a section but are missing a quantity or length. If either number isn't zero, your bid total is wrong. Check them before you price anything.

How to Use It: Drawing Set to Priced Summary in 6 Steps

Set your rates. Top of the Takeoff tab: steel $/lb and shop labor $/ton. The defaults ($0.85/lb, $950/ton) are placeholders — put in your real numbers.
Work the drawings one sheet at a time. Mark up a printed set or PDF as you go — every member you've entered gets a highlight, every member without a highlight isn't in your bid yet. This is the discipline that separates a takeoff from a guess; the common takeoff mistakes list is mostly people skipping this step.
One row per line item. Mark (B1, C3, L-101), section designation, quantity, length. Enter lengths in decimal feet: 28'-6" is 28.5. Record the sheet number in the Sheet/Detail column so you can trace any line back to the drawing during a bid review.
Watch the Wt/ft column. If it fills in, the designation matched. If it says NOT FOUND, check spelling against the Sections tab — the usual culprits are a missing X (W12 26), an O instead of a zero, or a fraction written as a decimal when the catalog uses fractions.
Check the Summary error counters. Both should read zero before you look at the total.
Read the roll-up. Total tonnage, material cost, labor, 5% contingency (editable), bid total. Adjust contingency to match the job risk and your backlog.

For a full walk-through of steps 2 and 3 against an actual drawing set — schedules, plans, sections, and how the piece counts reconcile — see the structural steel takeoff example.

The Built-In Section Weights: How the Lookup Tab Works

The Sections tab is the reason to use this template over a blank spreadsheet. It carries 4,500+ sections compiled from published catalogs across six standards, all normalized to pounds per foot so the roll-up stays in one unit system:

| Designation | Wt/ft (lbs) | Standard | |---|---|---| | W12X26 | 26.0 | AISC | | HSS6X6X1/4 | 19.02 | AISC | | L4X4X1/4 | 6.6 | AISC | | C10X15.3 | 15.3 | AISC | | 310UB40.4 | 27.15 | AS/NZS | | IPE300 | 28.36 | EN | | ISMB300 | 29.7 | IS 808 | | HW100X100X6X8 | 11.56 | GB | | 600S162-54 | 1.89 | CFS/SSMA |

Metric-catalog sections (EN, BS, IS, GB, AS/NZS) are converted from kg/m at the standard factor, so an Australian UB and an American wide-flange sum into the same tonnage column without you touching a converter. Cold-formed SSMA studs and tracks are in there too, which matters if you quote light-gauge alongside structural.

Two honest caveats. First, weights are catalog values — verify against your supplier's current catalog for anything contract-critical, because some standards print nominal thicknesses that differ slightly from rolled actuals. Second, a lookup table can't tell you a wrong but valid designation: type W12X26 where the drawing says W21X26 and every formula happily computes the wrong answer. If you just need to check one beam's weight quickly without opening Excel, the free steel weight calculator does the same lookup in the browser.

Where the Template Breaks Down

I'll be direct about the limits, because this is the part the Etsy listings don't mention.

The template starts at step 3. Finding every member on the drawings and counting them is 80% of takeoff labor, and the spreadsheet does none of it. On a 5-page shop building that's an afternoon. On a 40-page drawing set with framing plans, schedules, sections, and details, it's days — and every hour of manual counting is an hour of transposition risk.

Nothing cross-checks the drawings. If a beam appears on the plan and again in a section detail, nothing warns you that you counted it twice. If a schedule lists 14 of something and you only found 12 on plan, nothing flags the gap. The count-reconciliation habits in schedule vs. direct-label takeoffs exist precisely because spreadsheets can't do this.

Revisions are brutal. Rev B drops and you're re-reading every sheet, diffing against your rows by memory. Most estimators re-do the whole takeoff because trusting a manual diff is scarier than the lost day.

No audit trail per piece. A Sheet/Detail column says which sheet a line came from — not where on the sheet each of the 14 pieces was found. When a GC challenges your count, you're back in the drawings rebuilding your own evidence.

We wrote up the fuller version of this trade-off in steel estimating templates: what they can't do.

Template vs. Software: An Honest Comparison

| | This template | Takeoff software | |---|---|---| | Cost | Free | Free tier to ~$400/mo | | Weight math and roll-ups | Yes | Yes | | Reads the PDF and finds members | No — you count | Yes — AI detection, you verify | | Per-piece audit trail on the drawing | No | Yes — every count tied to a marked location | | Double-count / missed-member checks | Your discipline | Built-in review flags | | Handles revisions | Full manual re-take | Re-run and re-review | | Best for | 1–10 page jobs, occasional bids | Multi-sheet sets, weekly bidding |

The honest framing: if you bid a couple of small jobs a month, this template plus discipline is genuinely enough, and software subscription math doesn't work in your favor. The crossover comes when counting time — not calculating time — is what caps how many bids you can turn. That's the gap tools like SteelFlo target: upload the PDF, AI boxes every member label on every page, you verify the boxes instead of hunting for them, and the verified counts export straight into a BOM with the same weight lookups this template uses. The 95–99% accuracy that workflow reaches comes from AI detection plus your verification pass — the same reason this template makes you check its two error counters. The full comparison is in SteelFlo vs. Excel for steel takeoffs.

Worked Example: A Small Mezzanine

The template downloads with these four rows pre-filled so you can see it working. A single-level storage mezzanine, about as simple as structural steel gets:

| Mark | Section | Qty | Length (ft) | Wt/ft | Total Wt (lbs) | |---|---|---|---|---|---| | B1 | W12X26 | 8 | 30.0 | 26.0 | 6,240.0 | | B2 | W16X26 | 4 | 28.5 | 26.0 | 2,964.0 | | C1 | HSS6X6X1/4 | 6 | 14.0 | 19.02 | 1,597.7 | | L1 | L4X4X1/4 | 24 | 1.0 | 6.6 | 158.4 |

Summary tab output, at the default rates:

Total weight: 10,960 lbs → 5.48 tons
Material @ $0.85/lb: $9,316
Shop labor @ $950/ton: $5,206
Subtotal: $14,522 → bid total with 5% contingency: $15,248

Forty-two pieces, four line items, and the whole thing prices itself the moment the last length goes in. Note what the template caught along the way: the clip angles (L1) are 24 pieces at a foot each — 158 lbs that a "beams and columns only" takeoff would have dropped. Small stuff is where manual takeoffs quietly leak weight.

Now scale the picture: a real commercial job might run 300–1,500 line entries across 30+ sheets. The formulas hold up fine. The counting is what gets you.

Outgrown the spreadsheet? When the bottleneck stops being the math and starts being the counting, start 3 free takeoffs with SteelFlo — upload a PDF drawing set, verify the AI-detected members, and export a BOM with the same section weights built into this template. No credit card, and the template's still yours either way.

Free Steel Takeoff Template (Excel)