The fourth eBook in the Sales and Leads category. Most small businesses either run their entire customer list out of memory and a chaotic inbox, or they buy expensive customer list software they never log into. This eBook is the calm middle path: a small system, the right size for a business of one to ten people, that you will still be using in twelve months.
Members ebook·7 chapters· 35 minute read
Chapter 2
Spreadsheet vs Customer List Software
When a spreadsheet is enough, when it is not, the categories of lightweight software that suit small businesses and how to choose without spending three weekends comparing options.
The single most common mistake small businesses make with customer list systems is choosing a tool that is two sizes too big. They sign up for a powerful piece of software with thirty features, spend three weeks setting it up, never quite finish, drift back to the inbox and quietly stop logging in. Six months later they pay another year of subscription out of guilt and never use it again. The fault is rarely with the software; it is almost always with the choice.
The honest answer for most small businesses is to start with a spreadsheet, run it for three to six months until you outgrow it, then move to lightweight purpose-built software when you can describe in one sentence the specific thing the spreadsheet stopped doing. This chapter walks you through both options, when each one is the right answer and how to make the choice without losing a fortnight to product comparisons.
By the end you should know which side of the line your business is on this year, what the next step looks like when you cross over and the short list of features that actually matter when picking a customer list product.
The full chapter covers the spreadsheet structure that scales, the categories of lightweight software worth considering, the three features that matter and the three that do not and the migration path from one to the other.
When a spreadsheet is enough
A spreadsheet is enough if one or two people maintain the list, the contacts number in the low hundreds rather than the thousands, the workflow is mostly notes and follow-up dates rather than complex multi-step processes and you are willing to update it every week by hand. That covers most one-person businesses, most small studios, many freelancers, many trades and most independent retailers in their first three years. The advantages are real: free, no learning curve, no migration risk, easy to back up, no vendor lock-in and a structure you can change in five minutes when you decide to add a column.
The structure that scales is simple. One row per contact. Columns for name, business, primary contact (email and phone), source (where they came from), status (active customer, opportunity, dormant, lost), last contact date, next action, next action date and a notes column you actually use. Five tabs - active customers, opportunities, dormant, suppliers, archive - keep things tidy without becoming complicated. Filtering and sorting do almost everything more expensive software does. Save it weekly to a backed-up location. Done.
When you have outgrown the spreadsheet
You have outgrown the spreadsheet when one of three things is true. Three or more people need to edit it regularly and you keep losing each other's changes. The reminder system - a column of dates that you have to scan manually - has stopped firing because nobody opens the sheet often enough. The contact count has crept past around five hundred and finding things is starting to feel slow. Any one of these is reason enough to look at lightweight customer list software. None of them is reason to look at the largest products on the market.
Three features that matter
A clear list view you can sort and filter quickly
Reminders that fire on the right person's phone
An easy way to see the full history with a single contact
What to look for in lightweight customer list software
When the time comes, look for three things and ignore the rest. A clear list view you can sort and filter quickly. Reminders that fire on the right person's phone (not just an email that gets buried). An easy way to see the full history with a single contact - calls, emails, notes, last meeting - on one page. That is enough for most small businesses for years. Features to ignore at the start: marketing automation, complex pipelines with twelve stages, integrations with things you do not use, lead scoring algorithms, dashboards. They are nice in theory and unused in practice.
There are several categories of lightweight customer list product worth considering: the simple, low-cost ones aimed at one to ten person businesses; the slightly larger products that bundle a customer list with email and a website; the all-in-one systems that include invoicing and project management. We avoid recommending specific brand names because the market changes every year, but we will say plainly: if a tool requires a paid setup specialist to make work, it is too big for the kind of business this eBook is written for.
How to actually choose
Three steps that take an hour, not a fortnight. One, write down the three things the spreadsheet stopped doing - in plain English, not feature names. Two, ask three other small business owners in your network what they use; their answers are more useful than any review site. Three, pick one product, set it up with twenty real contacts in an afternoon, use it for two weeks. If after two weeks you trust it more than the spreadsheet, move the rest. If not, abandon it cheerfully and try the next one. Most products have free trials; use them properly.
Migrating from a spreadsheet
When you do migrate, do it in batches. Move the active customer tab first; that is the smallest, most important and easiest to test. Run the new system and the spreadsheet in parallel for two weeks, with the rule that any update goes into the new system first. Then move the opportunities tab. Then the dormant tab. Archive the old spreadsheet at the end, do not delete it; you will want to go back to it for context occasionally for the next six months.
What to do this week
If you do not yet have any list, set up the spreadsheet structure above and seed it with twenty real contacts. Do not start with two hundred; twenty is enough to feel the shape. If you have a spreadsheet that is creaking, write down the three specific things that stopped working and look at one lightweight product against those three things this weekend.
The previous chapter explained why this matters; this chapter chooses the container. The next chapter Pipeline Stages That Match Reality decides how the contents of that container move through your business. Recurring principle: use AI and tools to support judgment, not replace it.
The rest of this chapter walks through the practical steps, the templates and the checklists you need to put it into action. It includes worked examples, copy frameworks and the small decisions that make the difference between a plan that sits in a drive and one that gets used.
Inside you'll find a step-by-step playbook, a downloadable template, a checklist you can run this week and a short list of common mistakes to avoid before you start.
The full action plan, broken into weekly steps.
Ready-to-use scripts, templates and checklists.
Worked examples for different sized businesses.
Common mistakes and how to avoid them.
Members-only chapter
Become a member to read the full chapter
Members get the complete chapter, the step-by-step plan, the templates and the checklists. Cancel anytime.
