Free Google Sheets Schedule Template For Small Business Teams

Spreadsheets have been holding down the scheduling fort for a long time. And, honestly, they still do a decent job. If you're running a small team and need a free, flexible way to plan shifts, a Google Sheets schedule template is a solid place to start.

Below, you'll find five free templates you can copy and customize today: weekly, shift, biweekly, monthly, and rotating. Each one is built for small teams with hourly workers: restaurants, retail shops, salons, and anywhere else schedules change week to week.

Grab the one that fits your setup. And if you hit the limits of a spreadsheet along the way, we'll talk about what comes next.

Google Sheets Schedule template: What you need to know

A Google Sheets schedule template is a free, shareable spreadsheet for planning employee shifts. Here's the short version:

• Free templates below cover weekly, shift, biweekly, monthly, and rotating schedules
• Customize by adding your team's names, roles, shift times, and color coding
• Share instantly via a link — no downloads required
• Best for small teams with straightforward, stable schedules
• Heads up: Spreadsheets have real limits — no automatic reminders, no conflict detection, no labor cost tracking

Get your free Google Sheets schedule template

Here are five templates to cover the most common scheduling needs. Pick the one that matches how your team works.

• Weekly employee schedule template — Map out your full team's shifts across a seven-day week. Great for steady, recurring schedules. [Download weekly template] 
• Shift schedule template — Designed for teams working multiple shifts per day. Keeps morning, afternoon, and evening coverage clear at a glance. [Download shift template]
• Biweekly schedule template — Plan two weeks at a time and keep things synced with your pay cycle. [Download biweekly template]
• Monthly schedule template — A high-level view of the whole month. Better for planning ahead than managing day-to-day coverage. [Download monthly template] 
• Rotating shift schedule template — Built for teams where shifts cycle across employees on a set pattern. [Download rotating template]

Weekly employee schedule template (Google Sheets)

Who this is for

The weekly employee schedule template is built for small business owners managing a consistent team across a standard work week. If you run a café, boutique, salon, or any business where shifts repeat week to week with some variation, this is your starting point. It's simple enough for a first-time manager and flexible enough to handle part-timers, split shifts, and last-minute changes without starting from scratch every Monday morning.

What's included

The template includes a row for each team member and columns for each day of the week, Monday through Sunday. Each cell holds a shift start time, end time, or a quick role indicator like "open" or "close." You'll also get a totals column that tallies weekly hours per employee, making it easy to spot who's approaching overtime before it becomes a problem. Color coding by role or shift type helps you read the schedule at a glance without squinting at every cell.

How to customize it

Start by replacing the placeholder names with your team's names. Update shift times to match your actual hours of operation. If you have multiple roles like cook, server, or host, assign each a color so the schedule is instantly scannable. You can duplicate the tab each week to keep a running history, or set up a new copy from the master template each time. Either way, the structure stays consistent so you're not rebuilding the format from zero.

Shift schedule template for hourly teams

Best for restaurants and retail

If your business runs on shifts rather than standard nine-to-five hours, you need a template that can handle multiple roles, overlapping time blocks, and a team that changes day by day. Restaurants, retail shops, and hospitality businesses live in this world. A shift schedule template is built around this reality — it organizes your team by shift rather than by person, so you can see coverage at a glance and catch gaps before they become a problem during the Friday dinner rush.

Key features of the template

The shift template breaks each day into time blocks — morning, afternoon, evening — with space to assign employees to each. It includes columns for role and location if you're managing multiple stations or departments. A coverage summary row at the bottom of each day shows how many people are scheduled per shift at a glance. You can also add a notes column for shift-specific instructions, like "handle the patio" or "train new hire." The whole thing is shareable via a link, so your team can view it from their phones without downloading anything.

Limitations to consider

Shift templates work well until they don't. When you've got ten employees across three roles and overlapping time blocks, the spreadsheet gets crowded fast. There's no automatic flag when you've double-booked someone or scheduled a conflict with a requested day off. You'll catch those things — but only if you're looking carefully every single time.

Biweekly work schedule template

When biweekly makes sense

Not every business runs on a Monday through Sunday rhythm. If your payroll runs every two weeks, which is the most common pay cycle for small businesses in the US, a biweekly schedule template saves you from constantly reconciling your schedule with your pay period. Instead of managing two separate weekly views and trying to match them up come payday, you've got everything in one place across a 14-day window. It's one less mental load when you're already juggling a hundred other things.

Payroll alignment

The real advantage of the biweekly template is that your scheduling and payroll speak the same language. When your schedule spans the same two-week period as your pay cycle, it's easier to track total hours per employee, catch anyone p, and make sure your labor costs line up with what you planned. You're not stitching together two weekly sheets every time you run payroll. The hours are already there.

Customization notes

