“Free Weekly Planner Template for Google Sheets (Download + Guide)”

What should the template include?

weekly planner template for Google Sheets is a key topic in modern project management and teamwork. Four tabs, each with one job. Setup holds the constants nobody should edit casually, Week holds the grid and the tasks, Backlog holds what did not fit, and Review holds the weekly numbers so trends are visible after a month.

Keeping Setup separate is not fussiness. If the day start time sits in a cell that formulas read, changing 07:00 to 08:00 shifts the whole grid, and you never have to retype twenty-eight time labels again.

How do you build the planner, cell by cell?

Build it in seven steps and save a copy as your master. The cell references below assume the default Sheet1 renamed to Week, with row 1 reserved for the week anchor and row 2 for day names.

Step 1: Create the four tabs

Rename the first tab to Setup, and add Week, Backlog, Review in that order, left to right, because tab order is navigation. On Setup, put these labelled values in A1:B5: day start 07:00, day end 21:00, slot length 30 minutes, working days 5, weekly hours available 40.

Step 2: Build the time grid

On the Week tab, put the anchor formula in B1 and the seven day headers in C2:I2. Column B then holds the time labels, starting at B3 with the day start value pulled from Setup, and B4 down repeating the slot length.

With 07:00 to 21:00 at 30-minute slots you get 28 time rows, from B3 to B30. Seven day columns plus the time column gives 224 cells in the grid itself, which is small enough that the sheet stays responsive and large enough to hold a real week.

Step 3: Make Monday calculate itself

This is the formula that keeps the planner alive. Paste it into B1 and format the cell as a date.

=TODAY()-WEEKDAY(TODAY(),3)

WEEKDAY with mode 3 returns 0 for Monday and 6 for Sunday, so subtracting it from today always lands on the Monday of the current week. On Thursday 12 November 2026, WEEKDAY returns 3, and 12 minus 3 gives Monday 9 November.

Then set C2 to =$B$1 and D2 to =C2+1, and drag D2 across to I2. Format row 2 as a custom date such as ddd d mmm, so the header reads Mon 9 Nov, Tue 10 Nov, and so on, without ever being typed.

Step 4: Add dropdowns with data validation

Select the status column in the task list, then open Data, Data validation, and add a dropdown with four values: Planned, In progress, Done, Dropped. Turn on the option to reject invalid input, because free text is how a status column stops being countable.

Do the same for a Category column with five values that match how you actually spend time, for example Client work, Deep work, Meetings, Admin, Learning. Five is enough; twelve categories produce a chart nobody can read.

Step 5: Add one conditional formatting rule per status

Select the task rows, open Format, Conditional formatting, choose Custom formula is, and enter =$E3=”Done”. Set the format to grey text with strikethrough. Add a second rule for =$E3=”In progress” with a light fill.

Two rules are enough to make the list scannable. The common mistake is a rainbow of colours where every category competes for attention and none of them wins.

Step 6: Build the summary block

Reserve a block to the right of the grid, or below it, with four numbers: tasks planned, tasks done, hours allocated, hours available. Each is one formula, and each is worth more than any decorative chart.

=COUNTIF($E$3:$E$40,"Done")
=COUNTA($C$3:$C$40)
=SUMIF($E$3:$E$40,"<>Dropped",$G$3:$G$40)

The third formula sums an hours column while ignoring dropped tasks, which is the difference between a plan and a wish list. The fourth number, hours available, comes straight from Setup.

Step 7: Freeze, protect, and print

Freeze the first two rows and the first two columns, so the dates and times stay visible while scrolling. Protect the Setup tab and the formula cells from accidental edits using Data, Protect sheets and ranges. Then set the print area to the grid, choose landscape, fit to one page wide, and add a header with the week number.

Which formulas do you actually need?

Six formulas carry the whole planner, and four of them are one line. Keep them in named cells so the sheet documents itself.

The hours formula multiplies by 24 because Sheets stores time as a fraction of a day. A block from 09:00 to 10:30 is 0.0625 of a day, and multiplying by 24 gives the 1.5 hours a person expects to see.

If you want the plan to survive across months, add a Review tab row per week with the date, planned hours, actual hours, and completion rate. After four rows you have a trend, and after twelve you have evidence about how much you can honestly schedule.

What does a filled week look like?

Here is a realistic week for a product manager with 40 contracted hours, built in the grid above. The point is the arithmetic at the bottom, not the specific blocks.

