Steel RFQ template and generator
A steel RFQ is the material list you send to service centers so every vendor prices the same steel on the same basis. It lists each item by size, grade, quantity, stock length and purchase weight, grouped by material — W-shapes, plate, flat bar — with blank columns for the vendor's price, availability, lead time and alternates, and the terms you buy on.
What goes in the template
The blank CSV opens in Excel or Google Sheets with these 14 columns. The first eight are yours to fill; the last six are for the vendor.
- Item
- Category
- Description
- Size / Designation
- Grade
- Qty
- Stock Length / Size
- Est. Purchase Wt (lbs)
- Unit Price ($) — vendor fills
- Total Price ($) — vendor fills
- Availability — vendor fills
- Lead Time (days) — vendor fills
- Alternate Size — vendor fills
- Notes — vendor fills
Worked example
A fictional buyer, Example Fabricators LLC, needs material for a small sample loading dock canopy. The company and project do not exist. Purchase weights are the published weight per foot times the purchased length; plate is area × thickness × 40.84 lb/ft² per inch.
| Item | Size | Grade | Qty | Stock | Purchase wt |
|---|---|---|---|---|---|
| A-01 | W10X33 | A992 Gr.50 | 4 | 4 sticks × 20′ | 2,640 lb |
| A-02 | W16X26 | A992 Gr.50 | 2 | 2 sticks × 40′ | 2,080 lb |
| B-01 | PL 3/4 × 48 × 96 | A572 Gr.50 | 1 | 1 sheet 48×96 | 980 lb |
| C-01 | FB 3/8 × 4 | A36 | 1 | 1 bar × 20′ | 102 lb |
| Total purchase weight | 5,802 lb | ||||
The generator below is pre-filled with this input. Download it and the workbook has: the buyer and project header; a yellow draft line that tells the reviewer to check the sheet; a vendor contact block; the four lines in three groups — W-shapes (A992 Gr.50), plate stock (A572 Gr.50) and flat bar stock (A36); a total row that sums the 5,802 lb and the vendor's prices; and 8 standard terms. Run it again with the same input and you get the same rows and totals.
Generate your RFQ
Replace the example with your own lines. A line with zero quantity or "BY OTHERS" in the description is left out.
The file is a draft. A qualified person must check quantities, sizes, grades and terms before it goes to a vendor. Nothing you enter is stored.
Common questions
- What is a steel RFQ?
- A request for quotation: the material list a buyer sends to steel service centers or mills so each one prices the same items on the same basis. A good one fixes size, grade, quantity, stock length and terms, and leaves clear cells for the vendor's price, availability and lead time.
- What should a structural steel RFQ include?
- A header with the buyer, project, issue date and response date; a block for the vendor's contact details; line items grouped by material with size, grade, quantity, stock length and estimated purchase weight; vendor columns for unit price, total, availability, lead time and alternates; a total; and terms covering delivery, mill test reports, payment, substitutions and quote validity.
- Why group the line items by material?
- Service centers price wide-flange shapes, plate and flat bar from different stock and often different desks. Grouping keeps one grade per block where possible and lets a vendor quote the groups it carries and leave the others blank, which makes the returned quotes easier to compare line by line.
- Should the RFQ list net weight or purchase weight?
- Purchase weight — what the vendor will ship, in full sticks and sheets. Net takeoff weight leaves out drops and cutting waste, so a vendor would price less steel than you need. Work out purchase weight from your stock lengths and nesting, then let a person check it before the RFQ goes out.
- Can my AI assistant generate this RFQ?
- Yes. The same generator is the steel_rfq_generate tool on the free StructuPath MCP server. An assistant that has read your estimate passes the line items and gets back a link to the same workbook. The output is a draft either way: a qualified person reviews it before it is sent.
Sources
- AISC 303-22, Code of Standard Practice for Steel Buildings and Bridges
- ASTM A6/A6M, general requirements for rolled structural steel
- ASTM A992/A992M, structural steel shapes
- AWS D1.1 and other AWS standards
- Purchase weights: structural shape weights and plate weight calculator. Checking the certs that come back: how to read a mill test report.
Want these for yourself?
We can put these tools on your site, in your systems, or in front of your customers.
Everything here is something we built for ourselves first. If a calculator like this would earn its keep in your business, we build the same thing against your data and your brand.
On your website
Branded to your shop and hosted on your own domain. Reference tools are the reason people bookmark a fabricator's site — they come back for the chart and remember who published it.
Wired to your data
The same math running against your inventory, your mill certs and your job costs, so a takeoff pulls real weights from real material instead of a lookup table.
As internal tooling
Built into whatever your estimators already open. Fewer spreadsheets passed around, and one place where the numbers are known to be right.
Steel AI Assessment $1,500 · Custom builds from $8,500 · Free discovery call first