Task & Project Tracker (Excel)
One list for everything your team has to do. Each task has an owner, priority, due date and status; overdue tasks turn red and the Dashboard counts tasks by status and by owner with a chart you can paste into a report.
Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.
Preview
Real view of the file with its sample data (yellow cells are where you type).
Tasks
| Task | Project | Owner | Priority | Start | Due | Status | % done | Days left | Overdue |
| Prepare quarterly sales report | Reports | Neha | High | 23-10-2026 | 31-10-2026 | In progress | 70% | -2 | Overdue |
| Renew office insurance | Admin | Vikram | High | 28-10-2026 | 08-11-2026 | Not started | 0% | 6 | |
| Update price list on website | Website | Sana | Medium | 25-10-2026 | 01-11-2026 | Done | 100% | ||
| Collect vendor quotations for laptops | Purchase | Amit | Medium | 30-10-2026 | 12-11-2026 | In progress | 40% | 10 | |
| Train new staff on billing software | HR | Neha | Low | 04-11-2026 | 17-11-2026 | Not started | 0% | 15 | |
| Fix printer in accounts room | Admin | Vikram | Low | 27-10-2026 | 30-10-2026 | Blocked | 20% | -3 | Overdue |
What's inside
- Tasks sheet: task, project, owner, priority, start, due, status, percent done, notes; days left and overdue flag
- Drop-down lists for status and priority
- Dashboard: totals by status, by owner and by priority, overdue count and a bar chart
How to use it
- Type your team members' names on the Lists sheet.
- Add each task on the Tasks sheet with owner, priority and due date.
- Update status and percent done as work moves.
- Use Data › Filter to see one person's or one project's tasks.
- Open the Dashboard for the summary and chart.
Tips
- Review overdue tasks in your weekly meeting and set a new realistic date rather than leaving them red.
- Use the Project column to keep several projects in one file.
Questions and answers
When is a task overdue?
When today is past its due date and its status is not Done.
Can I share it with my team?
Yes. Upload it to OneDrive, Google Drive or SharePoint and everyone can edit the same copy.
More in the General Office toolkit
Meeting Minutes (Word)Free minutes of meeting (MOM) template for Word: meeting details, attendees, agenda, discussion and decisions, and an ac…Word templateExpense Claim Form (Excel)Free Excel expense reimbursement form: list bills by date and category, totals by category, less advance taken, net amou…Excel templateOnline Expense Claim MakerMake an expense reimbursement claim online: bills by category, advance, net payable and signatures. Print, save as PDF o…Online tool
Also useful
GST Invoice Template (Excel)Free GST tax invoice template for Excel. Pick a customer and items; it fills HSN, rates, CGST+SGST or IGST and the amoun…Excel templateGST Monthly Summary (Excel)Free Excel workbook that totals a month's sales and purchases by GST rate: taxable value, IGST, CGST, SGST, B2B and B2C,…Excel templateClient Dues & Ageing (Excel)Free Excel receivables tracker: list bills and receipts, see each client's balance by age (not due, 1-30, 31-60, 61-90, …Excel template