Task Planner Pro – Google Sheets To-Do List, Calendar & Weekly Schedule

Task Planner Pro is an all-in-one task planner for Google Sheets. You keep one to-do list, and the monthly calendar, the weekly schedule and every counter fill themselves.

No more copying the same task into three places: set a start date, a deadline and a priority, and the task appears in the right day of your calendar and in your list of tasks to schedule. The template is undated, so you can use it this year and every year after.

What's inside: 5 connected tabs

• TO DO LIST: your tasks with category, start date, deadline, priority, status and person in charge. Nine live counters at the top, four charts, and the ten most urgent tasks always in view.
• CALENDAR: the month laid out day by day, filled from your task list. Filter by priority or by tag, show or hide closed tasks, place tasks on their start date or on their deadline, and repeat an unfinished task until it is done.
• SCHEDULE: your week slot by slot, in 15, 30, 45 or 60 minute intervals, with upcoming cards and a list of the tasks you have not planned yet.
• SETUP: your own categories, priorities, statuses and people. Every dropdown in the file reads this page.
• INSTRUCTIONS: a guided tour with annotated screenshots.

See your day at a glance

• Overdue rows turn pink, tasks due today turn amber, closed tasks are struck through.
• A status icon follows each task on its own.
• Counters show your completion rate, what is overdue, what is due today and what falls in the next seven days.

Who is it for?

• Anyone juggling work, home and personal to-dos who wants one list instead of three.
• Freelancers and small teams who need to see who is in charge of what.
• People who prefer a spreadsheet to a subscription app.

How it works

• Open the file in Google Sheets (a free Google account is enough) and make your own copy.
• Set your categories, priorities, statuses and people in SETUP.
• Add your tasks in TO DO LIST: the calendar, schedule, charts and counters update on their own.
• Follow the 12-page illustrated guide if you need help on any page.

Google Sheets and Excel

Built for Google Sheets. The file also opens in Microsoft Excel, where the tables and the counters work; the charts and the automatic filling of the calendar use Google Sheets functions, so use Google Sheets to get everything.