School Attendance Register and Report – Free Excel Template

Manage student attendance at schools and educational institutions using this simple free Excel template.

Class Register Excel Template - Class Attendance Report
Class Register Excel Template – Class Attendance Report

Benefits of the Class Register Excel Template

  • To use as an attendance register tool
  • To create class attendance reports
  • To create student attendance reports
  • Can be used in schools and educational institutes
  • Can also be used at work places to track employee attendance 

For more advanced features, please see Student Attendance Register Excel Template

This template is an upgraded version of the School Attendance Register and Report (Excel template). The enhancements are 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students.

Free Downloads – Class Register Excel Template

Features of the Class Register Excel Template

  • Can track attendance for up to 50 students 
  • Late attendance by students can be tracked (in addition to Present on Time and Absent)
  • Customizable academic window (up to 366 working days)
  • Choice for Weekends: You can choose which days of the week and which week days of a month are considered weekends (holidays).
  • Up to 20 school Holidays can be entered 
  • Customizable ‘pass requirement’ for attendance rate
  • Ready to print Class and Student Attendance Reports
  • Friendly features for easy data entry
  • Data validation and tips to help identify errors in data
  • No Macros

Video Demo – Class Register Excel Template


What is in the Class Register Excel Template?

The template has 4 worksheets.

  • Settings
  • Attendance Register
  • Class Attendance Report
  • Student Attendance Report

How to create student attendance registers in Excel?

  1. Enter information in the Settings worksheet
  2. Enter information in the Attendance Register daily
  3. View and print Class Attendance Report when needed
  4. View and print Student Attendance Report when needed
    • Choose a student name to print

To restart, create a new document or delete all the attendance register entries and start with Step 1.

Settings

Class Register Excel Template - Settings Information
Class Register Excel Template – Settings Information
  • Enter information in the fields shaded in light blue colour
  • Make sure that there are no errors in your inputs
  • Error messages will disappear after you correct them
  • Reports will not be accurate until all the errors are corrected
  • Choose your weekends and enter your holidays so that they will not be considered as working days
Attendance Register Format in Excel - Enter Holidays
School Attendance Register Format Excel – Enter Holidays
School Attendance Register Template - Set Weekends for school
School Attendance Register Template – Set Weekends for school

Attendance Register

Attendance Register Format in Excel
Attendance Register Format in Excel


Instructions on how to fill student attendance register

  • Enter Student Roll No.
  • Enter Student Name
  • Enter P for Present on Time, L for Present Late or A for Absent for each student for each day
  • Do not change the cells shaded in Gray colour as they have formulas
  • Student names should be unique


Class Attendance Report

Class Attendance Report Format
Class Attendance Report Format
  • Fully automated
  • Ready to print
  • School Information
  • Class information
  • Monthly and overall summary of Class Attendance
  • Month and overall summary of Students’ attendance
  • Students not meeting attendance requirements highlighted


Student Attendance Report

Printable Student Attendance Report in Excel
Printable Student Attendance Report in Excel
  • Fully automated
  • Ready to print
  • Customized for each student 
  • School Information
  • Class information
  • Overall and monthly summary of Student’s attendance
  • Students not meeting attendance requirements highlighted
  • Student’s daily attendance
    • Present On Time, Present Late, Absent, Holidays, Weekends and Not Entered

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

211 Comments

  • If we change the Begin Date and End Date to this new academic year to cover the dates from in 2024 to 2025 then it creates an error on the Class and Student Attendance Report. If we change it back to dates in 2023 to 2024 then it work again. It is as though it doesn’t like an end date in 2025

    Reply
    • Thank you for showing interest in our template.

      As per our email communication, we are glad that your concern has been resolved after entering the start date on or before the current date.

      Best wishes.

      Reply
  • Sir ,
    How can we enter Summer Holiday (20 May to 30 June) in this sheet,

    we can enter only 20 holidays in this sheet.

    Please Support

    Reply
    • Thank you for showing interest in our template.

      You can unprotect the sheet using the password indzara and add more rows in-between the holiday list (For example, between row 40 and 41) to increase the holiday limit.

      But usually the school starts after summer holidays and ends before summer holidays. Hence you can enter the begin and end date accordingly to avoid entering all dates in summer holidays.

      Best wishes.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *