Building Estimate Excel Sheet (Free): Material Quantity & Cost per Sq Ft

Before you build a house or check a contractor’s quote, you need one number: how much will it cost, and how much cement, sand, steel and bricks will it need? This guide gives you a free building estimate Excel sheet that answers that in two minutes, the thumb rules behind it, a fully worked example for a 2,000 sq ft house, and the step-by-step method engineers use when they need an accurate BOQ.

What is a building estimate?

A building estimate is a calculation of the quantities of work and materials needed to build a structure, multiplied by rates to get the probable cost before construction starts. Engineers use two levels of estimate:

• Approximate (thumb-rule) estimate: based on built-up area and standard consumption per sq ft. Fast, accurate to roughly ±15–20%. Good for budgeting, loan planning and checking whether a contractor’s quote is sensible.
• Detailed estimate (BOQ): every item is measured from the drawings (excavation, PCC, footings, columns, beams, slabs, brickwork, plaster, flooring…), quantities are listed in a Bill of Quantities, and each line is priced from a schedule of rates. Needed for tenders, contracts and bank valuation.

The free Excel sheet does the first one. Further down you will see how the second one is done.

📚 Recommended Download

Building Estimate & BOQ Excel Kit

Type your building dimensions — get quantities, materials, a priced BOQ and cost per sq ft. 6 linked sheets, IS 1200-style measurement, editable rates.

✔ Editable Excel  ·  ✔ Instant download  ·  ✔ Lifetime access

₹799₹299

Get the BOQ Kit →

Thumb rules for material quantity per sq ft

These are the consumption figures widely used in India for an RCC framed residential building (G to G+2) with 230 mm outer walls, normal soil and normal finishes. They are per sq ft of built-up area (covered area including walls), not carpet area.

When to adjust: steel goes up to 4.5–5 kg/sq ft for G+3 and above, cantilevers or seismic zones IV–V. It drops to about 3–3.5 kg/sq ft for a simple single-storey house. Use 115 mm internal walls everywhere and bricks fall by 10–15%. Use AAC blocks and you replace the brick line entirely (600×200 mm face = about 8.3 blocks per m² of wall).

Worked example: 2,000 sq ft house (G+1)

Ground floor 1,000 sq ft + first floor 1,000 sq ft = 2,000 sq ft built-up. The rates below are sample rates only. Rates change by city and month, so put your own local rates in the Excel sheet.

Now add the costs that are not “materials”:

So with these sample rates, a normal-finish G+1 house of 2,000 sq ft costs about ₹1,250–1,300 per sq ft for structure plus basic finishes. Premium tiles, modular kitchen, wardrobes, compound wall, sump/overhead tank, borewell, approvals and architect fees are not included. List them separately.

How to use the free Excel sheet

1. Download the file and open it in Excel, Google Sheets or WPS Office (works on mobile too).
2. Enter built-up area per floor and number of floors (orange cells).
3. Replace the sample rates with today’s rates from your local supplier.
4. If you know your area better, adjust the thumb-rule factors and the labour / electrical / contingency percentages. Everything else updates on its own.
5. Read the grand total and cost per sq ft at the bottom. Compare it with your contractor’s per-sq-ft quote.

How to prepare a detailed estimate (BOQ) step by step

A thumb-rule estimate cannot tell you how much concrete goes into your footings or how much brickwork remains after deducting doors and windows. For that, engineers prepare a detailed estimate:

1. Study the drawings: plan, sections, elevations, structural drawings (footing, column, beam and slab schedules).
2. Break the work into items in construction order: earthwork excavation, PCC bed, RCC footings, columns, plinth beam, brickwork, lintels, floor beams, slab, plaster, flooring, painting, doors and windows, backfilling.
3. Take measurements (length × breadth × depth) for each item following IS 1200 measurement rules, e.g. deduct openings larger than 0.1 m² from brickwork, measure plaster on both faces.
4. Compute quantities in m³ / m² / kg / nos in a measurement sheet. This is the “abstract of quantities”.
5. Convert to materials: e.g. 1 m³ of M20 (1:1.5:3) needs about 8 bags cement, 0.42 m³ sand and 0.84 m³ aggregate (dry volume factor 1.54). Steel is usually taken as a percentage of concrete volume (footings ~0.8%, columns ~2.5%, beams ~2%, slabs ~1%).
6. Prepare the BOQ: item description, unit, quantity, rate (from your State SOR, CPWD DSR or market rates), amount.
7. Abstract of cost: add electrical and plumbing percentages, contingency (3–5%), work-charged establishment and GST if applicable.

Doing this by hand for even a small house takes a full day or two, and one wrong dimension carries through every sheet.

Thumb rule vs detailed BOQ: which one do you need?

If you are a site engineer, junior engineer or student who has to submit a proper estimate, the Building Estimate & BOQ Excel Kit does the detailed method for you: you type the dimensions from the drawing and it measures every item, works out materials and prints a priced 21-item BOQ with abstract and cost per sq ft.

Common estimating mistakes

• Using carpet area instead of built-up area. Thumb rules are per built-up sq ft. Carpet area is roughly 70–80% of built-up, so you will under-estimate by 20–30%.
• Forgetting the dry volume factor. Wet concrete volume × 1.54 (≈1.52–1.57) gives the dry material volume. Skip it and cement, sand and aggregate come out a third short.
• No wastage allowance. Add about 2–3% for cement, 5% for sand and aggregate, 3–5% for steel (cutting and laps) and 5% for bricks.
• Old rates. Steel and cement prices move every month. Always refresh rates before you share an estimate.
• Leaving out “small” items: compound wall, water tank, septic tank, staircase headroom, parapet, approvals. They easily add 8–12%.

Frequently asked questions

How many cement bags are required for 1,000 sq ft?

About 400 bags (0.4 bag per sq ft of built-up area) for a normal RCC framed house, including concrete, brickwork mortar, plaster and flooring bed.

How much steel is required for 1,000 sq ft house?

About 4,000 kg (4 tonnes) at 4 kg per sq ft. It can range from 3 to 5 kg per sq ft depending on floors, spans and seismic zone.

What is the construction cost per sq ft in India?

It depends heavily on city, finishes and current material rates. With the sample rates in this article, a normal-finish house works out to about ₹1,250–1,300 per sq ft. Put your local rates into the free Excel sheet to get your own figure.

Is a thumb-rule estimate accepted for bank loans or tenders?

Usually not. Banks and tenders ask for a detailed estimate with item-wise BOQ and abstract of cost. Use the thumb rule for planning and a detailed BOQ for official submission.

Does the free Excel sheet work in Google Sheets and on mobile?

Yes. It uses only simple formulas, so it works in Excel, Google Sheets and WPS Office on phone or computer.