Task Tracker
Everything you said you would do, in one place.
A task tracking spreadsheet for anyone running their own week, whose to-do list is currently split across a notebook, three apps and the back of an envelope.
Task Tracker is a 15-tab Excel and Google Sheets workbook. 2 you type into, 11 calculated from those and 2 you set once. No macros, so it opens without a security warning.
- Today What is due now, pulled from the task list.
- Dashboard Counts, completion rate and where the week is going.
- Momentum Completed over time, so a good run is visible and a stall is obvious.
Filed under productivity & planning.
All 15 tabs, exactly as they look in the file. Click a tab to look inside.
Sound familiar?
What's inside, tab by tab
You only ever type in the highlighted input cells. Everything else is calculated from what you type.
| Tab | What you do | What it does |
|---|---|---|
| Tab 1Start Here | Set once, never again | A one page setup guide inside the workbook. Enter your basics once, in about 5 to 10 minutes. |
| Tab 2Today | Calculated for you | What is due now, pulled from the task list. |
| Tab 3Dashboard | Calculated for you | Counts, completion rate and where the week is going. |
| Tab 4Momentum | Calculated for you | Completed over time, so a good run is visible and a stall is obvious. |
| Tab 5Workload | Calculated for you | How the load spreads across people or projects. |
| Tab 6Tasks | You type here | One row per task: title, project, owner, due date, priority, status and notes. Room for 500. |
| Tab 7Recurring Rules | You type here | Define a repeating task once, with its interval. Up to 30 rules. |
| Tab 8Task Schedule | Calculated for you | The occurrences your recurring rules generate, up to 480, built from the rules above. |
| Tab 9Filter | Calculated for you | A filtered view of the task list for slicing by project, owner or status. |
| Tab 10Monthly Calendar | Calculated for you | The month laid out, with tasks on their due dates. |
| Tab 11Weekly Calendar | Calculated for you | The same for a single week. |
| Tab 12Decision Matrix | Calculated for you | Urgent against important, plotted from the priority you already set. |
| Tab 13Kanban | Calculated for you | The same tasks as columns by status. |
| Tab 14Gantt | Calculated for you | Start and due dates drawn as bars across the timeline. |
| Tab 15Settings & Lists | Set once, never again | Projects, owners, statuses and priorities. Change them once and the whole workbook follows. |
Built like software, priced like a spreadsheet
Enter your data; totals, flags and the dashboard update instantly.
Checked cell by cell before release. Find one and we will fix it.
Formula cells are protected. You can only type where typing is safe.
Both versions in every purchase. No converting, no broken references.
Clean report pages for your records, your accountant, or your next meeting.
Delivered by Etsy the moment you pay. Free updates to this template forever.
How it works
Secure checkout through Etsy, no account needed here.
The Excel file and the Google Sheets link arrive immediately.
Type into the highlighted cells and every total is calculated from what you typed.
Questions, answered
Do I need a paid Excel version?
Any desktop Excel from 2016 onward works, including Microsoft 365. If you don’t have Excel at all, use the included Google Sheets version. It’s free.
Does it fully work in Google Sheets?
Yes. The Google Sheets version is made from the same file as the Excel one and checked in Google Sheets before release. Every formula uses functions that work the same in both.
Is this a one-time purchase?
Yes. One payment, no subscription. You keep the files forever and get free updates to this template.
What does it not do?
It does not remind you, email you or chase anyone. It has no macros or scripts, which is why it opens without a security warning in Excel and in Google Sheets.
What’s the refund policy?
Refunds follow Etsy’s rules for digital downloads. If a template doesn’t work as described, email support@elecart.us and we will fix it.
What if I get stuck?
Email support@elecart.us and the person who built the template answers, usually within one business day. Etsy Messages works too.
How much data can it handle?
Input tabs are sized generously and tested with full sample data: enough for years of typical use. Need more room? Duplicate the file per year, or email support for an extended version.
Everything you said you would do, in one place.
$2.09, once, 70% off until Nov 28. Yours forever, with free updates.
Get it on Etsy →
