Project plan template with a Gantt chart
A work breakdown with phases, milestones and dependencies and a weekly Gantt chart that redraws when dates change. The file uses the Etapero import layout.
Excel, 10 KB. No macros, no sign-up.
What is inside
- The “Plan” sheet: code, title, type, owner, start, finish, work days, predecessors, status and progress.
- A sample project of five phases with milestones; dates follow the Russian production calendar, holidays skipped.
- Sixteen weekly columns with Gantt bars; milestones are orange.
- An “Instructions” sheet with the steps to load it into Etapero.
How to use it
- Replace the sample with your own phases and work. The code sets the row’s place: 1 is a phase, 1.1 a piece of work inside it.
- Type is Phase, Work package, Task, Milestone or Goal. Dates are DD.MM.YYYY.
- List predecessor codes separated by semicolons; finish-to-start is assumed.
- Set cell K1 to the Monday the project starts — the week headers and bars move on their own.
How it looks in Etapero
In Etapero: Structure → Import → “Upload an Excel or CSV file”, the “Plan” sheet, “By the row numbers of a column”. Etapero skips the week columns. After the upload it recalculates dates from dependencies and the calendar, finds the critical path, and a baseline is one click away.
Related articles
The work breakdown structure (WBS)
How to build a project WBS: the 100% rule, levels and work packages, deliverable-oriented naming, an example structure and common mistakes.
How to make a Gantt chart
Step by step from a list of work to a Gantt chart with dependencies, durations, milestones and the critical path, plus the common mistakes to avoid.
The critical path in plain words
What the critical path and float are, how to work them out on a simple example, and how to use them to keep a project on schedule.
Other templates
Risk register
Probability and impact from 1 to 5, score and zone by formula, a 5×5 matrix on its own sheet.
Issues and decisions log
Issues with owners and due dates, decisions with who made them and when. Overdue ones turn red.
RACI matrix
Deliverables and roles with R, A, C and I. The check column shows rows with no accountable person or two.
Project management plan
A “how we run the project” checklist: plan sections, questions, answers and approval status.
Try it yourself
The demo runs in your browser with no sign-up: you enter as a demo user and can edit the sample projects.
Open the demo