Free template

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.

Free, no sign-up. Works in Excel, Google Sheets and LibreOffice. Columns marked “auto” are formulas.

Preview

Item no.Description of workUnitQuantityRate (₹)Amount (₹)
1.1Earthwork in excavation in foundation trenches, all kinds of soilcum450285auto
1.2PCC 1:4:8 in foundationcum386,200auto
2.1RCC M25 in footings, columns, beams and slabs (excl. steel)cum2107,850auto
2.2TMT reinforcement Fe500D, cutting, bending and placingkg24,50078auto
3.1Brickwork in CM 1:6 in superstructurecum1606,900auto
4.112 mm cement plaster 1:6 internal wallssqm2,400310auto

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