TF
Template Flow Hub

Class Attendance Template for Google Sheets

Track student attendance with this free Google Sheets template. No signup required — copy to Google Sheets or download Excel and CSV. Record presence, absences, tardiness, and attendance rates automatically.

Google SheetsExcelCSV
Copy Google SheetsDownload ExcelDownload CSV
Cost

Free

Signup

No signup

Formats

Sheets, Excel, CSV

Best for

Education

Updated

2026-06-01

Class Attendance Template for Google Sheets preview — free Google Sheets template

What Is This Class Attendance Template?

This class attendance template is a free Google Sheets spreadsheet for teachers, professors, and school administrators who need to track student attendance across multiple class sessions. It includes daily attendance logs, present-absent-late-excused flags, automatic attendance rate calculation, and a monthly summary view.

Why Use a Google Sheets Class Attendance Template?

A Google Sheets attendance template is easy to set up, share with teaching assistants, and access from any device. It eliminates paper attendance sheets and provides automatic attendance rate calculations. The template works offline in the Google Sheets mobile app and can be exported to Excel or CSV for school reporting systems.

When Should You Use This Class Attendance Template?

Use this template when you teach a class and need a simple digital attendance log. It works for K-12 classrooms, college courses, tutoring sessions, training workshops, and after-school programs. For larger deployments, check the student attendance tracker with multi-class support.

What's Included

  • ✓Student name & ID
  • ✓Class & course information
  • ✓Daily attendance log (date)
  • ✓Present / Absent / Late / Excused flags
  • ✓Attendance rate calculation
  • ✓Notes per student
  • ✓Monthly summary

How to Use This Template

1Copy the Google Sheets template to your Google Drive.
2Add your student names and ID numbers.
3Enter the date for each class session.
4Mark each student as Present, Absent, Late, or Excused.
5The template automatically calculates attendance rates.
6Review the monthly summary to identify attendance patterns.

Who This Template Is For

TeachersProfessorsSchool AdministratorsTutors

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 (Present, Absent, Late, Excused) for faster daily marking.
  • 💡Add a notes column to track reasons for absences or late arrivals for parent communication.
  • 💡Freeze the student name column so it stays visible when scrolling across multiple date columns.

Use Cases

  • Classroom attendance tracking
  • Student participation monitoring
  • School attendance reporting

Download or Copy

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

Frequently Asked Questions

Yes. It is free to use. Copy the Google Sheets version or download Excel/CSV.
Yes. Duplicate the sheet tab for each class or section you teach.
Yes. The template calculates each student's attendance rate based on the total sessions recorded.
Yes. Download as Excel or CSV for reporting, or print directly from Google Sheets.
Yes. The template includes an "Excused" flag in addition to Present, Absent, and Late for more accurate attendance tracking.

Related Templates

Last updated: 2026-06-01

Copy Google Sheets