Skip to content

Booking, CRM and Follow-Up

Call Log Template: Track Every Call in a Spreadsheet

A free call log template with the twelve columns that matter, example rows, dropdowns and formulas, and the signs your spreadsheet has outgrown itself.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing8 min read

On this page
  1. Twelve columns, one row per call
  2. Example rows from a fictional week
  3. Set it up in fifteen minutes
  4. Adjust the template to your business
  5. The Friday review
  6. When the spreadsheet stops working
  7. Frequently asked questions
  8. References
Booking, CRM and Follow-Up: Call Log Template: Track Every Call in a Spreadsheet67%: of US adults let unknown numbers ring but check voicemail, so log what your callback saidBOOKING, CRM AND FOLLOW-UPCall Log Template: TrackEvery Call in a Spreadsheet67%of US adults let unknown numbers ring but check voicemail, solog what your callback saidAssistCallInsightsBooking, CRM and Follow-Up: Call Log Template: Track Every Call in a Spreadsheet67%: of US adults let unknown numbers ring but check voicemail, so log what your callback saidBOOKING, CRM AND FOLLOW-UPCall Log Template:Track Every Call in aSpreadsheet67%of US adults let unknown numbers ringbut check voicemail, so log what yourcallback saidAssistCall
Figure source: Pew Research Center, 2020[1]

Key takeaways

  • A call log should answer three questions by Friday: who called, what they wanted and whether anyone acted on it.
  • Twelve columns are enough; dropdowns for caller type, reason and outcome make the log countable.
  • Format the phone column as text before you paste anything, or the spreadsheet may strip and round digits.
  • A 20-minute Friday review of open rows, missed calls and reason counts is where the log pays off.
  • Move to a contact-based system when several people log at once or you need a caller's history mid-call.

Twelve columns, one row per call

A call log earns its place when it answers three questions by Friday afternoon: who called, what they wanted, and whether anyone did anything about it. Every column in the template below serves one of those questions. Resist adding more. Each extra cell is one more reason for a busy person to skip the row, and a log with gaps is worse than no log, because it looks complete.

Keeping the record is not admin padding; it is part of the job. O*NET rates keeping records of customer interactions, including inquiries, complaints and actions taken, at 88 out of 100 in importance for customer service representatives[2]. Among receptionists, 75% say being exact or highly accurate is very or extremely important to the work[3]. A good template makes accuracy the easy option.

Call log template: copy these twelve headers into row 1 of a blank sheet
ColumnWhat goes in itFormat tip
A. DateDay the call came inYYYY-MM-DD, entered as a real date so it sorts
B. TimeStart time of the call24-hour clock; kept separate so you can count by hour
C. Caller nameFirst and last name as the caller gives itAsk for the spelling once; leave blank if unknown
D. PhoneThe number to call back, all ten digitsFormat the column as Text before any data goes in
E. New or existingNew, Existing or Not sureDropdown
F. ReasonWhy they called, from a fixed listDropdown of six to eight reasons, never free text
G. OutcomeWhat happened on the callDropdown: Resolved, Booked, Message taken, Callback needed, Voicemail, Missed
H. Taken byWho handled the callInitials
I. NotesOne or two lines of factsWhat they asked and what was promised, not opinions
J. Next step and ownerWhat has to happen and who does itVerb first: Call back with quote (JR)
K. DueWhen the next step is dueReal date; blank only if there is no next step
L. DoneDate the next step was completedBlank means the row is still open

Three columns do most of the work. Reason tells you why the phone rings. Outcome tells you what the phone produced. Done tells you what is still hanging. If you only had time to fill three cells per call, those would be the three. The guide to call disposition codes has a fuller set of outcome definitions if your team argues about what counts as resolved.

Example rows from a fictional week

Here is how five rows look for a small auto repair shop on a Tuesday. The phone column is left out to keep the table readable; in your sheet it sits between the name and the caller type.

Example: five call log rows from a fictional two-bay auto repair shop
Date and timeCallerTypeReasonOutcomeNext step (owner)DueDone
2026-03-03 08:12Dana PriceExistingBooking or rescheduleBookedNone––
2026-03-03 09:40Luis OrtegaNewNew job or quoteCallback neededPrice brake pads and rotors, 2017 Civic (MK)2026-03-032026-03-03
2026-03-03 12:25(blank)Not sureUnknownMissedCall back; caller left no voicemail (MK)2026-03-03Open
2026-03-03 14:05Pat KimExistingExisting job questionMessage takenTell her when the part arrives (TR)2026-03-05Open
2026-03-03 16:50Harbor Auto SupplyNot sureSupplier or salesResolvedNone––

