What is in the construction estimate template
- Excel (.xlsx): Estimate tab with formulas, Example tab, How-to tab. Opens in Excel, Google Sheets and Numbers.
- Word (.docx): customer-facing estimate with scope, line items, inclusions, exclusions and an acceptance block.
No sign-up and no email address. The files are yours to edit and reuse.
Construction estimate template columns and fields
Header: estimate number, date, client, project address, plans and addenda priced, estimator.
Line items (one row per item):
| Column | Entered or calculated |
|---|---|
| CSI division or trade | Entered |
| Description | Entered |
| Quantity | Entered, from your takeoff |
| Unit (SF, LF, EA, CY) | Entered |
| Labor unit cost | Entered |
| Material unit cost | Entered |
| Equipment unit cost | Entered |
| Subcontract unit cost | Entered |
| Total unit cost | Calculated: sum of four costs |
| Line total | Calculated: quantity x total unit cost |
Summary: direct cost; overhead %; profit %; contingency %; sales tax % on materials; estimate total.
Scope notes: inclusions, exclusions, assumptions, valid until.
Filled-in estimate example
The example tab prices a fictional office refresh. Grey cells are formulas, so totals fill in as you type. Quantities come from your takeoff; unit costs from your own records and quotes.
How the markup formulas work
- Direct cost = sum of line totals.
- Overhead = direct cost x overhead %.
- Profit = (direct cost + overhead) x profit %.
- Contingency = direct cost x contingency %.
- Sales tax on materials = material total x tax %. Enter zero if materials are not taxable on this job. Tax rules differ by state and by contract type, so check how your state treats materials on this kind of work.
- Estimate total = sum of the five lines above.
Your company sets every percentage. The example uses round numbers only to show the math.
Short on time? Bidmere can do this for you. Trade estimates from $195, ready in 48 hours. See construction estimating services or get a fixed quote.
How to use the estimate template, step by step
- Do the takeoff first, noting the sheet each quantity came from.
- Enter one line per item with quantity and unit, grouped by trade or CSI division.
- Enter unit costs from your records, supplier quotes and sub quotes.
- Set overhead, profit, contingency and tax for this job.
- Write inclusions, exclusions and assumptions.
- Check the total against experience before sending.
What is the standard construction estimate format?
There is no single required format, but most follow the same order: a header identifying the job and documents priced, line items grouped by trade or CSI division, a direct cost subtotal, markups, and scope notes. Grouping by CSI division makes it easy to compare with other bids and with the specification. Keep the takeoff that backs each quantity with the estimate file, so anyone checking the number can trace every line back to a plan sheet.
Estimate vs quote, and Google Sheets or PDF
An estimate is your calculated cost, which can change with the design. A quote is a fixed price offer for a defined scope; send it on the contractor quote template. The Excel file works in Google Sheets because it uses only standard functions such as SUM. To send a PDF, fill in the Word version and save as PDF.
Rather have the estimate done for you?
Send your plans. Bidmere measures the quantities and builds the estimate at your rates, delivered as an Excel estimate with live formulas, color-coded marked-up PDF plans, and a written list of assumptions, exclusions and open questions. Single-trade estimates are priced from $195 in 48 hours; multi-trade from $1,150. You get a fixed quote within 2 business hours and pay only after you accept.
Worked example
| Line item | Qty | Unit | Unit cost | Line total |
|---|---|---|---|---|
| Remove carpet and base | 1,200 | SF | your cost | qty x unit cost |
| Metal stud partition, 10 ft high | 80 | LF | your cost | qty x unit cost |
| Gypsum board, taped and finished | 1,600 | SF | your cost | qty x unit cost |
| Paint walls, primer and two coats | 3,200 | SF | your cost | qty x unit cost |
| Luxury vinyl tile flooring | 1,200 | SF | your cost | qty x unit cost |
| Relocate receptacles (electrical subcontract) | 12 | EA | sub quote | qty x unit cost |
| Direct cost | sum of line totals | |||
| Overhead, profit, contingency, tax | your % | per formulas | ||
| Estimate total | direct cost + markups |
Fictional example: office refresh estimate structure
Frequently asked questions
Is the construction estimate template really free?
Yes. Download the Excel and Word files with no sign-up and no email address, and use and edit them for your own jobs. The Excel file includes a filled example and a how-to tab so you can see the formulas working before you enter your own job.
Does the Excel template calculate totals automatically?
Yes. Total unit cost, line totals, direct cost, overhead, profit, contingency, tax on materials and the estimate total are formulas. You enter quantities, units, the four unit costs and your percentages. Formula cells are grey and locked so they are not overwritten by accident.
What markup should I use?
That is your decision, based on your actual overhead, the risk in the job and the market you bid in. Calculate overhead from your books rather than using a rule of thumb, then set profit job by job. The example uses round percentages only to show the math.
Can I group line items by CSI division?
Yes. The first column holds the CSI division or trade, and the sheet can be sorted or filtered by it. Grouping by division makes it easier to compare your number with other bids and to check that every specification section is covered.
Does the template handle subcontractor quotes?
Yes. Use the subcontract unit cost column for work you buy out, or enter a sub’s lump sum as one line with quantity 1 and unit LS. Level sub quotes on one scope before entering them, so exclusions do not slip into your total.
Should contingency be on every estimate?
Use it where scope is not fully defined: early-stage estimates, renovation with hidden conditions, or incomplete drawings. Show it as its own line rather than hiding it in unit costs, so the customer can see it and you can reduce it as the design or site conditions become clear.
Can someone prepare the estimate for me?
Yes. Bidmere measures the quantities from your plans and prices them at rates you approve. Send the job through the quote form and get a fixed price and delivery date within 2 business hours. Single-trade estimates are priced from $195 and are ready in 48 hours.
Link to this template
Teaching estimating, running a trade association or keeping a resources page for contractors? You are welcome to link to this free template. Copy the link below into your page’s HTML.