Free cold call tracking spreadsheet template

A working cold call log needs eight columns and the discipline to fill them in after every dial. Download the template below - it opens in Excel, Google Sheets, or Numbers - and start logging in the next two minutes. No email required.

Download the template

CSV format with three example rows showing how to fill it in. Delete the examples and make it yours.

Download CSV template

What each column is for

Date - The day you made the call. Keep one row per call, not per contact - repeat calls to the same person get their own rows.
Time - When you dialed. After a few hundred rows you can sort by this column and see which hours actually get answered.
Contact - The person you asked for. Leave it blank on pure cold dials and fill it in once you learn a name.
Company - The business name - useful for deduplicating and for grouping calls by account.
Phone - The number you dialed, formatted consistently so duplicates are easy to spot.
Outcome - Pick from a short, fixed list - for example: Interested, Not interested, No answer, Callback set, Wrong number. Free-text outcomes make your stats impossible to count.
Notes - One line on what happened. Write it immediately after hanging up; details evaporate within minutes.
Callback Date - When you promised to follow up. Sort by this column every morning - it is your call list for the day.

Getting your rates out of the spreadsheet

The point of logging calls is the math it unlocks. With consistent Outcome values you can compute your two core numbers with COUNTIF formulas:

Answer rate = rows where someone picked up ÷ total rows. In Sheets: =COUNTIF(F:F,"Interested")+COUNTIF(F:F,"Not interested") divided by COUNTA(A:A)-1.
Interest rate = rows marked Interested ÷ rows where someone picked up.

Review the numbers weekly. If the answer rate drops, your list or your calling hours are the problem; if answers are fine but interest is low, work on the first fifteen seconds of your pitch. Our guide to cold calling metrics walks through this in detail.

Where spreadsheets run out of road

A spreadsheet is genuinely fine at low volume. The failure mode is mechanical: every call costs you a row of typing, so on busy days you stop logging, and a call log with gaps in it lies to you. There are no callback reminders either - that "Callback Date" column only works if you remember to sort it.

ColdCallTracker exists for exactly that gap: logging a call is one tap, rates are computed live, and callbacks surface automatically. The free plan counts unlimited calls with your last 7 days of history; exporting your call history back out to CSV is part of Pro ($4.99/month) - read the honest comparison in tracker vs spreadsheet before you pick.

Frequently asked questions

Does the template work in Excel and Google Sheets?

Yes. It is a plain CSV file - open it directly in Excel, or in Google Sheets use File → Import. All eight columns are plain text and dates, no formulas or macros to break.

Do I need to give you my email to download it?

No. The download link above serves the file directly - no form, no signup.

How should I name outcomes?

Pick five or six fixed values and never improvise new ones mid-week. Consistent outcomes are what make answer-rate and interest-rate formulas possible.

Can I import this spreadsheet into ColdCallTracker later?

Yes. The Pro call list imports CSV files with column mapping, so the contacts in your spreadsheet (name, company, phone, notes, priority) carry straight over and become your call queue. Past call rows stay in your spreadsheet as an archive, and Pro can export your new history back to CSV anytime.

Tired of typing rows between dials?

ColdCallTracker logs a call in one tap and does the rate math for you. Free forever for unlimited calls.

Create a free account