Reviewed & updated by WordNExcel Team — Updated November 10, 2026
An attendance list template is the quickest way to record who turned up, who was absent and who arrived late, and to turn those marks into an attendance percentage you can act on. Use the free attendance percentage calculator above for a quick answer, then download the Excel templates for day-to-day tracking. On this page you can download five free attendance list templates in Excel: a monthly attendance sheet for employees with P, A, L and H codes, a class attendance register for teachers, and an event and meeting attendance list with sign-in columns and turnout, plus a training session attendance register and a weekly staff attendance grid.
All five are real, editable .xlsx workbooks built for this page. They calculate totals and percentages automatically, use drop-down codes to keep entries consistent, and open in Google Sheets, LibreOffice Calc and Numbers as well as Excel.
Attendance Percentage Calculator
Runs in your browser; nothing is sent or saved.
Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.
What Is an Attendance List?
An attendance list is a record of who was present at work, at school or at an event on a given date. The simplest version is a list of names with a tick next to each person who attended. More useful versions record absences and late arrivals separately, show the reason for leave, and calculate an attendance rate for each person over a month or a term.
Employers use attendance records to manage absence, plan cover and support payroll. Schools use registers because attendance is closely linked to learning and is often reported to parents and education authorities. Event organizers use attendance lists to check guests in, measure turnout and follow up with people who registered but did not come.
How the Attendance Percentage Calculator Works
The calculator at the top of this page needs only two numbers: the total number of working days, school days or sessions in the period, and the number of days the person was present. It divides present days by total days to give the attendance percentage. Late arrivals are counted as present but shown separately as a punctuality rate. If you enter a required attendance target, such as 90 percent, it also tells you how many more days the person could miss and still meet it, or how many consecutive days of attendance they need to get back on target. Nothing you type is sent or saved; the calculation runs in your browser.
Download the Free Attendance List Templates
Each template is hosted on this website and free to download. The preview image shows the layout of each file.
1. Monthly Attendance Sheet for Employees

The monthly attendance sheet has one row per employee and one column for every day of the month. Enter the first day of the month at the top and the template fills in the day numbers and weekday initials automatically, hiding the extra columns in shorter months. Each day cell has a drop-down list with four codes: P for present, A for absent, L for late and H for holiday or leave.
Absences are highlighted in red, late arrivals in yellow and holidays in grey, so patterns stand out immediately. At the end of each row the template counts days present (including late), days absent and late arrivals, and calculates the attendance percentage, ignoring holidays and leave so that approved time off does not count against anyone. There is room for twenty employees, and it prints in landscape on one page.
2. Class Attendance Register for Teachers

The class register is designed for teachers and tutors. Enter the class, teacher, term and the date of the first session, and the column headers fill in the next twenty school days automatically, skipping weekends. List up to twenty-five students and mark a tick for present or A for absent in each session.
The Present column counts ticks for each student and the percentage column divides that by the number of sessions recorded so far, so the rate is accurate even partway through the term. Any student below 90 percent is highlighted in red, which helps you notice attendance problems early and talk to students or parents before they fall behind.
3. Event and Meeting Attendance List

For workshops, training sessions, conferences and meetings, the event attendance list records each guest’s name, organization, email, phone, whether they attended and a signature column for printed sign-in sheets. The summary at the top counts the number of registered guests, the number who attended and the turnout percentage. Choose Yes or No from the drop-down in the Attended column on the day, or tick names off on the printed sheet and enter the results afterwards.
4. Training Session Attendance

A register for a course or workshop that runs over several sessions. List each participant and department, then mark P, A or E for up to eight sessions; absences are highlighted and the last column counts how many sessions each person attended. The header holds the programme name and dates. Trainers and HR teams need this for certificates, CPD records and compliance courses where a minimum attendance is required. Print a copy for the trainer’s clipboard and keep the file as the official record.
5. Weekly Staff Attendance Grid

