Project Tracker Excel: Examples, Setup, and Practical Tips

Yes—Excel can make a useful project tracker for tasks, owners, due dates, priorities, and progress. Start with one row per task, add a status dropdown, and use a formula or simple formatting to flag due dates; a small example and setup guide follow.

What an Excel project tracker is for

A project tracker is a shared view of the work needed to complete a project. It helps answer practical questions: What needs doing? Who owns it? When is it due? Is it blocked or finished? Excel is a good fit when the work is manageable in a worksheet, the team already uses spreadsheets, or people need to sort, filter, and summarize task information without adopting a dedicated project-management system.

A tracker is not automatically a full project plan. A task list can show ownership and dates, but it will not by itself explain every dependency, resource constraint, or decision. For a small product launch, for example, a spreadsheet could list drafting the announcement, reviewing it, and publishing it. The owner, due date, and status make the handoffs visible; the team still needs to agree on what “ready for review” means.

A practical project tracker example

Use one row per task and one column for each kind of information. A useful starter layout is:

Task ID: a short identifier, such as T-01, to make discussion and references easier.
Task: a specific action, such as “Approve launch email,” rather than a broad project name.
Owner: the person accountable for moving the task forward.
Start Date and Due Date: dates stored as Excel dates, not text that merely looks like a date.
Status: a consistent choice such as Not started, In progress, Blocked, or Complete.
Priority: a team-defined rating, such as High, Medium, or Low.
% Complete: an estimate from 0% to 100%, if the task benefits from progress measurement.
Notes: a short update, blocker, or link to the relevant document.

For a three-task example, the rows might be “Draft announcement” owned by Maya, “Review announcement” owned by Luis, and “Schedule announcement” owned by Maya. The review should not be marked Complete until it has actually been approved. Specific task names and an agreed definition of completion make a tracker more dependable than vague entries such as “Marketing work.”

How to set up the workbook

In Excel for Microsoft 365 on Windows, enter the column headings in row 1 and task information beneath them. Select the range and choose Insert > Table, then confirm that the table has headers. A table makes it easier to filter and sort records, and it expands as new task rows are added. On Mac, use Insert > Table as well; keyboard shortcuts can differ by keyboard and Excel settings, so the ribbon command is the clearest route.

Keep the task table on one worksheet and put summary figures on a separate dashboard sheet if the tracker grows. Freeze the header row using View > Freeze Panes > Freeze Top Row so column names remain visible while scrolling. Use short, clear headers and avoid merged cells inside the data range; merged cells can make sorting and filtering awkward.

To make Status consistent, select the cells below its heading and choose Data > Data Validation. Set Allow to List and enter the allowed values, separated by commas, in Source—for example, Not started,In progress,Blocked,Complete. This reduces inconsistent labels such as “In progress,” “Started,” and “Doing,” which otherwise complicate counts and filters. The Data Validation command is also available on Excel for Mac, though dialog details can vary slightly by release.

Formulas for dates and progress

A formula can calculate days remaining from a due date. Assume due dates are in E2:E100 and statuses are in F2:F100, with the first task on row 2. Enter this in I2 and copy it down; column I is the Days Left column:

=IF(OR(E2="",F2="Complete"),"",E2-TODAY())

The result is the number of calendar days between today and the due date: a positive value means days remain, zero means the due date is today, and a negative value means the date has passed. The formula leaves the cell blank if there is no due date or the task is complete. TODAY updates when Excel recalculates, so a displayed number can change on a later day. Format the due-date cells as dates and ensure they contain real date values.

For an overall progress estimate, assume percentage-complete values are in H2:H100. Put this formula in a dashboard cell:

=IFERROR(AVERAGE(H2:H100),0)

Format the result as a percentage. If the three entered task values are 0%, 50%, and 100%, the average is 50%. This treats every task equally, whether it takes an hour or a week, so it is an indicator rather than a weighted measure of project effort. If the team does not update percentages consistently, a count of completed tasks may be easier to interpret.

To count completed tasks, assume statuses are in F2:F100 and enter this formula in a summary cell:

=COUNTIF(F2:F100,"Complete")

If four cells in that range contain Complete, the result is 4. Keep the status spelling consistent with the dropdown values so the count reflects the intended tasks.

Make overdue work easy to spot

Conditional formatting can highlight late tasks without requiring someone to inspect every date. Select E2:E100, then choose Home > Conditional Formatting > New Rule and select the option to use a formula to determine which cells to format. With due dates in column E and statuses in F, use this rule formula:

