Why Use Excel for Pipe Weight?
While our online calculator gives instant results for single pipes, Excel is better when you need to:
- Calculate weight for many different pipe sizes at once (Bill of Quantities / BOQ)
- Combine pipe weights with other structural members in one sheet
- Keep a project-specific record that can be shared with clients or colleagues
- Build automated reports with totals, costs, and summaries
💡 Pro Tip
Use named ranges in Excel (e.g., name cell B2 as "density") so your formulas are readable: =(OD-t)*t*PI()*density/1000000 instead of cryptic cell references.
Round Pipe Weight Formula in Excel (MS / GI / SS)
The standard formula for round pipe weight per meter is:
Mathematical Formula
Weight (kg/m) = (OD − t) × t × 0.02466
For MS/GI pipes (density 7850 kg/m³) | For SS use 0.02476 | For Aluminium use 0.00843 | For Copper use 0.02796
In Excel, assuming OD is in column B and wall thickness in column C:
Excel Formula — Weight per Meter (kg/m)
=(B2-C2)*C2*0.02466
B2 = OD in mm | C2 = Wall thickness in mm | Result in kg/m
Excel Formula — Total Weight (kg)
=(B2-C2)*C2*0.02466*D2*E2
D2 = Length in meters | E2 = Quantity (number of pipes)
Density Constants for Different Pipe Materials
| Material | Density (kg/m³) | Excel Constant | Formula |
|---|---|---|---|
| MS / ERW / Seamless | 7850 | 0.02466 | =(OD-t)*t*0.02466 |
| GI (Galvanized) | ~8050 (with zinc) | 0.02528 | =(OD-t)*t*0.02528 |
| Stainless Steel (SS 304) | 7930 | 0.02476 | =(OD-t)*t*0.02476 |
| Aluminium | 2700 | 0.00843 | =(OD-t)*t*0.00843 |
| Copper | 8940 | 0.02796 | =(OD-t)*t*0.02796 |
Square Pipe (SHS) Weight Formula in Excel
For Square Hollow Section (SHS) pipes, the formula uses the outer width and wall thickness:
Mathematical Formula — Square Pipe
Weight (kg/m) = (4 × W − 4 × t) × t × 0.00785
W = Width in mm (all sides equal) | t = Wall thickness in mm | 0.00785 = steel density ÷ 1,000,000
Excel Formula — Square Pipe Weight per Meter
=(4*B2-4*C2)*C2*0.00785
B2 = Width in mm | C2 = Wall thickness in mm | Can also write as: =4*(B2-C2)*C2*0.00785
Rectangular Pipe (RHS) Weight Formula in Excel
For Rectangular Hollow Section (RHS) pipes, width and height can be different:
Mathematical Formula — Rectangular Pipe
Weight (kg/m) = (2 × (W + H) − 4 × t) × t × 0.00785
W = Width in mm | H = Height in mm | t = Wall thickness in mm
Excel Formula — Rectangular Pipe Weight per Meter
=(2*(B2+C2)-4*D2)*D2*0.00785
B2 = Width mm | C2 = Height mm | D2 = Wall thickness mm
Building a Complete Pipe Weight Sheet
Here is a recommended column layout for a professional pipe weight BOQ sheet:
🟢 Excel — Pipe Weight Calculator Sheet
| A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|
| Description | Type | OD / W (mm) | H (mm) | t (mm) | Length (m) | Qty | Total Wt (kg) |
| MS Pipe 2" | Round | 60.3 | — | 3.65 | 6 | 10 | 305.8 |
| GI Pipe 1" | Round | 33.4 | — | 3.25 | 6 | 20 | 289.8 |
| SHS 50×50×3 | Square | 50 | — | 3 | 6 | 15 | 395.1 |
| RHS 100×50×4 | Rect | 100 | 50 | 4 | 6 | 8 | 527.9 |
| Grand Total → | 1518.6 kg | ||||||
Excel Formulas for the H (Total Weight) Column
Use an IF statement to handle both round and square/rect pipes in one column:
Excel — Automatic Formula by Pipe Type (Column H)
=IF(B2="Round",(C2-E2)*E2*0.02466*F2*G2,
IF(B2="Square",4*(C2-E2)*E2*0.00785*F2*G2,
(2*(C2+D2)-4*E2)*E2*0.00785*F2*G2))
IF(B2="Square",4*(C2-E2)*E2*0.00785*F2*G2,
(2*(C2+D2)-4*E2)*E2*0.00785*F2*G2))
Handles Round, Square, and Rectangular pipes automatically based on Type column (B2)
Tips for Large BOQ / Material Lists
- Use a lookup table — Create a separate sheet with standard pipe sizes (OD, wall thickness) and use VLOOKUP or INDEX/MATCH to auto-fill dimensions when you type the pipe size.
- Add a unit check column — Create a column that shows kg/m separately so you can quickly spot any data entry errors before multiplying by length and quantity.
- Use data validation — Set dropdown lists for pipe type (Round/Square/Rect) and material (MS/GI/SS) to prevent typos that break formulas.
- Freeze header rows — For long BOQ lists, freeze the top two rows so column headers are always visible while scrolling.
- Colour-code by pipe type — Use Excel conditional formatting to highlight round pipes in blue, square in green, rectangular in orange for quick visual scanning.
⚠️ Common Error
Never mix mm and m in the same formula. OD and wall thickness must be in mm; length must be in meters. The constants (0.02466, 0.00785) already account for this unit conversion.
Common Mistakes to Avoid
| Mistake | What Happens | Fix |
|---|---|---|
| Using ID instead of OD | Weight calculated too low | Always use Outer Diameter in the formula |
| Length in mm instead of m | Weight 1000× too high | Convert: length mm ÷ 1000 = meters |
| Using MS constant for SS pipe | Weight ~1% low | Use 0.02476 for SS, 0.02466 for MS |
| Forgetting wall thickness units | Wrong result | Wall thickness must also be in mm |
| Not accounting for quantity | Single pipe weight only | Multiply by Qty at the end |
Frequently Asked Questions
What is the Excel formula for MS pipe weight per meter?▼
The Excel formula is
=(OD-t)*t*0.02466 where OD is the outer diameter in mm and t is the wall thickness in mm. For example, for a 2" MS pipe: =(60.3-3.65)*3.65*0.02466 = 5.10 kg/m. Multiply by length and quantity for total weight.Can I use the same formula for GI and MS pipe in Excel?▼
Approximately yes — the same 0.02466 constant works for GI as a reference value. For more precise GI calculation, use 0.02528 to account for the zinc coating (~2.5% heavier). The difference is within manufacturing tolerance for most practical purposes.
How do I calculate pipe weight for multiple sizes in one Excel sheet?▼
Set up columns for Description, Type, OD, Height (for RHS), Wall Thickness, Length, and Quantity. Use an IF formula in the weight column to handle round, square, and rectangular pipes automatically based on a "Type" dropdown. This lets you mix pipe types in one BOQ sheet.
Why is my Excel pipe weight calculation different from the chart?▼
Likely causes: (1) You used ID instead of OD, (2) Units mixed — length in mm instead of meters, (3) Using a different density constant, or (4) The chart uses a different wall thickness class (Light/Medium/Heavy). Check each input carefully and compare with our online calculator for verification.
Is there a ready-made pipe weight Excel template?▼
You can build one quickly using the formulas and layout shown in this guide. For single pipe calculations without Excel, use our free MS Pipe Weight Calculator — it handles all pipe types with instant results and PDF export, which is faster than Excel for one-off calculations.