Skip to content
Student Attendance Tracker cover: a sample sheet with attendance rate, absences and tardies and a pie chart, beside the Dashboard, Students and Daily log tabs

Student Attendance Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Student Attendance Tracker is for classroom teachers, homeroom tutors and small schools that take a daily register. The Students tab holds the class list and calculates days recorded, absences, excused days, tardies and attendance rate for each student. The Daily log tab records each student on each day, choosing a status from the dropdown. The Dashboard shows the overall rate and the status totals in charts.

Enter the register the same day, while it is fresh. Pick the four status words only from the dropdown, so the counts recognize them. Present and Tardy count as attended, while Absent and Excused count as missed. Review students whose rate is falling every two weeks, and keep the file in the school's shared storage so the record stays with the school.

Useful for

  • Take a daily register for one class
  • Spot students who miss many lessons
  • Share attendance figures with the school office

What's included

  • 4 tabs: Dashboard, Students, Daily log, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Students: a table
  • Daily log: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Students tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How is the attendance rate worked out?

Present and Tardy entries count as attended, and the rate divides them by all entries logged. Each student's rate on the Students tab uses the same rule for that student's own days. Absent and Excused entries count as missed, so check your school's official record before you report a figure.

Can one file cover several classrooms?

Yes. The simplest way is a separate workbook per class, which is easier to share with a single teacher and keeps the counts clean. Alternatively, add a Class column to both the Students and Daily log tabs and filter by it.

How do I spot a student who keeps arriving late?

The Tardy column on the Students tab counts late arrivals separately from absences, so you can see patterns without treating each tardy as a missed day. Talk with the student and family first, and then follow your school's attendance policy for any further steps.

  • #attendance-tracker
  • #student-attendance-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More attendance tracker templates

See all 8

Also in Human resources

All human resources templates
Get this template

Preparing your template…