Someone on the team says “we should get our records into a real system,” everyone nods, and then nobody asks the one question that actually decides whether this happens: how many hours is that, really? Not in spirit, in minutes. The answer turns out to be simple arithmetic, and once you do the math the task stops being a vague dread and becomes a Saturday morning you can put on the calendar.
This is not a productivity trick. It is just multiplication: minutes per record, times number of records, plus the time nobody counts. Do it once for your own church before you decide whether to hire it out, delegate it, or grit your teeth and do it yourself.
The basic equation
Manual data entry has one shape no matter what system you are entering into: minutes per record × number of records = hours of work. For a church directory, the record is usually a household — a name, an address, a phone number, an email, and the people in it. For giving, the record is a gift. For attendance, the record is a session. Each of these has its own pace, and confusing them is where most time estimates go wrong.
A household entry — typing a name, address, phone, and email, and adding each family member — runs two to four minutes once you have a rhythm, longer for a first-timer still learning where fields live. Call it three minutes as a working average. That number is the whole trick. Everything below is just applying it.
It is worth writing your own version of that number before you read any further. Open your spreadsheet, count the rows that represent a real, active household, and multiply by three. Whatever comes out is closer to the truth than any guess made in a meeting, and it is the number you should actually plan around.
What it looks like for a church of 120
A congregation of about 120 people is roughly 45 to 55 households, once you account for singles, couples without children living at home, and the odd household that is really two families sharing a address. At three minutes a household, 50 households is 150 minutes — two and a half hours. That is genuinely one evening, done in a single sitting, with a break in the middle.
Add giving history and the picture changes. If 30 of those households give regularly and you want a full year of contribution history rather than a running balance going forward, you are now entering individual gifts, not households. A household that gives weekly produces around 50 rows a year. Thirty households times 50 rows, at a brisk fifteen seconds a row once you are in a groove, is another 375 minutes — over six hours. The people list was an evening. The giving history is closer to a full day.
What it looks like for a church of 300
Scale the same math up and the honest answer gets less encouraging. A congregation of 300 is somewhere around 110 to 130 households. People entry alone, at three minutes each, is six to seven hours — a full working day, not an evening. If half of those households have giving history worth preserving, you are looking at another day or two on top of that, depending on how many years back you decide matters.
This is the point where “we”ll knock it out this weekend” quietly becomes untrue, and it is worth saying out loud before anyone commits a weekend to it. A church this size that tries to do the whole thing solo, after work, in the evenings, is often still entering data six weeks later, tired and behind on everything else. Naming the real number up front is what lets you plan around it instead of being surprised by it.
The minutes nobody counts
The three-minutes-a-household number assumes a clean record: a name you recognize, a phone number that still works, one household per row. Real church data is never entirely that. Some fraction of your list is a guest card with no last name, a phone number that bounces, two spreadsheet rows for the same family because someone updated only one of them, or a name you simply do not recognize anymore.
Each of those is not a three-minute record. It is a three-minute record plus a five-minute detour: a text to the greeter who might remember, a scroll through old emails, a decision about whether to enter a stranger at all. In practice, plan on 10 to 20 percent of your list needing this kind of detour, and budget accordingly. If your spreadsheet is more chaos than list, it is worth a pass at cleaning up the database before entry day, so the detours happen once, in bulk, instead of one at a time while you are trying to type.
Where the household decision changes the math
One decision moves the number more than any other: whether you enter by household or by individual. A family of five entered as one household with four dependents is one record. The same family entered as five separate individual profiles, each with its own address and contact fields typed out, is five records — and five times the minutes, for information that mostly repeats itself. If your church has not settled this question yet, it is worth reading through households versus individuals before you type a single row, because re-doing 200 records after you change your mind costs more than deciding it took to begin with.
Splitting the work without doubling the mess
Past roughly 150 households, doing this alone stops making sense. The fix most churches reach for is dividing the list — by last name, by ministry group, by whoever already has a relationship with those families — and having two or three volunteers enter in parallel. This genuinely cuts the calendar time, but it introduces a new cost: duplicates, where two volunteers both entered the Hendersons because the list wasn't split as cleanly as it looked on paper.
Budget one final session, after the splitting is done, for one person to scan for duplicates and inconsistent formatting before you call the migration finished. Skipping that step is how a shared spreadsheet problem quietly becomes a shared database problem. If you are moving off a spreadsheet entirely rather than starting from scratch, our guide on moving a church off spreadsheets walks through the order that keeps this clean: people first, giving with a paper trail, notes read before they are lost.
Deciding whether it is worth doing at all
Once you have a real number — say, six hours for a church of 150 — the decision in front of you gets simpler. Six hours is a Saturday for one person, or two evenings split between two people, or an afternoon if three volunteers each take a third of the alphabet. None of those is a reason to avoid moving off a spreadsheet; they are just the actual cost, named honestly, so nobody is blindsided by the size of the job partway through it.
SundayBridge does not import a spreadsheet for you — there is no automated import, and we say so plainly rather than promise something that does not exist. What we do offer is to load your spreadsheet by hand, for free, once you are ready, which is worth asking about if the math above looks bigger than your team has time for this month. Either way, doing the arithmetic first is what turns “we should really do this sometime” into a scheduled block of hours with an end in sight.
It also helps to say the quiet part out loud: the arithmetic above only covers typing. It does not cover the conversation where two volunteers disagree about which address is current, or the pause while someone tries to remember whether a family still counts as active after they stopped coming last spring. Those minutes are real, usually short, and they are the reason a six-hour estimate sometimes stretches into an eight-hour Saturday. Build in the slack rather than being surprised by it.
Three minutes a household, times your household count, is your real number. Everything else — giving history, messy records, splitting the work — is an addition on top of that one line of math, not a replacement for it.