CRM software like Salesforce, HubSpot, and Pipedrive are powerful tools built for sales teams with complex processes, large pipelines, and multiple users. They are also expensive, time consuming to set up, and frequently underused by the small businesses that pay for them.
For a small business with a manageable number of prospects and customers, Excel handles the core CRM functions well. Tracking leads, managing your pipeline, recording customer interactions, and monitoring sales performance are all things a well-built Excel system does without any monthly subscription. Here is how to build one.
A CRM at its core answers four questions. Who are your prospects and where did they come from? Where is each deal in your sales process? When did you last contact each person and what happened? And what is your pipeline worth in total? Build your Excel system to answer those four questions and you have everything a small business actually needs.
Your contact database is the foundation of your sales system. One row per contact with everything you need to know about them and where they came from. This sheet feeds your pipeline tracker and activity log.
| Column | What to Enter |
|---|---|
| Contact ID | Short unique code, C001 or initials |
| Full Name | Contact's name |
| Company | Their business name |
| Title | Their role, useful for knowing who you are talking to |
| Primary contact email | |
| Phone | Best phone number |
| Source | Where this lead came from, referral, website, cold outreach, event, etc. |
| Date Added | When they entered your system |
| Status | Lead, Prospect, Customer, or Inactive |
| Notes | Anything relevant about the contact or company |
Your pipeline tracker shows every active opportunity and where it stands in your sales process. This is the sheet you look at every Monday morning to know what deals need attention this week.
Here is what a typical pipeline looks like in Excel:
| Column | What to Enter or Formula |
|---|---|
| Opportunity ID | Unique reference, OPP001 etc. |
| Contact ID | Links to your contact database |
| Company | =VLOOKUP from contact database |
| Opportunity Name | Brief description of the deal |
| Deal Value | Expected contract or project value |
| Stage | Lead, Qualified, Proposal, Negotiation, Won, Lost |
| Probability | Estimated likelihood of closing as a percentage |
| Weighted Value | =Deal Value * Probability |
| Expected Close Date | When you expect this to close |
| Days in Stage | =TODAY() minus date entered current stage |
| Last Activity | Date of most recent contact |
| Next Action | What you need to do next and by when |
The weighted pipeline value is your most important summary metric:
The activity log records every meaningful interaction with a prospect or customer. Calls, emails, meetings, proposals sent, follow ups made. This is what turns a contact list into an actual CRM and gives you the context you need to pick up any conversation where it left off.
| Column | What to Enter |
|---|---|
| Date | When the interaction happened |
| Contact ID | Which contact this activity relates to |
| Activity Type | Call, Email, Meeting, Proposal, Demo, Follow Up |
| Summary | Brief note on what was discussed or what happened |
| Outcome | Positive, Neutral, Negative, or No Response |
| Next Step | What you committed to do next |
| Follow Up Date | When you need to follow up |
| Completed | Yes or No |
Your sales dashboard pulls key metrics from your pipeline and activity log to give you a clear view of how your sales process is performing. These are the numbers that tell you whether you are on track to hit your revenue targets.
Total pipeline value:
Weighted pipeline value:
Win rate this month:
Average deal size for won deals:
Revenue closed this month:
Excel works well for sales tracking when you have one or two salespeople, a manageable number of active opportunities, and a sales process that does not require automated emails, lead scoring, or deep integration with marketing tools. For most small businesses selling services or consulting, that describes the situation accurately.
The signals that it is time to move to dedicated CRM software are usually volume-related. You are tracking hundreds of active opportunities and the spreadsheet becomes hard to navigate. You need automated follow up sequences. Multiple salespeople need to update the same pipeline simultaneously. Or you need your CRM to integrate with your email marketing or accounting software.
Until then, a well-built Excel sales tracker gives you more visibility than most small businesses have and costs nothing to run.
Tell us about your sales process and we'll build a complete Excel CRM and pipeline tracker tailored to how you sell. Starting at just $75.
📧 Get Started Today