📥 Free template

BOQ format in Excel: free download with a filled example

A Bill of Quantities lists every item of work with its description, unit, quantity and rate. Download the free Excel format with live formulas and a 12-item sample for a G+2 building, or read below how to prepare one.

By the True Site Sync team · Last updated 11 November 2026

📥 Free download: BOQ format in Excel

Download Excel (.xlsx, 11 KB)

No email or sign-up needed. Opens in Excel, Google Sheets and WPS Office. Free to use, copy and share.

What is a BOQ?

A BOQ (Bill of Quantities) is a document that lists every item of work in a project with its description, unit of measurement, quantity and rate. It's used to price tenders, compare bids, and later measure and bill the work through RA bills.

BOQ format: the columns

Item NoDescriptionUnitQuantityRate (₹)Amount (₹)
1.1Earthwork in excavation for foundationsm³18028551,300
2.1PCC 1:4:8 (M7.5) below footingsm³125,85070,200
3.1RCC M25 in footings, columns, beams, slabsm³1407,4001,036,000
3.2Reinforcement TMT Fe 550Dkg16,500781,287,000
4.1Brickwork 230 mm in CM 1:6m³1306,400832,000
5.112 mm internal plaster in CM 1:6m²2,600265689,000

Sample rows from the free template. The rates are illustrative; use your SOR or market rates.

Skip the spreadsheet. Upload this BOQ file into True Site Sync: the columns are detected automatically and your project starts with every item ready for measurement and RA billing. Start a free 6-day trial →

How to prepare a BOQ in 6 steps

1. Study the GFC drawings

Architectural, structural and MEP, plus the specification.

2. List items by trade

Earthwork, PCC, RCC, steel, shuttering, masonry, plaster, flooring, finishes, MEP.

3. Take off quantities

Measure as per IS 1200, with deductions for openings. Use the concrete, brick and BBS calculators.

4. Write full descriptions

Material, grade, mix, thickness and finish: a description should price the item on its own.

5. Apply rates

From the state SOR / DSR for government work, or rate analysis and market quotes for private work.

6. Total and add GST

Amount = quantity × rate; add GST as per the contract (18% for most works contracts).

Common BOQ mistakes

Frequently asked questions

What is the format of a BOQ?

A table with Item No, Description, Unit, Quantity, Rate and Amount, where Amount = Quantity × Rate, grouped by trade, with a total and GST at the end.

How do I prepare a BOQ for building construction?

Study the drawings and specification, list items by trade, take off quantities as per IS 1200, write full descriptions, apply SOR or market rates, then total and add GST.

Is there a free BOQ format in Excel?

Yes. Download the free True Site Sync BOQ format above. It has formulas, a filled 12-item example and a summary sheet with GST. No sign-up needed.

What is the difference between BOQ and estimate?

An estimate is the owner's or contractor's forecast of cost. A BOQ is the contract document listing quantities that bidders price and against which the work is measured and billed.

Can I import a BOQ from Excel into software?

Yes. True Site Sync imports a BOQ from Excel or CSV and detects the Item No, Description, Unit, Quantity and Rate columns automatically.

Turn your BOQ into RA bills

Upload the BOQ once; measurements and RA bills follow from it.

Start free 6-day trial

Or book a demo.