A Simple Project Tracker Template for Excel

Most project trackers are accurate for about two weeks. Then a few rows go stale, someone stops trusting the dates, and the real status moves back into chat threads and meetings. The fix is rarely a fancier template. It's a smaller one: one row per task, one owner per row, one status from a fixed list, and a weekly habit of updating it.

Direct answer. A project tracker template is a spreadsheet with one row per task and ten columns: task ID, task, owner, status, priority, start date, due date, percent complete, depends on, and notes. Status comes from a fixed dropdown (Not started, In progress, Blocked, Done), and a second tab logs risks and decisions.

The project tracker template: ten columns

Here is the full column set. Every column has one job, and the formats are chosen so the sheet can be sorted and filtered without cleanup.

Column	What goes in it	Format
Task ID	Short reference like T-01, used for dependencies	Text
Task	One deliverable, written as a verb + object	Text
Owner	The one person accountable for the row	Text (or dropdown of team names)
Status	Where the task stands today	Dropdown: Not started / In progress / Blocked / Done
Priority	How much it matters to the deadline	Dropdown: High / Medium / Low
Start date	When work begins	Date
Due date	When it has to be finished	Date
% complete	Owner's honest estimate	Percent (0%, 25%, 50%, 75%, 100%)
Depends on	Task ID that has to finish first	Text (e.g. T-03)
Notes	Blockers, links, the latest decision	Text

Two choices in that table do most of the work. Status is a dropdown, never free text, because "almost done", "WIP" and "90%" can't be filtered. And Owner holds one name. Shared rows ("Sam / Priya") are the rows nobody updates.

Copy the template as CSV

Paste this into cell A1 of Excel, Google Sheets or Numbers, then use Data > Split text to columns (Sheets) or Text to Columns (Excel) if it lands in a single column. The five sample rows show a small website relaunch; swap in your own tasks.

Task ID,Task,Owner,Status,Priority,Start date,Due date,% complete,Depends on,Notes
T-01,Write homepage copy,Priya,Done,High,2026-10-05,2026-10-09,100%,,Approved by founder on Oct 9
T-02,Design homepage layout,Sam,In progress,High,2026-10-10,2026-10-17,50%,T-01,Two hero options in review
T-03,Set up product page template,Sam,Not started,Medium,2026-10-18,2026-10-24,0%,T-02,
T-04,Migrate blog posts,Alex,Blocked,Medium,2026-10-12,2026-10-21,25%,,Waiting on CMS export from old host
T-05,QA on mobile and desktop,Priya,Not started,High,2026-10-25,2026-10-28,0%,T-03,Use the device list from last launch

Build the formatted version with a prompt

A pasted CSV is plain text. To get the colored status labels, real date and percent formats and a second tab in one step, paste this prompt into the AI spreadsheet generator:

Create a project tracker spreadsheet with two sheets. Sheet 1 "Tasks" has these columns: Task ID (text), Task (text, wide), Owner (text), Status (dropdown: Not started gray, In progress blue, Blocked red, Done green), Priority (dropdown: High red, Medium amber, Low gray), Start date (date), Due date (date), % complete (percent), Depends on (text), Notes (text, wide). Bold header row, sized columns, and 6 sample rows for a website relaunch. Sheet 2 "Risks & decisions" has: Date (date), Type (dropdown: Risk orange, Decision purple), Description (text, wide), Owner (text), Impact (dropdown: High / Medium / Low), Next step (text), Closed (checkbox). Add 3 sample rows.

Playyy builds both tabs in the same file with the dropdowns, colors and formats in place. From there, edit by chat ("add a Project column at the front", "move Priority next to Status") or ask questions about the data, such as "which tasks are blocked and who owns them?", and get an answer while the sheet stays as it is. Export to Excel (.xlsx) or CSV when the team works in another app, and sort or filter rows right in the editor.

How to set up the tracker in Excel or Google Sheets

If you're building it by hand, these six steps take about fifteen minutes.

1. Start from the plan, not a blank sheet

A tracker lists the work a plan already agreed on. If scope, deliverables and the deadline aren't written down yet, start with a project proposal template and pull each deliverable into the tracker as one or more rows. Trackers that start from a brainstorm tend to mix goals, ideas and tasks in the same column.

2. Break work into tasks of one to five days

A row like "Build website" sits at 40% for a month and tells nobody anything. Split it until each task fits inside a week and has a visible output: a draft, a design file, a merged change. Short tasks make % complete honest, because a task either moved this week or it didn't.

3. Add the dropdowns

In Excel, select the Status column, then go to Data > Data Validation > List and type the four values, as described in Microsoft's guide to creating a drop-down list. Set the error alert style to Stop so off-list values get rejected. Repeat for Priority.

