← All posts
Templates·12 min read·

Free Construction Bid Template + Spreadsheet (2026)

If you're a small civil contractor, your construction bid template is probably an Excel file you built yourself three years ago. It mostly works. The formulas are a little fragile. You copy it for every new job, rename it, and start typing line items from whatever PDF the owner sent you.

That spreadsheet is doing more work than it should. And every time you set up a new bid, you're rebuilding the same structure from scratch.

This guide gives you a clean construction bid template you can use right away — with the right columns, the right adjustment rows, and a step-by-step walkthrough of how to fill it out. It's built for heavy civil work: excavation, grading, utilities, road work, drainage — the kind of unit-price bids that municipalities and DOTs put out.

We'll also show you when a spreadsheet stops being the right tool and what to use instead.

What a good construction bid template needs

Most construction bid templates you find online are built for general contractors or residential builders. They have sections for "materials" and "labor" as separate categories, or they assume you're pricing a kitchen remodel.

Civil work is different. You're responding to an Invitation to Bid with a specific bid schedule — a list of line items, each with a quantity and unit, provided by the owner's engineer. Your job is to fill in unit costs and unit prices for each item.

A construction bid template for civil work needs these columns:

  • Item # — the line item number from the bid schedule
  • Description — what the work is (e.g., "Roadway Excavation" or "8-inch PVC Sanitary Sewer")
  • Unit — CY, LF, SY, TON, EA, LS, etc.
  • Quantity — the estimated quantity from the owner's engineer
  • Unit Cost — what it costs you to do one unit of this work
  • Unit Price — what you're charging the owner per unit (cost + markup)
  • Extended Cost — Unit Cost × Quantity (your total cost for this item)
  • Extended Price — Unit Price × Quantity (total revenue for this item)

And below the line items, you need adjustment rows:

  • Mobilization — a fixed dollar amount for getting your equipment and crew to the site
  • Bonding % — the cost of your bid bond and performance bond, typically 1-3% of the total bid
  • Contingency % — a percentage buffer for unknowns, usually 3-10% depending on risk
  • Tax % — sales tax on materials where applicable (varies by state and item type)

That's it. No fancy categories. No pie charts. Just the structure you need to price a civil bid accurately.

The construction bid template layout

Here's exactly how the construction bid spreadsheet should be structured. You can build this in Excel, Google Sheets, or any spreadsheet tool.

Header section

At the top of your sheet, include these fields:

  • Project Name
  • Owner / Agency
  • Bid Date / Deadline
  • Project Location
  • Estimator Name
  • Bid Number (your internal tracking number)

Keep this simple. You're not designing a form — you're setting up context so you can find this bid later when you need to reference your pricing.

Line items section

This is the main body of your construction bid sheet. Set up these column headers in Row 1 (or wherever your data starts):

Item #DescriptionUnitQtyUnit CostUnit PriceExt. CostExt. Price
1MobilizationLS1$12,000.00$15,000.00$12,000.00$15,000.00
2Clearing and GrubbingAC5$1,800.00$2,200.00$9,000.00$11,000.00
3Unclassified ExcavationCY3,500$6.50$8.25$22,750.00$28,875.00
4Embankment in PlaceCY2,200$5.00$6.50$11,000.00$14,300.00
56" Aggregate Base CourseSY4,000$7.00$9.00$28,000.00$36,000.00
62" HMAC Surface CourseTON800$85.00$105.00$68,000.00$84,000.00
718" RCP Storm DrainLF600$42.00$55.00$25,200.00$33,000.00
8Storm Drain Manhole, 4' DiaEA6$3,200.00$4,100.00$19,200.00$24,600.00
9Curb and Gutter, Type ALF1,200$18.00$23.00$21,600.00$27,600.00
104" Concrete SidewalkSF3,000$5.50$7.00$16,500.00$21,000.00

The formulas are simple:

  • Extended Cost = Unit Cost × Quantity
  • Extended Price = Unit Price × Quantity