A one-week view of who is in. For each employee, mark Monday to Sunday with P (present), A (absent), SL (sick), AL (annual leave), OFF or H (holiday). The sheet counts days present, and leave or sick cells are colour-coded so the pattern is easy to see. Line managers fill it on Friday, and HR can paste a copy into a monthly file. It is lighter than the monthly attendance sheet when you only need the current week for the rota or a last-minute staffing decision.
How to Take Attendance With These Templates
- Choose the right template. Use the monthly sheet for staff, the class register for students and the event list for one-off sessions.
- Enter the period. Type the first day of the month or the first session date so the dates fill in.
- Add names once. List every person in the first column. Keep the same order every month so records are easy to compare.
- Mark attendance at the same time each day. Consistency matters. For staff, mark attendance at the start of the shift; for classes, at the start of the lesson.
- Use the codes consistently. Agree what counts as late, for example more than ten minutes after the start time, and what counts as approved leave.
- Review the percentages weekly. Look for people whose rate is falling and follow up early and supportively.
- Save a copy for each period. Save a new file for each month or term so you keep a complete history.
Calculating Attendance Percentage by Hand
The formula is simple: attendance percentage equals days present divided by total days, multiplied by 100. If an employee worked 19 of 22 working days, their attendance is 19 divided by 22, which is 86.4 percent. Most organizations exclude approved holidays and leave from both numbers, because the person was not expected to attend on those days. The monthly sheet in this post does exactly that by ignoring the H code in its calculation.
Tips for Fair and Useful Attendance Records
- Record facts, not judgments. Mark what happened, such as absent or late, and keep the reasons in a separate note or HR file.
- Separate authorized and unauthorized absence. Approved leave and sickness with notice are different from unexplained absence, and your records should show the difference.
- Look at patterns. Repeated Monday absences or regular late arrivals are easier to discuss when you can see them on one sheet.
- Protect privacy. Attendance records contain personal data. Store them securely and share them only with people who need them.
- Follow your policy. Make sure the rules you apply in the template match your written attendance policy or school rules.
Setting an Attendance Target
Many workplaces and schools set a minimum attendance target, often somewhere between 90 and 95 percent, and use it to decide when to check in with someone. A target is only useful if everyone knows how it is calculated. Write down whether late arrivals count as present, whether approved leave is excluded and over what period the rate is measured, such as a rolling month or a full term. Enter the same target in the calculator above to see how much room a person has left, or how many days of full attendance they need to get back on track. Use the result to start a supportive conversation, not as an automatic penalty.
Attendance List vs. Timesheet vs. Sign-In Sheet
An attendance list records presence or absence. A timesheet records the hours worked and is used to calculate pay. A sign-in sheet is a printed form that people sign themselves as they arrive. In practice many organizations use all three: visitors use a sign-in sheet at reception, managers keep an attendance list, and hourly staff complete timesheets for payroll. The event attendance list on this page doubles as a sign-in sheet because it includes a signature column.
You can also check these important templates like the sign-in sheet template for visitors and meetings, and the employee timesheet template for recording hours and overtime for payroll.
You may also like the timesheet calculator template for converting clock times into hours, and the school bus seating chart template for organizing students on school trips.
Frequently Asked Questions
How do I calculate attendance percentage?
Divide the number of days present by the total number of working or school days in the period and multiply by 100. For example, 19 present days out of 22 is 86.4 percent.
Are late arrivals counted as present?
In these templates, yes. Late arrivals count towards days present but are also counted separately, so you can track punctuality without treating late as absent.
Do holidays count against attendance?
No. Days marked H for holiday or approved leave are excluded from the monthly attendance percentage.
Can I use the attendance templates in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The drop-down codes, colors and formulas all carry over.
How many people can I track on one sheet?
The monthly sheet holds twenty employees, the class register twenty-five students and the event list thirty guests. Insert extra rows inside the table if you need more, and the formulas will extend.
