Cold call tracker: free template (Excel and Google Sheets)

In short

A spreadsheet is enough for one caller and one list: one row per lead, with columns for status, attempts, last outcome, next-step date, reason for a no and meeting date. Download the free template below (CSV for Excel and Google Sheets), add two drop-down lists and four formulas, and you have a working cold call tracker. It breaks when several callers share a list, when call-backs slip, or when a manager wants numbers per caller; that is when a calling workspace such as Ringlane, or a dialer plus a CRM, earns its place.

A cold call tracker is a list with one row per lead and a few columns that tell you what happened and what comes next. For one caller with one list, a spreadsheet does the job. You need columns for the status, the number of attempts, the last outcome, the next step and its date, the reason for a no and the meeting date, plus two drop-down lists and a handful of formulas. Download the free cold call tracker template (CSV); it opens in Excel, Google Sheets and Numbers, with three fictional example rows. What to measure once the tracker fills up is covered in our guide to sales KPIs.

Below: the twenty columns, how to set it up in Excel or Google Sheets, the formulas for your rates, how to run a calling day from it, five signs you have outgrown it, and an honest comparison with a dialer, a CRM and Ringlane.

The columns in the template

Every column answers a question you will ask later. Keep the names as they are if you plan to import the file into a tool; most tools recognise them.

Col.ColumnWhat goes in it
ACompanyCompany name
BContact nameThe person you want to reach
CJob titleTheir role, to check you have the right person
DPhoneDirect number if you have it, with country code
EEmailFor the follow-up after a conversation
FCityUseful for regional campaigns
GIndustryTo compare results per segment
HCampaignWhich list and message this lead belongs to
ICallerWho owns the lead
JStatusNew, Contacted, In conversation, Later, Meeting, Not interested, Unreachable, Invalid
KAttemptsNumber of calls so far
LLast call dateDate of the latest attempt
MLast outcomeNot reached, Conversation, Call back, Meeting, Not interested, Invalid number
NNext stepWhat happens next, in a few words
ONext step dateWhen it happens; the column you sort by every morning
PHad conversationYes once you spoke to the right person
QReason not interestedOne reason from a fixed list
RMeeting dateFilled in when a meeting is booked
SMeeting heldYes or No after the meeting date
TNotesAnything else, kept short

Set it up in Excel or Google Sheets

Three settings turn the list into a tracker. They take about ten minutes.

  1. Open the file. In Excel, open the CSV directly; in Google Sheets, use File, Import, and choose the CSV. Save it as a normal workbook so the settings below are kept.
  2. Add drop-down lists. Select column J and add a list with the eight statuses; select column M and add a list with the six outcomes; do the same for column Q with your reasons for "not interested" (for example: already has a supplier, no need now, no budget, not the decision maker, bad experience). In Excel this is Data, Data Validation, List; in Google Sheets, Data, Data validation, Dropdown. Fixed lists are what make the numbers countable.
  3. Colour overdue call-backs. Select column O and add a conditional formatting rule with the formula =AND($O2<>"",$O2<TODAY()). Every red date is a promise you have not kept yet.

Freeze the top row and filter on column I if more than one person calls from the sheet.

Formulas for your rates

Put these on a second tab. They assume rows 2 to 1000; adjust as your list grows.

NumberFormula (Excel and Google Sheets)
Call attempts=SUM(Tracker!K2:K1000)
Conversations=COUNTIF(Tracker!P2:P1000,"Yes")
Meetings booked=COUNTA(Tracker!R2:R1000)
Meetings held=COUNTIF(Tracker!S2:S1000,"Yes")
Conversations per attemptConversations ÷ call attempts
Meetings per conversationMeetings booked ÷ conversations
Attempts per meetingCall attempts ÷ meetings booked
Attempts for one caller=SUMIFS(Tracker!K2:K1000,Tracker!I2:I1000,"Anna")

Name the first tab "Tracker" or change the formulas to match. A per-lead sheet counts at most one conversation per lead, so these are approximations; good enough for one caller, not for a team. For what each rate means and what to do when it is low, see cold calling KPIs.

Run a calling day from the sheet

