Project Task Tracker in Excel with Status and Progress

Whatever the size of your project, you need tasks, owners and deadlines in one place. This table tracks 25 tasks and shows the share of completed tasks at the top.

What is inside the sheet?

• 25 tasks with owner, start and end dates
• Duration in days calculated automatically
• Status from a list: Not started, In progress, Done, Delayed
• Completed task percentage at the top

How to use it

1. Enter tasks and owners
2. Enter the start and end dates
3. Pick the status from the list
4. Follow overall progress at the top

Tips for best results

• Split big tasks into smaller ones
• Update the status once a week
• Give each task a single owner

Frequently asked questions

Does it draw a Gantt chart?

No, it is a simple and quick tracking table.

Can I add more tasks?

Yes, copy the last row and paste it below.

Download the sheet

Press the download button at the top of the page to get an Excel file ready to edit. The sheet is also available in Arabic from the language switcher.