Skip to content
Switching Tools

Excel Project Management: How to Set Up a Project Tracker and Where Excel Breaks

How to run project management in Excel: the columns, formulas and a worked tracker example, plus the signs that Excel is breaking and what to do next.

By Ryan Kramer, founder of Wisegrid. Last updated November 2026.

Excel project management means planning and tracking a project in an Excel workbook: a task list with owners, dates and status, plus formulas that flag late work and roll up progress. For one project and a small team it works well and costs nothing extra. It strains when many people edit at once or when you need one view across many projects.

Most teams already know Excel, so it is the natural first project tool. This guide shows the columns to use, the formulas that do the work, a worked tracker with numbers you can check, and the honest signs that it is time to move the same grid to something shared.

Key takeaways

– Start with six columns. Task, owner, start, due, percent complete and status cover most projects.

– Let formulas set the status. An overdue flag based on today’s date beats someone remembering to change a cell.

– Weight progress by effort. A simple average of percent complete overstates or understates progress.

– Excel’s grid is big, its sharing is the limit. A sheet holds 1,048,576 rows, but co-authoring needs OneDrive or SharePoint and the right versions.

– Move when you copy numbers between files. That is the point where errors start.

Can you use Excel for project management?

Yes. Excel can hold a full project plan: a task list, a schedule, a budget and a simple Gantt chart. It is not a dedicated project management app, so it has no built-in task assignments, notifications or permissions by row. You build those yourself with columns, formulas and conditional formatting.

Excel is a good fit when one person owns the file, the project has fewer than a few hundred tasks and updates happen weekly. Many small contractors and engineering teams run real projects this way. Our guide to the Excel Gantt chart shows how to add a timeline to the same sheet.

