← Templates

Free template · Excel & PDF

Monthly class attendance sheet

One row per student and one column per day. Enter the first day of the month and the dates, weekdays, totals, and attendance rate fill in for you—or print the PDF and mark it by hand.

Free · No sign-up · Made by the Attendable team · US Letter, landscape ·

Monthly class attendance sheet with 31 day columns, code totals, and a rate column
Preview of the printable PDF

What's in the sheet

  • 31 day columns. Enter the 1st of the month and the day numbers and weekdays fill in; days the month doesn't have stay blank.
  • Five codes from a drop-down list: P Present, A Absent, L Late, D Left early, E Excused.
  • Per-student totals for each code and an attendance rate of (P + L + D) ÷ (P + A + L + D). Excused days don't lower the rate.
  • A “Present that day” row that counts attendance for each date.
  • 30 student rows in Excel and 24 on the PDF. Weekends are shaded, and the sheet prints landscape on one page width.

Codes

  • P Present
  • A Absent
  • L Late
  • D Left early
  • E Excused

How to use it

  1. Download the Excel file and type the class name and teacher at the top.
  2. Enter the first day of the month, for example 12/1/2026, in the Month cell.
  3. Add student names, then pick a code for each student on each class day.
  4. Read each student's totals and rate on the right. For a new month, copy the sheet tab and change the Month cell.

When a paper sheet starts to slow you down

The month-end tally
Counting codes across 31 columns for every student takes time and is easy to get wrong. The Excel file counts for you; a printed copy doesn't.
More than one class
Every class needs its own sheet every month. Following one student across a term means opening several files or flipping through a binder.
Sharing with a co-teacher
Only one person can hold the paper. Emailing spreadsheets back and forth leaves everyone unsure which copy is current.
Times, not just codes
L tells you a student was late, not when they arrived. If anyone asks later, the sheet can't answer.

Automate it with the Attendable app

Attendable keeps the same roster on your phone and does the counting for you. It's free on iOS and Android and contains ads.

On the sheetIn the app
Write a code in every cellSwipe a name, or check the whole class at once with a status card
Count totals at the end of the monthAttendance rates by period and by student are calculated automatically
Write arrival times by handThe check time is saved when you record attendance
Photocopy or email the sheetShare the class with a co-teacher as an Editor or Viewer
Keep the file for reportsExport records to Excel or PDF (export can show a rewarded ad)
Download Attendable on the App StoreGet Attendable on Google Play

Free on iOS & Android · Contains ads

Read the step-by-step guide: Class attendance for school teachers
Attendable class roster with absent and late statuses and recorded times
Actual app screen · Sample data

Questions about this template

How is the attendance rate calculated?

Rate = (P + L + D) ÷ (P + A + L + D). Late and left-early days count as attended. Excused days are left out entirely, so they neither raise nor lower the rate.

Can I use different codes?

The totals count the five codes exactly as written. To use other letters, change both the drop-down list (Data validation) and the letters in the total formulas on the right.

Can I import this sheet into the Attendable app?

Not this file directly. The app imports rosters from your contacts or from its own Excel template, which it provides when you add members.