Twenty-five hours are allocated against forty contracted hours, which looks like a disaster until you subtract the 6 hours of slack that never gets planned: context switching, interruptions, and the ten minutes before every meeting. Real usable capacity is closer to 29 hours, so this plan runs at 86 percent of capacity and leaves about 4 hours of buffer.

That buffer is the whole reason the plan survives Thursday. A week planned to 100 percent of capacity has no room for the thing that always happens, and the first unstoppable event pushes the rest into next week.

How do you handle a week that overflows?

Cut in a fixed order instead of improvising. When planned hours exceed capacity, the sequence that works is: drop the lowest-value deep work block, defer the non-urgent admin, then decline or move one meeting.

Take a week where the task list sums to 34 hours against 29 usable. The gap is 5 hours. Dropping one 2-hour deep work block and deferring 3 hours of admin closes it exactly, and nothing that ships this week is affected. Without a rule, most people instead shave thirty minutes off six blocks, which protects nothing and makes every task slightly late.

A second habit pairs well with the grid: block the first ninety minutes of each day for one task, and treat that block as unmovable. Three ninety-minute blocks in a week is 4.5 hours of genuine focus, which is often more output than twenty hours of fragmented time.

How do you share it without breaking it?

Share the Week tab read-only and keep your own copy editable, or share edit access with one person and protect the formula cells. Google Sheets has no per-cell permissions on the free tier, so protection is a guardrail rather than a security control.

For a team version, publish the sheet to the web and embed it in a wiki page. Viewers get live data without a Google account, and nobody can move a row while you are presenting from it. If the team needs to write, that is the moment to move to a tool with real ownership, because a shared spreadsheet with six editors becomes a negotiation.

Do you need Apps Script?

No. A planner that needs a script also needs maintenance, and most people stop maintaining scripts before they stop planning. The only automation worth adding early is an onOpen trigger that jumps to today’s column, and even that is optional.

Everything else that people usually reach for a script to do is available as a built-in function. FILTER pulls the open tasks, QUERY summarises hours by category, IMPORTRANGE pulls data from another sheet, and SORT orders the backlog by estimate. Those four cover the reporting most weekly reviews need.

What are the limits of a Sheets planner?

Sheets is a document that recalculates, not a system that acts. It cannot remind you that a block starts in ten minutes, cannot assign a task to a colleague with a notification, and cannot repeat a task every Monday without you copying the row. On mobile it works for reading and quick edits, and poorly for dragging blocks around.

There are hard limits too, though they are far above personal use. A spreadsheet holds up to 10 million cells, a cap Google doubled to 20 million for general availability in September 2026, and column ZZZ is the last one at 18,278 columns. A weekly planner uses about 300 of those cells, so capacity is never the constraint; attention is.

The real limit is social. A spreadsheet assumes one owner and one source of truth. The moment two people need to change the same plan, the file becomes a conversation with cells in it.

Who is this template right for?

It fits anyone whose week is mostly self-directed and whose work is visible in hours. It fits badly where the work is defined by tickets, handoffs, or approvals owned by other people.

Where does a real work system fit?

When the week is planned but the work still slips, the missing piece is usually follow-through: someone else’s dependency, a reminder, a status that updates itself.

Doitify is built for that layer. A task carries an owner, a due date, and a checklist; progress rolls up to the project, and the same plan can be read as a calendar, a board, or a timeline. Time estimates and workload views answer the capacity question this spreadsheet answers by hand. Doitify is our product, so read this as scope rather than a review; if your week is your own and the grid above fits on one page, the spreadsheet is the lighter and better answer.

What mistakes make a Sheets planner fail?

Five failures show up again and again, and each is preventable in a minute.

• Dates typed by hand. By week three the header says the wrong Monday and every block is a week off.
• No capacity number. Without hours available in a cell, over-planning is invisible until Thursday.
• A category for everything. Twelve colours produce a chart nobody reads.
• The backlog living in the grid. Undated tasks in the time grid make the week look full when it is not.
• Never reviewing. A planner without a Friday look back is a wish list that resets weekly.

Conclusion

A weekly planner template for Google Sheets is worth building because it is the only planner that can recalculate itself. Four tabs, one anchor formula, 28 time rows, one validation list, and one conditional rule is the entire build.

Then let the numbers do the arguing. Compare allocated hours with available hours before Monday, cut the lowest-value block when they do not fit, and record the completion rate on Friday. The spreadsheet will not make the week go to plan, but it will tell you, honestly and in advance, whether the plan was ever possible.

If this post on weekly planner template for Google Sheets was helpful, you might also enjoy Project Management Statistics for 2026: The Data You Need and Project Integration Management Explained.