Connfig

Excel CRM Template: 15 Columns to Track Customers and Follow-Ups

Connfig TeamOctober 28, 2026crmguides
A customer spreadsheet with a calendar bell on its highlighted row sends three contact cards along a glowing path into a pipeline board

TL;DR: Track customers in one sheet with 15 columns, a locked stage list and a red flag on every overdue follow-up. Review it weekly and keep contact details in their own columns, so moving to a CRM later takes a header rename and one upload.

An Excel CRM template is a spreadsheet laid out like a simple CRM (customer relationship management system): one row per company, fixed columns for contact details, sales stage and the next follow-up, and drop-down lists so everyone types the same values. A small B2B team can run its first pipeline on one, provided every open row carries a next action and a date.

What columns does an Excel CRM template need?

Name the first sheet Customers. The example column is an example scenario: a dental practice from a lead list.

ColumnWhat goes inExample scenario
A CompanyLegal or trading nameBrightside Dental
B EmailOne main address per rowhello@brightside.example
C PhoneMain number+1 555 0100
D IndustryOne sector name from a fixed listDental practice
E CityCityAustin
F CountryCountryUnited States
G WebsiteWebsite or Google Maps linkbrightside.example
H ContactName and role of the person you talk toDana Lee, practice manager
I OwnerWho on your team handles the accountSam
J StageDrop-down, see the next sectionContacted
K TemperatureCold, Warm or HotWarm
L Last contactDate2026-10-26
M Next actionCall, Email, Meeting or Follow-upCall
N Next action dateDate2026-10-30
O NotesLatest outcome in one sentenceAsked for pricing for 2 locations

Columns A to G match the fields most CRM imports ask for. Columns M and N do most of the work, because nobody chases a deal that has no next action date.

Take the Industry values from your ideal customer profile.

Lock the stage column with a drop-down list

Free text breaks every count, because one person writes "proposal sent" and another writes "quote". Put the allowed values on a second sheet called Lists and define when a deal enters each one:

StageA deal enters it when
NewIt is in the sheet and nobody has contacted it
ContactedThe first email or call has gone out
QualifiedThey replied, the need is real and you know who decides
ProposalYou sent a price or a written offer
NegotiationThey are discussing terms, price or timing
WonThey signed or paid
LostThey said no, or went quiet after your last planned follow-up

In Excel, select column J, open Data > Data Validation, choose List under Allow and point the source at the range on Lists (Microsoft Support). In Google Sheets, use Insert > Dropdown or Data > Data validation (Google Docs Editors Help). Do the same for Temperature, Next action and Owner.

Make overdue follow-ups turn red

A conditional formatting rule marks the rows that need attention today. Select A2:O500, then in Excel go to Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format (Microsoft Support) and enter:

=AND($N2<>"",$N2<TODAY(),$J2<>"Won",$J2<>"Lost")

Pick a red fill, then add a yellow rule for open rows with no next action date:

=AND($A2<>"",$N2="",$J2<>"Won",$J2<>"Lost")

The dollar signs lock the columns, so the whole row changes color. Google Sheets accepts the same formulas under Format > Conditional formatting > Custom formula is (Google Docs Editors Help).

Run a weekly review in four steps

Clean the sheet on a fixed day, for example every Monday:

  1. Sort by next action date (column N), oldest first, and clear every overdue row, the ones in red.
  2. Give every yellow row (open, no date) a next action and a date, or move it to Lost.
  3. Note a one-sentence reason for every deal you mark Lost. After a quarter, these show where deals stall.
  4. Count deals per stage on the Lists sheet with =COUNTIF(Customers!J:J,"Proposal") and compare with last week.

Keep the sheet lean. In Salesforce's State of Sales survey of more than 7,700 sales professionals in 38 countries (December 2022), reps spent 28% of their week selling, and deal management and data entry took much of the rest. Add a column only when the weekly review needs it.

When does a spreadsheet stop being enough?

A sheet works while one or two people use it. Watch for these signs:

  • Two copies of the file circulate by email and nobody knows which one is current.
  • You open your inbox to find out what was last said to a customer.
  • Follow-ups depend on someone opening the file, because nothing reminds you.
  • You cannot tell who changed a stage or when.

A CRM handles each of these with one shared record per customer, email history on that record and tasks with due dates.

How to move the sheet into a CRM without retyping

Most CRMs import an .xlsx or .csv file. Before uploading, remove duplicate emails (Data > Remove Duplicates in Excel) and check that every row has an email.

In Connfig, the Bulk Add Customers button on the CRM page offers an .xlsx template and matches columns by header name. Email, City and Country already match; rename the other four before uploading:

Your headerTemplate header
Companybusiness_name
Phonegsm
Industrycategory
Websitebusiness_link

Columns H to O are ignored, and emails already in the system are skipped. Connfig records use the same seven stages plus temperature and next action fields, and an AI assistant such as Claude can fill those in after the import through Connfig MCP, the connection that lets it work in your account. As of 2026, the Free plan includes 100 manual CRM records, enough to test the import with part of your sheet, and paid plans have no such limit (pricing).

FAQ

Is Excel good enough as a CRM?

For one or two people with a few dozen open deals, yes, if every open row has a next action date. It falls short once several people edit it or you need email history and reminders.

Should I use Excel or Google Sheets for customer tracking?

Google Sheets is easier when more than one person edits, because everyone works in the same file. Excel also works offline. Both handle drop-downs and the formulas above.

How many pipeline stages does a small team need?

The template uses seven. With short sales cycles, merge Qualified and Proposal. Each stage needs an entry rule clear enough that two people would file the same deal in the same place.

When your sheet is ready to move, create a free Connfig workspace and upload it with the Bulk Add Customers template.

Connfig'i ücretsiz deneyin

Lead bulma, CRM ve e-posta kampanyalarını tek platformda toplayın. Kart bilgisi gerekmez.

Ücretsiz Başla

Related Posts