How to set up a project tracker in Excel

  1. Make a table. Select your headers and press Ctrl+T so formulas and formatting fill down as you add rows.
  2. Add the core columns: Task, Owner, Start, Due, % Complete and Status.
  3. Use data validation for Owner and Status. Dropdowns stop “Priya”, “priya” and “P. Shah” from becoming three people.
  4. Add a Days left formula: =[@Due]-TODAY(). Negative numbers mean late.
  5. Set Status with a formula: =IF([@[% Complete]]=1,”Done”,IF([@Due]
  6. Add conditional formatting so Overdue turns red and Done turns grey.
  7. Add an Hours column to weight progress, then a summary cell for overall percent complete.
  8. Save it where everyone can reach it, such as OneDrive or SharePoint, so there is one copy, not five.

If you would rather not build it from scratch, the free project tracker Excel template has these columns, the overdue flag and a status rollup already set up.

Worked example: a design-phase tracker

Here is a tracker for the design phase of a clinic renovation, as of Monday, November 9. Status comes from the formula above, not from the owner. The bold row is the one the project manager should chase today.

Task Owner Due Complete Status
Site survey Dana Oct 31 100% Done
Schematic design Priya Nov 14 70% Open
Code review Marcus Nov 7 40% Overdue
Cost estimate Lee Nov 21 0% Open
Client review Priya Nov 26 0% Open

How far along is the phase? A quick average of the percent complete column says 42%. That treats a 10-hour client review the same as a 120-hour design task. Weighting by planned hours gives a truer answer.

Task Hours Complete Earned hours
Site survey 40 100% 40
Schematic design 120 70% 84
Code review 30 40% 12
Cost estimate 50 0% 0
Client review 10 0% 0
Total 250 54.4% 136

What this tells you: the phase is 54.4% complete by effort, not 42%. The formula is =SUMPRODUCT(Hours,Complete)/SUM(Hours). The code review is two days late and 40% done, and the cost estimate cannot start until it finishes, so that one overdue row puts the Nov 21 estimate at risk. That is the sentence to put in the weekly project status report.

Where Excel works and where it breaks

Excel’s limits are rarely about size. Microsoft lists a worksheet limit of 1,048,576 rows by 16,384 columns, far more than any project tracker needs. The limits are about people and files.

Need Excel works when Strain shows when
Editing One owner updates it Several people edit at once
Sharing Everyone has Microsoft 365 Clients or subs lack access
Many projects One file per project You copy totals into a summary
Reminders Someone checks dates Tasks slip with no alert
History Changes are rare You need who changed what

Real-time co-authoring does exist in Excel. Microsoft’s requirements are a Microsoft 365 subscription, a supported version of Excel and a file saved on OneDrive, OneDrive for Business or SharePoint Online in .xlsx, .xlsm or .xlsb format. SharePoint sites hosted on your own servers do not support it. If one person opens the file in an older version, others can get a “file is locked” error. When those conditions are not met, edits made at the same time can be lost, the problem covered in why collaborative spreadsheet edits disappear.

Common Excel project management mistakes

  • Typing status by hand. Status that depends on someone remembering is always a week behind.
  • Emailing copies. “Tracker_v7_final_PS.xlsx” means nobody knows which file is right.
  • Merged cells. They break sorting, filtering and formulas. Use one value per cell.
  • No owner column. A task without a name does not get done.
  • Averaging percent complete. Weight by hours or cost, as in the example.
  • One giant workbook for everything. Keep risks in a risk register or RAID log tab, and scope in a project scope statement, not in task notes.

Moving the same grid to a shared Wisegrid sheet

When the strain shows, the usual advice is to switch to a dedicated project app with boards and cards. Many teams resist, because the grid is how they think. Wisegrid, a spreadsheet-native work management app, keeps the grid and changes how it is shared.

You import the .xlsx you already use, and formulas come across. Owner and Status become dropdown columns. A date-triggered automation can email the owner the day a task goes overdue. A portfolio sheet reads each project’s totals with cross-sheet references, so the status report stops being copy and paste. Viewers, such as clients or subcontractors, are free. To be fair about limits: a Wisegrid sheet holds up to 1,000,000 cells and 40,000 rows according to the pricing page, smaller than an Excel worksheet, which matters for large data sets but not for a project tracker. If your team pays for Smartsheet today, our Smartsheet alternatives guide compares the options, and the migration page explains the import.

FAQ

Is Excel a project management software?

No. Excel is a spreadsheet that can be used for project management. It has no built-in task assignments, notifications or project views. You can build a capable tracker with tables, formulas and conditional formatting, and many small teams do. Dedicated tools add sharing, reminders and history on top.

Does Excel have a project management template?

Yes. Microsoft offers free project tracker and Gantt templates inside Excel and on its website. Wisegrid also has a free project tracker Excel template with an overdue flag, a weighted percent complete and a multi-project tab. Templates save setup time, but you still need to keep them updated.

How do I track multiple projects in Excel?

Use one row per task with a Project column, or one tab per project and a summary tab that pulls totals with formulas such as SUMIFS. The second approach is easier to read but breaks when tabs are renamed or rows move. If several people manage different projects, a shared multi-project sheet is usually easier to keep accurate.

What is the best way to show progress in Excel?

Use percent complete weighted by planned hours or cost, not a simple average. Add a Days left column and conditional formatting for overdue tasks. For a visual, a simple Gantt chart built with a stacked bar chart or conditional formatting shows the plan against today’s date.

Sources


Keep your Excel tracker, make it shared

Import the workbook you use today and keep the same columns and formulas in Wisegrid. Start with the project tracker Excel template, add costs with the project budget template, and see the trade-offs in Wisegrid vs Smartsheet.

Start free → · Migrate from Excel → · Status report generator →


About the author Ryan Kramer is the founder of Wisegrid, a higher-capacity work management grid built around a 1,000,000-cell-per-sheet limit, date-triggered automations with run history, and cross-sheet reporting. He writes about the project management documents teams actually keep updated. More from Ryan →