Employee Schedule Template Google Sheets & Excel, Weekly, Monthly Shift Planner, Staff Rota, Coverage, Work Hours, Small Team Roster
Item highlights
Seller's description
This employee schedule template shows at a glance when you're short-staffed. Set your shift codes once. Then pick a code for each person and day. It adds up scheduled hours for each employee. It counts who's working each day and flags days below your minimum. Weekly and monthly views are included. It works in Google Sheets and Excel.
WHAT IT DOES
- Shifts tab: set up to 20 shift codes once (e.g. O = Open 6:00 AM-2:00 PM, C = Close, N = Overnight), with an unpaid break for each. Paid hours per shift are calculated for you, and overnight shifts (e.g. 10:00 PM-6:00 AM) work.
- Weekly Schedule: type the week's start date, then pick a code from a dropdown for each employee and day. You see each person's scheduled hours and number of shifts, and an OVER flag when someone is scheduled past their max hours for the week.
- Coverage: how many people are on each shift code each day, people working per day, scheduled hours per day, and a SHORT / OK check against a minimum you set for each day of the week.
- Monthly Schedule: type any date in the month for a full-month grid (28 to 31 days, leap years included) with monthly hours and shifts per employee, daily headcount and a SHORT / OK check against your minimum staff.
- Colour coding: working shifts, OFF / PTO days, OVER and SHORT are highlighted automatically, and days outside the month are greyed out.
- Up to 30 employees and 20 shift codes.
WHAT YOU GET
- 1 Excel file (.xlsx): Employee-Shift-Schedule.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute
HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: set up your shift codes, add your employees, clear the sample schedule and start planning.
GOOD TO KNOW
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- One shift code per cell. Split shifts need their own code, and 24-hour shifts aren't supported.
- The weekly and monthly tabs are separate plans; one doesn't fill in the other.
- It schedules and totals hours. It doesn't track actual clock-in times or calculate pay, and it doesn't check labour-law rules on breaks, minors or scheduling notice. It isn't legal or HR advice.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
HOW THIS WAS MADE
I designed this schedule with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 24-point test plan covering overnight shifts, breaks, coverage counts, staffing checks, month lengths and leap years, year boundaries and 30-employee / 20-shift-code capacity).
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$12.00
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
This employee schedule template shows at a glance when you're short-staffed. Set your shift codes once. Then pick a code for each person and day. It adds up scheduled hours for each employee. It counts who's working each day and flags days below your minimum. Weekly and monthly views are included. It works in Google Sheets and Excel.
WHAT IT DOES
- Shifts tab: set up to 20 shift codes once (e.g. O = Open 6:00 AM-2:00 PM, C = Close, N = Overnight), with an unpaid break for each. Paid hours per shift are calculated for you, and overnight shifts (e.g. 10:00 PM-6:00 AM) work.
- Weekly Schedule: type the week's start date, then pick a code from a dropdown for each employee and day. You see each person's scheduled hours and number of shifts, and an OVER flag when someone is scheduled past their max hours for the week.
- Coverage: how many people are on each shift code each day, people working per day, scheduled hours per day, and a SHORT / OK check against a minimum you set for each day of the week.
- Monthly Schedule: type any date in the month for a full-month grid (28 to 31 days, leap years included) with monthly hours and shifts per employee, daily headcount and a SHORT / OK check against your minimum staff.
- Colour coding: working shifts, OFF / PTO days, OVER and SHORT are highlighted automatically, and days outside the month are greyed out.
- Up to 30 employees and 20 shift codes.
WHAT YOU GET
- 1 Excel file (.xlsx): Employee-Shift-Schedule.xlsx
- 1 PDF with your link to make your own copy in Google Sheets, plus quick-start steps
- A built-in "Start Here" tab with instructions, and sample data you can clear in a minute
HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download your file. Etsy also emails you a download link.
2. Unzip it. Google Sheets: open the PDF, click the copy link and choose "Make a copy". The copy is saved to your own Google Drive.
3. Excel: open the .xlsx file in Excel 2010 or newer.
4. Follow the Start Here tab: set up your shift codes, add your employees, clear the sample schedule and start planning.
GOOD TO KNOW
- This is a digital download. Nothing physical will be shipped.
- Compatible with Google Sheets (needs a free Google account) and Microsoft Excel 2010 or newer, on Windows or Mac. Not designed for Apple Numbers.
- One shift code per cell. Split shifts need their own code, and 24-hour shifts aren't supported.
- The weekly and monthly tabs are separate plans; one doesn't fill in the other.
- It schedules and totals hours. It doesn't track actual clock-in times or calculate pay, and it doesn't check labour-law rules on breaks, minors or scheduling notice. It isn't legal or HR advice.
- Because this is a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
HOW THIS WAS MADE
I designed this schedule with help from AI tools, which assisted with building the formulas and layout. I chose the features, and before listing it I tested every calculation against an independent check (a 24-point test plan covering overnight shifts, breaks, coverage counts, staffing checks, month lengths and leap years, year boundaries and 30-employee / 20-shift-code capacity).
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Timesheet Template Google Sheets & Excel, Weekly Employee Time Card, Overtime Calculator, Hours, Gross Pay Tracker, Small Business
$13.00
-
Digital download
Rotating Shift Schedule Template, 12 Hour 2-2-3 DuPont Panama 24/48 Fire Rotation, Overtime Calculator, Crew Rota | Excel Google Sheets
$12.00
-
Digital download
Pet Sitting Spreadsheet, Dog Walking Booking Tracker & Client Pet Care Log, Key Log, Holiday Rates | Excel Google Sheets
$19.00
-
Digital download
Restaurant Food Cost Calculator & Menu Pricing Spreadsheet, Recipe Costing, Sub Recipes, Menu Engineering, Cafe | Excel Google Sheets
$15.00
-
Digital download
PTO Tracker 2026 2027 Google Sheets & Excel, Employee Vacation, Sick and Personal Time Off Tracker, Accrual, Carryover, Team Calendar
$16.25
-
Digital download
Employee Offboarding Checklist & Termination Letter Template, Exit Interview Template, Final Paycheck Tracker, HR Form | Excel Google Sheets
$14.00
This listing
Employee Schedule Template Google Sheets & Excel, Weekly, Monthly Shift Planner, Staff Rota, Coverage, Work Hours, Small Team Roster
Sale Price $10.20
Original Price $12.00
15% off "buy together" offer
Digital Download
-
Digital download
Monthly Excel Employee Schedule | Staff Roster with Payroll, FTE & Leave Tracking
Sale Price $9.98
Original Price $16.64
-
Digital download
Monthly Employee Shift Schedule Staff Roster (Excel & Google Sheets)
Sale Price $7.74
Original Price $11.92
-
Digital download
Employee Schedule Template, Digital Download, Editable & Easy to Use, Google Sheets Shift Planner
Sale Price $5.00
Original Price $10.00
-
Digital download
Employee Monthly Schedule Template Excel, Google Sheets, Staff Timetable, Work Planner, Editable Shift Schedule,
Sale Price $4.82
Original Price $13.77
-
Digital download
Weekly Roster Excel Template, Employee Shift Scheduler, Staff Rates Planner
$15.92
-
Digital download
Google Sheets Employee Roster Template | 4-Week Shift Planner & Staff Schedule
Sale Price $7.37
Original Price $12.29
-
Digital download
Professional 4-Week Excel Roster Template: Rotating Shift Planner for Staff Management
Sale Price $8.68
Original Price $14.46
-
Digital download
Excel Template for Roster Management and Scheduling: Shifts, Employee List and Cost/Rates Calculation
$15.92
-
Digital download
Excel Employee Shift Roster Template | 4, 6 & 8‑Week Rotating Schedule Planner for Workforce and Staff Scheduling
Sale Price $17.36
Original Price $28.94
-
Digital download
Weekly Staff Schedule Template with Overnight Shifts: Printable Employee Planner (Google Sheets, Excel)
$10.99
-
Digital download
Employee Schedule Template, Working Hours Excel Google Sheets Spreadsheet, Employee Timetable, Weekly Work Schedule, Shift Schedule Template
Sale Price $6.34
Original Price $10.56
-
Digital download
Employee Scheduling Tool: Restaurant Shift Tracker (Excel & Google Sheets)
$19.99
Shoppers with similar taste loved these
-
Custom Steel Blade Sign for hanging outdoor, wall mounted metal crafted business sign
Sale Price $219.26
Original Price $313.23
-
A Frame Sign, Double Sided Sign, A Board Pavement Sign, Sign For Cafes, Exchange Offices, Barbershop, Sidewalk Sign, Custom Store Sign
Sale Price $53.03
Original Price $106.06
-
Custom A-Frame Mirror Sign, Stainless Steel Sidewalk Cafe Display Board, A-Frame Sign for Coffee Shops.
Sale Price $187.06
Original Price $398.00
-
Metal A Frame Sign, Sidewalk Sign, Sandwich Board Sign For Businnesses, Modern Custom Sign, Pavement Sign, A Frame Easy Set Up, Shop Sign
Sale Price $35.00
Original Price $50.00
-
A Frame Sign, Double Sided Sign, A Board Pavement Sign, Sign For Cafes, Exchange Offices, Barbershop, Sidewalk Sign, Custom Store Sign
Sale Price $184.80
Original Price $264.00
-
Brushed Stainless Steel A Frame Sign, Minimal Sidewalk Sign, Custom Metal Sandwich Board, Modern Business Storefront Sign
Sale Price $15.40
Original Price $22.00
-
A Frame Sign, Double Sided Sign, A Board Pavement Sign, Sign For Cafes, Exchange Offices, Barbershop, Sidewalk Sign, Custom Store Sign
Sale Price $180.00
Original Price $300.00
-
Light Box, Brand Sign, Illuminated sign, Backlit Box Sign, Restaurant Cafe Shop Sign, Business Custom Sign, Outdoor Metal Sign, Round Sign
Sale Price $131.40
Original Price $146.00
-
3D Logo BACKLIT Sign | Backlit Sign | Neon Business Sign | Led Sign | FREE SHIPPING | Custom Acrylic Business Sign | Wall Sign
Sale Price $12.48
Original Price $24.96
-
Custom Round Sign, Circle Custom Sign, Custom logo Sign, Custom Wood Logo Sign, Custom Wood Words, Custom Round Logo Sign, Round Logo Sign
Sale Price $74.20
Original Price $140.00
-
Custom Round LED Light Sign: Outdoor Business Logo Display
$321.74
-
Custom Double Sided Blade Sign, Illuminated Storefront Logo Display, Exterior Round Light Box, Outdoor Business Signage
Sale Price $72.00
Original Price $90.00