A simple attendance sheet template
This is a monthly sheet for a group that meets twice a week. Each row is one person, each column one session.
| Name | Tue 3 | Thu 5 | Tue 10 | Thu 12 | Tue 17 | Thu 19 | Tue 24 | Thu 26 | Present | Rate |
|---|---|---|---|---|---|---|---|---|---|---|
| Amira K. | P | P | L | P | P | E | X | P | 6 | 100% |
| Ben O. | P | A | P | P | A | P | X | P | 5 | 71% |
| Chloe R. | P | P | P | P | P | P | X | P | 7 | 100% |
| Dev S. | A | P | P | L | P | P | X | A | 5 | 71% |
Codes used: P present, L late, E excused, A absent, X session cancelled. The session on Tue 24 was cancelled, so it is left out for everyone and each person has 7 counted sessions. Late counts as present and Excused is left out of the rate, so Amira has 6 of 6 (100%), Ben 5 of 7 (71%) and Chloe 7 of 7 (100%).
Herebook replaces the paper sheet with one tap per person for Present, Absent, Late or Excused, and works out each person's monthly rate. Get it on Google Play
Columns to include
| Column | Why it is there |
|---|---|
| Name | Full name or the name everyone uses. Sort it the same way every month so rows line up. |
| Date of each session | The date, not "Week 3". Dates make it clear which session was cancelled or moved. |
| A notes column or space | For short reasons such as "school trip" or "injured". Keep it brief. |
| Present count | The number of sessions attended, after applying your rules for late and excused. |
| Rate | Present count ÷ counted sessions × 100. |
| Group total row | How many people came to each session. Useful for room size, coaches needed or equipment. |
Leave out what you will not use. A sheet with columns for contact details, payments and attendance becomes hard to read and is more personal data to look after.
Choosing attendance codes
Four codes cover most groups that are not schools: present, absent, late and excused. Add a code for a cancelled session so it does not look like everyone was absent.
- Use one letter per code so the cells stay narrow when printed.
- Make the codes look different from each other. P and R, or O and 0, are easy to confuse in handwriting.
- Keep the same codes all year. Changing them mid-term makes old months hard to compare.
- Schools in England use a statutory set of attendance codes; if you run a school register, follow those rather than inventing your own (see the GOV.UK guidance linked below).
Printable attendance sheet or Excel?
| Printed sheet | Spreadsheet (Excel, Google Sheets) | |
|---|---|---|
| Taking roll | Fast with a pen, works anywhere | Awkward on a phone; easier on a laptop |
| Totals and rates | Worked out by hand at the end of the month | Formulas do it, as long as nobody breaks them |
| Losing it | Can be lost, rained on or left at the venue | Needs a backup or a cloud account |
| Sharing | Photo or scan | Send the file or a link |
Setting up the sheet in Excel
- Put names in column A starting at row 2, and session dates in row 1 from column B.
- Use Data validation to allow only your codes (P, L, E, A, X) in the mark cells. This stops typos like "p " from being missed by formulas.
- In the Present column, add =COUNTIF(B2:I2,"P")+COUNTIF(B2:I2,"L") and copy it down.
- In the Rate column, divide by the counted sessions: =J2/(COUNTA(B2:I2)-COUNTIF(B2:I2,"E")-COUNTIF(B2:I2,"X")), formatted as a percentage.
- Add conditional formatting so A cells turn red and E cells grey. Patterns stand out at a glance.
- Copy the tab for each new month rather than adding columns to one long sheet.
For a printable version, set the page to landscape, fit all columns to one page wide, and repeat row 1 at the top of each page so dates stay visible.
Common mistakes
- Blank cells counted as absent. A forgotten mark is not an absence. Fill in the sheet during or straight after the session.
- New members squeezed in at the bottom. Fine for one month, but re-sort names when you start the next sheet.
- People who left still on the list. Move them to a separate section so their past attendance stays, but they no longer count against the group rate.
- Only one copy. If the paper sheet or the file is lost, the whole term goes with it. Keep a copy somewhere else.
Take roll without drawing the grid
With Herebook you paste your list of names straight from a spreadsheet or a chat, set your meeting days, and every tap is saved right away.
Get it on Google PlayiPhone version coming soon
More guides
- Attendance Percentage Calculator: Formula, Examples and ExcelHow to calculate attendance percentage: sessions attended ÷ sessions held × 100. Worked examples, how to treat late and excused, cancelled sessions, and Excel formulas.
- Excused vs Unexcused Absences: What Counts and How to Record ThemThe difference between excused and unexcused absences, who decides, how late fits in, and how to record each one fairly in a class, club or team register.
- Sports Team Attendance Tracker: How Coaches Keep Training RecordsHow to track attendance for a sports team or club: what to record at training and matches, a simple sheet, injured and excused players, and attendance in selection.
- Church Attendance Tracking: Spreadsheet Layout and What to CountHow to set up church attendance tracking in a spreadsheet: headcounts vs named registers, Sunday school and small groups, a weekly layout, and using the numbers well.
Published by Zoranta, the developer of Herebook.