At the bottom, add a Subtotal row that sums Extended Cost and Extended Price columns.

Adjustment rows

Below the subtotal, add these adjustment rows:

AdjustmentBasisRate / AmountCostPrice
Subtotal (from line items)——$233,250.00$295,375.00
MobilizationFixed$15,000.00$12,000.00$15,000.00
Bonding% of Total2.0%$4,665.00$5,907.50
Contingency% of Total5.0%$11,662.50$14,768.75
Tax (materials only)% of Materials6.25%VariesVaries
Grand Total——CalculatedCalculated

A few notes on each adjustment:

  • Mobilization: Some bid schedules include mobilization as a line item. If it's already listed as Item #1 in the bid schedule, don't double-count it. If the bid schedule doesn't include it, add it here.
  • Bonding: Most public bids require a bid bond (5% of bid) and a performance bond (100% of contract). The bonding cost is what your surety charges you — typically 1-3% of the contract amount. Apply it to the total.
  • Contingency: This is your buffer for unknowns. On a well-defined municipal job with clear plans, 3-5% is typical. On a vague private bid with incomplete geotech, 8-10% might be warranted. This is a judgment call based on how much risk you see.
  • Tax: Sales tax on materials varies by state. Some states exempt materials installed in public projects. Some tax everything. Check your state rules. Only apply tax to the material portion of your cost — labor and equipment aren't taxable in most states.

How to use this construction bid template: step by step

Here's the process for filling out this construction estimate template on a real bid. We'll walk through it as if you just got an ITB PDF from a county government for a road reconstruction project.

Step 1: Read the bid packet first

Before you touch the spreadsheet, read the ITB document. You're looking for:

  • Scope of work: What's included? What's excluded? Are there alternates?
  • Special conditions: Prevailing wage? Liquidated damages? Phasing requirements?
  • Deadline: When is the bid due? Build in at least a day of buffer.
  • Bonding requirements: Bid bond amount, performance bond, payment bond.
  • Insurance requirements: Any special coverage needed?

Spend 15-20 minutes on this before transcribing anything. Missing a prevailing wage requirement or a phasing constraint will blow up your numbers later.

Step 2: Set up the header

Copy your construction bid template to a new file. Name it something you'll find later — like "2026-03-County-Road-Reconstruction.xlsx". Fill in the header fields: project name, owner, bid date, location.

Step 3: Transcribe the bid schedule

This is the part that takes the most time. Open the bid schedule section of the ITB PDF and start entering line items into your construction bid spreadsheet.