Set up the template with your actual pay period start date, then duplicate the structure for each new cycle. Add a totals row per employee to track hours across both weeks. If your team has different pay rates, a notes column can flag those without requiring a separate document.

Monthly schedule template in Google Sheets

Best use cases

A monthly schedule template is most useful when you need to plan further ahead than a week at a time. Think event-based businesses like wedding venues or catering companies, businesses with seasonal fluctuations, or managers who need to request staff availability well in advance. It's also a strong option for salaried or part-time employees with predictable, recurring schedules that don't change much week to week.

Benefits

The monthly view gives you a high-level picture of your entire team's schedule in a single glance. You can spot coverage gaps around holidays, plan for busy seasons before they sneak up on you, and communicate schedule expectations to your team earlier. For employees who need to plan childcare, second jobs, or school schedules, a monthly view is genuinely helpful and it reduces the back-and-forth of last-minute availability requests.

Drawbacks

Monthly templates sacrifice detail for scale. There's not much room to capture shift-specific notes, exact start and end times, or role assignments without the spreadsheet becoming unreadable. They're better as a planning companion than an operational schedule. Use one to plan ahead, then translate it into a weekly or shift template for the day-to-day.

Rotating shift schedule template

What rotating schedules are

A rotating shift schedule cycles employees through different shifts on a set pattern. For example, week one on mornings, week two on evenings, week three on nights. The rotation can repeat on a two-week, four-week, or longer cycle depending on your business. The goal is to distribute the less desirable shifts fairly across your team instead of having the same people stuck on closing every single week.

Industries that use them

Rotating schedules are most common in businesses that operate outside of standard hours: 24-hour diners, healthcare facilities, hospitality, manufacturing, and any retail environment with extended hours. They're also increasingly used in restaurants and bars where the difference between a Friday night shift and a Tuesday morning shift is significant in terms of tips and foot traffic.

Setup guidance

Start by mapping out the full rotation cycle before you touch the spreadsheet. Know how many weeks the rotation spans, which shifts are included, and how many employees are in each rotation group. Then build the template with one tab per week of the cycle. Assign employees to groups, Group A, Group B, Group C, and map each group to the appropriate shift for each week. Label everything clearly. Rotating schedules are only helpful if your team can actually read them without a decoder ring.

How to make a schedule in Google Sheets from scratch

Don't see a template that works for you? No problem! Creating your own schedule from scratch gives you complete control over the layout and functionality. Here's how to build one step by step.

1. Open a blank Google Sheet

Start fresh by opening a new spreadsheet in Google Sheets. Go to sheets.google.com and click the "+" button for a blank sheet, or open Google Drive, click "New," and select "Google Sheets."

Pro tip: If you’ve already logged in to your Google account, you can just type "sheet.new" to your browser’s search bar to create a blank Google Sheet.

2. Create a basic structure

First, let's set up the foundation of your schedule:

• For a weekly schedule: Label column A as "Employee/Task," then use columns B through H for days of the week.

• For a daily schedule: Label column A as "Time," then use column B for tasks or activities. You might add more columns for different people.

Here's how to format the headers to make them stand out:

1. Select your header row or column.
2. Click the "Fill color" icon (paint bucket) and choose a background color.

3. Bold the text using Ctrl+B (or ⌘+B on Mac).
4. Center the text using the alignment options in the toolbar.

3. Block out time intervals

For a time-based schedule, add time increments down column A:

1. Enter your start time in cell A2 (like "9:00 AM").
2. Enter the next time increment in cell A3 (like "9:30 AM").
3. Select both cells, then grab the small square in the bottom right corner.
4. Drag down to automatically fill in the rest of your time slots.

Pro tip: Format your time cells by selecting them, then going to Format → Number → Time to ensure they're recognized as time values.

4. Use color-coding for visual organization (tasks, roles, shifts)

Color-coding makes your schedule instantly readable:

1. Select the cells you want to color.
2. Click the "Fill color" icon in the toolbar.
3. Choose your color from the palette.

Create a color key at the top or bottom of your sheet explaining what each color represents (e.g., blue = meetings, green = breaks, pink = training).

5. Add helpful formulas

Make your schedule work harder with these useful formulas:

Calculate total hours per day

To sum up daily hours in row 6: =SUM(B2:B5)

Calculate total hours per employee

If employee names are in column A and their hours across the week in columns B-H: =SUM(B2:H2)

Calculate overtime hours

If overtime kicks in after 40 hours, and total hours are in cell I2: =IF(I2>40,I2-40,0)

Calculate labor costs

If an employee's total hours worked are in cell I2, overtime hours are calculated in cell J2, their hourly rate is in cell K2, and the overtime rate multiplier is 1.5: =IF(J2>0, (I2-J2)*K2 + J2*(K2*1.5), I2*K2)

