Excel project task tracker
Dina collects updates on assigned project tasks: status, forecast dates, completion percentages and cumulative hours. Original dates and the history of changes remain in the register.
Dina collects text replies for this format. Review the questions, respondents and schedule before starting.
No registration · fictional sample data · updated 10 September 2026Who is this for?
Project managers who coordinate several people and need to track changes against the original plan. Suitable for a website launch, a system rollout or another project with a defined list of tasks.
A filled-in example
| Task | Project phase | Due date | Forecast completion | Completion, % | Planned effort, h | Actual effort, h |
|---|---|---|---|---|---|---|
| Approve the test plan | Design | 2026-09-21 | 2026-09-23 | 75 | 24 | 18 |
Fictional sample data. Missing answers are shown separately from confirmed zero values. The downloadable workbook contains the full set of fields.
What the spreadsheet tracks
- Project, phase and task
- Import stable task IDs, owners, project and phase. Review extracted data before applying it.
- Baseline and forecast
- Original dates are preserved. An owner’s completion forecast is separate and does not automatically change the agreed deadline.
- Progress and hours
- Progress is a number from 0 to 100. Actual hours are cumulative per task, including previous days; repeated collections do not add the same hours again.
Questions for collecting the data
- What is the status of each assigned project task? What is blocking it and what are the next steps?
- Is the agreed due date still achievable? Give a separate forecast completion date.
- What percentage of each task is complete, and how many hours have been spent in total, including previous days?
These are the live format’s standard questions. Replies, clarifications and source messages remain available in the app.
How to use the template
Choose the format
Review the standard questions. For project tasks, import and check the register and owners first.
Invite respondents and set the schedule
Choose email or another connected channel, collection days, response deadline and report recipients.
Review the collected result
Check missing information and original replies, read the summary and download the frozen Excel report.
This workbook shows a completed collection, not a form for respondents to fill in. Import a reviewed register for project tasks. Participants answer other formats in text.
Questions about this template
Do I need a separate project registry?
Use the existing action import: XLSX, UTF-8 CSV, DOCX, PDF with a text layer, TXT or Markdown. Add project and phase information.
Does a forecast automatically change the deadline?
No. The owner reports a forecast; the manager reviews any change to the agreed deadline.
Are budgets, Gantt charts and portfolio reports included?
This format collects task updates. It does not include budgets, Gantt charts, dependency planning or automatic consolidation of separate collections into a portfolio report.
Put the template to work
View the English example and set up collection with your team. Check the report recipients before sending.