Construction estimate template in Excel, Word and PDF
A construction estimate template lists the work by trade or division, extends quantity x unit cost for material, labor and equipment, adds subcontract quotes, and applies contingency, overhead and profit to reach a total. The free files below are organized by CSI MasterFormat division: an Excel workbook that does the math, a Word estimate to send to customers, and a printable PDF form. No signup needed.
Construction estimate template free download
Three files, no account or email. All three use the same division list, so the Excel numbers carry straight into the Word or PDF estimate you hand to the customer. The workbook is a free building construction estimate spreadsheet for Excel, and it works as a general cost estimate template for any project you can break into divisions.
Which file to use
| File | Use it for | Does the math |
|---|---|---|
| Excel (.xlsx) | Building the estimate: quantities, unit costs, subcontract quotes, markups. | Yes: extensions, division subtotals, summary and markups. |
| Word (.docx) | The estimate the customer sees: totals by division, scope, exclusions, payment schedule, signatures. | No. Type the totals from the Excel summary. |
| Filling in by hand on a site visit or printing a quick estimate. | No. |
Construction estimate template for Excel: how to fill it in
- Fill in the project block on the Estimate tab: project, location, who prepared it, date.
- Under each division, type the work items with a quantity and a unit (EA, LF, SF, SY, CY, TON, LS, HR, DAY, MO from the dropdown). Each division starts with four blank lines; insert more above its subtotal row and the subtotal picks them up.
- Enter unit costs for material, labor and equipment. Line totals and division subtotals calculate as you type.
- For work you sub out, leave the unit costs blank and put the quote in the Subcontract column.
- Delete or hide divisions that are not in the job.
- On the Summary tab, check each division's share of the direct cost, then enter contingency, overhead and profit as markup percentages, and a bond rate if the job needs one.
Sales tax is not added as a separate line: include it in material unit costs, or add a line under Division 01. For a deeper walkthrough of building estimates in a spreadsheet (assemblies, lookups, protecting formulas), read construction estimating with Excel.
Free construction estimate template for Word
The Word file is the version a customer reads. It has your company and the customer at the top, an estimate number, date and expiry, a short project description, and a cost summary with the divisions most building and remodeling jobs use. Below that are Included and Not included lists, a payment schedule by milestone, terms and an acceptance block. Everything is in real Word tables, so rows can be added or deleted without breaking the layout. Replace the items in [brackets], add your logo to the header, and save as PDF to send.
Keep the Not included list honest and specific. Permit fees, hazardous material work and hidden conditions found during demolition are the usual disputes on remodeling jobs, and the template starts with those.
Estimate template free download in PDF
The PDF lists all 24 divisions on one letter page with columns for description, material, labor, subcontract and total, then a totals box with contingency, overhead, profit and bond, a Not included area and signature lines. Strike the divisions that do not apply. It suits small jobs priced on a site visit, or a quick budget before a full estimate in Excel.
CSI divisions explained
MasterFormat is the Construction Specifications Institute's list of numbers and titles for organizing construction work. CSI describes it as a way to organize project manuals and also to build detailed cost estimates and track costs1. Using its divisions in an estimate means each line lines up with the specification section that describes the work, which makes it easier to compare sub quotes and to find what is missing.
The template uses the division numbers and titles from the 2020 edition, the current edition on CSI's site, produced with Construction Specifications Canada1. Some numbers are not used in the 2020 list (15 to 20, 24, 29, 30 and others), and there are process equipment divisions from 40 to 48 that most building estimates do not need. CSI's number lookup page says a new MasterFormat release is anticipated2, so check the project manual you are bidding against for the edition it uses.
| Division | Title | Typical cost items |
|---|---|---|
| 01 | General Requirements | Supervision, temporary facilities, cleanup, insurance, mobilization: costs that belong to the whole job. |
| 02 | Existing Conditions | Surveys, selective demolition, hazardous material work. |
| 03 | Concrete | Footings, slabs, forms, reinforcing, cast-in-place and precast concrete. |
| 04 | Masonry | Block, brick, stone, mortar and grout. |
| 05 | Metals | Structural steel, joists, deck, stairs, railings, miscellaneous metals. |
| 06 | Wood, Plastics, and Composites | Framing, sheathing, blocking, finish carpentry, casework. |
| 07 | Thermal and Moisture Protection | Insulation, roofing, waterproofing, air barriers, sealants, fire stopping. |
| 08 | Openings | Doors, frames, hardware, windows, storefronts, glazing. |
| 09 | Finishes | Gypsum board, ceilings, flooring, tile, paint. |
| 10 | Specialties | Toilet partitions and accessories, signage, lockers, fire extinguishers. |
| 11 | Equipment | Food service, laboratory and other building equipment. |
| 12 | Furnishings | Window treatments, fixed seating, furniture. |
| 13 | Special Construction | Pre-engineered structures, special purpose rooms. |
| 14 | Conveying Equipment | Elevators, lifts, escalators. |
| 21 | Fire Suppression | Sprinkler and standpipe systems. |
| 22 | Plumbing | Piping, fixtures, water heaters. |
| 23 | Heating, Ventilating, and Air Conditioning (HVAC) | Equipment, ductwork, piping, controls. |
| 25 | Integrated Automation | Building automation systems. |
| 26 | Electrical | Service, distribution, power, lighting. |
| 27 | Communications | Data, voice, audio-visual cabling and pathways. |
| 28 | Electronic Safety and Security | Fire alarm, access control, video surveillance. |
| 31 | Earthwork | Clearing, excavation, grading, fill, soil treatment. |
| 32 | Exterior Improvements | Paving, curbs, fencing, landscaping. |
| 33 | Utilities | Site water, sewer, storm and power distribution. |
Contingency, overhead and profit, in that order
The Summary tab applies each markup on top of the one before:
Total = direct cost x (1 + contingency) x (1 + overhead) x (1 + profit), then bond on the result
Contingency covers unknowns in the design or the existing building, and it shrinks as drawings get more complete. Overhead is the cost of running the company that no single job carries: office, estimating, vehicles not charged to jobs, insurance. Profit is what is left. Because each is a markup on cost, the profit you see as a share of the final price is lower than the percentage you typed; the electrical estimate template page has a markup vs margin table.
Mistakes in construction estimates
- Leaving Division 01 empty. Supervision, temporary facilities, dumpsters and cleanup are real costs on every job.
- Carrying a sub quote without reading its exclusions, so the work it leaves out is in nobody's number. For Division 26, a quick check is to divide the electrical quote by the floor area and compare it with typical electrical costs per square foot for the building type.
- Old unit costs. Check material prices against a current quote before sending the estimate.
- Rounding quantities at the takeoff and then again at pricing. Keep the quantities exact until the last step; the construction takeoff software guide covers tools that measure and count them from PDFs.
- Sending the spreadsheet itself to the customer instead of a clean estimate with scope and exclusions.
When a spreadsheet stops being enough
A free construction estimating spreadsheet works well for one estimator and jobs of a size you can keep in your head. When you need assemblies, a cost database, takeoff on PDFs or several estimators on one bid, look at dedicated tools. The construction estimating software guide and the free construction estimating software roundup compare options. For a ballpark before you start, try the construction cost estimator.
Questions about the construction estimate template
Is this construction estimate template free?
Yes. All three files download directly with no signup, and you can edit, rebrand and reuse them.
Does it work for residential remodeling?
Yes. Delete the divisions you do not use. Most remodels only need 01, 02, 06, 07, 08, 09, 22, 23 and 26, all of which are already in the Word estimate.
Does it include unit costs?
No. Costs vary by region and change often, so the template has the structure and formulas and you enter current prices.
Keep reading
Sources
- CSI, MasterFormat 2020 Edition: description and table of contents (divisions and titles)
- CSI, What's My MasterFormat Number? (status of the numbers and titles lookup)
MasterFormat is a registered trademark of the Construction Specifications Institute. The templates use division-level numbers and titles only.