Free Dynamic Calendar & To-Do List Template for Google Sheets

I’ve put together a free To-Do List & Dynamic Calendar spreadsheet in Google Sheets to help you keep track of your tasks, appointments, and deadlines. On busy days, it’s easy to forget what’s due — this sheet shows everything at a glance and keeps you on top of your schedule.

Whether you’re managing work tasks, personal projects, or home appointments, this tool makes it simple to see what’s coming up and what’s overdue.

---

How It Works

Open the spreadsheet and start at the “Start Here” section. Select the year and month, and the calendar updates automatically — no need to type directly on the calendar grid.

Add your tasks in the Tasks Table. Enter the start date, due date, and select the appropriate options from the drop-down boxes for status, category, and priority. There’s space for two tasks per day, but you can extend the table if more tasks fall on the same date.

The month you select under “Start Here” is highlighted in yellow, so you can filter by colour to see only that month. Filter by orange to quickly find today’s tasks. Completed tasks grey out automatically, and overdue tasks turn red so you can see at a glance what needs attention.

Keep adding tasks as needed and flick through the months to plan ahead. The dynamic calendar updates automatically, showing all tasks that are due and their due dates.

---

Features

• Automatic Calendar: Enter the year and month — the calendar updates itself.
• Tasks Table: Enter all your tasks with start dates, due dates, status, category, and priority.
• Overdue & Completed Alerts: Overdue tasks appear in red, completed tasks are greyed out with a strike-through.
• Progress Tracking: The sheet shows progress bars, overdue counts, and charts for priority, status, and category.
• Customisable: Change colours, add notes, or adjust the layout — nothing is locked.
• Accessible Anywhere: Works on computer, tablet, or phone.
• Easy to Use: No special skills needed — just enter your tasks and watch the calendar update.

👉 Download: Free To-Do List & Dynamic Calendar Spreadsheet

After clicking “Make a copy,” the template will be saved to your Google Drive. You can edit and personalise it however you like.

Prefer to work offline? After saving, go to: File → Download → Microsoft Excel (.xlsx)

🎁 Grab the template, organise your tasks, and stay on top of deadlines — a little planning goes a long way! – ♡ Janet

---

Feature image: generated by Freepik and AI.