Free template · Excel & PDF
Church & Sunday school attendance sheet
A quarter of Sundays on one page. Track in-person and online attendance, total each Sunday for your report, flag people to follow up with, and keep first-time visitors on the same sheet.
Free · No sign-up · Made by the Attendable team · US Letter, landscape ·

What's in the sheet
- 13 Sunday columns for one quarter. Enter the first Sunday and the other dates fill in.
- Four codes: O Attended, N Online, X Absent, E Excused.
- Per-person totals and an attendance rate of (O + N) ÷ (O + N + X), plus a Weekly total row for your attendance report.
- Class/cell and contact columns, a Follow-up check for people you plan to call, and a table for first-time visitors.
- 40 people in Excel and 18 on the PDF, with room for 10 and 6 visitors.
Codes
- O Attended
- N Online
- X Absent
- E Excused
How to use it
- Type the ministry or class, the leader, and the date of the quarter's first Sunday.
- List members with their class or cell and a contact number.
- Each Sunday, mark O, N, X, or E. Check Follow-up for anyone you want to call that week.
- Write first-time visitors in the table below and tick Followed up after you've been in touch.
When a paper sheet starts to slow you down
- One report from many classes
- A department report needs every class's weekly totals, which means collecting each teacher's sheet first.
- Spotting who has drifted away
- Someone who has missed four Sundays in a row only stands out on paper if a leader reads across the row.
- Teachers who take turns
- When different teachers lead on different Sundays, the sheet has to be handed over every week—and sometimes it isn't.
Automate it with the Attendable app
Attendable keeps the same roster on your phone and does the counting for you. It's free on iOS and Android and contains ads.
| On the sheet | In the app |
|---|---|
| Hand the sheet to the next teacher | Share the group; Editors record attendance on their own phones |
| Add up weekly totals by hand | Statistics count each status for any period you choose |
| Read across rows to find absences | Sort individual statistics to see who has missed the most |
| Look up a number to follow up | Call or text directly from the member's record |
| Scribble newcomer notes in the margin | Memo templates such as First visit or Needs a call |
Free on iOS & Android · Contains ads
Read the step-by-step guide: Shared attendance for churches and small groups
Questions about this template
Why are excused weeks left out of the rate?
Someone traveling or sick with notice shouldn't look less committed than someone who was simply absent. The rate is (O + N) ÷ (O + N + X), so E weeks don't count either way.
Can I use it for a youth group or cell group?
Yes. Change the title and the Class/cell heading, and keep one sheet per group so each group's weekly total stays separate.
How do I start the next quarter?
Copy the sheet tab, clear the marks, and enter the next quarter's first Sunday. The 13 dates update automatically.