Cold call tracker: free template (Excel and Google Sheets)
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. | Column | What goes in it |
|---|---|---|
| A | Company | Company name |
| B | Contact name | The person you want to reach |
| C | Job title | Their role, to check you have the right person |
| D | Phone | Direct number if you have it, with country code |
| E | For the follow-up after a conversation | |
| F | City | Useful for regional campaigns |
| G | Industry | To compare results per segment |
| H | Campaign | Which list and message this lead belongs to |
| I | Caller | Who owns the lead |
| J | Status | New, Contacted, In conversation, Later, Meeting, Not interested, Unreachable, Invalid |
| K | Attempts | Number of calls so far |
| L | Last call date | Date of the latest attempt |
| M | Last outcome | Not reached, Conversation, Call back, Meeting, Not interested, Invalid number |
| N | Next step | What happens next, in a few words |
| O | Next step date | When it happens; the column you sort by every morning |
| P | Had conversation | Yes once you spoke to the right person |
| Q | Reason not interested | One reason from a fixed list |
| R | Meeting date | Filled in when a meeting is booked |
| S | Meeting held | Yes or No after the meeting date |
| T | Notes | Anything else, kept short |
Set it up in Excel or Google Sheets
Three settings turn the list into a tracker. They take about ten minutes.
- 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.
- 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.
- 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.
| Number | Formula (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 attempt | Conversations ÷ call attempts |
| Meetings per conversation | Meetings booked ÷ conversations |
| Attempts per meeting | Call 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:
- Sort by column O, oldest date first. Call the overdue and today's call-backs before anything else.
- Filter status on New and Contacted for the rest of the calling block.
- 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.
- 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.
| Spreadsheet | Dialer | CRM | Ringlane | |
|---|---|---|---|---|
| Main job | A list you maintain by hand | Placing calls, numbers, recording | Customers and deals after the first meeting | The caller's working screen and the numbers from it |
| Logging an outcome | Typing in several cells | Depends on the product | Several fields per call | One key per call |
| Next step after a call | You type a date | Depends on the product | A task you create | Planned automatically per outcome |
| Numbers per caller and campaign | Pivot tables by hand | Call statistics | Reports on what is logged | Built in (per caller and campaign from Plus) |
| Typical cost | Free | Per user per month | Per user per month | Free 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.