How to Make an Employee Schedule in Google Sheets + Templates

In this post, we’re going to walk you through an eight-step process for how to make an employee schedule in Google Sheets. We’ll also share a few free Google Sheets templates you can use to get started and highlight some of the benefits and disadvantages of using Google Sheets for creating employee schedules.

The benefits of using Google Sheets for employee scheduling

Creating employee schedules in Google Sheets has three big benefits:

• Making a work schedule in Google Sheets is easier and faster than making one with pen and paper. You can easily undo mistakes, copy and paste values from one cell into another, and use each week’s schedule as a template for future weeks.
• Using Google Sheets to create employee schedules is completely free.
• Google Sheets spreadsheets can be shared with employees as a link, so you don’t have to field calls from employees asking about their schedules, and they don’t need to come to work to find out when they’re scheduled for future weeks.

The disadvantages of using Google Sheets for employee scheduling

Creating employee schedules in Google Sheets also has a number of disadvantages:

• What you save on costs you’ll lose in time. While it’s completely free to create schedules using Google Sheets, it takes a lot more time than creating a schedule using employee scheduling software.
• You may make scheduling mistakes. It can be difficult to keep track of every employee’s availability, preferences, and scheduled time off when creating schedules in Google Sheets. You may have to create and reference multiple tabs and documents to keep track of everything you need.
• The most helpful features often require advanced knowledge. If you’re a spreadsheet pro, you can create a master sheet for all of your employees and then automatically populate other role- or location-based sheets using the details from the master sheet. But it will take a lot of time to learn how to do that, and one tiny typo can break your entire workflow.
• Google Sheets doesn’t offer helpful scheduling features. You won’t be able to notify employees automatically when their schedules change, let employees request shift trades with one another, or let employees change their availability on their own.

For some teams, these issues are not a deal-breaker. For other teams, it’s much cheaper and more efficient to use scheduling software. If that sounds like you, you can try Buddy Punch’s employee scheduling software for free for 14 days.

Buddy Punch makes it easy to create work schedules with features like a drag-and-drop builder, recurring shifts, employee availability, shift swapping, and more. Plus, Buddy Punch is also an employee time clock app that your team can use to clock in and out and that you can use to keep employees accountable, track time worked, calculate overtime, track PTO balances, and run payroll.

How to make an employee schedule in Google Sheets in 8 steps

Follow these step-by-step instructions to make a schedule for employees in Google Sheets. These are general instructions to show you the fastest way to make a schedule.

1. Create a new file

Open a blank spreadsheet and give your file a name like “Employee Schedule: ##-##-## to ##-##-##” to make it easy to find historical schedules. There are a lot of templates that Google provides both in the new spreadsheet section as well as when you first open a blank spreadsheet. We are not going to be using these for this guide, but feel free to peruse them for your own needs.

Google Sheets will also automatically save with every change you make as long as you are connected to the internet, so don’t worry about losing anything. 

2. Create a header

In row 1, select the number of columns you’ll need, then click the “Merge” button to turn all of those cells into a single cell. Type in the name of your schedule to create a header. You might also want to increase the font size of the header, add a color background, or add a border around it to make it stand out.

3. Add date headers to the columns in row 2

Your first column should be called “Employee” since you’ll list all employee names in that column. The following columns should list the individual days and dates that your schedule is covering.

If you want to change the size of the columns, you can either click on their borders and drag them to the desired size, or you can right click the column and select “Resize column.”

4. Add your employees’ names to the first column

In column A, list the names of all of your employees. If you have multiple locations, you can also create sections for your different locations and list the names of employees who work at those locations under those sections. If employees work in different roles, you can also create sections for roles, or add another column to the right of the employee’s name where you can specify their role.

5. List the hours each employee will work

At this point, you can actually start creating your schedule. For each day on your schedule, list the times you want each employee to work that day. Like mentioned earlier, you can adjust the columns if your times are too wide for the default size. You can also specify when an employee is off or when they’re taking PTO on the schedule.

6. Add some visual appeal to your schedule

Now that you’re finished scheduling, you may want to make your schedule more visually appealing. There is a lot you can do for visual style, such as changing the background colors of each row (which can be done easily with the “alternating colors” option), using the bold or italics for important information, changing the font, adding borders to your cells, or centering the text to add margin space between entries.

7. Make sure your schedule will print on a single sheet of paper

If you’re planning to print your schedule to hang it up at work, you’ll want to make sure that it can be printed on a single sheet of paper. Go to “File” –> “Print” and view the preview to make sure none of your schedule is getting cut off in odd places. If it is, you may need to adjust the design to get everything to print nicely on a single sheet of paper.

8. Distribute the finished schedule to your employees

Once your schedule is finalized, you can share it with your employees. You can:

• Print it and hang it in the break room or another central location.
• Download the file and email it to your employees.
• Create a shared link and send the link to employees.

Google Sheets has two ways to share your file: you can enter employees’ emails addresses to share it only with specific individuals, or you can create a link that lets anyone with the link view the spreadsheet.

When you use the email option, it will automatically default to “Editor,” but if you don’t want anyone to edit this file, be sure to change it to “Viewer” instead.

If you share the link, you have to change that in the last option by clicking the dropdown menu and selecting “Anyone with the link.” This will automatically default to the “Viewer” option. Then, just click the “Copy link” option on the bottom left and share that link with your employees via email, text, or any other method. 

Free employee schedule templates for Google Sheets

