A ready-to-use Excel and PDF template designed for hostel wardens. Track daily attendance, auto-calculate summaries, and flag low-attendance students — all in one clean, organised file.
| Student Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ... | Pres. | Att% |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Arjun Sharma | P | P | P | A | P | P | L | P | … | 22 | 88% |
| Priya Nair | P | A | A | P | A | P | P | A | … | 14 | 58% |
| Rohan Mehta | A | A | A | A | P | A | A | P | … | 9 | 36% |
| Sneha Pillai | P | P | P | P | L | P | P | P | … | 24 | 96% |
Built specifically for Indian university hostels. Clean, practical, and works right out of the box in Excel or Google Sheets.
A full month on one sheet. Columns for all 31 days with P / A / L / H / S codes. Dropdown validation prevents typos.
Present, Absent, and Leave counts calculated automatically per student. Attendance percentage updates live as you fill in each day.
Attendance percentage cells turn blue (≥75%), yellow (50–74%), or red (<50%) automatically using conditional formatting.
Fill student names, roll numbers, and room numbers once in the Directory sheet. The Attendance Register and Monthly Summary pull from it automatically.
A dedicated summary view that aggregates total present, absent, and leave days per student — ready to present to administration.
A clean landscape A4 PDF version for physical records. Fits all 30 students and 31 days on a single page, with signature fields.
Three interconnected sheets built to work together without any manual duplication.
| C | D | E | F | G | H | I | J | K | L | M | N | O | P | ··· | AJ | AK | AL | AM | ||
| 3 | # | Student Name | Room | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ··· | Pres. | Abs. | Leave | Att% |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 1 | Arjun Sharma | A-101 | P | P | P | A | P | P | L | P | P | P | P | A | … | 22 | 5 | 1 | 79.3% |
| 5 | 2 | Priya Nair | B-204 | P | A | A | P | A | P | P | A | P | A | P | P | … | 16 | 12 | 0 | 57.1% |
| 6 | 3 | Rohan Mehta | C-312 | A | A | P | A | A | A | P | A | A | A | P | A | … | 8 | 20 | 0 | 28.6% |
| 7 | 4 | Sneha Pillai | A-108 | P | P | P | P | L | P | P | P | P | P | P | P | … | 26 | 1 | 1 | 92.9% |
| 8 | 5 | Kiran Reddy | D-401 | P | P | L | L | P | P | A | P | P | P | P | P | … | 20 | 3 | 5 | 71.4% |
| 34 | Daily Total (P) → | 4 | 3 | 3 | 2 | 3 | 4 | 3 | 4 | 4 | 3 | 4 | 3 | … | ||||||
No setup required. Open the file and you're ready to go.
Get the Excel (.xlsx) or PDF version. Compatible with Microsoft Excel, Google Sheets, and LibreOffice.
Enter student names, roll numbers, room numbers, and contact details once. All other sheets pull from this automatically.
Enter P, A, L, H, or S in each cell using the built-in dropdown. Present and Absent counts update in real time.
Check the Monthly Summary sheet for a clean view of every student's attendance. Print or share the PDF for official records.
Yes. Download the .xlsx file and upload it directly to Google Drive. The formulas and sheet linking work in Google Sheets. Conditional formatting carries over too.
Yes. Copy any existing row and paste it below the last row. The formulas will replicate automatically. Just extend the Student Directory accordingly.
P = Present, A = Absent, L = On Leave, H = Holiday, S = Sunday. The % uses P / (P + A + L), so Holidays and Sundays don't affect the percentage.
The PDF is print-ready for physical record-keeping and signing. For editable records, use the Excel or Google Sheets version.
This template is a great starting point for manual record-keeping. SpaceBasic automates attendance via biometric, QR, or app-based check-in — saving wardens up to 60% of time on daily tasks.
No. The template is completely free — no sign-up, no email required. If you'd like to explore full hostel automation, you can schedule a demo separately.
Address:
SBasic Applications Private Limited
6, 80 Feet Rd, Indiranagar, Bengaluru
Karnataka, India 560038
© 2025 SpaceBasic, Inc. All rights reserved.
