Free Excel Attendance Trackers: Attendance Sheets & Lists

To track attendance data for employees or students, download an Excel attendance template. Use the template’s structure and functions to document and manage attendance data. You can also edit categories and headings, or add columns for identification numbers or contact details.

Use the following steps to create an attendance sheet using an Excel template:

1. Download the  student attendance tracker template  for Excel.
2. Open the file and click on the Blank Student Attendance tab at the bottom of the sheet.
3. Enter the information for the spreadsheet cells at the top of the template:
   1.    School Name
   2.    Course Title
   3.    Time/Class Period
   4.    Professor Name
   5.    Location
   6.    Semester, Month, and Year
4. Enter student names in the spreadsheet B and C columns with their corresponding identification numbers in the D column.
5. For each day, click the corresponding cell for each student. From the drop-down menu select a P for present, U for an unexcused absence, E for an excused absence, and T for tardy each class day. The category abbreviations are also in the attendance tracker key.

The template calculates totals and percentages for each attendance category.