People
How to clean up your church's member list in an afternoon
Households, duplicates, the fields worth keeping, and the two habits that stop it getting messy again.
Gather every list into one place, group people into households, merge duplicates, keep only the fields you actually use, and give each person a clear status. Then make one person responsible for the list and route every new name through a single form.
A church of a hundred people can do this in an afternoon. The steps are below.
Before you start
Find every list. The member spreadsheet, the kids ministry sign-in sheet, the email list, the giving records, the welcome cards in the drawer, and the contacts on the pastor's phone. You don't need to fix them yet, just know where they are.
Make a copy of everything before you change anything.
1. Bring it into one sheet
Create one new spreadsheet with these columns:
| Column | Why |
|---|---|
| Household | Groups a family. Use a simple label like "Park, James and Sarah". |
| First name, last name | Separate columns, so you can sort and import later. |
| Role in household | Adult or child. |
| Email, mobile | One of each per person. Children usually have neither. |
| Address | Per household, and only if you mail anything. |
| Status | Member, regular attender, guest, or inactive. |
| Birthdate (children) | For age groups in kids ministry. |
| Care notes (children) | Allergies or needs. See the privacy note below. |
| Last updated | The date someone last confirmed the details. |
Paste every list into it, one row per person. It will look worse before it looks better.
2. Group people into households
Sort by last name and address. Give every member of a family the same household label. Watch for blended families and different surnames under one roof; the address is a better guide than the surname.
Households matter because most of church life happens by family: one check-in for three children, one envelope, one invitation.
3. Merge duplicates
Sort by last name, then first name. Duplicates will sit next to each other: "Jim Park" and "James Park", or the same person with a work and a home email. For each pair:
- Keep the row with the most recent details.
- Copy anything missing from the other row into it.
- Delete the other row.
When you're not sure two rows are the same person, leave both and add a note to ask on Sunday.
4. Drop what you don't use
If no one has used a column in a year, remove it. Old lists collect fields like fax numbers, anniversaries and "spiritual gifts" that were filled in once. Every extra field is something you have to keep up to date, and something you're responsible for protecting.
5. Give everyone a status
Four statuses cover most small churches:
- Member: formally joined, if your church has membership.
- Regular attender: comes most weeks but hasn't joined.
- Guest: has visited in the last few months.
- Inactive: hasn't been seen in six months or more.
Don't delete inactive people. Mark them, and stop sending them weekly emails. Some come back, and a pastor will want to know who they were.
A note on privacy
A member list holds personal information, and children's care notes are the most sensitive part. Decide who needs to see what before you share anything. A kids leader needs their group's children and care notes. A welcome team needs names, not addresses. Shared spreadsheets make this hard, because anyone with the link sees every column.
Keeping it clean
Two habits do most of the work:
- One person owns the list. Others can suggest changes, but one person makes them.
- Every new name comes in one way. A single welcome form, on paper or online, that feeds the list. Not a card, a text and an email to three different people.
Once a year, send each household its own details and ask them to confirm. Update the "last updated" date as replies come in.
When to move it out of a spreadsheet
A clean spreadsheet is a good place to be. It's also the right starting point if you later move to church management software, because most systems import from a spreadsheet, and a clean one imports cleanly.
The usual reasons to move are the ones above: several people need different parts of the list, children's details need to stay private, and new names keep arriving through more than one door. If that's where you are, read does a small church need church management software?
Common questions
What information should a church keep about its members?
Keep what you use: name, household, email, mobile number, address if you mail anything, and a status such as member, regular attender or guest. For children, add birthdate and any allergies or care notes, shared only with the people who need them.
How should a church handle duplicate records?
Pick one record to keep, usually the one with the most recent contact details, copy anything missing into it from the others, then delete or archive the extras. Do it in one sitting so you don't lose track.
Who should be able to see the church member list?
Only the people who need it for their role. A kids leader needs the children in their group and their care notes, not every family's address. Decide this before you share the list.
Small Church Admin is written by the team behind Churchory. Choosing software? Read how a small church should choose church management software.