Excel CRM Template: A Free Six-Sheet Layout You Can Import Later
Every column, dropdown and formula for a spreadsheet CRM that one to three people can run, with a weekly tracker per salesperson and layout rules so each sheet moves into a CRM without retyping.

by Benjamin WagnerAn Excel CRM template supports customer relationship management with one sheet for each kind of record (companies, contacts, deals, activities) and one sheet that counts and sums them. The layout below is free to copy: type the headers into a blank workbook, add the dropdowns and paste the formulas. It holds up for one to three people who keep a single copy of the file, and each sheet is arranged so it can later go into a CRM as an import, without retyping a row.
Customermates publishes this guide and is the CRM in the import example. The workbook itself needs nothing but a current version of Excel.
- Six sheets: Lists, Companies, Contacts, Deals, Activities and a Dashboard with a weekly tracker per salesperson.
- Save as .xlsx. The old .xls format stops at 65,536 rows, and Excel co-authoring needs .xlsx, .xlsm or .xlsb stored in OneDrive or SharePoint.
- One to three people, one sales process, a few hundred active contacts.
- Two people work the same deals, a follow-up slipped because nobody filtered the date column, or deals move in LinkedIn and WhatsApp threads that never reach the sheet.
- One sheet per import: services and companies first, then contacts, then deals.
Use the contact list template for a small, shared directory with a named owner and next step, before you decide whether to move it into a CRM.
An Excel-based CRM system needs the same operating rules as a dedicated tool: one owner for each row, stable identifiers and a clear next step. A sheet layout alone does not enforce those rules.
Where can I download the checked CRM workbook?
Download the free Excel CRM workbook in English, or the German CRM workbook. It is an original, compact example with six working sheets plus a Readme: Companies, Contacts, Deals, Activities, Dashboard and Lists. It is separate from the fuller column-by-column layout below; do not paste the formulas below into the download without checking their column references.
The example keeps one customer and two jobs together with stable source IDs. Both JOB-001 and JOB-002 point to C-001, even if you rename the customer. Its dates are date cells, its states use dropdowns and its customer lookup uses the source ID. The dashboard contains 9,000 EUR in example opportunities and 4,050 EUR weighted value: 7,200 × 50% plus 1,800 × 25%. The two open next steps remain separate activities.
Checked on 29 October 2026: we wrote and reopened both XLSX files with ExcelJS, checked sheet names, date cells, lookup references and stored formula results, and checked that they contain no macros or external workbook connections. We did not perform a visual session in Microsoft Excel or LibreOffice. Open your copy in your spreadsheet application, recalculate it and confirm the two example totals before replacing the fictional rows. Do not add several currencies into one total without an explicit conversion policy.
What survived the local CRM import check?
We parsed the English example into schema-aware JSON and imported it through the actual Customermates MCP endpoint in a synthetic local workspace. This was a JSON/API test, not a test of the browser's native XLSX wizard. A separate example list kept a manual amount and probability; it did not silently replace the default deal-value calculation.
| Source value | Saved-state check |
|---|---|
C-001, JOB-001, JOB-002 | Retained in Text source-ID fields and a source-to-record-ID map |
| One customer, two jobs | Both saved relationships pointed to the same customer record |
Example owner | Resolved to the actual synthetic member ID; do this for your own members |
| Proposal / Qualified | Mapped to the actual choice-option IDs |
| 7,200 / 1,800 EUR and 20 November / 4 December 2026 | Amount, currency and date matched after readback and export |
| 50% / 25% | Decimal probabilities matched after export |
Replaying the identical import with its idempotency key returned the same result without adding two more jobs. For a real move, read your current list, field and option IDs first, then follow the JSON import contract. Keep a mapping from workbook source IDs to CRM record IDs, read the saved records back, and archive the original workbook. This is not an attachment migration, an undo feature or ongoing synchronization.
Four layout rules before the first row
- One header row, one row per record. No merged cells, no blank rows, no subtotals inside the data.
- Make each sheet an Excel table. Select the range, press Ctrl+T and name it under Table Design › Table Name:
Companies,Contacts,Deals,Activities. The formulas below use those names, and tables grow with new rows. - Give every fixed list a dropdown. Use Data › Data Validation, Allow: List, with a table on the Lists sheet as the source. Microsoft's drop-down guide notes that dropdowns based on a table update by themselves when you add or remove items.
- Keep a stable source ID as well as readable names. The layout below uses exact names for the native XLSX link mapping. The compact download also keeps source IDs for lookups and a later JSON/API mapping. Names help people choose a record; preserve the source-to-record-ID map when names change.
The template, sheet by sheet
Lists
Small tables that feed the dropdowns. The stage table also carries a win probability, which the Deals sheet looks up.
| Table | Columns | Starting values |
|---|---|---|
Stages | Stage, Probability | Prospecting 10%, Qualification 20%, Demo 40%, Proposal 60%, Negotiation 80%, Won 100%, Lost 0% |
ContactTypes | Contact type | Lead, Customer, Partner, Former customer |
Sources | Source | Referral, Website, LinkedIn, Event, Outbound |
ActivityTypes | Type | Call, Email, Meeting, LinkedIn, WhatsApp |
Team | Name | Full name of everyone who owns records |
These stages and probabilities are an example. Customermates has no preset stages: create the same options on the Stage field of your deals list in Data model (or let AI setup build them in the cloud), and the Stage column imports later without renaming. Treat the percentages as a first guess and replace them once you have a few months of won and lost deals to count.
Companies
Columns: Company (unique name), Industry (dropdown), Website, City, Country, Owner (dropdown from Team), Notes. Decide once whether you write "Ltd" or "Limited" and keep to it. Two spellings are two companies to every lookup and every importer.
Contacts
| Column | Content | Example |
|---|---|---|
| A First name | Text | Sarah |
| B Last name | Text | Okafor |
| C Company | Dropdown from the Company column of Companies | Brookfield Architects |
| D Email | Text | sarah@brookfield-architects.example |
| E Phone | Stored as text, so the plus sign survives | +44 113 496 0000 |
| F LinkedIn | Profile URL | linkedin.com/in/sarahokafor |
| G Contact type | Dropdown from ContactTypes | Customer |
| H Source | Dropdown from Sources | Referral |
| I Owner | Dropdown from Team | Anna Berg |
| J Last contact | Date | 2025-11-28 |
| K Notes | Short text | Prefers calls before 10:00 |
Keep first and last name apart: most CRMs need both to create a person.
Deals
| Column | Content | Example |
|---|---|---|
| A Deal | Text | Brookfield Architects security review |
| B Company | Dropdown from Companies | Brookfield Architects |
| C Contact | Full name of the contact | Sarah Okafor |
| D Value | Number | 18000 |
| E Stage | Dropdown from Stages | Proposal |
| F Probability | Formula | 60% |
| G Weighted | Formula | 10800 |
| H Expected close | Date | 2026-01-31 |
| I Owner | Dropdown from Team | Anna Berg |
| J Next step | One sentence | Send revised scope |
| K Next step date | Date | 2025-12-04 |
| L Closed on | Date, filled when Won or Lost | |
| M Loss reason | Dropdown: Price, Timing, Competitor, No decision |
Enter the two formulas once in the first data row; the table fills them down:
F Probability =XLOOKUP([@Stage],Stages[Stage],Stages[Probability],0)
G Weighted =[@Value]*[@Probability]XLOOKUP needs Excel for Microsoft 365, 2021 or 2024. Microsoft's XLOOKUP reference says it is not available in Excel 2016 and 2019, where =INDEX(Stages[Probability],MATCH([@Stage],Stages[Stage],0)) does the same.
To color past next-step dates red, select the data rows of column K and add a rule under Home › Conditional Formatting › New Rule › "Use a formula to determine which cells to format": =AND($K2<>"",TODAY()>$K2). The color shows only to whoever opens the file. The workbook itself notifies nobody.
Activities
One row per touch that mattered: Date, Contact (full name), Deal (name, or empty), Type (dropdown from ActivityTypes), Owner, Summary (one or two sentences on what was said and agreed) and Next step. It is the only sheet that answers "what did we last tell them?", so fill it right after the call.
Dashboard
Five pipeline numbers:
Open pipeline =SUMIFS(Deals[Value],Deals[Stage],"<>Won",Deals[Stage],"<>Lost")
Weighted pipeline =SUMIFS(Deals[Weighted],Deals[Stage],"<>Won",Deals[Stage],"<>Lost")
Win rate =COUNTIFS(Deals[Stage],"Won")/MAX(1,COUNTIFS(Deals[Stage],"Won")+COUNTIFS(Deals[Stage],"Lost"))
Won this month =SUMIFS(Deals[Value],Deals[Stage],"Won",Deals[Closed on],">="&EOMONTH(TODAY(),-1)+1)
Past next steps =COUNTIFS(Deals[Next step date],"<"&TODAY(),Deals[Stage],"<>Won",Deals[Stage],"<>Lost")For the pipeline by stage, insert a PivotTable from Deals with Stage in Rows and Value in Values, and put a bar chart on it. Refresh it after edits.
Once two or more people sell, add a tracker per salesperson. Put the Monday of the week in B1 and one name per row from A4 down, then copy these row-4 formulas down:
Calls =COUNTIFS(Activities[Owner],$A4,Activities[Type],"Call",Activities[Date],">="&$B$1,Activities[Date],"<"&$B$1+7)
Meetings =COUNTIFS(Activities[Owner],$A4,Activities[Type],"Meeting",Activities[Date],">="&$B$1,Activities[Date],"<"&$B$1+7)
Open pipeline =SUMIFS(Deals[Value],Deals[Owner],$A4,Deals[Stage],"<>Won",Deals[Stage],"<>Lost")
Won this week =SUMIFS(Deals[Value],Deals[Owner],$A4,Deals[Stage],"Won",Deals[Closed on],">="&$B$1,Deals[Closed on],"<"&$B$1+7)
Past next steps =COUNTIFS(Deals[Owner],$A4,Deals[Next step date],"<"&TODAY(),Deals[Stage],"<>Won",Deals[Stage],"<>Lost")Plenty of calls with a flat pipeline points to a qualification problem. A rising count of past next steps points to a follow-up problem. Use the tracker for coaching, not as a public ranking, or the activity counts start to inflate.
Excel, Google Sheets or a CRM?
| If this describes you | Use | Watch for |
|---|---|---|
| One person, a few hundred contacts, most conversations by email | This Excel template on your own machine | Keep one copy and back it up weekly |
| Two or three people on Microsoft 365 who edit the same file | The workbook in OneDrive or SharePoint with co-authoring | Needs a Microsoft 365 subscription and .xlsx, .xlsm or .xlsb |
| A team that lives in Google Workspace | The same layout in Google Sheets, see the Google Sheets CRM guide | Re-check each formula after rebuilding it |
| Several people share deals, follow-ups slip, deals move in LinkedIn or WhatsApp chats | A CRM | Plan the import below before you pick one |
Where a spreadsheet CRM stops working
Size is rarely the reason; these limits show up first.
- Links are text. Rename a company and every contact, deal and lookup that used the old name points nowhere until you run Find and Replace over the workbook.
- The file waits for you. A red date helps only the person who opens the sheet, and messages from email, LinkedIn or WhatsApp arrive only when someone types a summary.
- Access is all or nothing. Anyone who can open the workbook can read every sheet.
- Personal data spreads over copies. Under the GDPR, a person may ask what you hold about them (Article 15) and have it erased (Article 17). With a workbook, that means every copy on every laptop and in every sent folder.
When to switch: a checklist
- Two or more people update the same deals in a normal week.
- A follow-up slipped because its date sat in a column nobody filtered.
- You copy messages from LinkedIn or WhatsApp into the sheet, or you have quietly stopped doing it.
- Fixing the Dashboard takes longer than reading it.
- Someone asks who can see the customer list, and the honest answer is "anyone with the file".
If two of these are true, I would move. One alone is usually fixable inside the workbook.
Moving the template into Customermates
Customermates imports Excel workbooks (.xlsx or .xls) and CSV files, one list at a time. The import documentation has the full rules. A spreadsheet only follows up when someone remembers to open it. Once the sheet is in Customermates, each client's conversations sit on the client record (on Customermates Cloud from Pro), Mate or your own AI agent drafts the reply and the next step, and the next-step date feeds your dashboard instead of a red cell. Here is where the template's columns land:
| Template column | Customermates field |
|---|---|
| Company | Organization name |
| First name, Last name | First name and Last name |
| A contact's or deal's Company | Organizations, matched by name |
| A deal's Contact | Contacts, matched by full name |
| Email, Phone, LinkedIn | Contact details on the contact |
| Industry, Contact type, Source, Loss reason | Single choice custom fields |
| Website; City, Country, Next step | Web address custom field; Text custom fields |
| Last contact, Expected close, Next step date, Closed on | Date custom fields |
| Stage | The deal's Stage field |
| Value | Line items, see step 2 |
| Probability, Weighted | Left out: the stage's probability sets the weighted value |
| Owner | Assigned, matched by the team member's full name |
| Notes | Notes |
| Open next steps from Activities | Tasks |
Create the custom fields first
In Data model, open the list and choose Add, then Field. For each dropdown column, create a Single choice field whose option labels match your Lists sheet exactly; the import flags any cell that is not an option. Inspect the stage field and probabilities in your workspace; AI setup and existing workspaces can use different lists and options. Create or adjust the needed options in Data model rather than assuming they match this example.Decide how deal values come in
A deal's value in Customermates is the sum of its line items, each a service price times quantity. Import your price list into Services first (Name and Price are required), then add line items with their quantities on each deal. If every deal has its own price, a Money input field can keep the number. It does not automatically replace the existing line-item calculation; a schema manager must preview and deliberately change the value and weighting configuration if that is the intended model.Import in dependency order
Services, then companies into Organizations, then contacts, then deals. Links are matched by name, ignoring case, so a company must exist before a contact can point to it, and a name that matches no record or several is flagged. A comma separates names within a cell, so a firm called "Hale, Brook and Partners" needs a rename before the import or a link set by hand afterwards.Run the wizard
On each list, open More actions, choose Add from file and pick the file. The wizard asks which sheet to import, so the workbook can keep its other sheets; save it as .xlsx. A file can currently hold up to 10 MB and 5,000 rows. Match each column to a field; email addresses, phone numbers and LinkedIn profiles go into the contact's Contact details field.Fix or skip problem rows
The check lists every problem by row before anything is added. Fix the cells in Excel and check again, or import the rest and skip those rows. An import has no undo, so run ten rows first.Turn open next steps into tasks
From Activities, bring over only open next steps, as tasks linked to the deal and contact and assigned to the owner. Tasks have no due date field, so add a Date custom field for the date. Older history can go into the deal's Notes or stay in the archived workbook.
What replaces the dashboard and the red cells
- The pipeline becomes the Deals list as a board grouped by Stage, with total and weighted value per column; the pipeline view shows it.
- Past next steps become a saved view of deals with a Next step date, sorted oldest first. For deals nobody has touched, filter Updated at with Older than… and 14 days.
- The morning check can run in Customermates Cloud. Customermates has no reminders or notifications, but a routine set to run every day at 08:00 can work through an instruction like this one, using hosted AI credits:
List my open deals whose Next step date is today or earlier. For each one, create a task linked to the deal, assigned to me, named "Follow up" plus the deal name. Do not send or draft any messages.
A routine acts with its owner's access, and Mate sends messages when told to, so the instruction has to say what it must not do. Starter includes 1 routine per user and Pro 5; the routines documentation lists the run limits.
- The Activities sheet gives way, on Pro and higher, to the unified inbox, which keeps email, LinkedIn, WhatsApp, Instagram and Telegram threads with the contact. Pro includes 1 connected account per user, Business 3. Starter has no inbox.
What it costs, and when Customermates is the wrong step
| Team | Plan | Per month |
|---|---|---|
| 3 people, CRM without inbox | Starter, €12 per user | €36 |
| 3 people, with the unified inbox | Pro, €29 per user | €87 |
| Your own server | Self-hosted AGPL core | No licence fee, plus your hosting; REST, webhooks and MCP, but no inbox and no Mate |
Billing is monthly, and the hosted trial runs 14 days on Pro with no credit card: start your trial and import one sheet to see your own deals there. Each paid hosted plan includes monthly hosted AI credits per active user; see pricing.
Customermates has calculated fields, including values from the same record and totals over linked records. It is the wrong step if you need a general spreadsheet with arbitrary cell formulas and workbook layouts; keep that analysis in Excel through the export. It is also wrong if your team needs a phone dialer or email campaigns, or a native app on the phone: Customermates has no mobile app, no telephony and no campaign tool. Look for a CRM that ships those.
FAQ
Can you build a CRM in Excel?
Yes, for a small team. The six-sheet layout above covers companies, contacts, deals, activities and a dashboard. What Excel cannot do on its own is notify anyone, keep links intact when a name changes, or pull in conversations. Excel is a spreadsheet, not a CRM; Microsoft sells its CRM separately as Dynamics 365 Sales.
Is there a free Excel CRM template?
The layout in this article and the downloadable XLSX example above are free and need nothing except a compatible spreadsheet application. If you download a template elsewhere, check three things before you enter data: one record per row, contacts separate from companies, and no merged cells. A template that fails them is hard to import into a CRM later.
How many contacts can an Excel CRM handle?
A worksheet holds 1,048,576 rows according to Microsoft's Excel specifications, and a Google Sheets file up to 20 million cells according to Google's file limits. The practical limit is people, not rows: the checklist above applies long before the file fills up. Customermates currently reads up to 5,000 rows per import file, so split larger sheets.
Can a CRM stay in sync with my Excel file?
Not Customermates. Import and export are file transfers, one list at a time, with no live sync and no CSV export. A round trip works: export a list to .xlsx (up to 5,000 records), edit it in Excel and import it again as Existing records, and its Record ID column updates those records instead of creating duplicates.
What should a sales tracking spreadsheet for reps include?
One row per salesperson per week: calls, meetings, open pipeline, revenue won and the number of deals with a past next step. Calculate every cell from the Deals and Activities sheets with COUNTIFS and SUMIFS, as in the tracker above, so nobody types numbers that drift from the data.
Excel and Google Sheets details checked on 8 October 2026 against Microsoft's Excel specifications and limits, Excel with earlier versions, co-authoring, drop-down lists, XLOOKUP and Dynamics 365 Sales pages, and Google's Drive file limits.
Start from one description
One description. A workspace your agent built.
This is what setup builds from one sentence. Sample data, the real product.
Describe your business
One sentence about your team, your clients and how you sell.
Mate builds it
It asks a few questions, then creates the lists, pipeline, dashboard and playbook.
Work in it
Connect LinkedIn and email. Click through a finished example below.
We're a four-person strategy consultancy. Track clients, engagements and proposals, and help us follow up with prospects on LinkedIn.
Widgets built from the workspace's own lists and fields
Every client conversation from email, LinkedIn and WhatsApp in one place. Mate sets up your workspace and drafts the follow-up, you review and send. Works with Claude, ChatGPT or any agent that speaks MCP.
Related pages
Google Sheets CRM: Free Template and Setup Guide
Build a Google Sheets CRM with five tabs, dropdowns, QUERY formulas and a daily Apps Script email, and learn the point where a spreadsheet stops working.
Simple CRM
A simple CRM with an open-source core: lists built by the cloud AI setup or by you, plus Excel import. From €12 per user per month.
Digital Rolodex: Options Compared and How to Start
What a digital rolodex should hold, how phone contacts, a spreadsheet, Notion, a personal CRM and a business CRM compare, and how to move your cards.
Contact List Template: Free CSV Downloads
Download a blank contact list and a worked CSV example. Set up Excel imports, keep useful fields and give every customer follow-up an owner.
Customermates
Follow up on every client conversation
Start with one channel and one client on Customermates Cloud, or self-host the open-source core.
✓ No credit card required ✓ First 14 days free





