Free Attendance Sheet Template (Excel) and How to Use It
Download a free attendance sheet template for Excel: 20 lessons, 30 students, color-coded codes and automatic attendance rates, plus a guide to using it well.
In this article
- What the free attendance sheet template contains
- How to set up the template for a new class
- How to take attendance in under a minute
- Attendance rules to agree on before the first lesson
- How to read the attendance rate and when to act
- The limits of a spreadsheet attendance sheet
- How Zolinex handles attendance
An attendance sheet template is a ready-made spreadsheet in which a teacher records, for every lesson, which students were present, late, absent or excused. Our free attendance sheet template for Excel covers 20 lessons and 30 students, colors each entry automatically and calculates every student's attendance rate for you. Download the attendance sheet template (.xlsx); it opens in Excel, Google Sheets and LibreOffice Calc.
In short
- The file has one attendance sheet (20 lessons, 30 students, four codes with drop-downs and automatic colors) and one sheet with instructions.
- The attendance rate is (present + late) ÷ (present + late + absent), so excused lessons never count against a student.
- Agree on your rules for late arrivals and excused absences before the first lesson, and take attendance in the first minutes of every lesson.
- A spreadsheet works well for one class; with several classes and teachers, separate files, manual totals and shared copies become the weak point.
What the free attendance sheet template contains
The file is deliberately simple: two sheets, no macros and nothing to install. You can use it as it is or change the labels to match your school. Download the free attendance sheet template for Excel and keep the original as your blank master.
Sheet 1: “Attendance”
- Header fields: Course, Teacher, Group / level and Month / term, so you can tell your files apart at a glance.
- 20 lesson columns, numbered 1 to 20. Above the student list is the “Date” row, where you write the date of each lesson.
- 30 student rows, each with a number and the student's name.
- A drop-down in every lesson cell with the four codes P, L, A and E. The cell is colored automatically: green for present, amber for late, red for absent and grey for excused.
- Automatic totals per student: four columns (Present, Late, Absent and Excused) count each code, and the Attendance rate column shows the rate in percent.
- A count per lesson: the bottom row, “Present per lesson”, shows how many students were present in each lesson.
Sheet 2: “How to use”
The second sheet contains the legend of the four codes and short step-by-step instructions. A colleague or substitute teacher can pick up the file and use it without asking you how it works.
The four attendance codes
Each code has one meaning and one fixed effect on the attendance rate:
| Code | Meaning | When to use it | Effect on the attendance rate |
|---|---|---|---|
| P | Present | The student attended from the start or arrived within your agreed grace period. | Counts as attended. |
| L | Late | The student arrived after the agreed limit but still took part in the lesson. | Counts as attended; also appears in the late total. |
| A | Absent | The student missed the lesson without an accepted reason. | Counts as missed and lowers the rate. |
| E | Excused | The student missed the lesson for a reason you accept, for example with notice given in advance. | Left out of the calculation; does not lower the rate. |
How the attendance rate is calculated
For each student, the template uses this formula:
Attendance rate = (present + late) ÷ (present + late + absent)
Excused lessons are not part of the formula, and neither are empty cells, such as lessons that have not taken place yet. Take a hypothetical student with 14 lessons present, 2 late, 2 absent and 2 excused: the rate is (14 + 2) ÷ (14 + 2 + 2) = 16 ÷ 18, or about 89 percent. The two excused lessons neither help nor hurt.
How to set up the template for a new class
Setting up the file for a new group takes about ten minutes. Do it before the first lesson, not during it.
- Save a copy for each class. Keep the downloaded file as your blank master and save a copy per group with a clear name, for example “B1-evening-autumn-2026.xlsx”.
- Fill in the header. Enter the Course, Teacher, Group / level and Month / term.
- Add your students. Type or paste the names into the student rows, for example in alphabetical order. If the list already exists in another spreadsheet, copy and paste it instead of retyping it. Leave unused rows empty.
- Enter the lesson dates. If your schedule is fixed, write all dates into the “Date” row in advance. Otherwise, add each date on the day of the lesson. Public holidays and breaks simply get no column.
- Agree on the codes with your team. If several teachers share a class, make sure everyone uses P, L, A and E in the same way (see the rules below).
If a course runs longer than 20 lessons, start a new copy for the next block, for example one file per month or per term. For a group of more than 30 students, use a second copy for the remaining names.
How to take attendance in under a minute
The best moment to take attendance is the first two or three minutes of the lesson, before the teaching starts. Attendance recorded “after class” tends to be incomplete, because by then something else always seems more urgent. With this routine, a typical group takes less than a minute:
- Open the file before the students arrive and check that today's date is in the date row.
- Go down the column for today's lesson. Pick the code from the drop-down, or simply type the letter and press Enter to move to the next student.
- For a large group, type P for the first student, copy it down the column and then change only the exceptions.
- When someone arrives late, change their A to L.
- After the lesson, change an A to E only if the student's reason meets your rules for excused absences.
In online lessons, the participant list of your meeting tool is a useful checklist, but still mark attendance yourself at the start of the session instead of reconstructing it from a log later.
Attendance rules to agree on before the first lesson
The template can count, but it cannot decide what counts. Write down a few rules, share them with your students (and with parents or guardians for minors) and apply them in the same way in every class.
When is a student late?
Choose a clear limit, for example “more than ten minutes after the start counts as late”. Also decide whether there is a point after which a late arrival counts as absent, such as arriving after half of the lesson. Because L counts as attended in the rate, the late total is where frequent lateness becomes visible, so look at it as well.
What counts as excused?
- Which reasons you accept, for example illness, a family emergency or an exam at school or university.
- How and by when students must tell you, for example before the lesson starts.
- Who decides whether an absence is excused: the teacher or the office.
- Whether a notice that arrives after the lesson can still turn an A into an E.
Record only the code. The reason itself, especially a medical one, does not belong in an attendance sheet that other people can open.
Make-up lessons and online attendance
Decide whether a make-up lesson replaces the missed one in the record or is noted separately. For online lessons, define what counts as present: joining at the start, staying for most of the session or taking an active part.
How to read the attendance rate and when to act
The figures in the template are only useful if someone looks at them. A quick weekly look at the totals takes two minutes and is enough for most classes.
Per student
The rate column shows how much of the course a student has actually attended. Look at the codes behind it, too. A student with a good rate but many late arrivals, or with a long list of excused absences, may still be missing important content.
Per lesson
The bottom row shows how many students were present in each lesson. A clear dip on a single date often has an outside cause, such as an exam week or a holiday weekend. A downward trend over several lessons is a different signal: the pace, the level or the time slot may no longer suit the group.
Suggested follow-up rules
The following are suggested rules of thumb, not research findings. Adapt them to your school:
- After one absence: let the student know what was covered and where to find the materials.
- After two absences in a row: contact the student personally with a short, friendly message asking whether everything is all right.
- When the rate falls below your own threshold, for example a minimum attendance you require for a certificate: talk to the student early, while the minimum can still be reached.
- For minors: inform parents or guardians in the way you agreed at enrollment.
Our attendance tracking guide explains how to write an attendance policy and how to word absence messages so that they sound supportive rather than accusatory.
The limits of a spreadsheet attendance sheet
For one teacher with one or two groups, a spreadsheet is a perfectly good tool. Once several classes and teachers are involved, its weak points show:
- One file per class. Ten groups mean ten files, each with its own copy of the student list to keep up to date.
- No student view. Students cannot check their own attendance. They have to ask, and disagreements about a missed lesson are harder to settle.
- Manual totals across classes. To see the attendance of a whole department, or of one student across several courses, someone has to copy figures from file to file by hand.
- Sharing and versions. Files sent by email multiply, and two people editing different copies end up with conflicting versions. A shared cloud file helps, but anyone with the link may see or change everything in it.
- Data protection. An attendance sheet contains personal data about identifiable students. Under data protection laws such as the GDPR (EU/UK), you should limit who can open the file, record no more than you need and delete it when you no longer need it. This is general information, not legal advice; check the rules that apply to you with an expert.
When these issues start to cost more time than the spreadsheet saves, our guide to moving from spreadsheets to a management system shows how to plan the switch.
How Zolinex handles attendance
In Zolinex, attendance is part of each course. Teachers take attendance per lesson with the same four statuses as the template (present, absent, late and excused) and can add notes. Students see their own attendance in their portal, so there is less to discuss when a lesson is disputed, and teachers see attendance rates without maintaining formulas. Unlike the template, Zolinex calculates the rate over all marked lessons, so an excused absence counts as not attended. Because the students are added to the course once, there is no separate list to update in every attendance file. Zolinex runs in any modern browser on a phone, tablet or computer, and if your student list is already in a spreadsheet, you can bulk import students from Excel or CSV. Attendance sits next to homework, exams and certificates in the same course. See all features.
Download the template, set it up for your next class and make attendance the first thing you do in every lesson. Whether you stay with the spreadsheet or move to software later, clear codes and agreed rules are what make the figures reliable.
Frequently asked questions
How do I make an attendance sheet in Excel?
Create one row per student and one column per lesson, add a date row above the lesson columns and use data validation to offer a drop-down with your codes, such as P, L, A and E. Add COUNTIF formulas at the end of each row to total each code and calculate the attendance rate. If you would rather not build it yourself, a free template with all of this already set up saves the work.
How do you calculate an attendance percentage?
Divide the number of lessons a student attended by the number of lessons that count, then multiply by 100. In this template, the attendance rate is (present + late) ÷ (present + late + absent), so late arrivals count as attended and excused absences are left out. For example, a student who attended 16 of 18 counted lessons has an attendance rate of about 89 percent.
Can I use the attendance sheet template in Google Sheets?
Yes. The template is a standard .xlsx file that opens in Microsoft Excel, Google Sheets and LibreOffice Calc. To use it in Google Sheets, upload the file to Google Drive and open it from there. Before you share the file with colleagues, check who has access to it, because an attendance sheet contains personal data about your students.
Should late arrivals count as present?
In this template, late arrivals count as attended in the attendance rate but are totaled separately, so frequent lateness stays visible. Agree on a clear limit, for example more than ten minutes after the start, and decide whether arriving after a certain point, such as half of the lesson, counts as an absence. Then apply the rule in the same way for every student.
When should a teacher follow up on student absences?
React early. A practical rule is to share the missed content after one absence, contact the student personally after two absences in a row and talk about solutions if absences form a pattern or a required minimum attendance is at risk. For minors, inform parents or guardians as agreed at enrollment. These are suggested rules, not fixed standards, so adapt them to your school.