Why does Excel say 'No templates found' when you search 'CRM'? Why does the official Microsoft Template site show zero CRM options? Why do so many people waste 3 hours building their own—only to realize it can’t track follow-ups across weeks?
The answer is simple: Excel *does* have a CRM template. It’s buried—and it’s not called 'CRM'. It’s labeled 'Customer Contact List', and it ships with every copy of Excel since 2016. But that’s only half the story.
The Problem
You’re tracking leads in Excel because your team won’t pay for HubSpot or you’re testing a side hustle. You’ve got names, emails, last contact dates, and notes—but they’re scattered across 4 sheets. No status column. No way to filter 'Follow up in 3 days'. No visual cue when Sarah Chen hasn’t replied since March 12.
Here’s what your current sheet probably looks like (A1:E12):
| Name | Company | Last Contact | Notes | |
|---|---|---|---|---|
| James Rivera | Nexus Labs | jrivera@nexuslabs.io | 2024-02-28 | Wants pricing PDF |
| Lena Park | Veridian Systems | l.park@veridian.co | 2024-03-05 | Demo booked Fri |
| Marcus Bell | TerraForge Inc | mbell@terraforge.com | 2024-01-19 | Sent contract, no reply |
| Aisha Khan | Orion Health | a.khan@orionhealth.net | 2024-03-10 | Needs integration docs |
| Diego Mora | Stellar Dynamics | dmora@stellardyn.com | 2024-02-14 | Cold call, left voicemail |
| Rita Zhang | Acme Corp | rzhang@acmecorp.com | 2024-03-01 | Budget approval pending |
| Tariq Ali | Voyant Group | tali@voyant.group | 2024-02-22 | Asked about API access |
No sorting by urgency. No conditional formatting for stale leads. No way to know who’s overdue without scanning each date manually. That’s not a CRM—it’s a graveyard.
The Solution
Do this now. Open Excel. Don’t type anything. Press Alt + F, then N. That opens the New workbook pane. In the search box, type 'contact list'—not 'CRM'. Hit Enter. Click the tile titled 'Customer Contact List'. It’s blue, has a phone icon, and says 'Template' in small gray text. That’s the CRM template.
Once open, you’ll see columns: First Name, Last Name, Company, Email, Phone, Status, Next Follow-up, Notes. That ‘Status’ dropdown? It’s pre-loaded with 'New', 'Contacted', 'Qualified', 'Proposal Sent', 'Closed Won', 'Closed Lost'. And 'Next Follow-up' auto-calculates from today + days you set.
Here’s how to make it actually work:
- Replace sample data: Paste your existing list into A2:H12 (skip header row). Keep column order exact—especially 'Next Follow-up' in G2:G12.
- Add due-date logic: In cell G2, enter
=IF(F2="Contacted",TODAY()+3,IF(F2="Proposal Sent",TODAY()+7,TODAY()+14)). Drag down to G12. - Flag overdue leads: Select G2:G12 → Home tab → Conditional Formatting → Highlight Cells Rules → Less Than → type
=TODAY()→ choose red fill. - Filter by urgency: Click the dropdown arrow in G1 → Sort Oldest to Newest. Overdue entries jump to top.
Result: Your cleaned-up view (A1:H12 after applying above steps):
| First Name | Last Name | Company | Status | Next Follow-up | Notes | |
|---|---|---|---|---|---|---|
| Marcus | Bell | TerraForge Inc | mbell@terraforge.com | Contacted | 2024-03-18 | Sent contract, no reply |
| Diego | Mora | Stellar Dynamics | dmora@stellardyn.com | Contacted | 2024-03-21 | Cold call, left voicemail |
| James | Rivera | Nexus Labs | jrivera@nexuslabs.io | Proposal Sent | 2024-03-29 | Wants pricing PDF |
| Lena | Park | Veridian Systems | l.park@veridian.co | Contacted | 2024-03-22 | Demo booked Fri |
| Aisha | Khan | Orion Health | a.khan@orionhealth.net | New | 2024-04-02 | Needs integration docs |
Going Further
Add a column 'Deal Value' (I2:I12) formatted as Currency. Then create a pivot table: Insert → PivotTable → select entire range A1:I12 → drag 'Status' to Rows, 'Deal Value' to Values (Sum), 'Next Follow-up' to Filters. You’ll instantly see total pipeline value by status.
Want email reminders? Use Power Query to pull Outlook tasks—but only if you’re on Windows and have Outlook installed. Paste this in Data → Get Data → From Other Sources → Blank Query → Advanced Editor:= Outlook.CurrentUser.TaskList. Filter for tasks tagged 'CRM Follow-up'.
Surprising tip: The 'Customer Contact List' template saves automatically to your OneDrive under 'Templates'. Rename it before editing—or you’ll overwrite the original and lose the clean version forever.
When NOT to Use This
Stop now if any of these apply:
• You need shared editing with real-time sync (Excel Online locks cells during edits)
• You have more than 5,000 contacts (filtering slows past 2,500 rows)
• You require automated email sequences (no SMTP integration built-in)
• Your sales cycle involves multi-stage approvals or legal sign-offs
• You’re syncing with QuickBooks or Stripe (no native connectors)
If you hit two or more of those, use Airtable or Zoho CRM instead—even the free tiers beat Excel at scale.
Keyboard Shortcuts
| Action | Shortcut | Notes |
|---|---|---|
| Open New pane | Alt + F, then N | Faster than clicking File > New |
| Apply conditional formatting | Alt + H, L, H | Home → Conditional Formatting → Highlight Cells |
| Toggle filter arrows | Ctrl + Shift + L | Works even if headers aren’t selected |
| Paste values only | Alt + E, S, V, Enter | Critical when pasting from web forms |
