# Project Tracking Excel Template: Build Your Own in 7 Steps > Build a project tracking Excel template step by step: the columns, status drop-downs, overdue formulas and a weekly status report, plus where it breaks. _Source: https://professionalstoolkit.com/articles/project-tracker-excel — The Professional's Toolkit · updated October 2026_ --- A project tracking Excel template is a single table where every task gets one row with an owner, a due date, a status and a percent complete, plus a few formulas that flag what is late and roll everything up into a status line. You can build one yourself in under an hour. The method is simple: **one row per task, drop-downs for status, and a rule that turns overdue rows red.** It works well for one person or a small team, until several people edit it and the updates stop happening on their own. **8 columns** — Task, owner, start, due, status, % complete, days left, notes: enough for a working tracker - **4** — status values: Not started, In progress, Blocked, Done - **3 formula blocks** — days left, overdue flags, project roll-up - **5 parts** — of a weekly project status report ## What a project tracking Excel template needs Most trackers fail because they hold too much. Start small. Keep the columns that answer three questions: who owns this, when is it due, and where does it stand. Everything else (long descriptions, meeting notes, file links) belongs somewhere else, or in a single notes column at the far right. A tracker that fits on one screen gets updated. A tracker with thirty columns gets abandoned by week three. | Column | What goes in it | Why it matters | |---|---|---| | A · Task | Short verb-first name | One row, one deliverable | | B · Owner | One name | Shared tasks drift | | C · Start | Date | Shows work that should have begun | | D · Due | Date | Drives the overdue flag | | E · Status | Drop-down: Not started, In progress, Blocked, Done | Makes counting possible | | F · % complete | 0 to 100 | Feeds the project roll-up | | G · Days left | Formula | Sorts urgency for you | | H · Notes / blocker | One line | The context for the status report | Add a **Milestone** column (Yes or blank) if your project has fixed checkpoints such as a client review or a launch date. Milestones are what stakeholders actually ask about. Filtering on that column gives you the short list for the top of every report. > 💡 **Put the status list in a table:** Keep the drop-down values on a Lists sheet formatted as a table. When you add a status later, every drop-down picks it up. ## How to build the project tracker in Excel, step by step These steps follow Microsoft's own help pages for Excel for Microsoft 365, Excel 2024 and Excel 2021. The menu names are the same on Windows and Mac. 1. **Type the headers** from the column list above in row 1, starting at A1. 2. **Turn the range into a table.** Click any cell in it and press Ctrl+T. Microsoft recommends tables for list data because a drop-down whose list sits in a table updates when you add or remove items from that list.[1] 3. **Build the status list.** On a second sheet called Lists, type Not started, In progress, Blocked and Done in one column, then press Ctrl+T on it too. 4. **Add the drop-down.** Select the Status cells, go to Data > Data Validation, and on the Settings tab set Allow to List. Point Source at your status list and keep In-cell dropdown checked.[2] 5. **Restrict % complete.** Same dialog, Allow set to Whole Number between 0 and 100. Use the Input Message tab to remind people what the column means. 6. **Format the dates.** Select columns C and D and apply a short date format so sorting works. 7. **Freeze the header row** (View > Freeze Panes > Freeze Top Row) so the labels stay visible as the list grows. One detail trips people up. If the Data Validation command is greyed out, the sheet is protected or the workbook is shared, and Microsoft notes you cannot change validation settings in either state. Set the drop-downs before you share the file. ## The formulas that keep the tracker honest A tracker is only useful if it tells you something you did not type in. Three pieces do most of that work. Each takes a minute. The cell references below assume your data starts in row 2 and runs to row 100; adjust them to your table. ### Days left In G2: `=IF(E2="Done","",D2-TODAY())`. Finished tasks show blank. Everything else shows a number, and a negative number means late. Sort the table by this column and the most urgent work rises to the top. ### Highlight overdue rows Select A2:H100, then go to Home > Conditional Formatting > New Rule and choose Use a formula to determine which cells to format. Enter `=AND($D2<>"",$D2"Done")` and pick a red fill. The first check skips rows with no due date, so empty rows stay white. Microsoft's rule is that the formula must start with an equal sign and return TRUE or FALSE, and its own example compares a date column with TODAY() the same way.[3] The dollar sign before the column letter makes the whole row turn red, not just one cell. Add a second, amber rule for tasks due in the next seven days: `=AND($D2>=TODAY(),$D2<=TODAY()+7,$E2<>"Done")`. ### Project roll-up On a small summary block beside the table (for example in columns J and K): - **Overall % complete:** `=AVERAGE(F2:F100)` - **Tasks done:** `=COUNTIF(E2:E100,"Done")` - **Blocked:** `=COUNTIF(E2:E100,"Blocked")` - **Due this week:** `=COUNTIFS(D2:D100,">="&TODAY(),D2:D100,"<="&TODAY()+7,E2:E100,"<>Done")` That block is the heart of your status report. Nobody counts by hand. > 💡 **Keep formulas out of the table:** Keep roll-up formulas in a separate block beside the table, not inside it, so a sort or a pasted row cannot overwrite them. ## The same project tracker template in Google Sheets Google Sheets handles the same layout with nearly the same menus, and it adds live co-editing. Build the headers, then: 1. **Add the status drop-down** with Insert > Drop-down, or right-click a cell and choose Dropdown. Type the four status values as the options. 2. **Add the overdue rule.** Select A2:H100 and open Format > Conditional formatting. Under Format cells if, choose Custom formula is, then enter `=AND($D2<>"",$D2"Done")`. Google's help shows the same pattern for coloring a whole row from one column, and stresses the dollar signs for absolute references.[4] 3. **Paste the roll-up formulas.** TODAY, COUNTIF, COUNTIFS and AVERAGE behave the same way in Sheets. Sheets wins when two or three people update the tracker at once. Excel wins when one owner keeps it and wants tables, slicers and pivot tables on top. ## Turn it into a weekly project status report template A status report is not a dump of the tracker. It is the five things a stakeholder needs to decide or act on. Add a second tab called Status and fill it from the roll-up block each week: 1. **Overall status** in one color: green (on track), amber (at risk), red (off track). Define each color in advance, for example red when a milestone will slip. 2. **Progress:** overall % complete and tasks done since last week. 3. **Milestones:** the next two, with dates and whether they hold. 4. **Blockers:** every Blocked row, with its owner and what would unblock it. 5. **Next week:** the tasks due in the next seven days. Copy last week's tab before you overwrite it. A row of past colors shows the direction of travel, which says more than any single week. If the report takes longer than fifteen minutes, the tracker has too many columns or too few formulas. For the method behind these choices, see our guide on [how to track project progress](/articles/how-to-track-project-progress). > ⚠ **Pasted values skip validation:** Data validation checks what people type, not what they paste. A pasted status like Complete or Finished, or Done with a trailing space, will slip past the drop-down and drop out of your COUNTIF totals. ## Where a spreadsheet tracker stops working The template holds up well for one owner and a few dozen tasks. Then it cracks. It breaks at specific points, and you will recognize them. Here are four. **Updates depend on memory.** The sheet never asks anyone for a status. If an owner forgets, the row stays at In progress for three weeks and the report is wrong without anyone noticing. **Nobody gets told.** A task going overdue turns a cell red, but only for whoever opens the file. There are no notifications, no reminders and no assignment alerts. **Dependencies do not move.** When one task slips, the tasks that wait on it keep their old dates. You shift them by hand, and you miss one. **Several projects means several files.** A portfolio roll-up across trackers needs links between workbooks, and those break when files move. When two of these hit at the same time, a project tool earns its place. The reporting parts are where they differ most: ### Asana — solves this Each tracker row becomes a task with an owner and due date, and the project owner posts status updates in the project instead of filling a report tab. Reporting dashboards replace the roll-up block. - Where it stops: Free (Personal) is limited to 2 users and a single assignee per task; cross-project reporting needs Advanced. - Plan: Reporting dashboards from Starter - More: [Asana](https://professionalstoolkit.com/tools/asana) ### Wrike — solves this Tasks and projects replace the rows, and a shareable dashboard gives stakeholders the status view the spreadsheet report tab used to hold. - Where it stops: Free covers project and task management and the board view, not the dashboard. - Plan: Shareable dashboard from Team; advanced reporting at Pinnacle - More: [Wrike](https://professionalstoolkit.com/tools/wrike) ### Teamwork.com — partly solves this Task lists with owners and dates plus a Gantt view on the free plan, so slipping dates are visible on a timeline instead of a red cell; time tracking sits in the same place. - Where it stops: Free Forever is capped at 5 users and 5 projects. - Plan: Scheduled and custom reports and advanced dashboards at Optimize - More: [Teamwork.com](https://professionalstoolkit.com/tools/teamwork) A common path is to keep the spreadsheet for the first plan and the budget lines, then move task tracking into the tool once three or more people update it. We compare the full field in our roundup of [project tracking tools](/articles/project-tracking-tools). ## FAQ **Is there a free project tracker template for Excel?** Yes: the layout in this guide is free to build in any recent Excel and takes under an hour. A tracker you build from a blank table is easier to keep clean than a downloaded one, because you choose the columns and the status values yourself. **How do I stop people from overwriting formulas in a project management tracker template in Excel?** Select the cells people should edit, open Format Cells, and on the Protection tab clear Locked. Then protect the sheet from the Review tab. Set the drop-downs first, because data validation cannot be changed while the sheet is protected. **How do I show project progress as a percentage in Excel?** Average the percent complete column with =AVERAGE(F2:F100), or divide done tasks by all tasks with COUNTIF and COUNTA. The first weights partial work; the second only counts finished tasks. **How do I add a timeline to an Excel project tracker?** Put dates across the top row to the right of the table and the roll-up block (for example from column M), select the grid under them, and add a conditional formatting rule such as =AND(M$1>=$C2,M$1<=$D2) with a fill color. Each task then shows as a bar from its start to its due date. ## The bottom line A good project tracking Excel template is small: one row per task, an owner, a due date, a status drop-down and a few formulas that flag what is late and roll it up. Build it as a table, set the drop-downs before you share it, and let conditional formatting do the watching. It will carry a small team a long way. Once updates depend on someone remembering, dates have to move together, or you need reports across projects, the spreadsheet becomes the work instead of the record of it. That is the moment to move tracking into a tool and keep the sheet for what it does best. ## Sources [1] Microsoft Support — https://support.microsoft.com/en-us/excel/get-started/create-a-drop-down-list (Oct 2026) [2] Microsoft Support — https://support.microsoft.com/en-us/excel/get-started/apply-data-validation-to-cells (Oct 2026) [3] Microsoft Support — https://support.microsoft.com/en-us/excel/use-conditional-formatting-to-highlight-information-in-excel (Oct 2026) [4] Google Docs Editors Help — https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop (Oct 2026)