Free template · Excel
Free Multi-Project Tracker Template (Excel)
Track several software projects in one file. Every task has an owner, an expected outcome, and a status, and the overview counts open tasks and blockers for each project automatically.
Download (.xlsx)
Works in Excel and Google Sheets · No sign-up · Updated
What's inside
- Projects: One row per project with phase, next milestone, RAG health, and weekly client meeting. Open tasks, blocked tasks, and client-side blockers are counted automatically.
- Tasks: One row per task: owner, expected outcome, status, priority, estimated and actual effort, start and due dates, QA status, environment, blocker, blocker side, and linked tasks.
- Timeline (Gantt): Draws a weekly bar for every task with a start and due date. Blocked tasks show in red, done in grey, and this week is highlighted.
- RAID log: Risks, assumptions, issues, and dependencies, each with an owner and a next step.
- How to use: How to fill in each sheet and the daily routine to check it.
Preview
Example rows from the Projects sheet:
| Project | Name | Phase | Next milestone | Health | Client meeting |
|---|---|---|---|---|---|
| P1 | Mobile app | Sprint 3 | Beta to client | Amber | Tuesday |
| P2 | Web dashboard | Sprint 1 | Payments live in staging | Green | Thursday |
How to use it
- List every project once in Projects, using a code like P1 or P2.
- Add one row per task in Tasks, with an owner, an outcome, and a status.
- Note blockers and whether they sit with the client or the team.
- Check Projects every morning and review the RAID log weekly.
To use it in Google Sheets, open Google Sheets, choose File, then Import, and upload the file. The dropdowns and formulas carry over.
The full guide behind this template: How I Track 10 Projects at Once.