Cold call tracking sheet (free template)

How to use the sheet

Download the CSV with the button above and open it. Excel opens it directly; in Google Sheets, use File → Import and upload it.

1. Delete the three example rows, then save the file in your spreadsheet's own format (an Excel workbook or a Google Sheet), so filters and dropdowns are kept.
2. Turn on filters for the header row, so you can sort and filter by any column.
3. Add one row per call, not per contact. A contact you call three times has three rows, and together they are that contact's history.
4. Fill in the row as soon as you hang up, while you still remember what was said.
5. Start each calling session by sorting on Follow-up date, so the calls you promised come first.

What each column is for

Fill in everything up to Attempt before you dial, and the rest right after the call.

• Date: The day you made the call. Example: 2026-10-05
• Company: The company you called. Example: Example Co
• Contact: The person you were trying to reach. Example: Alex Example
• Title: Their job title, so you can see which roles pick up and which say yes. Example: Head of Operations
• Phone: The number you dialed. Example: (555) 555-0101
• Time zone: Their time zone, so you call during their working day, not yours. Example: Eastern
• Attempt: Which try this is for the contact: 1 for the first call, 2 for the second, and so on. Example: 1
• Outcome: What happened, from the outcome list. One outcome per row. Example: Voicemail
• Next step: What you'll do next, in a few words. Example: Send email, call again
• Follow-up date: When to do the next step. Sort by this column to plan your day. Example: 2026-10-07
• Notes: Anything you'll want to know next time: who answered, what they said, who you should call instead. Example: Left a voicemail with the one-line reason

Not sure of a contact's time zone? Look it up by area code with the prospect local time tool.

The outcomes to use

Pick exactly one outcome per row, from the same short list every time. A filter or a count only works when the words match, so type them the same way, or turn the Outcome column into a dropdown with data validation (it's under Data in both Excel and Google Sheets).

• No answer: The phone rang out, was busy, or the call didn't go through.
• Voicemail: You reached voicemail. Write in Notes whether you left a message.
• Gatekeeper: Someone else answered, such as an assistant or the front desk, and you didn't reach your contact.
• Conversation: You spoke with the contact, but no meeting is booked yet.
• Meeting booked: You spoke with the contact and agreed a time to meet.
• Call back later: The contact asked you to call at another time. Put it in Follow-up date.
• Not interested: The contact said no for now. Write down why, if they told you.
• Wrong number: The number doesn't belong to the contact. Find the right one before you call again.
• Do not call: The contact asked not to be called again. Stop calling and add them to your internal do-not-call list.

When a call fits two outcomes, use the one further down the list: a meeting booked was also a conversation, and a request not to be called again outranks everything else.

A weekly review

Once a week, filter the sheet to the past seven days and look at what happened, not at how much you dialed.

• Conversations and meetings. Count the rows marked Conversation and Meeting booked. Those are the calls that moved something forward.
• Which titles answer. Filter to those two outcomes and read the Title column. If one role keeps picking up and saying yes, put more of those people on next week's list.
• Which hours answer. Add a time column next to Date if you want this, then look at when your conversations happened, in the contact's time zone. Call more in those hours.
• Promises you haven't kept. Look for follow-up dates that have passed with no newer row for that contact.
• Do not call. Check that every contact marked Do not call is on your internal do-not-call list and off next week's list.

Compare each week with your own previous weeks. That tells you more about your list and your opener than anyone else's figures can.

When a sheet stops being enough

A sheet works while one rep keeps it up to date. It gets harder when several reps share it, rows are skipped on busy days, and nobody is sure which copy is current. In Personnect, the summary, transcript and outcome of every call are logged and synced to your CRM, so the rep has nothing to type.