Back to Blog

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.

Benjamin WagnerBenjamin Wagnerby Benjamin Wagner
ExcelCRM TemplateSpreadsheet CRMSales Tracking

An 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.

At a glance

What you build
Six sheets: Lists, Companies, Contacts, Deals, Activities and a Dashboard with a weekly tracker per salesperson.
File format
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.
Who it suits
One to three people, one sales process, a few hundred active contacts.
Time to move
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.
How to move
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 valueSaved-state check
C-001, JOB-001, JOB-002Retained in Text source-ID fields and a source-to-record-ID map
One customer, two jobsBoth saved relationships pointed to the same customer record
Example ownerResolved to the actual synthetic member ID; do this for your own members
Proposal / QualifiedMapped to the actual choice-option IDs
7,200 / 1,800 EUR and 20 November / 4 December 2026Amount, 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

  1. One header row, one row per record. No merged cells, no blank rows, no subtotals inside the data.
  2. 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.
  3. 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.
  4. 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.

TableColumnsStarting values
StagesStage, ProbabilityProspecting 10%, Qualification 20%, Demo 40%, Proposal 60%, Negotiation 80%, Won 100%, Lost 0%
ContactTypesContact typeLead, Customer, Partner, Former customer
SourcesSourceReferral, Website, LinkedIn, Event, Outbound
ActivityTypesTypeCall, Email, Meeting, LinkedIn, WhatsApp
TeamNameFull 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

ColumnContentExample
A First nameTextSarah
B Last nameTextOkafor
C CompanyDropdown from the Company column of CompaniesBrookfield Architects
D EmailTextsarah@brookfield-architects.example
E PhoneStored as text, so the plus sign survives+44 113 496 0000
F LinkedInProfile URLlinkedin.com/in/sarahokafor
G Contact typeDropdown from ContactTypesCustomer
H SourceDropdown from SourcesReferral
I OwnerDropdown from TeamAnna Berg
J Last contactDate2025-11-28
K NotesShort textPrefers calls before 10:00

Keep first and last name apart: most CRMs need both to create a person.

Deals

ColumnContentExample
A DealTextBrookfield Architects security review
B CompanyDropdown from CompaniesBrookfield Architects
C ContactFull name of the contactSarah Okafor
D ValueNumber18000
E StageDropdown from StagesProposal
F ProbabilityFormula60%
G WeightedFormula10800
H Expected closeDate2026-01-31
I OwnerDropdown from TeamAnna Berg
J Next stepOne sentenceSend revised scope
K Next step dateDate2025-12-04
L Closed onDate, filled when Won or Lost
M Loss reasonDropdown: 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 youUseWatch for
One person, a few hundred contacts, most conversations by emailThis Excel template on your own machineKeep one copy and back it up weekly
Two or three people on Microsoft 365 who edit the same fileThe workbook in OneDrive or SharePoint with co-authoringNeeds a Microsoft 365 subscription and .xlsx, .xlsm or .xlsb
A team that lives in Google WorkspaceThe same layout in Google Sheets, see the Google Sheets CRM guideRe-check each formula after rebuilding it
Several people share deals, follow-ups slip, deals move in LinkedIn or WhatsApp chatsA CRMPlan 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 columnCustomermates field
CompanyOrganization name
First name, Last nameFirst name and Last name
A contact's or deal's CompanyOrganizations, matched by name
A deal's ContactContacts, matched by full name
Email, Phone, LinkedInContact details on the contact
Industry, Contact type, Source, Loss reasonSingle choice custom fields
Website; City, Country, Next stepWeb address custom field; Text custom fields
Last contact, Expected close, Next step date, Closed onDate custom fields
StageThe deal's Stage field
ValueLine items, see step 2
Probability, WeightedLeft out: the stage's probability sets the weighted value
OwnerAssigned, matched by the team member's full name
NotesNotes
Open next steps from ActivitiesTasks
  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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:

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

TeamPlanPer month
3 people, CRM without inboxStarter, €12 per user€36
3 people, with the unified inboxPro, €29 per user€87
Your own serverSelf-hosted AGPL coreNo 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.

  1. Describe your business

    One sentence about your team, your clients and how you sell.

  2. Mate builds it

    It asks a few questions, then creates the lists, pipeline, dashboard and playbook.

  3. Work in it

    Connect LinkedIn and email. Click through a finished example below.

Your description to Mate

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

Customermates for consultants

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.

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