2023 School Attendance Register – Free Google Sheet Template

This template is a simple version of the Student Attendance Register and Report. The highlights are 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students. 

This template is designed for Google sheets, but if you are looking for an Excel template, please visit the SchoolAttendance Register and Report in Excel.



How to create a School Attendance Register in Google Sheets

Steps to use this template:

  1. Make a Copy 
  2. Enter the Input Data
  3. View the Class Attendance Report and Student Attendance Report

Step 1: Make a copy of the sheet

Click on the link above and then make a copy of the sheet as shown in the screenshot below.

Make a copy
Make a copy

You can save the copy in your own google drive for your use. You can then share the copy with your colleagues to collaborate as needed.

Step 2: Enter the Input Data

Enter information in the Settings worksheet

Attendance Register Template – Settings Information


Attendance Register Format in Google Sheet – Enter Holidays
School Attendance Register Template – Set Weekends for school

Enter information in the Attendance Register daily

Attendance Register Format in Google Sheets


Step 3: View and print Class Attendance Report when needed

Class Attendance Report Format
Printable Student Attendance Report


Please let me know if you find this useful or if your requirements are not captured in this template. 

Exit mobile version