In this article:

Free Roster Template for Google Sheets (2024 Update)

May 8, 2024

Free Google Sheets Roster Template

You can make a copy of this roster template in Google Sheets for free. Don't request for permission to edit, simply go to File > Make a copy.

roster template google sheets

How to Use the Roster Template in Google Sheets

Below we explain how to use our roster template in Google Sheets:


Enter the full name of the individual.


Specify the role or position of the individual within the team or organization. This could vary greatly depending on the context (e.g., Forward in a sports team, Volunteer in a charity event, Team Leader in a project).

Email Address

Provide the email address of the individual for communication purposes.

Phone Number

Enter the contact phone number. It's advisable to format phone numbers consistently (e.g., using dashes or spaces).


Specify the days and times the individual is available. This is especially important for scheduling shifts or meetings. Be as detailed as necessary for your context.


Use this column for any additional important information relevant to the individual or their role. This could include dietary restrictions, qualifications like CPR certifications, or other pertinent details.

Below are some sample entries for your reference: 

google sheets roster template

We hope that this article has helped you and given you a better understanding of how to use our free Google Sheets roster template. If you enjoyed this article, you might also want to check out our password manager template and portfolio tracker in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->