← Back to all articles Productivity

12 Free Project Schedule Templates

A dependency schedule with tasks, predecessors, dates, durations and critical path flags

A schedule is the project's model of time: what happens, in what order, for how long, and who does it. It is more than a list of dates because the dates depend on each other; move one task and the ones after it move too. A schedule that captures those dependencies can answer the only question sponsors ask, which is when, and can show which tasks decide the answer.

Twelve schedules are here, because projects differ. Four general ones (task list, weekly Gantt, monthly phase and milestone), two that model dependencies and resources, and six for particular kinds of work: sprints, construction, events, rollouts, maintenance and training. The Excel workbook calculates durations, status and the critical path flag on the dependency schedule; Word and PDF carry the printable versions.

Download the templates

Free files: Word, Excel and PDF

Three files, free, no email required. Word to edit, Excel to track, PDF to print or share.

Templates open in Microsoft Word, Excel, Google Docs and Sheets, LibreOffice and any PDF reader. Free to use and adapt for your organization.

The twelve schedules

ScheduleUse
Simple task list scheduleSmall projects; dates and status
Weekly Gantt scheduleOne to four months; shaded weeks
Monthly phase scheduleSix months to two years; shaded months
Milestone scheduleReporting against baseline
Dependency scheduleProjects where order matters; find the critical path
Resource-loaded scheduleProjects where people are the constraint
Sprint scheduleAgile teams
Construction schedulePhases by trade with inspections
Event scheduleRun-of-day timing
Rollout schedulePhased deployment by wave
Maintenance scheduleRecurring tasks with next-due dates
Training scheduleSessions with capacity

Dependencies and the critical path

Most tasks cannot start until something else finishes. The dependency schedule records that as a predecessor per task; the early start of a task is the early finish of its predecessor, and the longest chain of dependent tasks from start to finish is the critical path. Tasks on it have no slack: a day lost on any of them is a day lost on the project. Tasks off it have float and can slip without moving the end date. Knowing which is which is the difference between managing a schedule and watching one.

The Excel sheet asks you to mark the critical chain by hand, which is practical up to forty or fifty tasks. Beyond that, scheduling software that computes it is worth having; the timeline templates are the presentation layer either way.

Resource-loaded schedules

A schedule can be feasible in time and impossible in people. The resource-loaded sheet spreads each task's hours across weeks and totals by week, so a week that needs 90 hours from a person who has 35 is visible before it arrives. The resource planning templates extend this across projects, and the capacity planning templates cover the team-level view.

Keeping a schedule honest

Key takeaways

Frequently asked questions

What is a project schedule?

The project's plan of time: tasks, their order and dependencies, durations, dates and owners, with milestones to report against. It differs from a timeline, which is the summary picture, and from a task list, which has no dependencies.

What is the critical path?

The longest chain of dependent tasks from the project's start to its end. Tasks on it have no float: a delay to any of them delays the project. Finding it tells you which tasks to protect and which can slip without harm.

How do I build a schedule in Excel?

List tasks with owner, start and end dates; use NETWORKDAYS for working-day durations; add a predecessor column for order; and use formulas for status. For weekly or monthly bars, use the Gantt grids in the timeline templates. For automatic critical path and resource leveling, use scheduling software.

What is a resource-loaded schedule?

A schedule that spreads each task's effort across time periods and totals demand per person or role per week, so overloads show before they happen. It is the link between the schedule and the resource plan.

How often should the schedule be updated?

Weekly on active projects, with actual start and finish dates and remaining durations rather than percentage complete. Milestones are reported against the baseline in the status report.

← Back to all articles