Free Google Sheets Weekly Schedule Template
Plan the work week in one-hour blocks. The bottom row counts booked hours per day so you can spot overloaded days before they happen.
What it looks like
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Time | Mon | Tue | Wed | Thu | Fri |
| 2 | 08:00 | Gym | Gym | Gym | ||
| 3 | 09:00 | Team standup | Team standup | Team standup | Team standup | Team standup |
| 4 | 10:00 | Deep work | Client call | Deep work | Deep work | Planning |
| 5 | 11:00 | Deep work | Deep work | Review | ||
| 6 | 12:00 | Lunch | Lunch | Lunch | Lunch | Lunch |
| 7 | 13:00 | Workshop | ||||
| 8 | 14:00 | Workshop | 1:1s | Deep work | ||
| 9 | 15:00 | Project X | Project X | Project X | ||
| 10 | 16:00 | Admin | Weekly review | |||
| 11 | 17:00 | |||||
| 12 | Hours booked | 7 | 6 | 8 | 6 | 7 |
What's included
- One-hour blocks from 08:00 to 17:00
- Booked hours per day, counted automatically
- Easy to colour-code with conditional formatting
How to set up the weekly schedule template
- 1.Download the CSV and import it into Google Sheets.
- 2.Type activities into the blocks. Leave free time empty so it isn't counted.
- 3.Add rows for earlier or later hours and extend the COUNTA ranges.
- 4.Use Format → Conditional formatting → "Text contains" to colour meetings, focus time and breaks.
Questions
- Can I use half-hour slots?
- Yes. Insert a row between each hour and label it 08:30, 09:30 and so on. Booked hours then count half-hours, so divide the total by 2.
More templates
Calendar Template 2026
A Monday-first monthly calendar for Google Sheets that rebuilds itself when you change the month.
Get the templateHabit Tracker
A weekly habit tracker for Google Sheets with checkboxes and a completion rate for each habit.
Get the templateProject Management Template
A lightweight task tracker for Google Sheets with owners, priorities, due dates and overall progress.
Get the template