A useful project tracker spreadsheet has one row per task, clear ownership and due dates, a consistent status, and a simple way to spot work that is late or blocked. In Excel for Microsoft 365, start with the sample layout below, turn the range into a table, and add a formula for days remaining so the team can maintain a current view without a separate project-management app.
Sample Project Tracker Spreadsheet
Use these columns as a practical starting point. The example contains five tasks for a small project; replace the names and dates with your own. Enter dates as Excel dates, not text, so sorting, filtering, and date calculations work correctly.
| Task ID | Task | Owner | Start date | Due date | Status | Priority | Complete | Days left | Notes |
|---|---|---|---|---|---|---|---|---|---|
| T-01 | Confirm scope | Maya | Nov 2, 2026 | Nov 4, 2026 | Done | High | 100% | 0 | Scope approved |
| T-02 | Draft content | Luis | Nov 3, 2026 | Nov 10, 2026 | Not started | Medium | 0% | 7 | Waiting for outline |
| T-03 | Build prototype | Ana | Nov 4, 2026 | Nov 12, 2026 | In progress | High | 30% | 9 | Review navigation |
| T-04 | Review draft | Maya | Nov 11, 2026 | Nov 13, 2026 | Not started | Medium | 0% | 10 | Depends on content |
| T-05 | Approve release | Luis | Nov 14, 2026 | Nov 16, 2026 | Not started | High | 0% | 13 | Final sign-off |
The days-left values use November 3, 2026, as the current date. They are illustrative: the formula recalculates against the actual current date whenever Excel recalculates. For a real tracker, include a project name or project ID if one workbook will hold tasks from several projects.
What Each Column Is For
Task ID gives each item a stable reference, which is helpful when someone discusses a row in a meeting or an update. Task describes a deliverable or action in specific language, such as Draft content, rather than a broad label such as Marketing. Owner identifies one accountable person; other contributors can be named in Notes if needed.
Start date and due date show the planned schedule. Status communicates the task’s current state, while Priority indicates relative urgency. Complete is a numeric percentage, formatted as a percentage, that helps show partial progress. Days left is calculated rather than typed manually. Notes can record a dependency, a decision, or a concise blocker, but should not become a long-running meeting transcript.
- Status: Agree on a short set of choices, such as Not started, In progress, Blocked, and Done.
- Priority: Use a small shared scale, such as High, Medium, and Low, and define what each level means to the team.
- Complete: Decide whether estimates are subjective or tied to measurable milestones. A percentage should not imply more precision than the work supports.
Set Up the Tracker in Excel
In Excel for Microsoft 365 on Windows, put the headers in row 1 and the first task in row 2. Select the range, choose Insert > Table, confirm that My table has headers is selected, and choose OK. A table adds filter buttons, expands when you add rows, and carries formatting and formulas into new rows more reliably than a plain range. Give it a descriptive name from the Table Design tab if you want to refer to it in formulas later.
Format the Start date and Due date columns as dates, and set Complete to Percentage. For the sample, enter 60% as a percentage value rather than typing 60 if the cell is formatted as a percentage; 60 entered in that format displays as 6000%. To make entries consistent, select the status cells and choose Data > Data Validation. Set Allow to List and provide the approved status choices as the source. A drop-down reduces spelling variations that can break counts and filters.
You can add visual cues with Home > Conditional Formatting. For example, apply a rule to highlight blocked tasks, or use a date rule to call attention to approaching due dates. Choose colors that remain readable and do not rely on color alone: the Status text should still make the meaning clear. On Excel for Mac, the relevant commands are also on the ribbon, though their placement can differ slightly by build. Excel for the web also supports tables and common formatting, but some advanced options may be arranged differently.
Useful Formulas and a Worked Example
With task status in F2:F6 and due dates in E2:E6, put the following formula in I2 and fill it down through I6. It shows zero for a completed task, leaves the result blank when no due date has been entered, and otherwise subtracts today’s date from the due date.
=IF(F2="Done",0,IF(E2="","",E2-TODAY()))
For the sample row T-02, the due date is November 10, 2026. On November 3, 2026, the formula returns 7, meaning seven calendar days remain. T-01 returns 0 because its status is Done, even though its due date is in the past. A negative result on an unfinished task means its due date has passed; that can be useful, but label the column clearly so readers understand it.
With the status values in F2:F6, use this formula in a summary cell to count completed tasks:
=COUNTIF(F2:F6,"Done")
The sample returns 1 because one of the five tasks is marked Done. If you add rows, extend the range or use the table’s structured references so the summary includes the added tasks. A count of completed tasks is not the same as overall project completion: tasks vary in size, and this count treats a one-hour task and a two-week task equally. If you need an overall percentage, define a weighting method based on meaningful effort or deliverables instead of assuming that a simple average represents progress.
Keep Updates Useful and Trustworthy
A tracker works only when people know who updates it and how often. Assign responsibility for maintaining the task list, and agree on an update rhythm that suits the project—for example, before a weekly review, or more often when deadlines are close. Owners should update status, progress, and blockers, while the project lead checks dependencies and dates. A spreadsheet does not automatically reveal that work has changed; it reflects the information people enter.
Make task names small enough to track. A row called Build website may hide several distinct pieces of work with different owners or deadlines. Split it into tasks such as Create page layout, Add product copy, and Test checkout when those pieces can progress independently. On the other hand, avoid making a row for every tiny action if the resulting list becomes hard to maintain. The right level is one where a person can report meaningful progress and the team can see what needs attention.
Use Notes for concise context, such as Waiting for legal review, and record important decisions in an agreed project location if the workbook is not meant to be the formal record. Include a last-updated date or a short update log if the team needs to know whether a view is current. If several people edit the workbook, store it in a shared location that supports collaborative editing and agree not to maintain competing copies by email.
Common Problems and Practical Fixes
- Dates sort strangely: A date may have been entered as text. Re-enter it as a valid date or convert the cell value, then check that the displayed format is consistent.
- Counts miss a task: The status may contain a typo or an extra space. A validation list helps ensure entries match the agreed label exactly.
- Days left looks wrong: Check that the due date is a real date, that the formula references the correct row, and that the status is not Done. Remember that TODAY counts calendar days, not working days.
- Percent complete exceeds expectations: Confirm cells contain percentages such as 30%, not whole numbers such as 30 formatted as a percentage.
- The sheet becomes unwieldy: Filter by owner, status, or priority, and archive completed tasks when the team no longer needs them in its active view. Keep a separate history if records matter.
Another common misconception is that a tracker is a project plan by itself. It can record tasks and expose dates or blockers, but it does not decide whether a deadline is realistic, resolve a dependency, or ensure an owner has capacity. Those decisions need discussion and, for complex schedules, may require a dedicated planning method or tool.
When a Spreadsheet Is Enough—and When It Is Not
A spreadsheet is often a reasonable choice for a small team with a manageable number of tasks, a straightforward workflow, and a need for flexible columns or quick summaries. It is easy to adapt and can be shared without asking every contributor to learn a specialized system. A single-sheet tracker is particularly useful when the purpose is visibility rather than detailed resource planning.
Consider a dedicated project-management tool when work depends on complex linked schedules, recurring workflows, automated reminders, permissions by role, audit history, workload views, or reporting across many projects. A spreadsheet can imitate some of these features, but extra formulas, manual updates, and copied versions create more opportunities for errors. The choice is not simply spreadsheet versus software: compare the ongoing effort, collaboration needs, data controls, and required reports. Tool prices and plan limits change, so check current vendor information before choosing a paid service.
Frequently Asked Questions
What should a project tracker spreadsheet include?
A useful basic tracker includes a task name, owner, start and due dates, status, priority, progress, and notes. Add an ID, dependency, or project field when the team needs to reference or sort work across a larger set of tasks.
How do I make a project tracker spreadsheet update automatically?
Formulas can calculate values such as days remaining, and Excel tables can extend formatting and formulas when rows are added. However, owners still need to update task status, progress, and dates; Excel cannot know that work has changed unless someone records it or connects an appropriate data source.
Can I use this tracker for multiple projects?
Yes, add a Project or Project ID column and use filters to show one project at a time. For many projects, separate summary views or workbooks may be easier to manage, but use a consistent structure so information can be compared reliably.
Should I use a Gantt chart instead?
A Gantt chart is useful when the team needs to see task durations, overlapping work, and schedule dependencies along a timeline. A task table is simpler for ownership and status updates. Some projects benefit from a tracker plus a separate timeline rather than forcing both purposes into one view.
How often should a project tracker be updated?
Set a cadence that matches the pace and risk of the work. Weekly updates may suit a stable project; work with short deadlines or frequent blockers may need updates several times a week. The important point is to make the expectation explicit and review overdue or blocked items promptly.
Related
- Retired Budget Spreadsheet: Plan Income and Expenses
- PowerPoint Present with Notes Visible? Presenter View
- Reseller Inventory Spreadsheet: Free Template and Setup
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Template for Quotation Comparison: Build OneIn Excel for Microsoft 365 on Windows, create supplier columns in B:D, enter each quote’s comparable costs in…
- Count Excel Cells by Color: Practical MethodsExcel has no built-in COUNTBYCOLOR function. For a quick count in Microsoft 365 for Windows, filter the column…
- Can You Shade Half a Cell in Excel? Options ExplainedExcel does not have a built-in cell format that fills exactly half of a cell with one color…
- Excel Remove Duplicates Greyed Out? Fixes That WorkIf Excel’s Remove Duplicates command is greyed out, first exit cell-editing mode, click a normal worksheet cell, and…
- Excel Scatter Plot: How to Change Dot Size and ScaleTo change dot size in an Excel scatter plot, select a marker, open Format Data Series, then choose…
- Google Sheets Dropdown Default Value ExplainedGoogle Sheets does not have a setting that automatically inserts a default choice into every empty cell with…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.