BOQ Format for Steel Structure in Excel: A Practical Guide
The exact column layout, sheet structure and formula logic that makes a structural steel BOQ actually work in Excel — instead of a static table someone has to re-total by hand.
The Column Layout a Steel BOQ Needs
At minimum, each detailed BOQ line needs nine columns:
| Column | Purpose |
|---|---|
| Sl. No. | Sequential item number for reference in RFIs and correspondence |
| Item Code | A short code (e.g. SS-101) so items can be cross-referenced from drawings or a rate analysis tab |
| Description of Item | Full scope description — what's included, not just a shape name |
| Specification / Code Reference | The governing ASTM/AISC/AWS standard for that item |
| Unit | Ton, SF, LF, EA, Lb, Lot, etc. |
| Quantity | The measured or estimated quantity — this is your editable input cell |
| Rate (USD $) | Unit rate, either a direct input or linked to a Rate Analysis tab |
| Amount (USD $) | = Quantity × Rate, always a formula, never typed in |
| Remarks | Notes like "see Rate Analysis RA-1" or "excludes foundation concrete" |
Formulas, Not Hardcoded Numbers
The single biggest difference between a template that looks professional and one that actually functions is whether the numbers are formulas or typed-in results. In a properly built BOQ:
Amount cells
Always =Quantity*Rate, never a typed dollar figure.
Section subtotals
Always =SUM(range) over that section's amount cells.
Grand total
Always a formula summing every section subtotal, plus overhead/profit/contingency as percentage formulas of that subtotal.
Cross-sheet links
A Summary tab should pull each section total with a formula referencing the detail sheet, e.g. ='BOQ - Structural Steel'!H18, not a copy-pasted value.
Already Built, Formula-First
Every total in our template is a live formula — change a quantity or rate and the Summary, Rate Analysis and Bid Form all recalculate automatically.
Get the BOQ Template – $49 →How Many Sheets You Actually Need
A single-sheet BOQ works for a quick budget estimate. A tender-ready package needs several: a Cover Sheet, Document Control, General Notes & Preambles, Abbreviations, a BOQ Summary, the Detailed BOQ itself, a Rate Analysis backup, a Material Take-off cross-check, and a Bid Form. Nine tabs sounds like a lot until you consider that each one answers a question a reviewer or bidder will otherwise have to ask you directly.
Formatting Conventions Reviewers Expect
Shade the editable input cells (Quantity and Rate) a distinct color — pale yellow is the informal industry standard — so anyone opening the file instantly knows where to type. Where a rate is linked live to a Rate Analysis tab, color that font differently (green is common) so it's clear the number updates automatically and shouldn't be overtyped. Use currency formatting consistently ($#,##0.00) and never leave a formula cell displaying a raw unformatted number.
A Working Example, Already Built
Rather than build this structure from scratch, our Structural Steel Works BOQ Template already implements every convention above: color-coded input cells, live cross-sheet formulas, a 60-item detailed BOQ across 8 sections, and a Rate Analysis tab feeding 3 key items automatically. It's built around a realistic 150,000 SF Florida commercial project so you can see the format in action before adapting it to your own.
Frequently Asked Questions
Yes — standard SUM, multiplication and cross-sheet reference formulas work identically in Google Sheets and Excel.
Yes. A hardcoded Amount defeats the entire purpose of a spreadsheet BOQ — it should always recalculate when Quantity or Rate changes.
A takeoff is the raw quantity measurement from drawings. A BOQ takes those quantities and adds descriptions, spec references, units, rates and totals — it's the priced, tender-ready document.
Skip the Blank Spreadsheet
Get our tender-ready, 60-item Structural Steel Works BOQ template — 9 tabs, live formulas, Florida codes referenced. $49, instant download.
Get the BOQ Template – $49 →