=AND($E2<TODAY(),$E2<>"",$F2<>"Complete")

Choose a visible fill color and apply the rule to the selected range. The dollar signs keep the rule checking the date and status columns as it evaluates each row. The blank-date check prevents empty due-date cells being treated as overdue. On Excel for Mac, Conditional Formatting is also on the Home tab; dialog labels may differ by version.

Color should reinforce meaning, not replace it. Include the word Blocked or Complete in the Status column rather than relying on red or green alone. A color scale or data bars can show percentage complete, but avoid using too many competing colors: readers should be able to tell priority, status, and overdue warnings apart.

Build a useful summary without overcomplicating it

A dashboard can show a few indicators above or beside the task table: total tasks, completed tasks, blocked tasks, and overdue tasks. Filters on the table let a person focus on one owner, status, or priority without creating a separate copy of the task list. A separate copy can drift out of date when edits are made in only one place.

To count overdue tasks, assume task IDs are in A2:A100, due dates are in E2:E100, and statuses are in F2:F100. Put this formula in a dashboard cell:

=COUNTIFS(A2:A100,"<>",E2:E100,">0",E2:E100,"<"&TODAY(),F2:F100,"<>Complete")

This counts rows with a task ID, a nonblank date before today, and a status other than Complete. For instance, if two such tasks meet those conditions, the result is 2. The nonblank-date condition matters because an empty date should not be reported as overdue. Decide whether a task due today is still on time; this formula does not count it as overdue.

Choosing the right level of detail

Start with only the fields people will maintain. A small team may need just task, owner, due date, status, and notes. Add priority if the team uses it to decide what to do next. Add start dates, effort estimates, dependencies, or percentage complete only when those fields support a real decision. More columns do not necessarily make a project more controlled; neglected columns make the sheet less trustworthy.

Use a simple task list when work is mostly independent and readers need a quick status view. A Gantt-style schedule is more suitable when timing and task overlap matter: it presents tasks against a calendar timeline. Excel can be adapted to display dates across columns and use cell formatting to show task spans, but creating and maintaining dependencies takes more work than maintaining a basic list. If the project has many interdependent tasks or needs automatic scheduling, a project-management tool may be a better fit.

Common problems and ways to prevent them

Inconsistent status names: use a dropdown and agree what each status means. For example, define whether Blocked means work cannot continue or merely needs attention.
Unclear ownership: give each task one accountable owner, even if several people contribute. Shared responsibility can make follow-up uncertain.
Dates stored as text: use actual Excel dates and test sorting. Text dates may sort alphabetically or fail in date calculations.
Stale updates: agree who updates the tracker and when, such as during a weekly review. A formula cannot make old task information current.
Too much detail: break work into tasks that can be assigned and reviewed, but avoid turning every minor action into a separate row.
Conflicting copies: decide where the authoritative workbook lives and how collaborators should edit it. If several people use separate emailed copies, changes can be lost or duplicated.

Excel supports collaboration when a workbook is stored in a supported cloud location such as OneDrive or SharePoint and shared appropriately, but access depends on the organization’s settings and account permissions. Agree on editing practices and protect sensitive information. Do not treat a workbook as a secure place for passwords or confidential details simply because it is shared with a small group.

Frequently Asked Questions

Does Excel have a project tracker template?
Excel may offer templates through its start screen or File > New, depending on the installed version and available online templates. You can also build a basic tracker with a table, task fields, and status validation. Template availability and names can change, so check the templates shown in your own Excel.

How do I make a project tracker in Excel?
Create headings for tasks, owners, dates, status, and any essential notes; convert the range to a table with Insert > Table; and use Data > Data Validation to create a status list. Add formulas or conditional formatting only for information the team needs to see quickly.

Can Excel automatically highlight overdue tasks?
Yes. Apply a conditional-formatting rule to the due-date range that checks whether the date is before TODAY, the date is not blank, and the status is not Complete. The worksheet must recalculate for TODAY to reflect the current date.

Can multiple people update an Excel project tracker?
Yes, if the workbook is shared from a supported cloud location and users have suitable access. Coauthoring availability can depend on the file format, storage location, and Microsoft 365 or organizational settings. Agree on one shared workbook rather than circulating disconnected copies.

When should I use project software instead of Excel?
Consider dedicated project software when the work needs complex dependencies, automatic schedule changes, workload planning, or integrated communication that the spreadsheet does not provide well. For a modest task list with straightforward dates and owners, Excel may remain simpler to maintain.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.