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
sir please add register number, birth date, cast, 40 holidays list and need 90 students register also add cast category example : OBC, NT, DT, SC, OPEN
Thanks. Please email me at indzara@gmail.com if you need customized template. I can let you know the cost once I understand the specific requirements. Best wishes.
आपका कार्य अच्छा है. विद्यालय के हिसाब से इसमें कई कमियों भी हैं . जैसे 1 दो पारी उपस्थिति 2 कार्य दिवस की संख्या 3 अवकाश 4 अधिक छात्र संख्यां 5 आधे दिन की उपस्थिति 6 सत्र के बीच मै प्रवेश / त्याग 7 स्त्तम्भ मे घोषित अवकाश का विवरण . ये कमियां दूर करैं तो काफी अच्छा रहेगा .
Thanks for feedback. Best wishes.
how to you change the value for P, L, and A?
Plus when I look at the class attendance report I says #Div/0!
Please email the file to indzara@gmail.com and I will take a look why the error is appearing. Thanks & Best wishes.
The template https://indzara.com/product/student-attendance-register-excel-template/ allows modifying the values easily. Thanks & Best wishes.
thanks a lot for sharing
You are very welcome. Best wishes.
this is 2016 and from the part of the world i come from this is like the future lol thank you boss
You are welcome. Best wishes.
Can you please tell me how to fix the “Error: Please enter only dates for holidays” message? I have entered only dates, but the entries do not resolve the issue.
Please ensure that it is in DATE format (from the cell format menu at the top). Sometimes it may appear as date in the cell, but Excel will accept only certain date formats. And they also may vary with different country versions of Excel. If the issue continues, please email me the file (indzara at gmail dot com) and I will look into it. Thanks.
Comment…sir mujhe attendance sheet par absent aur present ka fomulas chahiye p sur a ko count kis trha karte hai
Thanks. You can see all the formulas in the sheet. Please unlock sheets using the password indzara and you can see the formulas. Hope this helps. Best wishes.
hiii sir please provide unprotect sheet password
You can unlock using ‘indzara’. Thank you.
Hi, please can you send me a template which allows you to work with each day split into AM and PM? I am aware that others have asked the same question and I just cannot work out how to change this myself.
Wonderful work, thank you so much!
Thanks for your message. Can you please review this template
https://indzara.com/product/student-attendance-register-excel-template/ ? It addresses attendance taken once or twice per day. Please let me know if there are further questions.
Hi, i find your templete very helpful for my school.And Thank you very much for providing it free download.
But i have a little problem with the “End date”. I could not customise it in setting. Even though i change the date in the setting, it doesn’t change in ” class attendence report and student attendence report”.
Note: my school’s academic session is winterly basis..i,e january -december.
Sir please help me in sorting out this issue. Thank you
I am glad that it is helpful for your school. You are welcome.
The Template shows only data until today in the Class Attendance Report and Student Attendance Report. For example, since it is Jan 24th today, it will only show until January and will not show February. That’s because Feb has not happened yet. In a couple of weeks, you will see February automatically appear. Everything seems to be working as designed. If this does not address your concern, please e-mail your file and I can look into it.
Thanks & Best wishes,