TF
Template Flow Hub

Student Attendance Tracker for Google Sheets

Track attendance across multiple classes with this free Google Sheets student attendance tracker. Supports multiple courses, grading periods, and automated attendance reports. No signup required.

Google SheetsExcelCSV
Copy Google SheetsDownload ExcelDownload CSV
Cost

Free

Signup

No signup

Formats

Sheets, Excel, CSV

Best for

Education

Updated

2026-06-01

Student Attendance Tracker for Google Sheets preview — free Google Sheets template

What Is This Attendance Tracker Template?

This student attendance tracker is a free Google Sheets template for teachers and administrators who manage attendance across multiple classes. It includes separate tabs for each class, automated attendance rate calculation, and grading period summaries.

Why Use a Google Sheets Attendance Tracker Template?

A multi-class attendance tracker in Google Sheets is more efficient than managing separate sheets for each course. The template consolidates attendance data in one file and calculates rates automatically.

When Should You Use This Attendance Tracker Template?

Use this template when you teach multiple sections and need a unified attendance system. It works for middle school, high school, and college instructors who want a single file for all their courses.

What's Included

  • ✓Multiple class tabs
  • ✓Student roster with IDs
  • ✓Daily attendance per class
  • ✓Present / Absent / Late / Excused
  • ✓Attendance rate per student
  • ✓Grading period summaries
  • ✓Notes & parent contact log

How to Use This Template

1Copy the template to your Google Drive.
2Create a tab for each class or section you teach.
3Add student names and ID numbers to each class roster.
4Mark attendance daily using the status flags.
5Review attendance rates per student and per class at the end of each grading period.

Who This Template Is For

TeachersSchool AdministratorsDepartment HeadsHomeroom Teachers

Available Formats

Google Sheets — Copy the template directly to your Google Drive. You can edit, share, and use it online from any device.

Excel (.xlsx) — Download the file and open it in Microsoft Excel, Apple Numbers, or any compatible spreadsheet application.

CSV — Download the comma-separated values file for use in data applications, databases, or legacy spreadsheet software.

Customization Tips

  • 💡Use data validation dropdowns for consistent status entries across all class tabs.
  • 💡Create a master summary tab that pulls attendance data from all class sheets using QUERY formulas.
  • 💡Share the sheet with a teaching assistant who can help with daily attendance entry.

Use Cases

  • Multi-class attendance management
  • School-wide attendance reporting
  • Grading period attendance summaries

Download or Copy

Copy Google SheetsDownload ExcelDownload CSV
Disclaimer: For planning and tracking purposes only.

Frequently Asked Questions

Yes. Free to copy or download.
Yes. Each class gets its own tab, and you can add as many tabs as needed.
Yes. Each student's attendance rate is calculated automatically based on total sessions.
Yes. The template supports Present, Absent, Late, and Excused status flags.
Yes. The grading period summary section provides attendance data for report cards and administration.

Related Templates

Last updated: 2026-06-01

Copy Google Sheets