What’s in the template
The template follows a typical renovation or small build of about six months, in five phases. Each task has a start week and a duration, and the phases are linked in the order the trades come on site.
| Phase | Weeks | Tasks | Milestone |
|---|---|---|---|
| Preparation | 1–5 | Survey and drawings, Permits and quotes | Contracts signed |
| Structure | 6–11 | Site setup and demolition, Structural work, Roof and windows | — |
| Services | 12–17 | Plumbing and electrical rough-in, Insulation and drywall, Screed and drying | — |
| Finishes | 18–21 | Tiling and flooring, Painting, Kitchen and bathroom fit-out | — |
| Handover | 22–23 | Snagging | Handover |
Rename the tasks and change the durations and it fits a house extension, a flat refurbishment, a shop fit-out or a small new build.
The Excel version
The workbook has a Schedule sheet and a short How to use sheet. Dates are calculated from one start of works cell, so if the start slips by two weeks you change one date and the whole schedule moves. A Trade column shows which contractor is on site each week. The bars are drawn by conditional formatting: no macro, no add-in, and it opens in Excel, Google Sheets and LibreOffice. Print it in landscape for the site office.
How to make a construction schedule
- Start from the handover date if it is fixed, and work backwards. Otherwise start from the date you can get on site.
- List the work packages by trade: groundwork, structure, roof, first fix, plastering, second fix, finishes. One line per trade and area is enough.
- Put them in order. The building must be weathertight before the inside work starts, and first-fix plumbing and electrics go in before the walls are closed.
- Add waiting times: a screed needs to dry before tiles or wooden floors go down, and windows or a kitchen can take several weeks to arrive after ordering.
- Mark the milestones the client cares about: contracts signed, weathertight, handover.
- Keep a buffer of one or two weeks before handover for weather, late deliveries and snagging.
Tips from the site
- Weekly is the right scale for a project of a few months. Plan the critical weeks day by day if you need to.
- Order long-lead items early. Put the order date in the schedule as its own task, not just the installation.
- Update it every week after the site meeting, and send the new version to every trade.
- Watch the chain. A delay on the roof pushes every inside trade. The critical path tells you which delays move the handover date.
Excel or online?
In Excel, when the roofer is a week late you move every following task by hand. In Ganttmint you drag the roof bar and the linked tasks follow. You can share a read-only link with the client and the trades, and export to Excel or PDF whenever someone asks for a file. For other kinds of projects, see the Gantt chart templates or the Excel Gantt chart templates.
Questions
Is the construction schedule template free?
Yes, online and in Excel, for personal or commercial projects.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets: the formulas and the bars keep working.
How detailed should a construction schedule be?
For a project of a few months, one line per trade and area, by week, is enough. Plan the critical weeks day by day if needed.
Can I share the schedule with the client and the trades?
Yes. Online, share a read-only link. In Excel, print it in landscape or export it to PDF.
Can I add my own tasks?
Yes. In Excel, insert a row inside a phase and copy the row above. Online, click a row and press Enter.