{"id":12958,"date":"2026-09-19T15:06:06","date_gmt":"2026-09-19T15:06:06","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12958"},"modified":"2026-11-09T09:55:41","modified_gmt":"2026-11-09T09:55:41","slug":"project-tracker-gantt-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/de\/product\/project-tracker-gantt-spreadsheet\/","title":{"rendered":"Project Tracker with Gantt Chart (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 One task list, every project<\/span><\/p>\n<h2 id=\"a-project-tracker-spreadsheet-with-a-gantt-chart-that-draws-itself\">A project tracker spreadsheet with a Gantt chart that draws itself<\/h2>\n<p>The Project Tracker with Gantt is for anyone running several projects at once, a small team, an agency or a busy freelancer, who wants a Gantt chart without project management software. Put your people on Settings and your projects on Projects: a name and a lead is enough.<\/p>\n<h3>The only tab you type into<\/h3>\n<p>Every task is a row on Tasks: project, owner, start, end, % done, status, the task it depends on and whether it is a milestone. Health fills itself in: Done, Overdue when the end date has passed, Late start when it should have started and is still at 0%, or On track. A task that starts before the one it depends on has ended is flagged in the Check column, so a slipped date shows you what it knocks on.<\/p>\n<h3>What it draws from that<\/h3>\n<ul>\n<li><strong>Gantt<\/strong>: bars with % done, late work in red, milestones and today, for one project or all of them, by day or by week.<\/li>\n<li><strong>Projects<\/strong>: each project&#8217;s dates, progress, overdue count, status and next milestone. Progress is weighted by each task&#8217;s length, so a month of work counts for more than a one-day task.<\/li>\n<li><strong>Dashboard<\/strong>: open, overdue and due this week, % complete, milestones in the next 30 days, and who has what.<\/li>\n<\/ul>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n<p>Planning on a tablet or on paper instead? <a href=\"\/find-your-planner\/\">Find your planner in 60 seconds<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Type your tasks once and the Gantt chart draws itself: bars shaded by % done, late work in red, milestones and a today line, for one project or all of them.<\/p>\n","protected":false},"featured_media":16128,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Gantt Chart Project Tracker for Google Sheets and Excel | Templacity","rank_math_description":"A project tracker spreadsheet with a self-drawing Gantt chart for Google Sheets and Excel: tasks, owners, dependencies, milestones and a dashboard.","rank_math_seo_score":"13","_templacity_copy_live":"1","_templacity_faq":[{"q":"Do I have to draw the Gantt chart?","a":"No. It is drawn from the start and end dates on Tasks. Pick a project or all of them, and days or weeks."},{"q":"Does it handle task dependencies?","a":"Yes. Point Depends on at another task's ID. If a task starts before the one it depends on has ended, the Check column flags it."},{"q":"How is project progress calculated?","a":"Weighted by each task's length, so a month-long task counts for more than a one-day task."},{"q":"Can I track more than one project?","a":"Yes. Every task belongs to a project on the Projects tab, and the Dashboard and Gantt show one or all of them."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12958","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product\/12958","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/comments?post=12958"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media\/16128"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/media?parent=12958"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/niche?post=12958"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/template_type?post=12958"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/templacity_topic?post=12958"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_brand?post=12958"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_cat?post=12958"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/de\/wp-json\/wp\/v2\/product_tag?post=12958"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}