If you don’t want to bother creating an employee schedule in Google Sheets from scratch, have more complex schedules than what’s covered above, or want something that’s already designed for you, click the links below to download our free employee schedule templates for Google Sheets:

• Monthly employee schedule template – If you create monthly schedules for your employees, use this template to easily get your entire schedule for the month printed on one sheet of paper.
• 24 hour schedule template – If your business operates 24 hours a day, use this template to schedule employees weekly across all 24 hours of each day.
• 7-day weekly work schedule template – If you just need a basic weekly work schedule, this template is the right choice for you.
• Employee shift schedule template – If you want to schedule employees for specific shifts (e.g., first, second, third), use this template to create a weekly schedule that’s broken out into shifts.
• Job schedule template – If your employees work on specific jobs or projects, use this template to specify not only when they’ll work but also what specific projects you’ve assigned them to work on.
• Schedule template for multiple positions – If your employees rotate between different positions, use this template to let employees know when they’re working and what position they’re filling.
• Daily employee schedule template – For trade businesses where employees work at different locations each day and may not be planned in advance, this daily schedule template will let you create a schedule for employees each morning that specifies what jobs they’re working on that day.

To use these templates, you’ll need to make a copy of them. When you click the links above, the system will ask you if you want to make a copy of the spreadsheet in your Google account. Select yes to make your own editable copy.

Simplify your employee scheduling with Buddy Punch

Buddy Punch is an employee scheduling app that’s user-friendly, has high customer satisfaction ratings, and comes with all of the features you need to create schedules quickly.

Buddy Punch’s scheduling tool displays all of your employees in one column and the days you’re creating a schedule for in subsequent columns. To create a shift, simply click in an open area, specify the shift’s start and end times, and add any employees you want to work that shift.

Repeat this for all of the days your schedule covers, then publish your schedule. Your employees will receive notifications that the schedule is live, and they can view their schedule at any time in the Buddy Punch app, which is available on the web and has mobile apps for both iOS and Android devices.

If your scheduling is simple, that’s all you’ll ever need to do. However, Buddy Punch’s scheduling tool also has all of the advanced features you need to create more complex work schedules.

Locations

Buddy Punch’s locations feature lets you assign locations to shifts so employees know not only when they’re working but also where. Your schedule can also be filtered by location so you can build schedules for each location quickly and easily, and different locations can be assigned different colors so you can quickly see where everyone will be working at a glance.

Departments

If you have employees working in different roles — such as server and host — you can create those different roles as departments in Buddy Punch. After that, you can assign the appropriate department to shifts so employees know when they’re working, where they’re working, and what position they’re filling.

Repeating shifts

If your employees work the same hours every day, every week, you can create repeating shifts to automatically add shift templates to future weeks. The future shifts won’t be published until you push the publish button for the schedule they apply to, but it gives you a big head start on creating future schedules.

If you do need to shift something around on a future schedule, that’s easy too. Buddy Punch’s drag-and-drop functionality makes it easy to move shifts to different days and times.

Employee availability

Nothing is more frustrating than working hard on your schedule, publishing it, finding out that an employee isn’t available to work on a day you scheduled them for, and having to start over.

With Buddy Punch, you’ll never run into this issue again. Employees can specify their availability in the app, and times when employees aren’t available show up on your calendar view. Plus, if you try to schedule an employee when they’re unavailable, the system will give you an error message and prevent publishing the schedule.

Shift trades and covers

When an employee can’t make their scheduled shift, either the employee or an admin/manager can open that shift up to be covered. You can select who should receive the cover request, and if another employee accepts it, the schedule adjusts automatically.

Additionally, when employees work out amongst themselves that they want to trade shifts, they can make that request in Buddy Punch. The request then goes to a manager or admin to be approved before the schedule adjusts. 

Scheduling and much more

While Buddy Punch makes creating work schedules easier than ever, that’s not all it can do. It’s also a time clock that compiles timesheets for you automatically, makes running payroll easier, and keeps your employees accountable with features like:

• Clock in/out reminders: If your employees haven’t clocked in or out within a certain amount of time after their shift starts or ends, Buddy Punch will automatically send them a reminder to clock in/out.
• Limit early/late punches: You can prevent employees from clocking in before their shift starts or automatically clock them out at the end of their shifts to prevent unplanned overtime and unexpected labor costs.
• Geofencing: Prevent employees from clocking in or out when they’re not on-site by creating geofences. If employees try to punch when offsite, the system will block the action.
• Photos on punch: If you’re concerned about buddy punching — where employees clock in and out for each other — you can require employees to take a selfie when they clock in and out. Those photos can be reviewed on their timecards.
• Payroll integrations: Buddy Punch integrates with popular payroll providers like QuickBooks, ADP, Workday, Gusto, and more, letting you transfer your time data to payroll in seconds and run payroll more quickly than ever before.

There are lots of additional features available in Buddy Punch beyond what we’ve covered here, and you can use them all or just the ones you need. View a complete list of Buddy Punch’s features.

Want to learn more about Buddy Punch? Start a free trial — no credit card required — watch a video demo, take an interactive tour of the product, or request a personalized demo.

Related Reading:

• The Best Employee Scheduling Software for Small Businesses
• Free Employee Scheduling Templates
• How to Create an Employee Schedule in Google Calendar
• Top 10 Schedule Maker Apps + Who They’re Best For
• The Best Drag and Drop Scheduling Software