Home/Spreadsheets/Special Ed & Teachers/Simple Attendance Tracker

Simple Attendance Tracker

A simple attendance tracker for one class: tick a box for each student who is here, and the present count, attendance percentage and daily totals fill themselves in. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.

What you get

One column per school day, Monday to Friday, grouped into numbered weeks for a full school year
Present and Attendance % beside every name, and a Daily Present total, percentage and bar under every day
Attendance Report: pick a student to see days present and absent, attendance %, a month-by-month table and recent absences
Holidays, breaks and days outside your dates turn grey and are never counted
Add a snow day later and its column greys out while the boxes you already ticked stay on the right dates
Opens in Excel and in Google Sheets

$7.99one-time, no subscription

Buy on Etsy

Instant digital download · one-time purchase · no subscription

Simple Attendance Tracker — the workbook open in Excel

What it does

One column per school day, Monday to Friday, grouped into numbered weeks for a full school year
Present and Attendance % beside every name, and a Daily Present total, percentage and bar under every day
Attendance Report: pick a student to see days present and absent, attendance %, a month-by-month table and recent absences
Holidays, breaks and days outside your dates turn grey and are never counted
Add a snow day later and its column greys out while the boxes you already ticked stay on the right dates
Up to 50 students; empty student rows are skipped and show no errors

What it looks like

Every tab in the workbook

These are the actual sheet names in the file, not a feature list.

Student Attendance
Attendance Report
Settings

Works in

Google Sheets, free, in any browser; the tick boxes work on any device (a ready-made Sheets copy link is included)
Microsoft Excel for Microsoft 365 (Windows, Mac or Excel for the web) for the in-cell tick boxes; Excel 2019 and 2021 do all the math but show TRUE and FALSE instead of boxes
Not for Excel 2016 or older, Numbers or LibreOffice; no macros, no add-ins

Honest scope

This is an organizational template. It reports the data you enter. It does not determine mastery, eligibility or compliance, and it does not replace your district documentation system — those stay your professional judgement.

Others in Special Ed & Teachers

Simple Attendance Tracker$7.99Buy on Etsy