Report this item to Etsy

Employee Schedule Template Google Sheets & Excel, Weekly, Monthly Shift Planner, Staff Rota, Coverage, Work Hours, Small Team Roster

Item highlights

  • Digital download
  • Digital file type(s): 1 ZIP

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).

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$12.00

Loading

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

Employee Schedule Template with weekly and monthly shift schedule spreadsheet cover image for Google Sheets and Excel, showing a preview of the sheet with feature labels.

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).

Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

TeamTimeToolsDesigns ·

United States

No reviews yet
·
0 sales
·
New on Etsy

Buy together, get 15% off

Bundle price: $33.15

View more items

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Oct 29, 2026