Skip to content
The title slide and first slides of the Volunteer Schedule template

Volunteer Schedule

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

The Volunteer Schedule helps a charity or community group plan who is needed and when. The Shifts tab lists each shift with its date, role, start and end times and the hours it comes to. The Volunteers tab keeps the people who help, their skills and the most hours they can give in a week.

The Dashboard totals the hours for each volunteer and for each role, and flags shifts that still need someone. It comes with sample data for six volunteers and fourteen shifts. Make a copy, replace the sample rows and add your own people. Hours, dropdowns and the charts update on their own.

Useful for

  • Filling a rota for a food bank, shop or event
  • Thanking volunteers with a record of the hours they gave
  • Spotting shifts that still have no one booked

What's included

  • 4 tabs: Dashboard, Shifts, Volunteers, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Shifts: a table
  • Volunteers: 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

Is this Volunteer Schedule template free?

Yes. Download the template and use it at no cost. There is no account to create.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. Hours are calculated from the start and end times in both Excel and Google Sheets.

What does a red shift mean?

A shift turns red when its date has passed and no volunteer is listed against it. It is a prompt to check whether the shift was covered.

  • #shift-schedule
  • #volunteer-schedule
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More shift schedule templates

See all 3

Also in Business operations

All business operations templates
Get this template

Preparing your template…