In this article:

Free Attendance Sheet Template for Google Sheets (2024 Update)

May 8, 2024

Free Attendance Template in Google Sheets

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

google sheets attendance template

How to Use the Attendance Template in Google Sheets

Below we outline the steps on how to use our attendance sheet template in Google Sheets:

Step 1: Enter Student Name and ID

Enter the name and ID of each student.

attendance template google sheets

Step 2: Mark Attendance Under the Date Columns

Each column represents each day of the week, except for Saturday and Sunday. Mark attendance with P (Present), A (Absent), L (Late), or E (Excused). 

attendance sheet template google sheets

Step 3:  Add Notes (Optional) 

Use this column to add any relevant notes for a student on a particular day, such as reasons for absence or other observations.

google sheets attendance template free download

Feel free to customize this layout based on your specific needs!

We hope that this article has helped you and given you a better understanding of how to use our attendance sheet template in Google Sheets. If you enjoyed this article, you might also want to check out our wedding guest list template and time tracking template 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 ->