Direct download · XLSX checked with LibreOffice Calc
This free Excel template helps teams manage attendance sheet template. This free attendance sheet template for Excel 2026 helps course operations teams record learner attendance by session, maintain a roster, calculate attendance rates, and identify follow-up needs. The Excel template includes four worksheets: Dashboard, Attendance Log, Roster & Settings, and Instructions.
Use the populated sample records to understand the workflow, then enter operational data in the prepared roster and attendance rows.
Preview 1 — “Dashboard” sheet Click to enlarge
In practice
What this template helps you manage
✓
Keep session attendance organized: Record one row for each learner scheduled for each session, with fields for Record ID, Session Date, Session Title, Learner ID, Attendance Status, Scheduled Minutes, Attended Minutes, and Note.
✓
Reduce repetitive entry: Select a Learner ID from the roster, and the Attendance Log calculates the corresponding Learner Name and Group.
✓
Apply consistent counting rules: Present and Late count as attended sessions, Absent counts as a session but not as attended, and Excused is excluded from both counted-session and attended-session totals.
✓
Monitor learners against individual targets: Maintain a Target Attendance Rate for each learner and review calculated attendance results and follow-up statuses on the Dashboard.
How to use it
How to use the workbook
Start on Roster & Settings by replacing or updating the populated sample learners within the 100 prepared roster rows. Give each learner a unique Learner ID and enter a name, group, Active value, and Target Attendance Rate. Review the default target rate and supporting dropdown lists. Next, open Attendance Log and enter one row for every learner scheduled for every session in the 500 prepared log rows. Complete Record ID, Session Date, Session Title, Learner ID, Attendance Status, and Scheduled Minutes; add Attended Minutes and a Note when appropriate. Leave the calculated Learner Name, Group, Counted Session, Attended Session, Attendance Rate, and Review Flag cells intact. Correct any flagged source records, then use the Dashboard date and group controls to analyze attendance and follow-up needs.
Preview 2 — “Attendance Log” sheet Click to enlarge
Inside the file
Included features and controls
＋Four purpose-built worksheets: The workbook contains Dashboard, Attendance Log, Roster & Settings, and Instructions sheets.
＋500 prepared attendance rows: The Attendance Log uses the range A5:N504 and is structured as the tblAttendance Excel table. Some rows contain populated samples, while the prepared range contains 500 rows in total.
＋100 prepared roster rows: Roster & Settings uses the range A5:I104 and is structured as the tblRoster Excel table. Some rows contain sample learners within the 100-row prepared range.
＋Validated attendance inputs: Record IDs are checked for uniqueness; session dates are limited to January 1, 2020 through December 31, 2035; session titles allow 1 to 80 characters; Learner IDs and statuses use configured lists; Scheduled Minutes allow whole numbers from 1 to 1440; Attended Minutes allow whole numbers from 0 to 1440; and Notes allow up to 250 characters.
Track Course Attendance by Learner and Session
The attendance sheet is organized around learner-session records rather than a simple list of names. Each Attendance Log row captures the session, learner, attendance status, and scheduled duration. Attended Minutes can document partial participation, while the Note field can hold a short operational explanation. Formulas use the selected Learner ID to retrieve the learner’s name and group from the roster.
Preview 3 — “Roster & Settings” sheet Click to enlarge
Understand the Excel Attendance Rate Calculation
The template calculates attendance on a session basis. Present and Late each produce one counted session and one attended session. Absent produces one counted session and zero attended sessions. Excused produces zero for both values, excluding it from the denominator. Attendance Rate is Attended Sessions divided by Counted Sessions; Attended Minutes provides additional detail but does not alter that session-based rate.
Use the Dashboard for Attendance Follow-Up
The Dashboard can be filtered with a Start Date, End Date, and Group selection. Its headline metrics cover attendance rate, counted and attended sessions, absences, learners below target, and records needing review. It also breaks completed records into Present, Late, Absent, and Excused statuses, compares listed groups, and displays learner-level results against target rates. If the Start Date is later than the End Date, the sheet displays a warning rather than presenting normal results.
Preview 4 — “Instructions” sheet Click to enlarge
Maintain Data Quality with Validations and Review Flags
Input validation supports consistent dates, status values, learner selections, minute values, target rates, and text lengths. The Attendance Log’s calculated Review Flag checks operational records for problems including missing required information, duplicate Record IDs, unknown learners, future session dates, and invalid scheduled-minute values. Roster Review separately checks for missing roster fields and duplicate Learner IDs.
Common questions
About this template
The Attendance Log has 500 prepared rows from row 5 through row 504. The range is formatted as the tblAttendance Excel table. Some rows contain sample records that demonstrate Present, Late, Absent, and Excused workflows; those samples are part of the 500-row prepared range.
Roster & Settings has 100 prepared learner rows from row 5 through row 104. The range is formatted as the tblRoster Excel table. Some rows are populated with sample learners, so distinguish those examples from the remaining rows available for operational data.
The required attendance fields are Record ID, Session Date, Session Title, Learner ID, Attendance Status, and Scheduled Minutes. Attended Minutes should be entered for Late records and may be entered for other statuses. Note is optional.
Late counts as both a counted session and an attended session. Excused is excluded from both counts, so it does not reduce the calculated attendance rate. Absent counts in the denominator but not as attended.
Yes. The Dashboard includes validated Start Date and End Date inputs plus a Group dropdown. The group control includes All Groups and values from the workbook’s configured Dashboard Group list.
The Dashboard includes two charts: an attendance-status count chart and a group attendance-rate chart. Automated review logic can identify issues such as missing required fields, duplicate Record IDs, unknown learners, future session dates, invalid scheduled minutes, missing roster fields, and duplicate Learner IDs.
Editorial process
Prepared and reviewed against the workbook
Course Ops Workbook Team
Workbook preparation
This functional byline identifies the team role that structures the workbook, sample data, calculations, and operating checks.
Course Ops Editorial Team
Editorial review
This functional byline identifies the team role that checks the page against the generated workbook and states its limits.
