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.
209 Comments
Hello sir,
How can I download two times in a day attendance excel sheet
Hello
In that case, each working day will have two sessions. alternatively, you can have one register for session 1 and another for session 2
best wishes
Hello,
You can use our premium template ” Student Attendance Register – Excel Template ”
https://indzara.com/product/student-attendance-register-excel-template/
It can handle more than one session
Best wishes
Hi great work, But here is possible to calculate prefix or suffix leave.
Hello
Please elaborate about what you mean by “Prefix”or “Suffix” leave.
Best wishes
Dear Sir/Madam
Thanks for your Fantastic Template. but in my class 65 Students, Its possible to increase 65 students in that excel template, and the attendance will calculate FN & AN Wise., (Twice a day), any solution for this, Waiting for your kind reply.
Thanks
Hello
Thank you for using the template.
The “Class Attendance Report” is formatted for 50 students only. In case you increase the count, the print for the report will get distorted. Hence, you can use two files, one for first 50 students and the rest in another file. Else you can try our premium template https://indzara.com/product/student-attendance-register-excel-template/
This supports more students.
Best wishes
Thanks for your excellent Template. But I am dealing with over thirty Classes and wished I could get a single Template/file which can Handle all the classes. Or otherwise I have to create single template for each class. That is over 30 Templates/Files. Thanks for the great work.
Hello
This template is designed to track attendance for one class. You can have maximum 50 students.
Best wishes
Respected Sir,
Suppose someone leaves school at the middle of the term, then How to manage attendance?
There is no built-in way to handle this scenario.
In the Student Attendance Register https://indzara.com/product/student-attendance-register-excel-template/ we have 5 possible tracking values. We can use one to represent ‘Not applicable’ and then use it when students start late or leave mid-way.
Please let me know if there are any questions.
Best wishes.
If a student starts mid-way, will using NA on days prior to start-date cause percentage to be calculated from start date?
hI IT wont let me add more students I have 25 students I need to add a few more but it wont let me
The template should allow 50 students. If there are further questions, please email file to support@indzara.com
Thanks & Best wishes.
Hi Indzara,
Great work and thanks for providing password, this made me to learn excel formulas.
Would it be possible to create one template for fee tracking for different classes and provide us to learn.
Appreciate your efforts
Thank you
You are welcome. Glad to hear.
Can you please specify what features are needed in fee tracking? I don’t have a template yet, but will try in the future.
Best wishes.
Won’t let me add a student or any data. But keep telling me ……………. is on a protected sheet. To make changes…………….. a password is required. what’s the password?
Hello
The password to un protect the sheet is indzara.
Best wishes
Hi Indzara, Great template. Is it possible to add another 2 function to the attendance Register section “not required” and “leave”. These would be omitted from the final calculation of attendance.
Many thanks Kylie
Thank you. Please see https://indzara.com/product/student-attendance-register-excel-template/ which allows customizing the attendance tracking values.
Please let me know if there are any questions.
Best wishes.
Hello
Thanks for the great and dynamic job. I am using this sheet for attendance in the University where there is semester system. I need to have the following information along with others to be printed:
1. Semester (Spring or Fall)
2. Subject Name
3. Session.
Also, information about :
1. Long (more than a month) winter vacation
2. Long (more than a month) summer vacation.
Please update this with these, although it’s alrady rocking in design, accuracy and flexibility.
Thanks
Sincerely
Abdur Rahman
You are welcome. Thanks for feedback.
Please try the Student Attendance Register template. https://indzara.com/product/student-attendance-register-excel-template/ which allows long list of holidays and multiple tracking options.
Best wishes.
Thanks alot. May you prosper in all walks of life.
You are welcome. Thanks for the wishes.
Best to you as well.
THANKS DEAR INDZARA.
I AM VERY GLAD TO SEE YOUR THIS TEMPLETE.
You are welcome. Thanks for feedback. Best wishes.