Read the rows the way the owner would on Friday. The 12:25 call is a lunch-hour miss with no name and no voicemail; it is still open, and it may have been a new customer. Pat Kim's message has a due date two days out, so it is not overdue yet. The quote for Luis Ortega was done the same day. None of that needs a dashboard. It needs consistent dropdowns and a Done column someone actually fills.

The notes rule is worth spelling out. Write what was asked and what was promised, in words the caller could read without wincing. Price brake pads and rotors is a note. Seemed annoyed, probably won't book is a guess that will mislead whoever picks up the row next week. For how to capture the details that make a message usable, see how to take a phone message.

Set it up in fifteen minutes

  1. Format the phone column as text first

    Spreadsheets treat phone numbers as numbers. Excel removes leading zeros, keeps at most 15 significant digits and shows long values in scientific notation[4]. Select column D, set it to Text, then enter data.

  2. Add the dropdowns

    Use data validation lists for columns E, F and G. A suggested reason list: New job or quote, Booking or reschedule, Existing job question, Billing, Complaint, Supplier or sales, Wrong number or spam, Unknown.

  3. Freeze row 1 and turn on filters

    Frozen headers keep the columns readable on a long sheet, and filters let anyone show only open rows or only today's calls in two clicks.

  4. Add a small summary tab

    Missed calls in the last seven days: =COUNTIFS(Log!G:G,"Missed",Log!A:A,">="&TODAY()-7). Overdue next steps: =COUNTIFS(Log!K:K,"<"&TODAY(),Log!L:L,""). One cell per question you ask every week.

  5. Share one file, never copies

    Keep a single shared sheet that everyone edits. Emailed copies and a desktop version on the front-desk computer split the record within a week.

  6. Decide what never goes in

    No card numbers, security codes or Social Security numbers, ever. The FTC tells businesses not to collect sensitive data they have no need for[5], and PCI rules do not allow a card's security code to be kept after authorization[6].

Add the time-of-day habit from the start. Most of your callers are at work during your opening hours: in 2025, 81% of employed people worked on an average weekday, against 30% on an average weekend day[7]. That is why calls bunch at lunch, before 9 and after 5, and why a separate Time column is worth its space. After four weeks, a simple count by hour shows exactly when the phone is unattended.

Adjust the template to your business

The twelve columns are a base. Most businesses need one or two extra fields, and the test for each one is simple: will someone filter or count on it within a month? If not, it belongs in the notes.

  • Trades and home services: add Service ZIP code. It tells you at a glance whether the job is in your area, and a month of ZIPs shows where your calls come from.
  • Salons, spas and clinics with several providers: add Provider requested. Callers who ask for one person and get another are a retention issue worth counting.
  • Law firms: add Practice area and Referral source, and put the other party's name in the notes so the conflict check can run. Keep notes to facts; legal questions go to an attorney, not into the log.
  • Medical and dental offices: log the reason in general terms such as New patient or Billing question. Health details belong in the patient record, not a shared spreadsheet.
  • Businesses that also make outbound calls: add Direction (In or Out) rather than starting a second sheet, so callbacks sit next to the calls that caused them.

Whatever you add, keep the dropdown rule. A Provider requested column with free text produces seven spellings of the same name by the end of the month. A dropdown with eight names produces a count you can act on.

If you run more than one location, use one sheet with a Location column rather than a sheet per site. Separate files hide the customer who calls both branches in the same week, and they make the Friday totals a copy-and-paste job.

The Friday review

The log only pays off if someone reads it. Block twenty minutes on Friday, filter, and work through five checks in the same order every week.

  1. Open rows past their due date. Each one gets a new owner and date, or a Done date with a note saying why it was closed.
  2. Missed calls and voicemails with no callback. Sort by date and call the newest first; a three-day-old missed call is usually a lost one.
  3. The reason count. If Existing job question is a third of the week, a status update you send proactively may remove a lot of calls.
  4. Calls by hour. Look for the same gap two weeks running, such as 12 to 1 or the first hour of the morning.
  5. Taken by. If one person handles most calls, cover for them before they burn out, not after.

Example: after four weeks, a fictional two-bay repair shop finds 31 missed calls, 19 of them between noon and 1 pm, and 11 open rows with no Done date. Two decisions follow from those numbers alone: stagger lunch so one person always covers the phone, and give every open row an owner before Monday. No software purchase, no new report, just the log read honestly once a week.

