The short version: a proper weekly scheduling template in Excel is really just a grid (time down the side, days across the top), a set of colour rules, one dropdown list, and a SUMIFS formula counting hours per category, built once and saved as a.xltx file so you never rebuild it again. It takes about 40 minutes the first time and about 3 minutes to duplicate for a new week after that. Most people skip straight to downloading a free template off the internet and then spend longer fixing someone else’s formulas than it would have taken to build their own.
Why I stopped downloading free templates
I used to grab whatever “weekly planner template” came up top of Google, and every single one had the same problem: half-broken merged cells, formulas referencing a sheet called Sheet2 that no longer existed, and colour formatting that fell apart the second I added a row. I rebuilt my scheduling template from scratch in 2023 when I was juggling client calls across three time zones (UK, Israel, and a Chicago-based client) and needed something that reflected how I work, not how a template designer in a different country works.
It took me one Sunday afternoon. It has needed exactly two changes since. That’s the whole pitch for doing it yourself: you build it around your week, not around a stranger’s guess at your week.
What you need before you open Excel
Decide these three things before you touch a single cell, because retrofitting them later is where most templates fall apart:
- Your working hours as actual start and end times, not “roughly 9 to 6.” Mine are 7:30am to 6pm because I do an early call block with US clients.
- Your time increment. 30 minutes is the standard for most people. 15 minutes if you bill in quarter hours. 60 minutes if you’re mostly blocking whole tasks rather than meetings.
- Your categories. Mine are Client Work, Content, Admin, Calls, and Personal. Four to six categories is the sweet spot, more than that and the colour coding stops being readable at a glance.
Step by step: building the grid
Step 1: Set up the columns and rows
Open a blank workbook. In column A, list your time slots starting at row 3 (rows 1 and 2 are for headers). If you’re working 7:30am to 6pm in 30-minute blocks, that’s 21 rows. In cell A2 type 7:30, then in A3 type =A2+TIME(0,30,0) and drag that down to row 22. Format column A as time (h:mm AM/PM) via Format Cells, not as text, so it sorts and calculates.
Step 2: Build the day headers
In row 1, from column B to column H, type Monday through Sunday (or drop Saturday and Sunday if you only plan weekdays, in which case B to F). Merge row 1 across the whole sheet and type the week’s date range, something like “Week of 2 Feb 2026,” so every printed copy is dated.
Step 3: Widen and format for readability
Set column A to 70 pixels wide and columns B onward to 130 pixels. Set row height to 20 for the time rows. This matters more than it sounds: a cramped grid gets abandoned within two weeks because nobody wants to squint at their own schedule.
Step 4: Add a dropdown for your categories
Select the whole grid (B3:H22 or whatever your range is), go to Data, Data Validation, and choose List. In the source box type your categories separated by commas: Client Work,Content,Admin,Calls,Personal. Now every cell in your schedule has a dropdown instead of free text, which keeps the data clean enough to total up later.
Step 5: Colour-code with conditional formatting
This is the step everyone skips and it’s the one that makes the template usable. Highlight the grid, go to Conditional Formatting, New Rule, “Format cells that contain,” and set one rule per category: if cell equals “Client Work” fill green, “Admin” fill grey, “Calls” fill blue, and so on. Once this is set up, you stop reading text and start reading colour blocks, which is how your brain processes a week at a glance.
Step 6: Total your hours with SUMIFS
Below the grid, list your categories in column A (say, rows 25 to 29) and next to each one use a formula like =SUMIFS(B3:H22,B3:H22,A25)*0.5 if you’re working in 30-minute blocks (the 0.5 converts the count of matching cells into hours). This one formula is the entire point of building it in Excel instead of on paper: at a glance you can see you spent 14 hours on admin this week when you thought it was 6, which is exactly the kind of thing a paper diary will never tell you.
Step 7: Save it as an actual template
Once it looks right, go to File, Save As, and choose Excel Template (.xltx) instead of a normal workbook. Every time you double-click it, Excel opens a fresh untitled copy instead of your original, so you can never accidentally overwrite the master. This one step is what separates a template from a document you keep re-saving under slightly different filenames until you lose track of which one is current.
The week I built this for a five-person team
I built a version of this exact structure for a small client team in 2024 when their scheduling was living across four separate calendars and one increasingly resentful group WhatsApp. Five people, one shared workbook, one tab per person, and a summary tab that pulled totals from each with SUMIFS across sheets. It took roughly three hours to set up across all five tabs. Within a fortnight the team lead had spotted that one team member was carrying 11 hours a week more “admin” than anyone else, purely because it was now visible in colour on a shared sheet instead of buried in someone’s head. That’s not a formula doing the work. That’s visibility doing the work.
Where this goes wrong (and it’s not the formulas)
Here’s the part most guides on this topic won’t tell you: the template is never really the problem. I’ve watched people spend four hours perfecting conditional formatting rules and colour gradients on a schedule they then abandon within ten days, because the actual issue was that their week had too many commitments to fit into any grid, however pretty. A beautifully formatted Excel template will not fix a workload that’s 20 percent bigger than your available hours. It will just show you the overflow in very tidy colour blocks. If you build this and find your Admin category eating 15 hours a week, the fix isn’t a better formula, it’s deciding what stops being your job, which is a much less comfortable conversation to have with yourself than picking a fill colour.
If part of what’s eating your week is repeatable admin (inbox triage, diary management, data entry), that’s usually a sign the fix is a person, not a spreadsheet. Worth reading what a virtual assistant’s job description usually covers before you assume the answer is another formula.
What to build alongside your weekly template
A weekly schedule works best when it sits next to a couple of other simple spreadsheets rather than trying to do every job on one tab. For daily follow-through I keep a separate checklist tab, and it’s worth reading up on what makes a good Excel checklist template for daily tasks so the two don’t overlap and duplicate effort. If your week is driven by a bigger project timeline rather than recurring tasks, you might want a Gantt chart built in a spreadsheet instead of, or alongside, the weekly grid. And if the reason you’re scheduling at all is that money is tight and every hour needs to earn its keep, pair this with a monthly budget built in Excel so your time and your money are being tracked with the same discipline.
A few small things that make it last
- Freeze the top row (View, Freeze Panes, Freeze Top Row) so your day headers stay visible when you scroll a long week.
- Print area: set it to your grid only, not the formula section below, if you print physical copies for a desk.
- Keep the master.xltx file backed up somewhere outside your laptop. I lost an early version to a corrupted hard drive in 2022 and had to rebuild from memory, which taught me to save a copy to cloud storage the same day I finish any template.
- Revisit your categories every quarter. Mine changed twice last year as my client mix shifted, and a template that still reflects last year’s work stops being useful fast.
None of this needs to be complicated. If you’re rebuilding your working week from scratch anyway, whether that’s because you’re going freelance, restructuring a small team, or just tired of a paper diary that nobody else can see, it’s worth treating the schedule with the same care you’d put into building a personal brand as a consultant or setting up a one-person business: not perfect on day one, just built enough that you’ll still be using it in six months.
Frequently asked questions
Do I need any add-ins or is basic Excel enough?
Basic Excel is enough. Everything in this build, time formatting, data validation dropdowns, conditional formatting, and SUMIFS, has been standard in Excel since at least the 2010 version, so there’s nothing to install and nothing that breaks when you open the file on a different computer.
How long should building a weekly scheduling template take?
The first build takes around 40 minutes if you follow the steps in order rather than jumping around. Every version after that is a copy of your saved.xltx template, which takes under a minute to open as a fresh week.
Should I build one template for myself or one shared template for a team?
Start with your own. Once you’re happy with the layout, duplicate the tab for each additional person and add one summary tab that totals everyone’s hours by category with SUMIFS across sheets, the same structure I used for a five-person client team in 2024.
What’s the biggest mistake people make with these templates?
Treating formatting as the finish line. A colour-coded, beautifully laid out schedule that shows you’re overcommitted by 15 hours a week is still telling you something is broken, and no amount of extra formatting fixes a workload problem, only a difficult conversation about what stops does.
