HomeBiz
ACTUAL PRODUCT PREVIEWProject Planner
Put every project and every task in one clear view.
Secure purchase through Etsy. Check the listing for current availability, included files and purchase instructions.
Take a closer look ↓What can Project Planner help you do?
This Project Planner & Gantt Tracker is a ready-to-use spreadsheet for Google Sheets and Excel. Add every task with the project, the owner, the start and due dates and the priority: overdue tasks turn red. The Timeline draws a Gantt chart across 26 weeks for you, the Board shows tasks by status, and Projects shows progress, open tasks and the next deadline for each project. Type in the yellow cells; everything else is calculated for you.
Who is it for?
Designed for project teams planning tasks and deadlines. Use the preview to check whether the screens and level of detail fit the way you prefer to work.
What's inside.
- Start Here: quick setup guide
- Dashboard: tasks done, overdue, due this week, overall progress, in progress, projects, next deadline, open tasks, charts
- Tasks: tasks with project, owner, priority, status, start, due, % done, progress bar and days left
- Timeline: a Gantt chart of every task across 26 weeks, color coded by status, with today's week shaded
- Board: a status board (to do, in progress, waiting, done) with owners and due dates
- Projects: tasks, done, open, overdue, progress bar, next deadline and who owns it, for each project
- Setup: projects, team, status options, priority, timeline start and due-soon days
Real screens. Clearer decisions.
Explore the supplied product previews. Example data illustrates the layout; your own entries will be different. Select an image to view it at full size.
Dashboard
Dashboard: tasks done, overdue, due this week, overall progress, in progress, projects, next deadline, open tasks, charts
Board
Board: a status board (to do, in progress, waiting, done) with owners and due dates
Projects
Projects: tasks, done, open, overdue, progress bar, next deadline and who owns it, for each project
Tasks
Tasks: tasks with project, owner, priority, status, start, due, % done, progress bar and days left
A walkthrough from Albina.
Project Planner Spreadsheet Tutorial: Gantt Chart, Task Board & Deadlines (Google Sheets & Excel)
Loads YouTube when you press play. Watch on YouTube
Before you make it yours.
A simple way to get started
- Review the screenshots and included tools to check the template fits your workflow.
- Open the matching Etsy listing to confirm the current version, compatibility and what is included.
- After purchase, follow the supplied setup instructions. Start with a small set of your own records and review the results.
Good to know
- Projects tab shows up to 12 projects, Board the first 30 tasks per status. Share the Google Sheet with your team to edit together.
- Check the Etsy listing for included files and supported spreadsheet software before purchase. Enter your own information and review calculated results before relying on them.