All services

Free template · Excel & Google Sheets

Free weekly staff schedule template

Plan who works when, at a glance. Pick a shift for each person and day: the colors, days worked and staff on duty update on their own.

  • No macros
  • Sample data included
  • Print-ready
Download free ↓
Free weekly staff schedule template: Sample data is fictional.
Sample data is fictional.Save on Pinterest

Get the free template

Free, instant download. Tell us a little about you so we only send what’s useful.

Your details stay with us. No spam.

What’s inside

  • A week grid for up to 15 people, Monday to Sunday, with the dates filled in
  • Shift drop-down (morning, afternoon, evening, full day, off, leave) with colors
  • Days worked per person and staff on duty per shift and per day
  • A day with fewer than 2 people on duty turns red
  • Shift names and hours you can rename in one place
  • Landscape print on one page, with a “How to use” tab

Who it’s for

  • Restaurants, cafés and bars
  • Shops, salons and clinics
  • Any team that works in shifts

Google Sheets version. The Google Sheets copy is the same template without Excel “table” objects, which Google Sheets doesn’t convert cleanly: lists use plain formatting, banded rows and a filter instead. Formulas, drop-downs and colors work the same. Print settings are chosen in File → Print.

How to use it

  1. 1Download the file and open it in Excel, Google Sheets or Numbers.
  2. 2Type your business name and the Monday of the week.
  3. 3Set your shift names and hours in the legend, then list your staff.
  4. 4Pick a shift for each person and day from the drop-down.
  5. 5Check staff on duty, print it or share it. Copy the tab for next week.

Custom version

Want it customized for your business?

Want it automated for your business (dashboard, alerts, macros, connected to your data)? We build the custom version for you, at a fixed price.

For example: hours and overtime per person, labor cost per day, several weeks and locations, conflicts with time-off requests flagged automatically.

Formulas, macros & spreadsheet automation

from$5924 h delivery
See the service →

Also useful: Workflow automation (n8n, Make, Zapier) · from $199

Questions

How do I make a weekly staff schedule in Excel?

Open this template, type the Monday of the week, list your staff, then pick a shift for each day from the drop-down. The colors, days worked and staff on duty update on their own.

Can I change the shift names and hours?

Yes. Rename them in the legend under the schedule: the drop-downs and colors follow. Keep “Off” and “Leave” as the last two.

How do I make next week’s schedule?

Right-click the tab → Move or Copy → Create a copy, then change the Monday. The dates update by themselves.

Does it calculate hours and overtime?

This free version counts days worked and staff on duty. Hours, overtime and labor cost per person are what the custom version adds.

Does it work in Google Sheets?

Yes. Download the Google Sheets copy and open it from Google Drive with Google Sheets.

More free templates