Time Blocking Planner Spreadsheet

About this template

This time blocking planner adds up your week, so you can see how many hours went to meetings and how few to the work you are judged on. It is for anyone who already blocks their days and wants the grid to tell them something back.

Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).

Block the week

The Time Blocks tab is an hourly schedule of sixteen hours across seven days, from 06:00 to 21:00. Type straight into any cell, with no forms to fill in.

Tag what kind of hour it was

Beside each block is a dropdown with eight kinds of hour: deep work, admin, meetings, exercise, family, rest, errands and learning. Tagging takes a second and turns the grid into a time tracker.

See where the week went

Most time blocking templates are an empty grid that never adds anything up. This one does.

• Hours and share for each kind of hour, added up across the week
• Hours blocked per day and across the week
• Free slots counted, so you can see before Monday that Thursday has nothing left in it
• How booked the week is, as a percentage

The planner underneath

A blocked week is not the same as a planned life, so the productivity planner side sits in the same file.

• Today, assembled from your tasks
• A task tracker with 250 tasks by area and priority
• Habits
• A dashboard reading all of it

The seven connected tabs are Start Here, Setup, Time Blocks, Today, Tasks, Habits and Dashboard, which makes it a weekly planner and a record of where the time actually went.

Works with

• Microsoft Excel 2016 or later, on Windows or Mac
• Google Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.
• No dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.
• No subscription

What you download

• Two Excel files: a real working week with eleven hours of meetings in it, and a blank one ready for yours
• The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
• The terms of use as a PDF

Your files are ready to download as soon as payment clears. The file is for your personal use, so please do not share or resell it. Questions before or after you buy? Use our contact page and we will help.

Frequently asked questions

Does it work in Excel or Google Sheets?

Both. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to make your own copy of the Google Sheets versions.

What hours does the grid cover?

Sixteen hours a day, from 06:00 to 21:00, for all seven days of the week.

How does it show where my time went?

Each block has a dropdown for one of eight kinds of hour, such as deep work or meetings. The file adds up the hours and share for each kind across the week.

Does it show how full my week is?

Yes. It counts hours blocked and free slots for each day and shows how booked the week is as a percentage.

Is there a task list too?

Yes. There is a Tasks tab with 250 tasks by area and priority, a Today tab built from them, a Habits tab and a dashboard.