This formula first checks if there are any overtime hours (J2>0):

• If yes: It calculates regular pay for non-overtime hours (I2-J2)*K2, then adds overtime pay at 1.5x rate: J2*(K2*1.5)
• If no: It simply calculates all hours at the regular rate I2*J2

For even more flexibility, you could put the overtime multiplier in its own cell (let's say L2) and use: =IF(J2>0, (I2-J2)*K2 + J2*(K2*L2), I2*K2)

This way, you can easily adjust the overtime rate multiplier (1.5x, 2x, etc.) for different employees or scenarios.

6. Add dropdown menus for quick scheduling

Create standardized options for fast, consistent scheduling:

1. Select the range where you'll assign shifts.
2. Click Data → Data validation.

Pro tip: After you’ve selected your range, hold Ctrl (if you’re using a Windows device) or Command (if using a Mac device) and select the headings of the range so the headings won’t have to follow the dropdown rules.

3. A window called "Data validation rules" will pop up to the right of the screen. Click "Add rule".

4. Under "Criteria," select "Dropdown" or "Dropdown from a range" if you already have an existing range of items. 
5. Enter your options like "Morning,Afternoon,Evening,Off" (if assigning shifts), or select a range with predefined options. Here I’ll choose “Dropdown from a range” and select the three Task types as the range.

6. Change the color coding if needed as well as the other options, then click “Done”.

Now you'll get a dropdown menu in those cells, making it super fast to schedule shifts or assign tasks.

7. Save your template for future use

Once you've got your schedule looking perfect:

1. Go to File → Make a copy.
2. Name it something like "My Schedule Template".
3. Save it to a folder where you can easily find it.

Now you've got a reusable template you can duplicate whenever you need a new schedule—no need to start from scratch each time!

{{banner-cta}}

Google Sheets vs. Scheduling software for small teams

There's no shame in starting with a spreadsheet. Most small business owners do. But as your team grows and your schedule gets more complex, the gap between what a Google Sheet can do and what you actually need starts to widen.

The biggest differences aren't about looks, they're operational. Spreadsheets don't send your team a notification when the schedule changes. They don't flag a conflict when you've accidentally double-booked someone. They don't alert you before an employee crosses into overtime territory. And when a shift swap needs to happen, it plays out across three different text threads while you try to keep track of what's final.

Tools built for hourly team scheduling handle all of that automatically. Shift reminders go out the moment you publish. Overtime alerts fire before someone crosses the threshold. Employees can claim open shifts, request time off, and message you directly without anyone touching a spreadsheet. Your labor costs stay visible in real time, not after you've already run payroll.

A spreadsheet gets you started. Purpose-built scheduling software keeps you from spending your week putting out fires.

"After doing some research and discovering Homebase, I gave it a try and absolutely fell in love with it! I've been doing scheduling with Homebase ever since and can't imagine using anything else." — Mike Davis, Owner, A Hidden Vine

Ready to upgrade from Google Sheets? Try Homebase free today and see why over 100,000 small businesses trust our scheduling tools.

Soogle Sheets schedule template FAQs

Is there a schedule template in Google Sheets?

Yes, Google Sheets has a few basic schedule templates built into the template gallery, accessible when you open a new sheet. They're functional but fairly bare-bones. The templates in this article are built specifically for small business employee scheduling, with shift times, role columns, and hours tracking already included. Download any of them for free and customize to fit your team.

How to use Google Sheets as a planner?

Google Sheets works as a planner by letting you build a grid of dates, tasks, or shifts and share it with anyone via a link. Set up your rows and columns to match whatever you're tracking, whether that's a weekly schedule, a project timeline, or a monthly calendar. Use color coding to categorize entries, add a notes column for context, and duplicate the structure each week or month so you're not starting from scratch. It's flexible enough to plan most things, as long as you're comfortable doing the setup yourself.

How do I create a scheduling calendar in Google Sheets?

To create a scheduling calendar in Google Sheets, start with a blank sheet and add your dates across the top row and your employees or tasks down the first column. Fill in each cell with the relevant shift, task, or appointment. Use conditional formatting to color code by role, shift type, or status so the calendar is easy to read at a glance. Freeze the header row and first column so they stay visible as you scroll. For a faster start, use one of the free templates above and swap in your own team and schedule details.

How to use Google Sheets for employee scheduling?

To use Google Sheets for employee scheduling, set up a spreadsheet with your team's names in the first column and the days of the week across the top. Enter each employee's shift times in the corresponding cells and use a totals column to track weekly hours. Share the sheet with your team via a view-only link so everyone can check their schedule from their phone. For best results, keep a master template and duplicate it each week rather than rebuilding the layout every time. Just know that as your team grows, you'll likely outgrow the manual upkeep faster than you'd expect.