Skip to content
Retail Shift Planner cover: a sample sheet with hours planned, peak-hour share and shifts planned and a bar chart, beside the Dashboard, Shifts and Team tabs

Retail Shift Planner

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

The retail shift planner is for store managers and supervisors who staff a shop floor through busy weekends and seasonal sales. The Shifts tab logs each shift with the person, role, whether it falls in a Peak or Quiet period, and its start and end times, with hours calculated for you. The Team tab sets each person's maximum hours, totals what is booked and shows the spare hours left, and the dashboard breaks hours down by role and by period.

Open with the sample shifts for Black Friday week, then type in your own team and rota. Mark the busy hours as Peak so the peak share on the dashboard reveals how much of the week falls at the busiest times. A person whose booked hours go past their maximum turns red on the Team tab, so move a shift before the rota is posted to the staff room.

Useful for

  • Covering the Saturday rush with enough cashiers and floor staff
  • Planning extra hours across a holiday sales week
  • Checking that part-time staff stay under their maximum hours

What's included

  • 4 tabs: Dashboard, Shifts, Team, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Shifts: a table
  • Team: 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 do I decide which hours count as Peak?

Use your own sales figures. Look at the busiest hours on your till reports, then mark the shifts that cover them as Peak. Weekend afternoons and the evenings before a holiday are common starting points, but check your own data.

Can I plan more than one store?

Yes, but use one copy per store. Each file has its own team list, so copies keep the hours and maximums apart. Rename each copy with the store name so the rota is easy to find.

Does the planner take breaks off the hours?

Not automatically. Hours are the time between the start and end, so take unpaid breaks off by changing the end time or the hours in that row. Check your store's rules on meal and rest breaks.

  • #shift-schedule
  • #retail-shift-planner
  • #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…