Project & Task Tracker: Excel & Google Sheets Template

Project and Task Tracker for Excel and Google Sheets

A project tracker for small teams running several projects at once. You add tasks with owners, dates, % done and cost, and the Gantt timeline, Kanban board, project budgets and dashboard are built from that list.

What's included

• A task list with 300 rows and dropdowns for project, phase, owner, priority and status
• Workdays that skip weekends and your holiday list, days left, and cost per task
• A health flag on each task (On Track, At Risk, Overdue, Blocked, Upcoming or Done), with rules you can change on Settings
• A 30-week Gantt timeline with progress shading, overdue bars and a marker for the current week
• A Kanban board grouped by status
• A Projects tab for up to 20 projects with budget, spend, budget left, % complete weighted by task length, and a schedule flag
• A dashboard with 6 summary figures, one project you pick from a list, 4 charts and the next 10 deadlines
• A My Tasks tab that lists one person's open tasks, narrow enough for a phone
• An Instructions tab and a 2-page Quick Start Guide (PDF)

Files

• Project and Task Tracker.xlsx, with five fictional sample projects
• Project and Task Tracker (blank).xlsx, the same workbook with no data
• Quick Start Guide.pdf

You get them in one zip file, Project and Task Tracker.zip.

Good to know

Works in Excel 2016 or later and Microsoft 365 on Windows or Mac, and in Google Sheets on a computer, phone or tablet. There are no macros or add-ins. To use it in Google Sheets, upload the .xlsx to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.

Gray cells hold formulas. You only type in the white cells.

This is a digital download, so nothing is shipped. You can download the files from your Etsy Purchases page (or the Payhip link) right after you buy. Sample names and figures are fictional.

License (single company): for use inside one company only. You may edit it and use it with your team. You may not resell, share or redistribute the files, or use one purchase for more than one company.

Questions? Email Bengopoyan1@gmail.com. More templates: etsy.com/shop/KeelAndCharter and payhip.com/KeelandCharter

Designed and reviewed by Keel & Charter. AI tools helped build the spreadsheets, draft the text and lay out the preview images. Preview images show the actual files with sample data.