For each line item, enter:

  • Item # (exactly as shown in the bid schedule)
  • Description (exactly as shown — don't paraphrase)
  • Unit (match the bid schedule)
  • Quantity (from the bid schedule)

Leave Unit Cost and Unit Price blank for now. You're just building the structure.

On a typical municipal road project, this step takes 45 minutes to 2 hours depending on the number of line items. A 40-item bid is manageable. A 150-item DOT bid is a grind.

Common mistakes at this step:

  • Misreading quantities (1,200 vs. 12,000 — happens more than you'd think)
  • Getting units wrong (SY vs. SF is a 9x difference)
  • Skipping line items (especially on multi-page bid schedules)
  • Confusing base bid items with alternate bid items

Double-check your transcription against the original PDF before you start pricing. A quantity error at this stage flows through every calculation that follows.

Step 4: Enter your unit costs

Now you're doing the actual estimating work. For each line item, figure out what it costs you to perform one unit of this work.

Your unit cost should include:

  • Labor: Crew size × hourly rate ÷ production rate per hour
  • Equipment: Equipment hourly rate ÷ production rate per hour
  • Materials: Material cost per unit installed
  • Subcontractor: If you're subbing this item, use their quote

Where do you get these numbers? From your own history. If you've done roadway excavation before, you know what it costs you per CY with your equipment and your crew. If you're pricing a new item type, build it up from crew rates and production estimates.

This is where a pricing catalog saves massive time. If you keep a list of items you've priced before — with your actual unit costs — you can pull numbers instead of calculating from scratch every time. More on this below.

Step 5: Set your unit prices

Unit Price = Unit Cost + your markup. Your markup covers overhead and profit.

How much markup? That depends on:

  • Competition: On a competitive public bid with 8 bidders, margins are thin — maybe 8-12% on direct cost items.
  • Risk: Higher-risk items (uncertain soil conditions, tight timelines) warrant higher markup.
  • Your capacity: If you're busy and don't need this job, bid it higher. If you need work, bid it tighter.

A common approach: apply a flat markup percentage to all items, then adjust specific items up or down based on risk. For example, 15% markup on everything, but bump excavation to 20% because the geotech report is thin.

Step 6: Check the extended columns

Make sure your formulas are calculating correctly:

  • Extended Cost = Unit Cost × Quantity (for every row)
  • Extended Price = Unit Price × Quantity (for every row)
  • Subtotals sum correctly

This sounds obvious, but formula errors in construction bid spreadsheets are incredibly common. One broken cell can throw off your entire bid. Check the subtotals manually against a few line items to make sure the math is right.

Step 7: Fill in the adjustment rows

With your line item subtotals calculated, fill in the adjustments:

  1. Mobilization: If it's a bid schedule line item, it's already in your subtotal. If not, add your mobilization cost here. This covers equipment transport, temporary facilities, site setup, and initial erosion control.
  2. Bonding: Call your surety or use your standard bonding rate. Multiply it by your estimated total bid price. For a $300K bid at 2% bonding, that's $6,000.
  3. Contingency: Apply your contingency percentage to the subtotal. This is your judgment call — how much uncertainty is in this project?
  4. Tax: Calculate sales tax on the materials portion of your cost. You'll need to estimate what percentage of each line item is materials vs. labor/equipment. A rough rule of thumb for civil work: 20-40% of direct cost is materials, depending on the item type.

Add it all up. That's your grand total bid price.

Step 8: Sanity check

Before you submit, do a gut check:

  • Does the total feel right? If a road reconstruction project comes out to $50,000, something is wrong. If it comes out to $5,000,000 and the scope is a quarter-mile of residential street, something is also wrong.
  • Compare to similar past bids. If you have historical data, pull up a similar project you bid (or won) and compare cost per LF of road, cost per CY of excavation, etc.
  • Check unit prices against published bid tabs. Many DOTs and municipalities publish bid results. Look at what winning bidders priced for similar items in your area.
  • Look for outlier line items. Sort by Extended Price descending. The top 5-10 items usually make up 60-80% of the bid total. Make sure those items are priced correctly — an error on a big item matters more than an error on a small one.

Why most construction bid templates break down over time

The template above will work for your next bid. And the one after that. But here's what happens over time:

You end up with 50 copies of the same spreadsheet. Each one named something slightly different. Each one with the same columns but different formatting because you tweaked it on bid #7 and forgot to update the master.

Your pricing history is scattered. You priced 18-inch RCP at $42/LF on the county job last March. What was it? You'd have to open that file — if you can find it — and look. There's no catalog, no memory. Just files in folders.

Formulas break. Someone inserts a row in the middle of the bid schedule and the subtotal formula doesn't expand to include it. Or you copy-paste from another bid and the cell references shift. You don't notice until the bid total looks wrong and you're scrambling to find the error 30 minutes before deadline.

Transcription takes the same amount of time on bid #100 as it did on bid #1. Every bid, you're typing the same line items from a new PDF. The spreadsheet doesn't learn. It doesn't remember. It doesn't help you go faster.

These aren't reasons to throw out Excel. Excel is a great tool. But a construction bid spreadsheet is doing two jobs: structuring your bid data and storing your pricing knowledge. It's good at the first job and bad at the second.

When to move beyond a construction bid template

A spreadsheet is the right tool when:

  • You're bidding 1-5 jobs per month
  • Your bids have fewer than 40 line items
  • You have time to type line items from the PDF
  • You don't mind looking up past prices manually

A spreadsheet starts to cost you money when:

  • You're bidding 5-15 jobs per month and spending 2+ hours per bid just on data entry
  • Your bids regularly have 60-200+ line items (DOT projects, utility programs)
  • You're losing bids because you didn't have time to price them carefully — you rushed through because transcription ate your hours
  • You can't find your historical pricing without digging through old files

At that point, the construction bid template isn't the bottleneck — the workflow around it is. You need something that reads the PDF for you, remembers your prices, and lets you focus on the estimating instead of the typing.

Skip the spreadsheet — CivBid does this automatically

CivBid is construction bidding software built for small civil contractors who are tired of typing bid schedules into Excel.

Here's how it works:

  1. Upload your bid packet PDF. The ITB, the bid schedule, the whole document — just upload it.
  2. CivBid extracts the line items automatically. Item numbers, descriptions, units, quantities — pulled from the PDF using AI. No typing.
  3. Review and correct. The extraction isn't perfect 100% of the time. You review the items, fix any errors, and confirm the bid structure. This takes 2-5 minutes instead of 1-2 hours.
  4. Enter your costs and prices. Price each item from your catalog. If you've priced "Unclassified Excavation" before, CivBid shows your last unit cost. Over time, your catalog builds itself.
  5. Add adjustments. Mobilization, bonding percentage, contingency percentage, tax percentage — same adjustments from the template above, built into the tool.
  6. Generate your bid document. Export a clean bid sheet ready for submission.

Upload your bid packet PDF and get a clean bid sheet in minutes. No more transcription. No more formula errors. No more hunting through old spreadsheets for last year's unit prices.

The construction bid template in this guide will work if you prefer spreadsheets. But if you're spending more time typing than estimating, CivBid is built to fix that.

Construction bid template tips and common mistakes

Whether you use a spreadsheet or software, these tips apply to every construction estimate template:

Tip 1: Match the bid schedule exactly

Use the exact item numbers, descriptions, and units from the owner's bid schedule. Don't rename items. Don't reorder them. Don't combine line items. Owners reject bids that don't match their format.

Tip 2: Never leave a line item blank

On public bids, a missing unit price can get your bid disqualified. If a line item doesn't apply to you, enter $0.01 — not $0.00 (some agencies reject zero-dollar line items) and not blank.

Tip 3: Don't front-load your bid

Front-loading means putting artificially high prices on early items (like mobilization or clearing) and artificially low prices on later items. Owners and engineers know this trick. It can get your bid flagged as unbalanced and rejected — even if your total is the lowest.

Tip 4: Keep a separate pricing catalog

Maintain a separate spreadsheet (or use software) that tracks every item you've priced, with your unit cost, the date, and the project. When you need to price "18-inch RCP" on a new bid, look it up in your catalog instead of guessing. Update it after every job with your actual costs.

Tip 5: Build in your review time

Don't price a bid and submit it the same day if you can avoid it. Sleep on it. Come back the next morning and check the big-dollar items with fresh eyes. More bidding mistakes happen under time pressure than any other cause.

Tip 6: Track your bid results

After the bid opening, get the bid tab results. Compare your price to the winner's price. Where were you high? Where were you low? This is how you calibrate your pricing over time. Most public agencies publish bid results — DOTs, counties, and cities all have them available.

Wrapping up

A good construction bid template doesn't need to be complicated. It needs the right columns (Item #, Description, Unit, Quantity, Unit Cost, Unit Price, Extended Cost, Extended Price), the right adjustment rows (Mobilization, Bonding %, Contingency %, Tax %), and a clean layout that doesn't break when you add rows.

The template in this guide covers all of that. Use it for your next bid.

And if you're tired of the part where you type 80 line items from a PDF into a spreadsheet — try CivBid. Upload the PDF, get the line items extracted automatically, price from your catalog, and generate the bid. It's what this template would be if spreadsheets could read PDFs.

Ready to try it?

Upload an ITB PDF and see CivBid extract your line items automatically. No signup required.

Upload an ITB PDF — Try Free