A tracker only works if the routine is fixed. Every morning:

  1. Sort by column O, oldest date first. Call the overdue and today's call-backs before anything else.
  2. Filter status on New and Contacted for the rest of the calling block.
  3. After each call, before you dial the next number, update K, L, M, N and O. Logging at the end of the day loses the unanswered calls.
  4. Stop after three to five attempts per lead. In Cognism's 2025 data, 93% of all conversations happened within the first three attempts and 98.6% within five; set the status to Unreachable after your last attempt.

For context on volume: The Bridge Group's 2025 survey found a median of 56 dials a day on phone-centric SDR teams. A spreadsheet can keep up with that for one person, as long as logging happens after every call.

Five signs you have outgrown the spreadsheet

  • Two people called the same lead. Shared sheets do not lock a row while someone is on the phone.
  • Call-backs slip. Red dates pile up in column O because nobody sorts every morning.
  • Friday is report day. Someone spends an hour building numbers per caller and per campaign.
  • Logging happens later. Callers fill in the sheet at the end of the day, so unanswered calls go missing and your rates look better than they are. With an average of 19 dials per conversation in Gong's data, most of what gets forgotten is exactly those calls.
  • Copies travel by email. Several versions of a file with names and phone numbers is a data protection risk, and nobody knows which one is current.

Spreadsheet vs dialer vs CRM vs Ringlane

Each tool adds something different. This is what they add for a calling team; check each vendor's site for current prices.

SpreadsheetDialerCRMRinglane
Main jobA list you maintain by handPlacing calls, numbers, recordingCustomers and deals after the first meetingThe caller's working screen and the numbers from it
Logging an outcomeTyping in several cellsDepends on the productSeveral fields per callOne key per call
Next step after a callYou type a dateDepends on the productA task you createPlanned automatically per outcome
Numbers per caller and campaignPivot tables by handCall statisticsReports on what is loggedBuilt in (per caller and campaign from Plus)
Typical costFreePer user per monthPer user per monthFree plan for one caller, paid plans per user

Ringlane is not a dialer and not a CRM: you call with your own phone or softphone, and Attio is the CRM it connects to today. Our guide to cold calling software explains when you need which layer, and sales KPI dashboard shows what to put on one screen once the data is clean.

Moving from the sheet to Ringlane

You can import the same file. Ringlane takes Excel and CSV files, and Bizzy exports, and recognises most column names by itself; you check the mapping and leave columns you do not need empty. Company and phone number are the minimum; contact name, job title, email, city and industry come along too, and extra columns you want to keep can become custom fields. Ringlane counts attempts and outcomes from the calls you log in it, so your reports start on the day you switch; keep the sheet's history as a note if you need it. Ringlane does not supply leads: the list stays yours. It has a free plan for one caller with no end date, and paid plans per user for teams; see pricing. Custom fields can be choice lists or dates (see attributes), and on Pro and Business rules keep your data clean. From Plus you call through your softphone in one click (see call with your own phone or softphone). The Academy guide to importing a call list walks through the four steps.

Frequently asked questions

Can I do cold calling from a spreadsheet?
Yes, for one caller with one list. Sort by next-step date every morning, call from the top, and log the outcome in the row right after each call. A spreadsheet starts to fail when several people edit it at once, when nobody sorts it daily, or when you need numbers per caller and per campaign every week.
What columns should a cold call tracker have?
At least: company, contact name, phone, status, number of attempts, last call date, last outcome, next step, next-step date, reason for not interested, meeting date and whether the meeting was held. Add campaign and caller as soon as more than one list or person is involved. Our free template has all twenty columns.
How do I track cold calls in Google Sheets?
Import the CSV template with File, Import, then add drop-down lists for status and last outcome under Data, Data validation. Use COUNTIF and SUMIFS for your totals per caller, and a conditional format that colours overdue next-step dates. Share the sheet only with the people who call from it.
When should I switch from Excel to a CRM or calling tool?
When call-backs start slipping, when two people call the same lead, when you spend an hour every Friday building the weekly numbers, or when callers log at the end of the day instead of after each call. At that point the cost of the spreadsheet is the time and the meetings you lose, not the licence you save.

Sources

  1. Cognism: The State of Cold Calling in 2025 (online since February 2025)
  2. The Bridge Group: SDR Models, Motions and Metrics 2025 (6 February 2025)
  3. Gong Labs: The hidden power of cold calling, insights from 300M calls (18 July 2024)