Skip to content
Restaurant Staff Schedule cover: a sample sheet with shifts planned, staff hours and dinner shifts and a bar chart, beside the Dashboard, Shifts and Staff tabs

Restaurant Staff Schedule

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The restaurant staff schedule is for owners and shift leads who staff a dining room and kitchen across lunch and dinner. The Shifts tab has one row per person per service, listing the station they cover, when they start and finish, and the hours worked out automatically. The Staff tab sets each person's weekly maximum and shows the hours booked and the spare time left, and the dashboard charts hours by station and by service.

Begin with the sample week for seven staff, then replace the names and stations with your own. Keep the station names matched to your floor plan so the station chart stays useful. A shift whose end time is not after its start turns red, which catches a late shift typed the wrong way round. Review the Staff tab each Friday before you publish the next week's rota.

Useful for

  • Staffing lunch and dinner service on a busy weekend
  • Keeping part-time servers under their weekly maximum
  • Showing how many hours each station needs in a week

What's included

  • 4 tabs: Dashboard, Shifts, Staff, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Shifts: a table
  • Staff: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Shifts tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How are the shift hours worked out?

Each row takes the start and end times and works out the gap in hours, so 16:30 to 22:30 gives 6 hours. A shift that finishes after midnight needs its hours typed in by hand, since the formula reads both times on one day.

Can I see the pay cost of the rota?

Not in this version. The template tracks hours and stations, not pay. Multiply the hours by each person's rate in a separate column or on your payroll sheet.

What happens when someone is over their maximum?

Their row on the Staff tab goes red, and the dashboard adds them to Staff over limit. Move a shift to someone with spare hours, and the count drops back.

  • #shift-schedule
  • #restaurant-staff-schedule
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More shift schedule templates

See all 9

Also in Human resources

All human resources templates
Get this template

Preparing your template…