Free BOQ Template — Excel for Builders
Excel
What this is
Who it's for: Freelancers who need a bill of quantities template
A bill of quantities spreadsheet for builders and quantity surveyors, in Excel format, that prices measured work item by item with automatic totals.
Free in full — download it and use it on your own freelance work.
The BOQ template is a free Excel spreadsheet that prices measured construction work item by item with automatic totals for builders and quantity surveyors.
The BOQ template is a free Excel spreadsheet that prices measured construction work item by item with automatic totals for builders and quantity surveyors. A bill of quantities only earns trust when every line can be checked, so the template keeps the structure simple: one row per measured item, a quantity, a rate, and an Amount column that calculates itself, plus a TOTAL row that updates as the bill changes. That structure is what lets a client compare your price with another bid line by line instead of arguing about a single lump sum.
How to use it. Open boq-template.xlsx in Excel, LibreOffice Calc or Google Sheets and replace the sample items with your own measured items, keeping the descriptions specific enough that the client can see exactly what is included. Enter the quantity and rate for each item, then check that the Amount column and the TOTAL row have updated; both use formulas, so a total that looks wrong usually means a quantity or rate was mistyped, not that the sheet failed. When the bill is complete, print it or share it with the client as the priced document for the job. If the job grows, insert new rows above the TOTAL row and copy the Amount formula down, so nothing falls outside the total.
Worked example. A builder prices a small boundary wall job with three lines: excavation at 50 cubic metres and 400 PKR per cubic metre, which is 20,000 PKR; brickwork at 100 square metres and 1,200 PKR per square metre, which is 120,000 PKR; and plaster at 100 square metres and 300 PKR per square metre, which is 30,000 PKR. The Amount column calculates each line, and the TOTAL row shows 170,000 PKR. The client can see where every rupee sits, and if the plaster area later changes to 110 square metres, only that quantity changes and the total updates itself to 173,000 PKR without retyping the bill.
The template is free in full, with no checkout and no account. If a download fails or a file arrives damaged, email tariqshahzad88@gmail.com and the file will be re-sent, and if a product does not work as described it will be fixed or replaced within 7 days.
Questions
Q: What does bill of quantities template do?
A: A bill of quantities spreadsheet for builders and quantity surveyors, in Excel format, that prices measured work item by item with automatic totals.
Q: What files do I get?
A: The download is boq-template.xlsx.
Q: What do I need to open or use it?
A: A spreadsheet app such as Excel, LibreOffice Calc or Google Sheets.
Q: Can I add more items?
A: Yes. Insert rows above the TOTAL row and copy the Amount formula down.
Q: Does the total update itself?
A: Yes, the Amount column and TOTAL row use formulas.
User manual
- Open the file
- Replace sample items with your own
- Enter quantities and rates
- Check the automatic total
- Share with your client
Requirements
A spreadsheet app such as Excel, LibreOffice Calc or Google Sheets.
Download details
Format: XLSX
What is inside: Instructions sheet plus a BOQ sheet with sample items, quantity, rate and formula-driven amounts and total.
Download free — boq-template.xlsx (6.1 KB)
- README.txt — 467 B
- boq-template.xlsx — 6.1 KB
Questions
What does bill of quantities template do?
A bill of quantities spreadsheet for builders and quantity surveyors, in Excel format, that prices measured work item by item with automatic totals.
What files do I get?
The download is boq-template.xlsx.
What do I need to open or use it?
A spreadsheet app such as Excel, LibreOffice Calc or Google Sheets.
Can I add more items?
Yes. Insert rows above the TOTAL row and copy the Amount formula down.
Does the total update itself?
Yes, the Amount column and TOTAL row use formulas.
What it actually looks like
Real preview rendered from the actual file (downloads/boq-template/boq-template.xlsx).