Log every callback attempt, not just the first. Calling back an unknown number rarely gets a pickup. In Pew's survey, 67% of US adults said they don't answer calls from unknown numbers but check the voicemail if one is left, while 14% generally ignore voicemail altogether[1]. A callback with a clear voicemail is a real attempt; a ring-out with no message barely counts. The callback script has wording that gets returned calls.

What US adults generally do when an unknown number calls their cellphonePew Research Center survey of 10,211 US adults, July 2020.
What US adults generally do when an unknown number calls their cellphoneDonut chart. Don't answer, but check voicemail: 67%; Generally answer: 19%; Don't answer, ignore voicemail: 14%.Don't answer, but check voicemail: 67%Generally answer: 19%Don't answer, ignore voicemail: 14%2020
  • Don't answer, but check voicemail 67%
  • Generally answer 19%
  • Don't answer, ignore voicemail 14%

Source: Pew Research Center, 2020[1]

Show the data
ItemValue
Don't answer, but check voicemail67%
Generally answer19%
Don't answer, ignore voicemail14%
Example: one missed call through the log
  • Caller
  • Your team
  1. 01Caller

    Call rings out at 12:20

    Both staff are at lunch; no voicemail is left.

  2. 02Your team

    Row added from call history

    Date, time and number entered; outcome set to Missed.

  3. 03Your team

    Callback within the hour

    No answer; voicemail left with the business name and a reason to call.

  4. 04Your team

    Second try next morning

    Caller picks up; it is a new customer asking for a quote.

  5. 05Your team

    Outcome and Done filled

    Outcome Booked; Done date entered; row drops off the open list.

Example of a missed lunch-hour call tracked to a booking in a fictional shop.

When the spreadsheet stops working

A call log is a list of events. Sooner or later you need a list of people instead, with each person's calls gathered in one place. These are the signs you have reached that point:

  • Two or more people log calls at the same time and rows get duplicated or overwritten.
  • Staff search old rows during a call to find what a customer was told last time.
  • The same caller appears in five or more rows and nobody can see the thread.
  • Rows go unlogged on the busiest days, which are the days with the most new customers.
  • You want to know which customers have not called in a year, and the sheet can't tell you.

There are two ways forward. The first is a contact-based system where each caller has one record and calls attach to it; CRM for small business explains how to pick one, and turning callers into contacts covers the naming and duplicate rules to keep it clean. The second is to stop typing rows at all. When an SI Employee answers the phone, each call creates or updates a contact from the caller's number with the summary, recording and transcript attached, so the log becomes a by-product of answering. What an SI Employee is explains what that looks like day to day.

Keep the spreadsheet habit either way. Four weeks of a clean log is the baseline for testing whether an AI receptionist is worth it, and it shows where calls go unanswered, as the after-hours plumbing example does for evening calls. For a sector view of what to record on sales calls, the real estate guide to what to log after every lead call is a useful companion.

Frequently asked questions

Should I use Excel or Google Sheets for a call log?

Whichever your team can open at the same time. A shared online sheet usually wins because everyone edits one copy. Either way, set the phone column to text before entering numbers.

Do I log calls that were answered and resolved?

Yes. Resolved calls tell you why the phone rings and how much staff time it takes. Without them you only see problems, which skews every count.

How long should I keep call log rows?

Keep what you need for follow-up and reporting, often a year or two, and archive or delete older rows. Holding personal details you no longer use only adds risk.

What about spam and wrong numbers?

Log them with the Wrong number or spam reason and no next step. The count is useful, because a spike in spam calls is worth raising with your phone provider.

Can call history fill the log automatically?

Many phone systems export call history with date, time, number and duration, which covers columns A, B and D. Reason, outcome and next step still need a person, or a system that summarizes each call.

References

  1. Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑

  2. O*NET OnLine (U.S. Department of Labor, Employment and Training Administration) (2025). 43-4051.00 - Customer Service Representatives (opens in a new tab) ↑

  3. O*NET OnLine (U.S. Department of Labor, Employment and Training Administration) (2025). 43-4171.00 - Receptionists and Information Clerks (opens in a new tab) ↑

  4. Microsoft Support (2026). Keeping leading zeros and large numbers (opens in a new tab) ↑

  5. Federal Trade Commission (2016). Protecting Personal Information: A Guide for Business (opens in a new tab) ↑

  6. PCI Security Standards Council (2011). Information Supplement: Protecting Telephone-based Payment Card Data (opens in a new tab) ↑

  7. U.S. Bureau of Labor Statistics (2026). American Time Use Survey - 2025 Results (opens in a new tab) ↑

Book a demo

Meet your SI Employee.

Book a short demo. We walk through calls like yours and show what your SI Employee would answer, book and follow up.

Book a demo