Excel template

Student Attendance Register (Excel)

The class register you know, in Excel. Type the month once and the sheet shows the right dates and shades the Sundays. Mark P (present), A (absent) or L (leave) and each student's days present, absent, on leave and attendance percentage calculate themselves. Low attendance is highlighted.

Download Attendance register workbook .xlsx · 20 KB

Free · no sign-up · opens in Microsoft Excel, Google Sheets, LibreOffice and WPS Office. Files contain no macros.

Preview

Real view of the file with its sample data (yellow cells are where you type).

Roll

Name

Aarav Sharma

Ananya Singh

Ishaan Verma

Diya Kaur

Kabir Gupta

What's inside

Monthly grid for up to 60 students with roll number and name
Dates and weekdays fill in from the month you choose; Sundays and days after month end are shaded
P / A / L drop-down in every cell
Totals per student and per day, and attendance percentage with a red highlight below 75 percent

How to use it

Type your school or centre name, class and the first day of the month at the top.
Type the roll numbers and names of your students.
Each day, mark P, A or L in that day's column (you can also just type the letter).
Totals and percentage update as you go.
At month end, print on A4 landscape or save as PDF. For the next month, save a copy and clear the marks.

Tips

Copy the student list into the next month's copy so you only type it once a year.
Change the 75% warning level in the Settings box if your school uses a different rule.
Leave holidays empty: only marked days count towards the percentage.

Questions and answers

How is the percentage calculated?

Days present divided by days marked (present + absent + leave). Empty days are not counted.

Should leave count as absent?

The template counts leave as not present, which is the usual school practice. If your school counts approved leave as present, mark those days P.

Can I use it for staff attendance?

Yes. Replace roll numbers with employee codes.

More in the Teachers & Tutors toolkit

Marks Sheet & Report Card (Excel)Free Excel result sheet: enter marks for up to 6 subjects and 60 students; totals, percentage, grade, rank and pass/fail…Excel templateTuition Fee Register (Excel)Free Excel fee register for tutors and coaching centres: students, fee payments, a month-by-month paid grid, total dues …Excel templateOnline Report Card MakerMake a student report card online: subjects, marks, percentage, grade and remarks. Print, save as PDF or download as Exc…Online tool

Also useful

GST Invoice Template (Excel)Free GST tax invoice template for Excel. Pick a customer and items; it fills HSN, rates, CGST+SGST or IGST and the amoun…Excel templateGST Monthly Summary (Excel)Free Excel workbook that totals a month's sales and purchases by GST rate: taxable value, IGST, CGST, SGST, B2B and B2C,…Excel templateClient Dues & Ageing (Excel)Free Excel receivables tracker: list bills and receipts, see each client's balance by age (not due, 1-30, 31-60, 61-90, …Excel template