Church Member List: Moving Out of Excel and WhatsApp
How to move your church member list out of Excel and WhatsApp: what to record, families, consent and data protection, duplicates and who gets access.
· 4 min read

Most small churches have a member list. The trouble is that they usually have four of them: an old spreadsheet on the secretary's laptop, a WhatsApp group, a paper list in the office and the pastor's phone contacts. Each one is slightly different, and nobody is sure which is right.
Moving to one shared list is less work than it sounds. Here is a calm, step-by-step way to do it.
Decide what to record (and what not to)
Before you copy anything, agree as a leadership team on which fields you actually need. The rule is simple: only record what you use.
| Usually worth recording | Think twice | Usually leave out |
|---|---|---|
| Name | Date of birth (useful for birthdays, but ask) | Health details or prayer requests |
| Phone and email | Baptism or membership date | Pastoral notes about personal situations |
| Postal address | Children's school or age group | Financial situation |
| Family / household | Photo | Anything "just in case" |
| Groups they belong to |
Sensitive pastoral information belongs in a conversation, not a spreadsheet. If you would be uncomfortable reading a field out loud to the person, it probably shouldn't be in the list.
Think in families, not just individuals
In a small church, people come as households. Recording families makes many everyday tasks easier: one address for the whole family, children linked to their parents, and a clear picture of who belongs together.
A few practical tips:
- Give each household one main address.
- Link children to their parents rather than creating separate, unconnected entries.
- Keep individual phone numbers and emails per person, since teenagers and spouses often have their own.
- Allow for real life: blended families, single parents, adults living with their parents.
Consent and data protection basics
Membership data about a church is personal data, and in many countries it is treated as especially sensitive because it reveals religious belief. In the UK and EU this falls under GDPR; elsewhere there are similar privacy rules. The basics are the same everywhere:
- Tell people what you store and why. A short paragraph on the sign-up form is enough.
- Ask for consent where it's needed, for example for photos or for sharing contact details with other members.
- Store only what you need, and delete what you no longer use.