School Attendance Register and Report – Free Excel Template
Manage student attendance at schools and educational institutions using this simple free Excel template.
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?
- Enter information in the Settings worksheet
- Enter information in the Attendance Register daily
- View and print Class Attendance Report when needed
- 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
- 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
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
- 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
- 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.
Related Templates
Recommended Templates
-
Excel Calendar Template – Excel Calendar 2024/2023 or any yearOriginal price was: $25.$20Current price is: $20. -
Student Attendance Register – Excel Template$15
-
Student Attendance Register – Google Sheet Template$15
211 Comments
Hello sir
You are doing good work .
I have a question .
We have 9 class in school
How can we add more class in sheet ?
Thank you
Thanks for the feedback.
The template is to track attendance for one class. To track for multiple classes, you can create a copy of the file for each class.
Best wishes.
Hi, Yes its very interesting, but I have two major problem. First, I have more than 50 student, can I add more than 50?. Second I need a report shows the Absent for each students by month? can you make this changes?
Thanks and very nice work
Thank you. Please see the https://indzara.com/product/student-attendance-register-excel-template/ template for supporting more than 50 students. The report sheet shows the monthly count for each attendance tracking value.
Best wishes.
Hello indzara,
Your template is very functional. I use it to register attendance to my UHD classes. But, in some classes i have double lectures which the template does not have option for. How can I modify the template to be able to register double lectures?
Thank you in advance
Thank you.
Please see the https://indzara.com/product/student-attendance-register-excel-template/ which allows tracking 2 attendances per day.
Please let me know if there are any questions. Thanks. Best wishes.
its Awesome but i have 150 student and this file consisted of only 50 student so plz help me….
Thanks. Please try https://indzara.com/product/student-attendance-register-excel-template/ which allows 200 students. Best wishes.
Hi, Yes its very interesting, but I have two major problem. First, I have more than 50 student, can I add more than 50?. Second I need a report shows the Absent for each students by month? can you make this changes?
Thanks and very nice work
Thank you. Please see Student Attendance Register template https://indzara.com/product/student-attendance-register-excel-template/ which allows 200 students. It has student report and class report. Please see the product page for specific details and screenshots. Thanks. Best wishes.
Hi there,
This is a brilliant attendance spreadsheet! We run a small Saturday and Sunday school and this works very well for us as the spreadsheets allows to filter out weekdays.
I just wanted to ask if there is a way of adding another field to record student ‘authorised absence’ (AA). This would be for hospital appointments or exceptional circumstances where it would not effect students overall attendance as this is beyond their control.
Thank you for sharing…
Many thanks.
Thank you for the great feedback.
Please see Student Attendance Register template https://indzara.com/product/student-attendance-register-excel-template/ which allows customizing up to 5 different tracking values and assigning whether to count as attended or not. Please let me know if there are any questions. Thanks. Best wishes.
sorry My email is bensone28@yahoo.co.uk and was written without 28 in previous message
Please feel free to edit the file with the password indzara. Best wishes.
Thank you very much I got it, all the best
You are welcome. Best wishes.
Hi it is very very good well done for the job.
I like to use this template and wanted to add up something like term attendance report but no way to make a change it is protected.
Here there is only yearly report and how should I build a first, second and third report before using your one as the last main report
Please help me
HI the template is just too good. we have attendance on hourly basis can that be modified on the template. and more number of students be added
The Student attendance register https://indzara.com/product/student-attendance-register-excel-template/ supports 2 attendances per day. I am sorry I don’t have one that tracks hourly attendance. Best wishes.
whats the password to unprotect it
Please use indzara as password. Thanks & Best wishes.