BOQ format in Excel: free bill of quantities template
This BOQ (bill of quantities) template lists each work item with unit, quantity, rate and amount, with sub-total, GST and grand total formulas — ready to price a tender or to use as the base for RA bills.
Preview
| Item no. | Description of work | Unit | Quantity | Rate (₹) | Amount (₹) |
|---|---|---|---|---|---|
| 1.1 | Earthwork in excavation in foundation trenches, all kinds of soil | cum | 450 | 285 | auto |
| 1.2 | PCC 1:4:8 in foundation | cum | 38 | 6,200 | auto |
| 2.1 | RCC M25 in footings, columns, beams and slabs (excl. steel) | cum | 210 | 7,850 | auto |
| 2.2 | TMT reinforcement Fe500D, cutting, bending and placing | kg | 24,500 | 78 | auto |
| 3.1 | Brickwork in CM 1:6 in superstructure | cum | 160 | 6,900 | auto |
| 4.1 | 12 mm cement plaster 1:6 internal walls | sqm | 2,400 | 310 | auto |
How to use this template
- Rates shown are placeholders — use your own rate analysis or the applicable DSR/SOR.
- Keep the original BOQ unchanged and record changes as revisions or variation orders.
Template FAQ
Is the Construction BOQ Template free to download?
Yes. The .xlsx file is free with no sign-up. It opens in Excel, Google Sheets and LibreOffice.
What columns does the Construction BOQ Template include?
Item no., Description of work, Unit, Quantity, Rate (₹), Amount (₹).
Which columns are calculated automatically?
Amount (₹) is filled by formulas, so you only enter the other columns. Formulas stay visible so you can audit or change them.
When should I move from this spreadsheet to Construction ERP?
Use the spreadsheet while one person maintains it. Move to construction ERP software when several people need to update it, you need approvals and history, or the numbers must post to GST accounting and reports automatically.
Related tools and templates
Construction Profit Calculator
Free contractor profit calculator for Indian construction projects: contract value vs material, labour, subcontract, equipment and overheads, with margin %, cost breakdown and retention — formula and worked example included.
Use calculator → Free toolProject Cost Calculator
Free project cost estimator: direct cost, overheads, contingency, target margin and GST to arrive at a quote value for construction and contracting jobs.
Use calculator → Free toolBOQ Calculator
Free online BOQ calculator: add items with unit, quantity and rate, get amounts, sub-total, GST and grand total, and export the bill of quantities to CSV.
Use calculator → TemplateConstruction Project Budget Template
Free construction project budget template: budget, committed and actual cost by cost head, variance and percentage used, with totals.
Download → TemplateProject Cost Sheet
Free project cost sheet Excel template: material, labour, equipment and subcontract lines with overheads, contingency, profit margin and GST to quote value.
Download →