Track church attendance,
measure what matters.
HolyJot's free church attendance tracker gives leaders a clear, organized view of weekly attendance, first-time visitor trends, small group participation, and year-over-year growth — all in a ready-to-use Excel template with built-in charts.
Free download · No account required
Built for your spiritual journey
Every feature is designed to help Christians grow deeper in faith — not just log their day.
Weekly attendance by service
Log attendance for each service (early, main, online) week by week. Totals calculate automatically and roll up into monthly and annual summaries without any manual math.
Year-over-year comparison
See how this year's attendance compares to the same week or month last year. Spot growth trends, seasonal patterns, and the impact of outreach campaigns with side-by-side data.
First-time visitor tracking
Log first-time visitors separately each week to measure your church's outreach reach and guest retention rate — the metrics that tell you whether new people are finding and staying in your church.
Small group attendance included
Track mid-week small group, Bible study, and community group attendance alongside Sunday numbers to get a complete picture of your congregation's engagement — not just weekend counts.
How it works
Download the template
Get the free Excel attendance tracker instantly. Works in Microsoft Excel or Google Sheets — no special software required.
Enter your Sunday attendance weekly
Take a few minutes each Sunday evening to log that week's count by service. The template calculates monthly totals automatically.
Track first-time visitors
Record your guest count separately each week using connection cards or check-in data, and watch your visitor trends develop over time.
Review trends and share reports with leadership
Use the built-in summary tab and charts to present attendance health at your next board meeting — no reformatting required.
Frequently asked questions
How do churches track attendance?
Churches typically track attendance using one of three methods: physical count (head count or clicker), connection cards collected during the service, or a digital check-in system. The raw numbers are then logged weekly in a spreadsheet or church management system. HolyJot's free attendance tracker gives you a structured Excel format to record weekly counts by service, track first-time visitors separately, and generate trend charts without needing expensive software.
Why is tracking church attendance important?
Attendance data is one of the clearest indicators of church health and growth. It helps leadership identify seasonal patterns, measure the impact of new programs or outreach efforts, plan staffing and space needs, and celebrate milestones with the congregation. Tracking first-time visitors separately reveals how well your church is reaching new people and whether guests return.
What is a good church attendance rate?
Church health researchers often measure 'active attendance rate' as the percentage of members who attend in any given month. A healthy active attendance rate is generally considered 60-80% of your membership roll. Average weekly attendance relative to membership above 50% is a positive sign. However, attendance benchmarks vary widely by denomination, community size, and church culture — trend lines matter more than absolute numbers.
How do I track first-time visitors?
The most reliable way to track first-time visitors is through a connection card or digital check-in system that asks guests to identify themselves. HolyJot's attendance tracker includes a separate first-time visitor column so you can log visitor counts each week and compare them to overall attendance — a metric that directly measures your church's outreach effectiveness.
How do I create an attendance report for church leadership?
HolyJot's attendance tracker includes a built-in summary tab that compiles your weekly data into monthly and year-to-date totals, year-over-year comparisons, and visual charts. Simply copy the summary tab into a document or print it directly for your board meeting, elder session, or annual report. No additional formatting required.
Growth is visible when you track it.
Download HolyJot's free church attendance tracker today and start turning weekly counts into insights that help your leadership team make better decisions for ministry growth.