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

ABCDEF
1TimeMonTueWedThuFri
208:00GymGymGym
309:00Team standupTeam standupTeam standupTeam standupTeam standup
410:00Deep workClient callDeep workDeep workPlanning
511:00Deep workDeep workReview
612:00LunchLunchLunchLunchLunch
713:00EmailWorkshopEmailEmailEmail
814:00Workshop1:1sDeep work
915:00Project XProject XProject X
1016:00AdminWeekly review
1117:00
12Hours booked76867
Tab: This week. Teal cells are live formulas; hover one to see it.

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. 1.Download the CSV and import it into Google Sheets.
  2. 2.Type activities into the blocks. Leave free time empty so it isn't counted.
  3. 3.Add rows for earlier or later hours and extend the COUNTA ranges.
  4. 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