Squadra PlanningSquadra

Free employee schedule templates for Excel and Google Sheets

Three templates you can use today: a weekly schedule that adds up hours and deducts breaks, a monthly grid by shift code, and a four-team rotating cycle. Download the Excel file or make a copy in Google Sheets. No sign-up, no watermark, no macro.

Weekly employee schedule template

Stores, cafes and restaurants that plan one week at a time.

One row per employee, clock-in and clock-out per day, unpaid break deducted, hours for the week added up automatically. Handles overnight shifts. Dates update from the week start date.

Monthly employee schedule template

Teams that plan by shift code (morning, afternoon, evening) rather than by exact times.

A grid of 31 days per employee with one-letter codes, counts of shifts, days off, vacation and sick days per person, and a line showing how many people are on shift each day.

Rotating shift schedule template (4 teams, 4-week cycle)

Operations that run early, late and night shifts with teams that rotate.

Team A holds the pattern for 28 days; teams B, C and D follow with a one-week offset. Change one cell and the whole rotation updates. Counts of day, swing and night shifts per team, and coverage per day.

How to use the weekly template

  1. Enter the Sunday that starts the week in cell B2. The dates above each day update on their own.
  2. One row per employee. Type clock-in and clock-out times as 9:00 AM and 5:30 PM. Leave both blank for a day off.
  3. Column Q is the unpaid break deducted from every shift (30 minutes by default). Set it to 0 if breaks are paid.
  4. Column R adds the week per person, breaks deducted. Anything over 40 is overtime under federal law; some states add daily thresholds, California after 8 hours in a day.
  5. Duplicate the sheet for next week and change B2.

Federal law does not require breaks, but about 20 states do: see break laws in the US before deciding what goes in the break column. To split regular hours from overtime and get gross pay, use the time card calculator.

What a spreadsheet does not do

A template holds the plan. It does not warn you that Friday's closer opens on Saturday with nine hours of rest, it does not tell the team the schedule changed, and it lives on one computer while the team is on the floor. The method for building the schedule itself is in how to make a work schedule for a small business. When the file starts changing several times a day, the online schedule maker does the same job as the weekly template with the team on the link, and the free scheduling software page explains what changes: the schedule is shared as a link, the team opens it on their phone without an account, and breaks and hours are checked as you type. In the UK? The same files, with UK vocabulary and rules, are on the staff rota templates page. Need the hours side rather than the schedule? The timesheet templates (weekly, biweekly, monthly time card, availability form) are the matching set. Running 24/7 with 12-hour shifts? The named rotations, with a calendar you can date and a template each, are under 12-hour shift schedules: 2-2-3, DuPont, 4 on 4 off.

Frequently asked questions

How do I make an employee schedule in Excel?
Start from the weekly template: one row per employee, two columns per day for clock-in and clock-out, a break column and a formula that adds the week. Enter the week start date once and the day headers update. Duplicate the sheet for the next week.
Do these templates work in Google Sheets?
Yes. Each template has a "Copy to Google Sheets" link that creates your own editable copy in your Google Drive. Formulas, formats and the instructions tab come with it. The sheets are set to the United States locale.
Does the weekly template calculate overtime?
It adds the hours for the week per person, breaks deducted, so hours over 40 are visible in the total. It does not split regular from overtime pay: for that, use the time card calculator, which also applies California daily rules.
Can I add more employees or days?
Yes. Insert rows for more employees and copy the formula in the hours column down. The monthly template covers 31 days and blanks out days that do not exist in the month. The rotating template covers a 28-day cycle; copy the sheet for the next cycle.
When should I stop using a spreadsheet for scheduling?
When the schedule needs to be on the team's phones, when someone has to check breaks and rest between shifts, or when swaps and call-outs mean the file changes several times a day. A spreadsheet holds the plan; it does not tell anyone the plan changed.