Construction schedule template
A construction schedule lists every activity, how long it takes, what has to finish first, and who does it. Download this template as a CSV for Excel or Google Sheets, or print it.
A construction schedule template is an activity list with start dates, durations, finish dates, and the links between tasks. Fill it in from top to bottom in the order work happens, note which activity has to finish before the next one starts, and you have a working construction schedule you can share with subs and the owner. Drop the columns into a spreadsheet and add a bar chart to get a simple Gantt chart.
A spreadsheet schedule will not replace scheduling software on a 200-activity hospital job. On a $480,000 tenant improvement or a custom home, it is often all you need, as long as it gets updated every week.
What the schedule is for
The schedule tells everyone when they are needed and what they are waiting on. It drives sub coordination, material orders, inspections, and the owner's move-in plan. Save the first approved version as your baseline schedule, then update a working copy each week so you can show where the job slipped and why. Short-term field planning comes from the master schedule, typically as a three-week look-ahead.
How to fill in each column
- ID: a short number for each activity so predecessors can reference it.
- Activity: one piece of work with a clear finish, like "Rough electrical, level 1," not "Electrical."
- Responsible: the crew or subcontractor who owns it.
- Duration: working days. Be consistent about whether weekends count.
- Start and finish: planned dates. The finish should equal start plus duration, adjusted for non-work days.
- Predecessor: the ID of the activity that must finish first. This is what makes the schedule show the chain.
- Percent complete and status: updated each week from the field, not from memory in the office.
Common scheduling mistakes
- Activities that are too big to track, so progress is a guess.
- No predecessors, which turns the schedule into a calendar and hides the critical path.
- Building it once for the contract and never updating it.
- Leaving out owner tasks such as selections, approvals, and furniture deliveries.
- Not adding weather or holiday days, then promising dates the crew cannot hit.
Related forms and guides
Start with how to build a construction schedule, then keep it current with how to update a construction schedule every week. For subs, see how to schedule subcontractors. If the job is falling behind, how to recover a construction schedule covers the options.
Smart Business Automator keeps project dates, tasks, and shipment tracking in one place so a late delivery shows up against the schedule before the crew is standing around. See construction workflow automation.
Construction schedule
| ID | Activity | Responsible | Duration (days) | Start | Finish | Predecessor | Percent complete | Status |
|---|---|---|---|---|---|---|---|---|
| 1 | Permit issued and notice to proceed | GC | 1 | 2026-06-01 | 2026-06-01 | 100% | Complete | |
| 2 | Demolition and haul-off | Demo sub | 5 | 2026-06-02 | 2026-06-08 | 1 | 100% | Complete |
| 3 | Layout and interior framing | GC framing crew | 8 | 2026-06-09 | 2026-06-18 | 2 | 60% | In progress |
| 4 | Rough plumbing, electrical, HVAC | MEP subs | 7 | 2026-06-15 | 2026-06-23 | 3 | 20% | In progress |
| 5 | Rough-in inspections | City inspector | 2 | 2026-06-24 | 2026-06-25 | 4 | 0% | Not started |
| 6 | Insulation and drywall hang | Drywall sub | 6 | 2026-06-26 | 2026-07-03 | 5 | 0% | Not started |
| 7 | Tape, finish, prime | Drywall sub | 5 | 2026-07-06 | 2026-07-10 | 6 | 0% | Not started |
- Sample data only. Durations here are in working days, Monday to Friday.
- Use the Predecessor column to show which activity must finish before the next starts. Overlapping starts (like activity 4) mean work can begin before the predecessor fully finishes; note the lag if you use one.
- Save the first approved version as the baseline and update a copy weekly.
- To make a Gantt view in Excel, add a stacked bar chart using Start and Duration.
- Pull the next three weeks into a three-week look-ahead for field meetings.
Frequently asked questions
Can I make a construction schedule in Excel?
Yes. Download the CSV, open it in Excel or Google Sheets, and add a stacked bar chart on the start date and duration columns to create a basic Gantt chart.
How detailed should a construction schedule be?
Detailed enough that each activity has one responsible party and a clear finish. On small jobs that is often 30 to 80 activities. Break big activities by area or floor.
How often should the schedule be updated?
Weekly is a common rhythm, usually before the weekly site meeting, with percent complete coming from the field.
What is the difference between a master schedule and a look-ahead?
The master schedule covers the whole job. A look-ahead pulls the next few weeks out in more detail so the superintendent can plan crews, deliveries, and inspections.
