Civil Work Boq Excel: Complete Guide For Contractors In India 2026

By Author: Construction Estimator India
Total Articles: 1
Comment this article

Civil contractors across India frequently face challenges while preparing accurate bills of quantities. Manual calculations often lead to errors in quantities, missed items like reinforcement steel or formwork, and last-minute corrections that can result in lost tenders or reduced profit margins. A well-designed civil work BOQ Excel template helps eliminate these issues by providing automated, professional, and tender-ready documentation.

This guide explains what a civil work BOQ is, why Excel format works best, presents real sample data for a typical residential project, and outlines best practices for creating or customizing your own BOQ.

What is a Civil Work BOQ and Why Use Excel Format?

A Bill of Quantities (BOQ) for civil works is a detailed document that lists every item of work — from excavation to finishing — along with descriptions, units, quantities, rates, and total amounts. It forms the foundation for tender submissions, client quotations, project costing, and progress monitoring.
In India, especially in regions ...
... like Delhi NCR, Uttar Pradesh, Rajasthan, and other states, authorities prefer PWD-style civil BOQ Excel formats aligned with CPWD, DSR, and IS 1200 standards. Excel remains the preferred platform because it supports automatic calculations, section-wise subtotals, GST integration, and professional formatting for tender documents.
Manual BOQ preparation is time-consuming and prone to 10-20% errors, while a structured Excel template ensures accuracy and consistency across residential houses, small commercial buildings, or renovation projects.

Real Sample: Civil Work BOQ for 1500 sq.ft. G+1 House (Delhi NCR – 2026 Rates)

Here is a realistic example of a civil work BOQ Excel for a 1500 sq.ft. residential G+1 house based on current DSR guidelines applicable in Delhi NCR, Ghaziabad, Meerut, and surrounding areas.

Excavation & Earthwork
Excavation in earthwork for foundation (up to 1.5m depth): 25 Cum × ₹180 = ₹4,500
Earth filling in plinth: 10 Cum × ₹120 = ₹1,200
Subtotal: ₹5,700

PCC, RCC & Reinforcement
PCC 1:4:8 (40mm) for footing: 8 Cum × ₹4,200 = ₹33,600
RCC M20 for beams/columns (formwork included): 15 Cum × ₹6,800 = ₹1,02,000
Reinforcement steel (Fe500): 2.5 MT × ₹65,000 = ₹1,62,500
Subtotal: ₹2,98,100

Brick Masonry & Plastering
Brick masonry in cement mortar 1:6 (230mm thick): 20 Cum × ₹5,500 = ₹1,10,000
Internal plaster 12mm (1:6): 300 Sqm × ₹180 = ₹54,000
External plaster 20mm (1:5): 200 Sqm × ₹220 = ₹44,000
Subtotal: ₹2,08,000

Concrete Flooring & Tiling
Cement concrete flooring 1:4:8 (50mm thick): 150 Sqm × ₹450 = ₹67,500
Vitrified tiles 600x600mm (first quality): 150 Sqm × ₹850 = ₹1,27,500
Subtotal: ₹1,95,000

Roofing & Waterproofing
RCC slab M20 (100mm thick, centring included): 150 Sqm × ₹1,200 = ₹1,80,000
Waterproofing with APP membrane: 150 Sqm × ₹350 = ₹52,500
Subtotal: ₹2,32,500

Finishing Works
Door/window frames (Sal wood): 12 Nos × ₹4,500 = ₹54,000
Painting two coats (oil bound distemper): 400 Sqm × ₹120 = ₹48,000
Subtotal: ₹1,02,000

Grand Total (Civil Works): ₹11,31,300 + 18% GST = ₹13,35,934 (approx.)
This sample demonstrates a clean, professional PWD style civil BOQ Excel format suitable for tender submissions.

Step-by-Step Process to Create Civil Work BOQ in Excel

Sheet Structure — Set up columns: Sl. No., Description of Item (as per IS 1200/DSR), Unit, Quantity, Rate, Amount (=Qty × Rate), and Subtotal rows.
Organize by Sections — Group items under clear headings such as Earthwork, RCC, Masonry, Finishing, etc.
Add Formulas — Use =SUM() for subtotals, automatic grand total, and GST calculation.
Incorporate Rates — Reference latest DSR 2026 values and adjust for local market rates in your city.
Enhance Functionality — Apply data validation for units, conditional formatting for cost alerts, and protect formula cells.
Review & Export — Validate quantities against drawings, format professionally, and export as PDF for client or tender use.
Advanced Tips — Use PivotTables for summary analysis or separate sheets for rate analysis.

Key Benefits of Using Professional Civil Work BOQ Excel

Significant time savings — complete BOQs in hours instead of days
Reduced errors through automated calculations
Consistent, tender-compliant professional appearance
Better project cost control and margin visibility
Easy customization for different project types and locations
Improved bid success rate due to accuracy and presentation
Contractors working on house construction, villa projects, or small commercial works in Noida, Ghaziabad, Delhi, or other Tier-1/Tier-2 cities find this approach particularly effective.

FAQ – Civil Work BOQ Excel

What is a civil work BOQ Excel?
It is a spreadsheet-based template that systematically lists and calculates all civil construction items with automatic totals, ideal for tenders and quotations.
Is the civil BOQ format Excel PWD compliant?
Yes, when prepared according to DSR and IS 1200 standards, it meets requirements for PWD and other government tenders in most states.
How accurate is a house construction civil BOQ Excel sample?
It provides a reliable reference when quantities are taken correctly from architectural and structural drawings.
Can the same template be used for commercial projects?
Absolutely. The structure scales well for both residential and small-to-medium commercial civil works.
Does it support GST calculation?
Modern formats include built-in provisions for GST at applicable rates with clear breakdowns.
Is Google Sheets compatible?
Yes, most well-designed civil BOQ Excel templates work smoothly on Google Sheets as well.
How to update rates for local areas like Meerut or Ghaziabad?
Simply edit the rate column — all amount and total calculations update automatically.
Accurate civil work BOQ preparation remains one of the most important skills for successful contractors in India. Using a structured Excel approach helps deliver professional results consistently while saving valuable time on every project.