Attendance Register Maker — Printable Monthly Attendance Sheet

An attendance sheet maker for a printable monthly register

This attendance sheet maker builds a printable monthly register for a class in a few seconds. Paste your class list, choose the month and year, tell it which days are the weekly off and which are holidays, and it draws a table with one column per day, shaded weekends, a numbered row for each student and Present, Absent and % columns to fill in at month end.

If you prefer a spreadsheet, the same register downloads as an Excel file with formulas: type P or A in each cell and the Present, Absent and percentage columns update by themselves. Everything is made in your browser; your class list never leaves your device.

How to use the Attendance Register Maker

1. Enter the school, class and teacher, then choose the month and year.
2. Pick the weekly off (Sunday, Saturday and Sunday, or Friday and Saturday) and type any holidays, such as 14, 26-27.
3. Paste your class list, one name per line, and add blank rows for new admissions.
4. Check the preview and the working days count; use the page buttons if the list runs to several pages.
5. Press Print register or download a PDF, or choose Download Excel with formulas.

Attendance Register Maker features

How the attendance percentage works

The register counts working days as the days of the month minus the weekly offs and the holidays you list. The percentage in the Excel file is present days divided by working days, times 100, rounded to one decimal. For example, a student who is marked present on 20 of 22 working days has 90.9%.

Choosing paper, rows and columns

Landscape A4 gives each day column about 6 mm, which is enough to write P or A clearly in pen. If your class has more than about 25 students, pick the compact row height, or let the list run onto a second page: the header row repeats on every page and the Total present and Total absent rows go at the very end. Add a few blank rows if students often join mid-term, so that you do not have to rewrite the register. For a half-day or shift system, keep two registers or use the Excel file and add a second sheet.

Tips for keeping the register

Students who want to check their own attendance against a 75% rule can use the attendance calculator, and a whole-class report card can be made with the report card maker.

• Mark attendance at the same time each day, and keep a code for leave (L) and half days if your school uses them; only P and A are counted by the Excel formulas.
• Print on A4 landscape for a month of 31 days; portrait works but the day columns become narrow.
• Keep the Excel file as a monthly record, or print the PDF and file it. Check your school or board’s rules for required register formats before using it as the official record.