A project tracker template is a table with one row per project or task and columns for owner, due date, status and next step. This post gives you three to copy into Excel or Google Sheets: a project list, a milestone sheet and an issues log, plus a weekly status block. A sheet works well for a few projects. Five signs below tell you it has stopped being enough.
Key takeaways
- A tracker needs few columns. Owner, date and status do most of the work; extra columns mostly go stale.
- Use dropdowns for status so every row says the same thing.
- Track milestones separately from tasks. Milestones are what the client sees.
- A sheet cannot tell you anything unless someone updates it. Decide who and when.
- When two people edit at once, deadlines slip between tabs, or invoices depend on it, a sheet is no longer enough.
What should a project tracker template include?
Start with the smallest set that answers four questions: what are we delivering, who owns it, when is it due, and is it on track. Add a column only when somebody asks a question the sheet cannot answer.
Copy the first table into a new sheet, or download the workbook, which has all four sheets in this article. It is the main list: one row per project.
Download the project tracker template (Excel)
| Project | Client | Owner | Start | Promised date | Current milestone | Status | Next step | Budget (₦) | Spent (₦) |
|---|---|---|---|---|---|---|---|---|---|
| Ikeja office fit-out | Bakare & Sons | Adaeze Okafor | 03/11/2026 | 28/02/2027 | First fix | On track | Client to sign inspection sheet | 9,000,000 | 3,150,000 |
| Logistics website | Trans-Niger Freight | Tunde Bello | 10/11/2026 | 15/01/2027 | Design | At risk | Waiting on logo files | 1,500,000 | 400,000 |
The two rows are examples. Delete them and start your own.
How to set it up.
- Make Status a dropdown: Not started, On track, At risk, Late, Done. Google Sheets explains how in Create an in-cell dropdown list; Excel has the same idea under Data validation.
- Colour the status cell by value, so late projects stand out when you open the sheet.
- Write dates one way (day/month/year) in the whole sheet, so nobody reads 03/11 as March.
- Keep Next step to a short sentence with a name in it.
What does a milestone tracker sheet look like?
Milestones are what the client sees, so give them their own sheet, with one row per milestone. Link it to the project list by the project name.
| Project | Milestone | Owner | Due date | Proof needed | Proof received (yes/no) | Status | Payment waiting on it (₦) | Invoiced (yes/no) |
|---|---|---|---|---|---|---|---|---|
| Ikeja office fit-out | First fix signed off | Adaeze Okafor | 12/12/2026 | Inspection sheet signed | No | In progress | 2,700,000 | No |
| Ikeja office fit-out | Furniture installed | Chinedu Eze | 30/01/2027 | Delivery note and photos | No | Not started | 2,700,000 | No |
The last two columns are the ones that save money. If a milestone is done and Invoiced still says No, you have found revenue waiting. For how to choose milestones and tie each to a payment, see project milestones examples.
What does an issues log look like?
Every project has things in the way. A log gives each one an owner and a date.
| # | Project | What went wrong | Severity | Owner | Raised | Answer by | Resolved | What fixed it, and the lesson |
|---|---|---|---|---|---|---|---|---|
| 1 | Ikeja office fit-out | Ceiling boards delivered in the wrong size | High | Chinedu Eze | 04/12/2026 | 05/12/2026 |
Use four severities (Critical, High, Medium, Low) and decide in advance how fast each should be answered. If nobody ever fills in the last column, you will repeat the same mistake on the next project.
How do you keep a weekly status table?
On Monday, copy this block into a new tab, or into an email to the owner, and fill it in for each project. It answers the question "where do we stand" in one screen. For more on weekly reporting, see weekly report to your boss.
| Project | Done this week | Planned next week | Blocked by | Money to invoice (₦) | Status |
|---|---|---|---|---|---|
Excel or Google Sheets for a project tracker?
Both work. Pick by how your team shares.
| Excel | Google Sheets | |
|---|---|---|
| Best when | One person keeps it and it is emailed around | Several people edit it at once |
| Strength | Powerful formulas and charts on a desktop | Shared by link, edits seen live |
| Risk | Many copies, "finalv3REAL.xlsx" | Anyone with edit access can overwrite a formula |
| On a phone | Works, but wide sheets are awkward | Works, with the same limit |
Whichever you use, lock the header row and the formula columns, and keep one master copy.


