Customer database software for small business: what to keep and what to use
Customer database software for small business: the fields to keep, how to clean up a spreadsheet, free plans and prices from $7 a user, and when to switch.
Start from the CRM template
Customers, calls and quotes in one place.
On this page
Customer database software keeps every customer’s contacts, service addresses, job history and notes in one searchable place. In November 2026, free options included HubSpot’s CRM (2 users, 1,000 contacts), Bigin’s free plan (1 user, 500 records) and Airtable (5 editors, 1,000 records), and a spreadsheet works until two people edit it.
This guide is for the owner or office manager of a service business, such as HVAC, landscaping or cleaning, whose customers live in a spreadsheet, a phone and an accounting program. A lawn company with 300 homeowners fits a free plan. An HVAC company with 1,800 customers and their contacts is past every free plan here. It covers the fields to keep, how to clean up before you move, what the tools cost, and when to leave a spreadsheet. GoodTaco’s CRM template and spreadsheet upload are at the end.
How we researched this: prices and limits come from each vendor’s own pages, November 2026. Check the page again before you buy.
Here is the short version, by how you work.
| If this is you | Look at first |
|---|---|
| One or two people, under 1,000 contacts | HubSpot’s free CRM |
| Three to ten people who call customers | Bigin or Pipedrive |
| You also schedule and invoice jobs | Jobber |
| You want your own fields and screens | Airtable, or an app of your own |
| Your customers are in your phone | Export them to a file (below) |
| Your customers are one messy sheet | Clean it first (steps below) |
What should a small business keep in its customer database?
Keep one list for each kind of thing, not one wide row per customer. A customer has several people, sometimes several addresses, and many jobs, and one row can’t hold that. The examples come from an invented HVAC company, Pinecrest Heating and Air, and its customer C-9107, Lakeview Dental.
The customer (one row each)
| Field | Example |
|---|---|
| Customer number | C-9107 |
| Name and type | Lakeview Dental, business |
| Owner | Marcus, who looks after them |
| Billing address | Invoices to the office manager |
| Agreement ends | Sept 30, 2027 |
| Things to know | Pays by check, usually 30 days |
The people (one row for each person)
| Field | Example |
|---|---|
| Name and role | Tamika Reyes, office manager |
| Phone and email | (555) 010-4417 |
| Main contact | Yes |
| Still there | No, if she leaves: mark it, don’t delete |
Service addresses (where the truck goes)
| Field | Example |
|---|---|
| Place and address | Main office, 214 Lake Rd |
| Access notes | Rooftop ladder behind the building |
| Equipment | Rooftop unit 2, model, serial, installed 2019 |
Jobs and follow-ups
| Field | Example |
|---|---|
| Date and what was done | Oct 14, blower motor replaced |
| Where and who | Main office, Marcus |
| Amount | $1,180 |
| Last contact | Nov 3 |
| Next follow-up | Call about spring tune-up, due Mar 1 |
Keep the billing address on the customer and each service address on its own, because invoices go to one and the truck goes to the other. When a landlord pays for a tenant’s unit, the landlord is the customer, the unit’s address is the service address, and the tenant is a person on it. For HVAC, plumbing and pest control, the thing you service matters as much as the customer, so keep its model, serial number, install date and warranty end. Ask GoodTaco to add an Equipment list under each customer.
For the job itself, see our HVAC work order guide.
A homeowner on a lawn route looks different. Here is an example for a two-crew lawn company: one person, one address, and the notes that save a trip.
| Field | Example |
|---|---|
| Customer | Dan and Carla Whitfield |
| Address | 12 Birch Ln |
| Access | Gate code 4471, side gate |
| Warning | Dog in the yard: text first |
| Service day | Tuesday, crew 2 |
| Due next | Fall aeration, September |
| Money | Last paid Oct 3 |
Keep passwords and full card numbers out of every note field; a customer database doesn’t need them. Keep the notes only your team knows, such as “invoices go to the property manager, not the board,” because a new hire can’t guess them.
How do you create a customer database from a spreadsheet?
Clean the list first, because moving duplicates into a new tool just gives you duplicates on a nicer screen. It takes about an hour for a few hundred customers.
Customers in your phone instead? In Google Contacts, select the contacts, open the more actions menu and choose Export, then pick Google CSV. A CSV is a spreadsheet file Excel and Sheets open. Most accounting programs can export their customer list the same way, so check yours.
- Make a copy. Work on the copy until you’ve checked the result.
- Trim the spaces. In Google Sheets, select your data and choose Data, Data cleanup, Trim whitespace, as Google’s help page describes.
- Put phone numbers in one format. “(555) 010-4417”, “555.010.4417” and “+1 555 010 4417” are one number that looks like three.
- Flag matching phones and emails. A phone number is a better match than a name, because “Lakeview Dental” and “Lakeview Dental Group” are one customer.
- Decide, row by row, what is a duplicate. The example below shows why.
- Split people from customers. One customer with three contacts becomes one customer row and three people rows.
- Add the customer number last, once the list is clean: C-9101, C-9102, and on.
Here is an example list. Column E strips each phone number to its digits, and column F counts how many rows share it.
Before you paste phone numbers into column C, select the column and choose Format, Number, Plain text. Otherwise “+1 555 010 2290” turns into an error. With the phones in column C, paste this into E2 and fill down, without editing it:
=RIGHT(REGEXREPLACE(C2&"","[^0-9]",""),10)
It removes everything but digits and keeps the last 10, which drops a leading +1. In F2, fill down:
=COUNTIF($E$2:$E$9,E2)
REGEXREPLACE works in Google Sheets and in Excel for Microsoft 365, but not in older Excel versions. COUNTIF works everywhere. Excel’s Remove Duplicates, on the Data tab, is described by Microsoft with one warning worth heeding: check what it will remove first, because deleting is permanent.
In the example, six of the eight rows show a 2. Not all are duplicates:
- Lakeview Dental and Lakeview Dental Group share a number. One customer: merge them.
- Birch Street Apartments and Birch St. Apts share a number. One customer: merge them.
- Ruth Okafor and Dale Okafor share a number, but they’re two people in one household. Keep one customer with two people.
- Dr. Singh has a different number but the same practice. Not a duplicate customer: a second contact on Lakeview Dental.
Eight rows become four customers. A formula finds the candidates, and you decide. Remove Duplicates only catches rows that match exactly. On the name column alone it would have deleted Dr. Singh’s row and missed every pair above.
What does customer database software cost?
For five people, prices run from $35 to $149 a month, billed yearly. Here are five tools from their own pricing pages in November 2026, with the plan we priced.
| Tool and plan | Five users a month |
|---|---|
| HubSpot Starter | $35 for new customers |
| Bigin Express | $35 |
| Pipedrive Lite | $70 |
| Airtable Team | $100 |
| Jobber Connect, 5 users included | $149 |
What each costs and suits:
- HubSpot. Free for up to 2 users. Starter is $7 per seat a month billed yearly, or $10 monthly, for new customers; HubSpot says it is normally $20 per seat, so five seats at the normal price is $100.
- Bigin. Zoho’s CRM for small businesses. Express is $7 per user a month billed yearly, or $9 monthly, and its pricing page lists 1 pipeline on Free and 3 on Express.
- Pipedrive. Lite is $14 per seat a month billed yearly. It includes lead, deal, contact, calendar and pipeline management, spreadsheet import and more than 500 integrations, with a 14-day free trial.
- Airtable. $20 per user a month billed yearly, $24 monthly: a flexible grid you shape yourself. Our guide to Airtable alternatives covers when to look elsewhere.
- Jobber. Job management for service companies. Core is $29 a month billed yearly for one user. Connect with five users is $149 billed yearly, or $199 with no commitment, and its client page lists customer profiles, past jobs and message history.
For an office of five that answers phones, we’d look at HubSpot’s free plan or Bigin first, because they’re cheap and the screens are familiar. If you schedule and invoice in the same tool, look at Jobber instead of running two.
Is there free customer database software?
Yes, with limits on people or records. In November 2026:
- HubSpot’s free CRM. Up to 2 users, 1,000 contacts, and 1,000 other records.
- Bigin’s free plan. 1 user, 500 records and 1 pipeline.
- Airtable’s free plan. 5 editors and 1,000 records per base.
- Google Sheets. Free with a Google account.
- GoodTaco. Free to start, with a template you copy and rename.
Count before you pick. A lawn company with 300 homeowners, one contact each, fits HubSpot’s free plan. An HVAC company with 1,800 customers and two contacts each has 3,600, past every free plan above, so budget for a paid plan. If customers, addresses and jobs share one Airtable base, they share its 1,000 records. Make sure you can export everything to a CSV file, so you can move later. For more tools, see our guide to free database software.
Is a customer database the same as a CRM?
Not quite. A customer database is the record: who the customer is, how to reach them, where you serve them and what you did there. A CRM (customer relationship management software) adds the work around it: follow-ups, quotes, a list of people who haven’t hired you yet, and a reminder of who has gone quiet.
Most service businesses need a bit of both, so don’t shop for the label. Write down the three questions your team answers most often, such as “what’s the gate code, and when is this lawn due?” or “who approves work over $2,500?”, and pick the tool that answers them fastest. Our page on CRM software for small business covers the sales side.
When should you move from a spreadsheet to a customer database?
A spreadsheet stops working when the second person edits it. Move when two or more of these are true. Print this page to tick them off.
☐ Two people add customers, and you’ve found the same customer twice.
☐ Someone asks “who’s the contact?” on every call.
☐ Nobody can say when a customer was last contacted.
☐ You keep addresses and gate codes in a text thread.
☐ A customer has more than one address or contact crammed into a cell.
☐ People work from phones in trucks and can’t find the row.
If the team already lives in Google Sheets, you can build a CRM in Google Sheets as a middle step. When you outgrow that, upload the clean sheet instead of retyping it.
How do you keep a customer database clean?
Make adding a customer a ten-second habit: search first, then add. A 15-minute monthly check does the rest:
- Sort by last contact and call the oldest three.
- Look for customers with nothing planned and no contact in 90 days.
- Search for two spellings of your five biggest customers.
- Mark anyone who has left as no longer there.
- Export a copy and save it with the date.
Build your customer database with GoodTaco
Start with the customer you answer questions about most. Open the CRM template, a working app whose sample company is Cedar Ridge Landscaping: ten customers with their contacts, service addresses, quotes and jobs, and follow-ups. Rename them to yours or clear the sample.
Each customer has a page with:
- Contacts. A main contact and everyone else, with role, phone and email. Someone who leaves is marked as no longer there, and the history stays. The call and text links open your phone’s own apps.
- Sites. Every service address, with access notes such as where the key is kept.
- Quotes and jobs. What you quoted and did, with dates and amounts.
- Activity. A log of the calls, emails, texts, visits and notes your team records, so anyone can see what happened last.
- Follow-ups. What to do next and by when, with an owner.
Search finds a customer by name, note, contact, email or address, and a phone number however it’s written. Adding a customer warns you if the name, phone or email already exists, which stops duplicates coming back. Today shows follow-ups due and the active customers going quiet: nothing planned and no contact for 90 days. On a phone it opens in the browser with tabs at the bottom, for calls made from the truck. The customer list exports to a CSV file.
To keep customer numbers, billing addresses, tags and equipment, ask GoodTaco:
Add a customer number, a billing address and tags like maintenance plan and referral to each customer. Add an equipment list under each customer with model, serial number and install date. Let me filter the customer list by tag.
If your customers are in a spreadsheet, turn the spreadsheet into an app: upload the Excel or CSV file, with no account needed to try it. GoodTaco puts your customers into the app’s own built-in database. Then ask it to split the contacts and addresses out. You change it by chatting, and every version is saved with one-click rollback. Your team signs in to use it.
GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.
Put every customer, contact and address where the whole office can find it. Start free
Frequently asked questions
What is customer database software?
Customer database software keeps every customer's contacts, service addresses, job history and notes in one searchable place, so anyone on your team can answer a call without hunting through a spreadsheet, a phone and an accounting program. Some tools are plain databases. Others are customer relationship management (CRM) software, which adds follow-ups and a sales pipeline.
What is the best customer database software for a small business?
It depends on how many people use it and what else you need. For one or two people, HubSpot's free CRM allows 2 users and 1,000 contacts. For a team of five, Bigin by Zoho CRM's Express plan lists $7 per user a month billed yearly. If you also schedule and invoice jobs, look at Jobber. If you want your own fields and screens, look at Airtable or an app of your own.
Is there free customer database software?
Yes. In November 2026, HubSpot's free CRM allowed 2 users and 1,000 contacts, Bigin's free plan allowed 1 user and 500 records, and Airtable's free plan allowed 5 editors and 1,000 records per base. Google Sheets is free with a Google account, and GoodTaco is free to start. Count your contacts first, because each person at a business customer is usually a record.
How do you create a customer database?
List what you need to know about a customer, then give each kind of thing its own list: customers, the people at each customer, service addresses and jobs. Move your existing customers into it, one row per customer, and clean up spacing, phone formats and duplicates first. Pick one place where everyone looks, and add new customers there the day they call.
What is the difference between a customer database and a CRM?
A customer database is the record of who your customers are and what you have done for them. A CRM, customer relationship management software, adds the work around it: follow-ups, quotes, a sales pipeline and reminders of who has gone quiet. Many small businesses need both, and most CRM tools include a customer database.
What should a customer database include?
For a service business: the customer's name and type, who looks after them, the billing address, each contact with a role, phone and email, each service address with access notes, the equipment you service, a history of jobs with dates and amounts, the last time anyone was in touch, and the next follow-up. Add a free-text note for the things only your team knows. Keep passwords and full card numbers out of it.
How do you remove duplicates from a customer list?
Trim extra spaces first, then put every phone number in one format. In Google Sheets, select the data and choose Data, Data cleanup, Remove duplicates, and in Excel, use Remove Duplicates on the Data tab. Both only catch rows that match exactly, so also look for the same phone number or email on two differently spelled names, and review them by hand before you delete.
Start from the CRM template
Get your own copy of a working CRM app with sample records, ready to make yours. Free to start.
Use the template, free