Skip to content
The title slide and first slides of the Class Attendance Sheet template

Class Attendance Sheet

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 6, 2026

Every slide (4)

Overview

The Class Attendance Sheet is a register for teachers who mark pupils present, absent or late. The Students tab holds the pupil list with form groups and contact notes. The Register tab is a grid with one row per pupil and one column per school day, so each day takes a single code. The Dashboard counts the pupils in each form group.

It comes with sample data for three form groups and twenty school days in October. Make a copy, replace the sample pupils and clear the Register values. Dropdowns and the form-group counts update on their own.

Useful for

  • Taking the daily register for a class or form group
  • Tracking late arrivals and absences across a half term
  • Sharing a termly register with a head of year

What's included

  • 4 tabs: Dashboard, Students, Register, How to use
  • Dashboard: a dashboard with 2 summary figures
  • Students: a table
  • Register: a grid
  • 1 chart 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

Is this Class Attendance Sheet template free?

Yes. Download the template and use it at no cost. There is no sign-up needed to open it.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Microsoft Excel. The grid, dropdowns and counts work the same way.

Can I count each pupil's absences for the term?

The Register grid holds one code per cell, so counting codes per pupil takes a filter or a formula such as COUNTIF on each row. The template does not total codes for you.

  • #attendance-tracker
  • #class-attendance-sheet
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More attendance tracker templates

See all 3

Also in Careers

All careers templates
Get this template

Preparing your template…