Attendance sheet template
A class attendance sheet with student names down the side, dates across the top and totals.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Attendance (one sheet per 4 weeks): number and student name down the side, class dates across, P / A / T / E dropdown, present, absent, tardy and excused counts per student and a present count per date
- Totals: for 8 weeks or more, adds every sheet's counts per student
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
1 / 1
Attendance sheet, weeks 1-4
| # | Student | 10/22 Thu | 10/23 Fri | 10/26 Mon | 10/27 Tue | 10/28 Wed | 10/29 Thu | ... | Present | Absent | Tardy | Excused |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example | Jordan Lee | P | P | T | P | P | A | ... | 18 | 1 | 1 | 0 |
| ... | (auto) | (auto) | (auto) | (auto) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Enter the number of students, the first class day, how often the class meets and how many weeks you need. You get an attendance sheet with the class dates already in the header. In each cell pick P for present, A for absent, T for tardy or E for excused, and the totals per student and the present count per date fill in by themselves.
Every 4 weeks starts a new sheet so each one prints on a single landscape Letter page. Type the names once on the first sheet; the later sheets and the Totals sheet read them from there.
Things to watch
Student names are personal information even on a tutoring or church class list. Check who you send the file to, and keep phone numbers and addresses out of the attendance sheet. If your school requires its own attendance record, this sheet is a working copy, not a replacement.
Calculators that go with this
Frequently asked questions
How do I change a class date?
Edit the date text in the header. The counts work by cell position, so changing the label does not break anything.
Can I use different marks?
The dropdown is fixed to P, A, T and E and the counts look for those letters. To use other marks, change both the Data Validation list and the letters inside the COUNTIFS formulas.
Can it calculate an attendance rate?
Divide the Present count on the Totals sheet by the Class days column. Whether tardy and excused count as present is a school policy, so the sheet leaves that to you.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.