An attendance sheet records who was present, absent, or late across dates for class, training, shifts, or meetings. Excel templates make it easy to add dates as columns and names as rows. They do not magically compute payroll compliance—inspect any totals or percentage cells, or calculate by hand, before relying on them for official decisions.
Set up names, codes, and date columns deliberately
List participants in a stable order (alpha or team). Define codes such as P, A, L, E and put a legend on the sheet. Freeze header rows. Pre-fill known session dates so staff do not invent columns mid-course. For schools, include student IDs if required; for workplaces, use employee IDs consistent with HR systems.
Protect privacy: attendance can reveal health-related absences patterns—limit access. Do not publish full sheets publicly. When printing sign-in variants, leave signature space readable.
Capture attendance in the room, then reconcile
Have a single person responsible for marking each session. For sign-in sheets, watch for illegible names and ask for clarifications on the spot. Transfer paper sign-ins into Excel the same day when digital records are required. If formulas count “present,” verify they match your codes.
Correct errors with transparent notes rather than silent overwrites when records feed grades or pay. Keep dated backups.
Quick Template Comparison
These attendance sheets are mainly Excel files, with a few printable companions. Scroll the cards to compare how each grid records names, dates and attendance codes.
| Template | File format |
|---|---|
| Yearly Class Attendance Sheet Template | Excel (.xlsx) |
| Employee Attendance Sheet Excel Template | Excel (.xlsx) |
FREE Attendance Sheet Excel Templates are Given Below
Yearly Class Attendance Sheet Template

File Size: 423 KB
Employee Attendance Sheet Excel Template

File Size: 15 KB
Fillable School Attendance Sheet Report Template

File Size: 07 KB
Standard Attendance Sheet Template

File Size: 05 KB
Time and Attendance Sheet Excel Template

File Size: 08 KB
Use attendance data carefully
Managers and teachers should interpret patterns alongside context—do not weaponize a sheet without conversation. For compliance training, pair attendance with assessment results if policy requires proof of learning, not merely presence.
Retire sheets at retention-period end. Align category definitions across departments so “excused” means the same thing in every workbook.
Attendance sheets versus timesheets and call sheets
Timesheets track hours worked; call sheets direct film crews; attendance sheets track presence at sessions. Using one for the other’s purpose creates messy audits. Pick the sheet that matches the question you must answer.
For payroll or compliance uses, lock columns that should not be casually overwritten and keep an audit copy after each session. Attendance sheets that double as fire-roll lists should print clearly and stay at the exit clipboard. Train substitutes on abbreviations so “E” does not mean both excused and employed.
Delete leftover class lists, employee names and sample dates from the download before the sheet is used for a real session or week.
Keep a blank workbook as the starting point for later periods, and save each term or roster under its own filename so yesterday’s marks are not reused by mistake.
Ask someone who takes the register to fill one practice row and tell you whether the codes for present, absent and late are obvious without a sidebar explanation.
Confirm that the names, session dates and any group codes on the sheet match the official list or timetable you attach to it.
Hybrid classes complicate attendance: define whether camera-on remote presence counts and write it on the legend. For paid trainings, reconcile attendance with payment lists to spot seat theft. If using QR check-in, keep a paper fallback for outages. Managers should not use attendance sheets as a covert performance score without policy transparency. When absences cluster on the same weekday, ask about structural conflicts before assuming attitude problems. Export monthly summaries carefully so filtered hidden rows do not silently drop people. Attendance administration is dull until it is disputed—then good legends and timestamps earn their keep.
Setting up an attendance sheet in Excel
Put names in the first column, one person per row, with an ID column if names may repeat. Add dates across the top—each school day, each training session or each workday of the month. Use short, defined codes in the cells, such as P for present, A for absent, L for late and E for excused, and write the legend at the top of the sheet. At the end of each row, add totals for each code and, if you need it, an attendance percentage that you calculate and check yourself.
Lock the header row and the formulas so that only the attendance cells can be edited. This avoids accidental changes when several people fill in the same sheet.
Choosing the right template
The downloads include daily, weekly, monthly and yearly class sheets, school and child care attendance, employee and company weekly time and attendance sheets, meeting attendance, and training attendance sheets. A training sheet is often a one-off sign-in for a session, while a monthly class sheet tracks the same group over many dates. Employee time and attendance versions may include hours worked as well as presence.
Child care and school sheets often need parent or guardian contact columns kept separately and securely.
How you might code one week of attendance
This walk-through is hypothetical. It is not a real class or staff list:
Clear codes let anyone read the sheet without asking the person who filled it in. For planning who should be present in the first place, a work schedule template sits naturally alongside the attendance record.
Questions about attendance sheet templates
Should late arrivals count as present?
Follow your policy and code it consistently. Ambiguous marks destroy the sheet’s value for reporting.
Can students mark their own Excel attendance?
Risky without verification. Sign-in plus staff confirmation is safer for graded courses. Honor systems need clear rules.
Do I need formulas for percentage attendance?
Only if you verify them. Many templates are static grids. Manual counts are acceptable and often safer.
How do I make an attendance sheet in Excel?
List names in rows and dates in columns, add attendance codes with a legend, then add total columns with COUNTIF formulas for each code.
Can I print an Excel attendance sheet?
Yes. Set the print area, choose landscape orientation for wide date ranges, and use “Fit all columns on one page” so the sheet stays readable on paper.
What codes are used on attendance sheets?
Common codes are P (present), A (absent), L (late) and E (excused). Define your own list and keep it on the sheet.
