Gantt Chart & Kanban Board Project Planner Template (Excel)

Type each task once and your Gantt chart, Kanban board and dashboard all stay in sync. Built for Excel.

Most project templates make you keep a Gantt chart and a task board in sync by hand. This one does not. Type each task once and everything else updates.

Automatic Gantt chart

Bars draw from your start date and duration (or end date)

Darker shading shows % done, today's column is highlighted

Daily or weekly timeline, weekends shaded

Kanban board that fills itself

Backlog, To do, Doing, Review and Done columns

Each card shows the task, owner, due date and an overdue flag

Change a status and the card moves column

Project dashboard

% done weighted by task length, project end date

Overdue and due-in-7-days counts

Open tasks, overdue tasks and days of work left per owner

Tasks by status chart

Plus the Project Starter toolkit

Project Charter, Risk Register, SIPOC, DMAIC Worksheet, Fishbone and Lessons Learned tabs

Printable Word version of those pages

Works everywhere

Microsoft Excel 2016 or newer (Windows and Mac) and LibreOffice Calc

No macros, no add-ons, no subscription

Up to 150 tasks, sample project included

Made for small teams, freelancers, agencies, students, event planners and anyone running a project without paying for project software.