A CRM database is the organized list of people and companies who buy from you, or might, with their contact details and what's happened with each of them. The CRM database examples below show what that looks like in practice for a small business: which fields to keep, how to start in a spreadsheet and when a simple CRM is worth it.
Without one, contacts end up scattered across your phone, inbox, chats and sticky notes, and opportunities go cold.
What a CRM database is for
- Following up on time: knowing who's waiting on you and since when.
- Not relying on memory: anyone on the team can see where each contact stands.
- Selling again: past customers are the easiest ones to win back.
- Knowing where leads come from: which channel (events, referrals, social) brings the best contacts.
Example: the fields that matter
Start with a few and keep them complete:
- Name and company.
- Phone and email.
- Source: where you met.
- Interest: which product or service.
- Status: new, contacted, in conversation, won or lost.
- Last action and date.
- Next-step note.
A sample row: Jane Doe · Acme Interiors · +1 555 000 0000 · jane@example.com · Trade show · Kitchen remodel · Contacted · Oct 9 call · Send quote Friday.
More fields don't make the database better; they fill it with blanks. Add one only when you'll use it to make a decision.
Example: a spreadsheet CRM database
A spreadsheet is a fine starting point:
- One row per contact, one column per field. Never put two pieces of data in one cell.
- Dropdowns for status and source, so everyone writes the same thing.
- Filters to spot who's been "contacted" for over a week.
- One date format so you can sort.
The limit shows up when contacts arrive from several channels: you copy them by hand, and whatever isn't copied that day gets lost.
Example: a simple CRM fed by your digital card
A CRM is a customer database plus follow-up tools. You don't need an enterprise one to start; you need contacts to come in on their own and status at a glance. For more, read mini CRM for sales.
In Cardreen, the database builds itself from your digital business card: when someone scans your QR code and fills in the form, they land in the mini CRM with name, company, phone, email, the service they're interested in and their message. You set one of five statuses, add a note and a tag, and on paid plans export to CSV to open in a spreadsheet. See all card and mini CRM features.
Keeping your database up to date
- A fixed hour each week to review statuses and notes.
- Log it right away: update the note when you hang up.
- Remove duplicates once a month.
- Get consent before bulk messaging and respect opt-outs. Your country's data protection rules apply; check them.
Common mistakes
- Contacts with no source, so you can't tell which channel works.
- Vague statuses everyone reads differently.
- Separate databases per rep that nobody else can see.
- No next step written down.
FAQ
What is a CRM database?
An organized list of customers and prospects with their contact details, status and history, kept in a tool that helps you follow up.
What are examples of CRM data?
Name, company, phone, email, lead source, interest, status, last action and next step.
Can I use Excel as a CRM?
Yes, to start. It works with one row per contact and dropdowns for status. It gets hard when contacts arrive from several channels and must be copied by hand.