{"id":209,"date":"2026-11-05T07:19:53","date_gmt":"2026-11-05T07:19:53","guid":{"rendered":"https:\/\/wisegrid.co\/blog\/?p=209"},"modified":"2026-11-05T07:19:53","modified_gmt":"2026-11-05T07:19:53","slug":"excel-project-management","status":"publish","type":"post","link":"https:\/\/wisegrid.co\/blog\/excel-project-management\/","title":{"rendered":"Excel Project Management: How to Set Up a Project Tracker and Where Excel Breaks"},"content":{"rendered":"<p><em>By <a href=\"\/blog\/author\/ryan-kramer\/\">Ryan Kramer<\/a>, founder of Wisegrid. Last updated November 2026.<\/em><\/p>\n<p><strong>Excel project management<\/strong> 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.<\/p>\n<p>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.<\/p>\n<blockquote>\n<p style=\"margin:0\"><strong>Key takeaways<\/strong><\/p>\n<p style=\"margin:0.55em 0 0\">\u2013 <strong>Start with six columns.<\/strong> Task, owner, start, due, percent complete and status cover most projects.<\/p>\n<p style=\"margin:0.55em 0 0\">\u2013 <strong>Let formulas set the status.<\/strong> An overdue flag based on today\u2019s date beats someone remembering to change a cell.<\/p>\n<p style=\"margin:0.55em 0 0\">\u2013 <strong>Weight progress by effort.<\/strong> A simple average of percent complete overstates or understates progress.<\/p>\n<p style=\"margin:0.55em 0 0\">\u2013 <strong>Excel\u2019s grid is big, its sharing is the limit.<\/strong> A sheet holds 1,048,576 rows, but co-authoring needs OneDrive or SharePoint and the right versions.<\/p>\n<p style=\"margin:0.55em 0 0\">\u2013 <strong>Move when you copy numbers between files.<\/strong> That is the point where errors start.<\/p>\n<\/blockquote>\n<nav class=\"wg-toc\" aria-label=\"Table of contents\">\n<div class=\"wg-toc-eyebrow\"><span class=\"lp-dot\" aria-hidden=\"true\"><\/span> On this page<\/div>\n<ul>\n<li><a href=\"#can-you-use-excel\">Can you use Excel for project management?<\/a><\/li>\n<li><a href=\"#how-to-set-up\">How to set up a project tracker in Excel<\/a><\/li>\n<li><a href=\"#worked-example\">Worked example: a design-phase tracker<\/a><\/li>\n<li><a href=\"#where-excel-breaks\">Where Excel works and where it breaks<\/a><\/li>\n<li><a href=\"#common-mistakes\">Common Excel project management mistakes<\/a><\/li>\n<li><a href=\"#moving-to-wisegrid\">Moving the same grid to a shared Wisegrid sheet<\/a><\/li>\n<li><a href=\"#faq\">FAQ<\/a><\/li>\n<\/ul>\n<\/nav>\n<h2 id=\"can-you-use-excel\">Can you use Excel for project management?<\/h2>\n<p>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.<\/p>\n<p>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 <a href=\"\/blog\/excel-gantt-chart\/\">Excel Gantt chart<\/a> shows how to add a timeline to the same sheet.<\/p>\n<h2 id=\"how-to-set-up\">How to set up a project tracker in Excel<\/h2>\n<ol>\n<li><strong>Make a table.<\/strong> Select your headers and press Ctrl+T so formulas and formatting fill down as you add rows.<\/li>\n<li><strong>Add the core columns:<\/strong> Task, Owner, Start, Due, % Complete and Status.<\/li>\n<li><strong>Use data validation for Owner and Status.<\/strong> Dropdowns stop \u201cPriya\u201d, \u201cpriya\u201d and \u201cP. Shah\u201d from becoming three people.<\/li>\n<li><strong>Add a Days left formula:<\/strong> =[@Due]-TODAY(). Negative numbers mean late.<\/li>\n<li><strong>Set Status with a formula:<\/strong> =IF([@[% Complete]]=1,\u201dDone\u201d,IF([@Due]<today>\n<li><strong>Add conditional formatting<\/strong> so Overdue turns red and Done turns grey.<\/li>\n<li><strong>Add an Hours column<\/strong> to weight progress, then a summary cell for overall percent complete.<\/li>\n<li><strong>Save it where everyone can reach it<\/strong>, such as OneDrive or SharePoint, so there is one copy, not five.<\/li>\n<\/today><\/li><\/ol>\n<p>If you would rather not build it from scratch, the free <a href=\"\/templates\/project-tracker-excel-template\/\">project tracker Excel template<\/a> has these columns, the overdue flag and a status rollup already set up.<\/p>\n<h2 id=\"worked-example\">Worked example: a design-phase tracker<\/h2>\n<p>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.<\/p>\n<div class=\"wg-table-wrap\">\n<div class=\"wg-table-wrap\"><table>\n<thead>\n<tr>\n<th style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Task<\/th>\n<th style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Owner<\/th>\n<th style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Due<\/th>\n<th style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\">Complete<\/th>\n<th style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Status<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Site\u00a0survey<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Dana<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Oct\u00a031<\/td>\n<td style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\">100%<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Done<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Schematic\u00a0design<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Priya<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Nov\u00a014<\/td>\n<td style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\">70%<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Open<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Code\u00a0review<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Marcus<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Nov\u00a07<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>40%<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Overdue<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Cost\u00a0estimate<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Lee<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Nov\u00a021<\/td>\n<td style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\">0%<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Open<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\"><strong>Client\u00a0review<\/strong><\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Priya<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Nov\u00a026<\/td>\n<td style=\"text-align:right;white-space:nowrap;padding:11px 14px;font-size:14px\">0%<\/td>\n<td style=\"white-space:nowrap;padding:11px 14px;font-size:14px\">Open<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n<p>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.<\/p>\n<div class=\"wg-table-wrap\">\n<div class=\"wg-table-wrap\"><table>\n<thead>\n<tr>\n<th style=\"white-space:nowrap\">Task<\/th>\n<th style=\"text-align:right;white-space:nowrap\">Hours<\/th>\n<th style=\"text-align:right;white-space:nowrap\">Complete<\/th>\n<th style=\"text-align:right;white-space:nowrap\">Earned\u00a0hours<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Site\u00a0survey<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\">40<\/td>\n<td style=\"text-align:right;white-space:nowrap\">100%<\/td>\n<td style=\"text-align:right;white-space:nowrap\">40<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Schematic\u00a0design<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\">120<\/td>\n<td style=\"text-align:right;white-space:nowrap\">70%<\/td>\n<td style=\"text-align:right;white-space:nowrap\">84<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Code\u00a0review<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\">30<\/td>\n<td style=\"text-align:right;white-space:nowrap\">40%<\/td>\n<td style=\"text-align:right;white-space:nowrap\">12<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Cost\u00a0estimate<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\">50<\/td>\n<td style=\"text-align:right;white-space:nowrap\">0%<\/td>\n<td style=\"text-align:right;white-space:nowrap\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Client\u00a0review<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\">10<\/td>\n<td style=\"text-align:right;white-space:nowrap\">0%<\/td>\n<td style=\"text-align:right;white-space:nowrap\">0<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Total<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\"><strong>250<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\"><strong>54.4%<\/strong><\/td>\n<td style=\"text-align:right;white-space:nowrap\"><strong>136<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n<p><strong>What this tells you:<\/strong> the phase is <strong>54.4% complete by effort<\/strong>, 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 <a href=\"\/blog\/project-status-report-template\/\">project status report<\/a>.<\/p>\n<h2 id=\"where-excel-breaks\">Where Excel works and where it breaks<\/h2>\n<p>Excel\u2019s 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.<\/p>\n<div class=\"wg-table-wrap\">\n<div class=\"wg-table-wrap\"><table>\n<thead>\n<tr>\n<th style=\"white-space:nowrap\">Need<\/th>\n<th style=\"white-space:nowrap\">Excel\u00a0works\u00a0when<\/th>\n<th style=\"white-space:nowrap\">Strain\u00a0shows\u00a0when<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Editing<\/strong><\/td>\n<td>One owner updates it<\/td>\n<td>Several people edit at once<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Sharing<\/strong><\/td>\n<td>Everyone has Microsoft 365<\/td>\n<td>Clients or subs lack access<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Many\u00a0projects<\/strong><\/td>\n<td>One file per project<\/td>\n<td>You copy totals into a summary<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>Reminders<\/strong><\/td>\n<td>Someone checks dates<\/td>\n<td>Tasks slip with no alert<\/td>\n<\/tr>\n<tr>\n<td style=\"white-space:nowrap\"><strong>History<\/strong><\/td>\n<td>Changes are rare<\/td>\n<td>You need who changed what<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/div>\n<\/div>\n<p>Real-time co-authoring does exist in Excel. Microsoft\u2019s 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 \u201cfile is locked\u201d error. When those conditions are not met, edits made at the same time can be lost, the problem covered in <a href=\"\/blog\/collaborative-spreadsheet-edits-disappear\/\">why collaborative spreadsheet edits disappear<\/a>.<\/p>\n<h2 id=\"common-mistakes\">Common Excel project management mistakes<\/h2>\n<ul>\n<li><strong>Typing status by hand.<\/strong> Status that depends on someone remembering is always a week behind.<\/li>\n<li><strong>Emailing copies.<\/strong> \u201cTracker_v7_final_PS.xlsx\u201d means nobody knows which file is right.<\/li>\n<li><strong>Merged cells.<\/strong> They break sorting, filtering and formulas. Use one value per cell.<\/li>\n<li><strong>No owner column.<\/strong> A task without a name does not get done.<\/li>\n<li><strong>Averaging percent complete.<\/strong> Weight by hours or cost, as in the example.<\/li>\n<li><strong>One giant workbook for everything.<\/strong> Keep risks in a <a href=\"\/blog\/risk-register\/\">risk register<\/a> or <a href=\"\/blog\/raid-log\/\">RAID log<\/a> tab, and scope in a <a href=\"\/blog\/project-scope-statement\/\">project scope statement<\/a>, not in task notes.<\/li>\n<\/ul>\n<h2 id=\"moving-to-wisegrid\">Moving the same grid to a shared Wisegrid sheet<\/h2>\n<p>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.<\/p>\n<p>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\u2019s 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 <a href=\"\/pricing\/\">pricing page<\/a>, 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 <a href=\"\/blog\/best-smartsheet-alternatives\/\">Smartsheet alternatives<\/a> guide compares the options, and the <a href=\"\/migrate\/\">migration page<\/a> explains the import.<\/p>\n<h2 id=\"faq\">FAQ<\/h2>\n<h3 id=\"is-excel-a-project-management-software\">Is Excel a project management software?<\/h3>\n<p>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.<\/p>\n<h3 id=\"does-excel-have-a-project-management-template\">Does Excel have a project management template?<\/h3>\n<p>Yes. Microsoft offers free project tracker and Gantt templates inside Excel and on its website. Wisegrid also has a free <a href=\"\/templates\/project-tracker-excel-template\/\">project tracker Excel template<\/a> 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.<\/p>\n<h3 id=\"how-do-i-track-multiple-projects-in-excel\">How do I track multiple projects in Excel?<\/h3>\n<p>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.<\/p>\n<h3 id=\"what-is-the-best-way-to-show-progress-in-excel\">What is the best way to show progress in Excel?<\/h3>\n<p>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\u2019s date.<\/p>\n<h2 id=\"sources\">Sources<\/h2>\n<ul>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/excel-specifications-and-limits\" target=\"_blank\" rel=\"noopener\">Microsoft Support: Excel specifications and limits<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/excel\/get-started\/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring\" target=\"_blank\" rel=\"noopener\">Microsoft Support: Collaborate on Excel workbooks at the same time with co-authoring<\/a><\/li>\n<li><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/best-practices-for-coauthoring-in-excel-7564b417-977b-48f1-aa31-98a95bad4dc7\" target=\"_blank\" rel=\"noopener\">Microsoft Support: Best practices for coauthoring in Excel<\/a><\/li>\n<\/ul>\n<hr>\n<h3 id=\"keep-your-excel-tracker-make-it-shared\">Keep your Excel tracker, make it shared<\/h3>\n<p>Import the workbook you use today and keep the same columns and formulas in Wisegrid. Start with the <a href=\"\/templates\/project-tracker-excel-template\/\">project tracker Excel template<\/a>, add costs with the <a href=\"\/templates\/project-budget-template\/\">project budget template<\/a>, and see the trade-offs in <a href=\"\/blog\/wisegrid-vs-smartsheet\/\">Wisegrid vs Smartsheet<\/a>.<\/p>\n<p><strong><a href=\"\/signup\/\">Start free \u2192<\/a><\/strong> \u00b7 <a href=\"\/migrate\/\">Migrate from Excel \u2192<\/a> \u00b7 <a href=\"\/free-tools\/status-report-generator\/\">Status report generator \u2192<\/a><\/p>\n<hr>\n<blockquote>\n<p><strong>About the author<\/strong> <strong><a href=\"\/blog\/author\/ryan-kramer\/\">Ryan Kramer<\/a><\/strong> 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. <a href=\"\/blog\/author\/ryan-kramer\/\">More from Ryan \u2192<\/a><\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[43],"class_list":["post-209","post","type-post","status-publish","format-standard","hentry","category-switching-tools","tag-excel"],"_links":{"self":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/209","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/comments?post=209"}],"version-history":[{"count":1,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/209\/revisions"}],"predecessor-version":[{"id":210,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/posts\/209\/revisions\/210"}],"wp:attachment":[{"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/media?parent=209"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/categories?post=209"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wisegrid.co\/blog\/wp-json\/wp\/v2\/tags?post=209"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}