Attendance Sheet Template
Mark present, absent or late across a month and get per-person totals.
Free · no email, no sign-up · built in your browser · works in Excel, Google Sheets and LibreOffice
What is in the file
The Attendance sheet, exactly as you will get it. Cells shown as=… are live formulas in the download, not text. A second tab, How to use, explains what to change first.
| Name | Mon | Tue | Wed | Thu | Fri | Present | Absent | Late | Rate |
|---|---|---|---|---|---|---|---|---|---|
| Alex Fry | P | P | P | L | P | =COUNTIF(B2:F2,"P") | =COUNTIF(B2:F2,"A") | =COUNTIF(B2:F2,"L") | =(G2+I2)/COUNTA(B2:F2) |
| Sam Ojo | P | A | P | P | P | =COUNTIF(B3:F3,"P") | =COUNTIF(B3:F3,"A") | =COUNTIF(B3:F3,"L") | =(G3+I3)/COUNTA(B3:F3) |
| Jo Baptiste | P | P | P | P | P | =COUNTIF(B4:F4,"P") | =COUNTIF(B4:F4,"A") | =COUNTIF(B4:F4,"L") | =(G4+I4)/COUNTA(B4:F4) |
| Kim Ndlovu | A | A | P | P | L | =COUNTIF(B5:F5,"P") | =COUNTIF(B5:F5,"A") | =COUNTIF(B5:F5,"L") | =(G5+I5)/COUNTA(B5:F5) |
| Daily present | =COUNTIF(B2:B5,"P") | =COUNTIF(C2:C5,"P") | =COUNTIF(D2:D5,"P") | =COUNTIF(E2:E5,"P") | =COUNTIF(F2:F5,"P") |
How this template works
Attendance registers are quick to fill and slow to summarise. This one counts the marks for you: P, A and L are tallied per person and turned into an attendance rate, so the summary is a by-product of the register rather than a second job.
Use it for
- Taking a register for a class, course or training day
- Tracking team attendance over a fortnight
- Producing an attendance rate without counting by hand
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Is this attendance sheet template free?
Yes — free to download and free to use, personally or commercially. There is no email gate, no account and no watermark.
Do the formulas work, or are they just shown?
They work. The file contains live formulas, so editing a value recalculates everything that depends on it. The "How to use" tab lists which cells are formulas so you know what you are typing over.
Which apps open it?
Any spreadsheet that reads .xlsx: Excel, Google Sheets, LibreOffice Calc and Apple Numbers. To use it in Sheets, upload the file to Drive and open it with Google Sheets.
Where does the file come from?
Your browser builds it when you click download. Nothing is uploaded, nothing is stored, and no request leaves the page — which is also why there is nothing to sign up for.