How to Use Excel for Construction Estimating

Build a construction estimate in Excel with clear cell-by-cell formulas for materials, labor, overhead and markup. Test your totals before sending a quote.

3D contractor building a construction estimate in a spreadsheet

Before you start

  • Use quantity times unit cost for each job line.
  • Add direct costs, overhead and markup without counting subtotals twice.
  • Test a quantity change before relying on the worksheet.

You can build a working construction estimate in Excel with five columns and a handful of formulas. The sample job below comes to $1,100 before tax. It's built from direct cost, overhead and markup, and the total updates when you change a quantity or a price.

Follow the cell references below to build your own worksheet. All figures are hypothetical USD teaching inputs; replace them with your own costs. For a ready-made alternative, our electrical estimate template includes an Excel download. That template uses selling rates with overhead and profit already included; this tutorial builds a price from costs.

Set up the columns and enter the job lines

Type these headings in row 1:

  • A1: Item
  • B1: Quantity
  • C1: Unit
  • D1: Unit cost
  • E1: Line cost

Then enter the four job lines in rows 2 to 5:

  • Row 2: Materials, 10, units, 40
  • Row 3: Labor, 8, hours, 35
  • Row 4: Equipment, 1, day, 60
  • Row 5: Disposal, 1, job, 40

Leave column E empty for now. The formulas go there next.

The unit in column C has to match what column D is priced per. Eight hours goes with an hourly cost, one day with a day rate, and one job with a lump sum. If the unit and the price don't match, the multiplication still runs but the answer is wrong.

Column D holds what the work costs you, not what you charge the customer. Keep those two apart. Mixing a cost and a selling rate in the same column is how a price ends up marked up twice, or not at all.

For labor, use a loaded hourly cost. That means the wage plus the employment costs you pay on that worker, such as payroll taxes and benefits. Leave overhead and profit out of it, because you'll add them once, further down the sheet.

For materials, use real supplier prices you've been quoted or paid, not a number from memory. Give disposal its own line instead of burying it in another one, so you can see it, change it or drop it later.

Format the money cells as currency instead of typing "$" or "per hour" into them. Text inside a number cell can break a formula.

Add the formulas: line costs and direct cost

Excel multiplies with the asterisk (*), and SUM adds a range of cells, using Excel’s multiplication operator. Start in E2, then copy it down through E5. Each row's formula shifts to use its own row.

Leave row 6 blank, then add the direct cost total in row 7. Type "Direct cost" in A7.

Cell Formula Result
E2 =B2*D2 400
E3 =B3*D3 280
E4 =B4*D4 60
E5 =B5*D5 40
E7 =SUM(E2:E5) 780

Direct cost is the cost of the work itself, before overhead and profit. Here it's $780.

Dollar signs fix a reference so it doesn't shift when you copy a formula. You don't need them yet. They matter when a single rate or percentage cell has to stay put while a formula is copied to many rows, for example $D$10.

Add overhead and markup once

Overhead is the cost of running your business that isn't tied to one job. Markup is a percentage you add on top of your total cost. Both get added once, in this order, below the direct cost.

Fill in rows 8 to 11 like this:

Cell Entry Result
A8 / D8 / E8 Overhead / 100 / =D8 100
A9 / E9 Total cost / =SUM(E7:E8) 880
A10 / D10 / E10 Markup / 25% / =E9*D10 220
A11 / E11 Price before tax / =SUM(E9:E10) 1100

Type 25% into D10 as a real percentage, not the word "25 percent". Excel stores it as 0.25, which is what the formula needs.

Markup isn't the same as margin. Markup is a share of your cost, and margin is a share of your price. Here the $220 markup is 25% of the $880 cost, but only 20% of the $1,100 price. If you want a 25% margin, you'd need a bigger markup.

Two mistakes will quietly inflate your price:

  • Don't sum the whole column. A formula like =SUM(E2:E11) would count the subtotals and the markup a second time. Use the specific ranges shown above; putting that whole-column sum in E11 would also create a circular reference.
  • Don't mark up twice. If a unit cost or labor rate already includes profit, the 25% markup stacks on top of it. Overhead belongs in row 8 only, not folded into your labor rate or unit costs.

The $1,100 is before tax. Work out which tax basis applies to your job before you send the price. This worksheet doesn't decide that for you.

Test the sheet by changing one input

Before you trust the sheet, change one number and see whether everything moves. Change B3 from 8 hours to 10. You should see:

Cell New result
E3 350
E7 850
E9 950
E10 237.50
E11 1187.50

Now put B3 back to 8. E11 should return to 1100. If a total doesn't move when it should, either a formula was typed over with a number or a range is missing a row.

Also watch for blank prices. A blank cell isn't a checked zero. Excel will treat it as nothing, and the line will quietly price at $0. If you're waiting on a supplier, highlight the cell in yellow and write "price needed" in column F, outside any total. Clear that note only after you have a real price.

Adjust for bigger jobs and keep a clean master

Most jobs have more than four lines. Insert the new rows inside the list, for example by right-clicking row 5 and choosing Insert, so they land above the last line. Inserting inside the range usually expands the SUM automatically. Check the direct-cost SUM cell at its new row afterward, and extend the range if the new rows aren’t included. Every cell below the inserted row moves down, so your totals will no longer sit in rows 7 to 11.

Insert a row below the last line and above the blank row, and the range may not grow. That's why the check matters.

Save a clean master copy with the labels, formulas and percentage cell intact, and no job data in it. For each job, save a renamed copy and work there. That way a typed-over formula or a leftover quantity never travels into the next estimate.

Turn the worksheet into a customer quote

This worksheet is for you. Your customer should get a separate quote that covers:

  • The scope of work
  • What's included
  • What's excluded
  • The total price
  • How long the price is valid and your payment terms

Your wage rates, overhead and markup workings don't need to appear on it.

Be clear about exclusions. An excluded item with no price is different from an allowance, which is an amount you can support. If you leave something out, say so plainly in the quote.

When rebuilding this sheet for every job gets old

The workbook does the arithmetic well. The slow parts are usually retyping the same job structure and chasing current material prices.

That's where Construction Job Estimator fits. You describe the job by voice or text, including the measurements you've taken, and it turns those details into a working estimate. It pulls real-time material prices from local suppliers, and you can also enter a price you already have. Materials, labor, delivery, equipment hire and disposal sit together in one estimate. You can see the quantities, pack sizes, prices and labor behind each figure, then adjust quantities, labor time, rates and markup. The result is a professional estimate or quote you can send in minutes. It runs on iOS and Android and costs $19.99 per month.

If you're still deciding between the two approaches, the spreadsheet versus app guide walks through that choice.

← Back to all guides

Construction Job Estimator

Your next estimate.
Ready in minutes.

Tell us what needs doing. Get real-time material prices from local suppliers, bring your labour and other costs together, and send your customer a professional estimate.

Take the next job from description to estimate.

★★★★★ Used by 10k+ contractors