Free Excel Attendance Tracker Sheets & Lists | Smartsheet (2024)

Download the Employee Attendance Tracker Template for Excel

Use this template to track your employees' daily, weekly, and monthly attendance. Track shifts, sick leave, vacation days, and personal time with this employee attendance template. The spreadsheet format displays attendance patterns and employee availability at a glance. Use the included point system function to help minimize no-shows, late arrivals, and early departures.

Visit the solution center to explore and use this employee attendance tracker template in Smartsheet.

Download the Monthly Employee Attendance Sheet Template for Excel

This template tracks employee attendance, as well as sick, personal, and vacation leave days, for a specific month. The spreadsheet will automatically calculate the overall attendance percentage for each employee. Use this template to collect the essential work data needed for successful business operations.

To download other attendance template types and learn more about creating an attendance spreadsheet, check out this collection of free attendance spreadsheet templates.

Download the Attendance Dashboard Template for Excel

Use this dashboard template to visualize attendance data as charts and graphs. This comprehensive spreadsheet lists multiple employees' work shifts; vacation, personal, and off days; and sick leave totals. The attendance sheet cell columns include week numbers, dates, monthly totals, and more data for each employee.

To manage and track attendance in another spreadsheet format, use this resource of free Google Sheets attendance tracker templates.

Download the Student Attendance Tracker Template for Excel

Use this tracker template to mark daily attendance, late arrivals, and unexcused or excused absences for a specific month and semester. List your school name, the course title, class start time, and location in the space provided at the top. This spreadsheet automatically calculates totals and percentages for each category, making it easy to see an overview of student attendance at a glance.

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.

Use an attendance template in Excel to perform percentage calculations. As an employer, you can enter percentages for different categories, such as work shifts compared to vacation, sick, and personal days for employees. In the classroom, an instructor can view the percentage of unexcused vs. excused absences for students.

Once you enter the data in the template, it automatically calculates the percentage and appears in the corresponding column.