Civil Work BOQ Excel: How to Create a Professional Bill of Quantities in Excel
Learn how to structure, format, and automate your Bill of Quantities (BOQ) in Excel so you can bid, bill, and control costs with confidence.
While specialised estimation software exists, Civil work BOQ Excel remains the gold standard for most engineers and contractors in India. Excel and Google Sheets offer unmatched flexibility, allowing users to build custom formulas, easily edit quantities as designs evolve, and share professional-looking documents with stakeholders without requiring expensive licenses. This guide walks you through creating a professional Bill of Quantities Excel sheet from scratch, from basic column setup to automation and best practices for 2026.
Want to skip the setup and start with a ready‑made Excel BOQ?
Basics of a Civil Work BOQ Format
Before you start typing into a spreadsheet, you must understand the components that make a BOQ legally and technically sound. A professional construction BOQ format in Excel is divided into logical work categories and standardised columns.
What information goes into a BOQ?
A comprehensive BOQ should be organised into work sections that follow the natural sequence of construction. Common sections include:
- Preliminaries: Site setup, mobilization, temporary facilities, and safety equipment.
- Earthwork: Excavation, site clearance, sand filling, and anti-termite treatments.
- Concrete Works: PCC for foundations and RCC for structural members.
- Masonry: Brickwork or AAC block masonry for walls.
- Plastering & Finishing: Internal and external plaster, flooring, and wall tiles.
- Painting: Primers, distemper, emulsion, or weather-proof exterior paints.
- External Works: Roadwork, drainage, and landscaping.
Standard BOQ Columns
Every civil BOQ template needs a clear set of columns:
- Item No. / S. No.: Unique identifier (e.g., 1.1, 1.2).
- Description of Work: Full technical specification, not just “concrete”.
- Unit: Cu.m, Sq.m, Tonne, Nos, etc.
- Quantity: Derived from drawings and quantity take‑off.
- Rate: Per‑unit cost including material, labour, and wastage.
- Amount: Calculated as Quantity × Rate.
- Optional: Remarks, Item Code, GST breakdown.
Designing Your Civil Work BOQ Excel Template
A professional layout makes your estimate easy to read and difficult to dispute. Use a clean hierarchy, consistent fonts, and clear separation between sections, the main BOQ table, and totals.
Sheet layout and structure
- Header Section: Project Name, Client Name, Site Location, Preparation Date, Version/Revision Number.
- Main BOQ Table: The core area where items, descriptions, units, quantities, rates, and amounts reside.
- Summary Section: Subtotals for each work category and a final Grand Total, either at the bottom or on a master sheet.
Setting up columns and basic formatting
- Headers: Place column headers in Row 1 or 2 with a subtle background colour and bold text.
- Freeze Panes: Use “Freeze Top Row” so headers stay visible while scrolling.
- Number Formats: Set Quantity, Rate, and Amount as numbers with 2 decimal places.
- Borders: Apply thin borders for cells and thicker borders to separate major work categories.
Don’t want to build this structure manually?
Use our pre‑built Excel file with sections, formulas, and printing layout already configured.
Adding Formulas to Automate Your BOQ
The main advantage of a bill of quantities Excel sheet is automation. With formulas, you reduce manual errors and can update your entire bid instantly when quantities or rates change.
Basic calculation formulas
- Row Total: In the “Amount” column, use
=E10*F10if Quantity is in E10 and Rate in F10. - Section Subtotals: At the end of each section, use
=SUM(G5:G15)to add all line items. - Grand Total: Sum all section subtotals to get the overall project value.
- Taxes & Contingencies: Add rows for GST (for example,
=GrandTotalCell*0.18) and a 3–5% contingency.
Example Structure of a Civil Work BOQ Excel Sheet
Below is a simplified example of how to structure your BOQ. Replace the placeholders with your own quantities and rates.
| Item No. | Description of Work | Unit | Quantity | Rate | Amount |
|---|---|---|---|---|---|
| 1.0 | EARTHWORK | ||||
| 1.1 | Site clearance and removal of vegetation up to 150mm depth | Sq.m | 225.00 | ___ | ___ |
| 1.2 | Excavation in foundation trenches in ordinary soil up to 1.5m | Cu.m | 45.00 | ___ | ___ |
| 2.0 | CONCRETE WORKS | ||||
| 2.1 | PCC 1:4:8 using 40mm stone aggregate under foundation | Cu.m | 15.00 | ___ | ___ |
| 2.2 | RCC M25 grade in columns including shuttering and curing | Cu.m | 42.00 | ___ | ___ |
| 3.0 | MASONRY & FINISHING | ||||
| 3.1 | Brick masonry 230mm thick in CM 1:6 in superstructure | Cu.m | 60.00 | ___ | ___ |
| 3.2 | 12mm thick cement plaster CM 1:4 on internal walls | Sq.m | 380.00 | ___ | ___ |
| 3.3 | Vitrified tile flooring 600x600mm (Premium Grade) | Sq.m | 140.00 | ___ | ___ |
Prefer a plug‑and‑play template instead of building this from scratch?
Separating Sections and Using Multiple Sheets
There are two common ways to organise your civil estimate Excel sheet:
- Single-Sheet Approach: All items on one sheet with bold section headings and subtotals. Ideal for smaller projects.
- Multi-Sheet Workbook: One tab per discipline (Civil, Electrical, Plumbing), plus a Summary sheet aggregating totals.
- Name sheets clearly: “01_Civil”, “02_Electrical”.
- Create a “Summary” sheet as the first tab.
- Link each sheet’s total into the Summary using cell references.
Exporting and Sharing Your BOQ
- Set Print Area: Highlight the BOQ region and set it as the print area.
- Page Layout: Use landscape orientation and “Fit to width” for wide tables.
- Export to PDF: Share PDFs with clients to lock formatting and avoid accidental edits.
Common Mistakes to Avoid in BOQ Excel Sheets
- Mixing Units: Do not mix Nos, Kg, Cu.m for the same type of item.
- Manual Totals: Never type totals; always use formulas.
- Version Confusion: Maintain revision numbers (R0, R1, R2…).
- Ignoring Wastage: Always add realistic wastage allowances to net quantities.
Turn Your Civil Work BOQ Excel Sheet into a Live Project Control Tool
Mastering your Civil work BOQ Excel process is a game-changer for your career and business. A well-designed sheet is more than just a list of prices; it is a living document that you will update throughout the project lifecycle—from initial tender to final billing and variation management. By using automation, standardised layouts, and precise descriptions, you build trust with your clients and keep projects profitable and professionally managed.
Ready to use a battle‑tested BOQ Excel file on your next project?
