Free church attendance spreadsheet template
A church attendance spreadsheet needs one row per person, one column per meeting, and a few formulas that tell you who's been missing. Our free template does exactly that for a Sunday school class, youth group, small group or ministry: download it, type your first meeting date, and mark an x for each person who's there. It works in Excel, Google Sheets and Numbers, and you don't need to sign up for anything.
Download the template
Download the spreadsheet (.xlsx, 22 KB)
Using Google Sheets? Upload the file to Google Drive and open it with Google Sheets, or in Sheets go to File → Import → Upload. The formulas work the same way.
The file has two tabs. How to use explains each step. Attendance is the tracker: 13 weeks (one quarter) for up to 150 people, with three example rows to delete before you start.
What's in it
- Name, group or class, grade, and a parent or emergency phone. Only the name is required. Add a column if you need one, but every extra column is more personal information to look after.
- Thirteen weekly date columns. Type your first meeting date in cell E3 and the rest fill in seven days apart. If you meet on a different schedule, overwrite any date.
- A total for each meeting in row 2, so you can see attendance trends at a glance.
- Present: how many times each person came this quarter.
- Attendance %: present divided by the meetings held so far (meetings dated today or earlier), so the percentage is fair mid-quarter.
- Last attended: the last date each person was marked present.
- Weeks missed in a row: meetings held since they last came. Two or more turns orange; four or more turns red.
The header row and names stay frozen as you scroll, every column has a filter, and the sheet prints landscape on one page wide if you want a paper sign-in sheet for the door.
How to use it each week
- Before the quarter: list everyone you expect, one per row. Paste from an existing list if you have one.
- During or after each meeting: type
xin that week's column for each person who came. Leave it blank if they didn't. - New person? Add a row at the bottom of your list and mark them present. Make a note of who's new so a leader can follow up.
- The next day (10 minutes): filter or sort by "Weeks missed in a row" and look at the orange and red names. Share them among your leaders so each person gets one friendly message. Our guide to following up with students who stop coming has message examples.
- New quarter: right-click the Attendance tab, duplicate it, clear the x marks, and type the new start date.
If you'd rather build your own
The formulas are simple enough to add to a sheet you already use. Assuming names in column A, meeting dates in E3:Q3 and x marks in E4:Q4:
- Times present:
=COUNTIF(E4:Q4,"x") - Meetings held so far:
=COUNTIF($E$3:$Q$3,"<="&TODAY()) - Last attended:
=SUMPRODUCT(MAX((E4:Q4="x")*$E$3:$Q$3))(format the cell as a date; 0 means never) - Weeks missed in a row:
=SUMPRODUCT(($E$3:$Q$3>T4)*($E$3:$Q$3<=TODAY())), where T4 holds the last-attended date
Add conditional formatting to the last column (greater than or equal to 2) and the spreadsheet will point out who to contact without anyone scanning rows of x's.
When a spreadsheet is enough
For a lot of church groups, a spreadsheet is the right tool. It's free, everyone knows how to use it, and it does the important thing: it remembers who came. It's usually enough when:
- One person takes attendance and also maintains the sheet.
- The group is fairly stable, with few first-time visitors.
- You only need attendance for one group, not several ministries.
- Someone reliably enters the marks every week, even in busy seasons.
When it starts to break
Spreadsheets struggle in predictable ways as a group grows:
- Data entry falls behind. If attendance is taken on paper and typed up later, a busy month leaves gaps, and gaps make everyone look absent.
- Several people edit it. Two leaders typing into the same sheet on a Sunday morning leads to duplicates, overwritten cells and "which version is right?"
- Visitors are hard to capture. New people need a row, a name spelled correctly, and a contact, usually while the room is filling up.
- Privacy gets messy. A shared spreadsheet with children's names and parents' phone numbers tends to get forwarded, downloaded and copied in ways nobody planned.
- Nobody can see it during the meeting. The sheet tells you who came last week, not who's in the building right now.
We go into this in more detail in when attendance spreadsheets stop working.
Where RollCall fits
RollCall does what this spreadsheet does, without the typing. People check themselves in on a tablet at the door or on their own phone, visitors add their own details, leaders see who's here in real time, and the Members list filters to who's missed two or more weeks in a row. You can import the names from this spreadsheet as a CSV when you start, and export everything back to CSV whenever you like.
It isn't a full church management system: there's no giving, scheduling or event registration. If you only need attendance and follow-up for a ministry, that's the point. It's free for groups of up to 30 people, with no card needed and no time limit. Larger groups use Pro at US$9.99/month (a launch price; standard $19.99), which includes 150 people and starts with a 14-day free trial.
Common questions
Is the template really free?
Yes. It's a plain Excel file you can download, copy and change however you like. There's no signup and no email required.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets, or use File → Import in Sheets. The formulas and color highlighting work the same way. It also opens in Apple Numbers.
How do I track more than one class or group?
Either use the Group / class column and filter by it, or duplicate the Attendance tab once per class. Separate tabs are easier when different leaders take attendance for different classes.
How many people does it hold?
The formulas are set up for 150 rows. To add more, copy the last row's formula cells (columns R to U) down as far as you need.
Should I store children's information in a spreadsheet?
If you do, keep it to what you need (often just a name, grade and a parent's phone), store it where only your leaders can open it, and delete old copies. Check your church's child-safety policy for any rules about where children's information can be kept.
Want to see how this could work for your group? You can try RollCall free. It's free for groups of up to 30 members, with no card needed. Or see how RollCall works for churches.