In Google Sheets, select the column and choose Insert > Dropdown. Sheets lets you give each dropdown value its own color, per Google's help page on in-cell dropdown lists, which turns the Status column into a quick visual scan: red for Blocked, green for Done.

4. Format dates and percent

Format Start date and Due date as dates and % complete as a percent. Sorting by Due date only works when every cell is a real date, not text like "next Fri".

5. Flag overdue tasks

A helper formula catches rows that slipped. In Excel or Google Sheets, put this in a column next to Due date:

=IF(AND(G2<TODAY(), D2<>"Done"), "Overdue", "")

Pair it with conditional formatting that turns the row light red when the flag says Overdue. A count of blocked tasks for the top of the sheet is one more formula: =COUNTIF(D:D,"Blocked").

6. Freeze the header and filter

Freeze row 1 so the headers stay visible, then turn on filters. The most used filters are Owner (each person's list) and Status (everything not Done).

Keep the tracker accurate: status rules

Templates are easy. Keeping one true for three months is the hard part, and it comes down to a few rules the whole team agrees on before the first update.

• One weekly update window. Pick a time, say Friday before noon, when every owner updates their own rows. The review meeting then reads the sheet instead of rebuilding it out loud.
• Blocked always has a note. A Blocked status with an empty Notes cell is just a red label. The note says what's blocking and who can unblock it: "Waiting on CMS export from old host" gives someone a job.
• Done means delivered. A task moves to Done when its output exists and has been handed over, not when the work feels finished. Partially done work stays In progress with an honest percent.
• Dates move in the open. When a due date changes, write the old date in Notes ("was Oct 17"). Silent date changes are how a tracker loses trust.
• Done rows stay. Filter them out of view instead of deleting them. They're the record of what shipped, and they make the next project's estimates better.

The second tab: risks and decisions

Risks and decisions don't belong in task rows. "Vendor may raise prices in Q1" isn't a task, and "We chose Shopify over WooCommerce" has no due date. Give them their own tab with Date, Type (Risk or Decision), Description, Owner, Impact, Next step and a Closed checkbox. When someone asks why the scope changed in week four, the answer sits in one row with a date on it.

For a fuller treatment of risks with likelihood and impact scoring, a dedicated risk register is the next step. For most small projects, the tab is enough.

Variations of the template

The same ten columns adapt to three common setups.

Single project

Use the template as is. One tab for tasks, one for risks and decisions. This fits a launch, a website rebuild, a client engagement or an event with up to a few dozen tasks.

Multiple projects in one spreadsheet

Add a Project column as column A, ideally a dropdown so names stay consistent. Keep the same status and priority values across every project so filters and counts work everywhere. A weekly review then becomes: filter Status to Blocked across all projects first, then go project by project.

Once a project has its own team and its own meeting, give it a separate tab. Mixing three teams' rows in one list makes every owner scroll past work that isn't theirs.

Action item tracker for meetings

An action item tracker is the lightest version: the tasks that come out of meetings. Cut the columns to Meeting date, Action item, Owner, Due date, Done (checkbox) and Notes. Add rows during the meeting, not after it, and open the next meeting by reviewing every unchecked item from the last one. That opening review is what keeps action items from disappearing.

A personal task tracker template is the same idea for one person: task, status, due date and a Done checkbox. Skip Owner and Depends on entirely.

Common project tracker mistakes

• Too many columns. Budget, hours logged, phase, category, sub-owner, approver. Each extra column is one more cell to update every week, and the empty ones make the sheet look abandoned. Start with ten; add a column only when someone asks for that information twice.
• Tasks that are really goals. "Improve onboarding" can't be Done. Rewrite it as the next concrete deliverable.
• Status as free text. Once "in prog", "WIP" and "started" coexist, the Status filter stops working.
• Tracking in one place, discussing in another. If decisions get made in chat and never land in the tracker, the tracker is always a week behind. Paste the decision into the Risks & decisions tab the same day.
• Mixing process with tasks. Repeating steps like "publish blog post" belong in a checklist or an SOP template, with a single row in the tracker pointing to it.

From tracker to status update

The tracker answers "where is everything" for the people doing the work. Stakeholders want three lines instead: what shipped, what's blocked, what's next. Filter Done for the week, Blocked, and anything due in the next seven days, and the update writes itself.

To turn those three filtered views into a formatted weekly update, drop the rows into the AI report generator and ask for a one-page status report with sections for shipped, blocked and coming up.

Keep Reading

• A Project Proposal Template With a Full Example — The plan that comes before the tracker: scope, deliverables, timeline and budget.
• An SOP Template With a Filled-In Example — For the repeating work that shouldn't live as tasks in a tracker.
• Executive Summary Examples — How to open a status report or proposal so a busy reader gets the point first.
• Pitch Deck Examples — When the project update turns into a funding or board conversation.