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.
| Column | What goes in it | Format tip |
|---|---|---|
| A. Date | Day the call came in | YYYY-MM-DD, entered as a real date so it sorts |
| B. Time | Start time of the call | 24-hour clock; kept separate so you can count by hour |
| C. Caller name | First and last name as the caller gives it | Ask for the spelling once; leave blank if unknown |
| D. Phone | The number to call back, all ten digits | Format the column as Text before any data goes in |
| E. New or existing | New, Existing or Not sure | Dropdown |
| F. Reason | Why they called, from a fixed list | Dropdown of six to eight reasons, never free text |
| G. Outcome | What happened on the call | Dropdown: Resolved, Booked, Message taken, Callback needed, Voicemail, Missed |
| H. Taken by | Who handled the call | Initials |
| I. Notes | One or two lines of facts | What they asked and what was promised, not opinions |
| J. Next step and owner | What has to happen and who does it | Verb first: Call back with quote (JR) |
| K. Due | When the next step is due | Real date; blank only if there is no next step |
| L. Done | Date the next step was completed | Blank 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.
| Date and time | Caller | Type | Reason | Outcome | Next step (owner) | Due | Done |
|---|---|---|---|---|---|---|---|
| 2026-03-03 08:12 | Dana Price | Existing | Booking or reschedule | Booked | None | – | – |
| 2026-03-03 09:40 | Luis Ortega | New | New job or quote | Callback needed | Price brake pads and rotors, 2017 Civic (MK) | 2026-03-03 | 2026-03-03 |
| 2026-03-03 12:25 | (blank) | Not sure | Unknown | Missed | Call back; caller left no voicemail (MK) | 2026-03-03 | Open |
| 2026-03-03 14:05 | Pat Kim | Existing | Existing job question | Message taken | Tell her when the part arrives (TR) | 2026-03-05 | Open |
| 2026-03-03 16:50 | Harbor Auto Supply | Not sure | Supplier or sales | Resolved | None | – | – |
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
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.
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.
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.
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.
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.
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.
- 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.
- 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.
- 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.
- Calls by hour. Look for the same gap two weeks running, such as 12 to 1 or the first hour of the morning.
- 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.
- 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
| Item | Value |
|---|---|
| Don't answer, but check voicemail | 67% |
| Generally answer | 19% |
| Don't answer, ignore voicemail | 14% |
- Caller
- Your team
01Caller
Call rings out at 12:20
Both staff are at lunch; no voicemail is left.
02Your team
Row added from call history
Date, time and number entered; outcome set to Missed.
03Your team
Callback within the hour
No answer; voicemail left with the business name and a reason to call.
04Your team
Second try next morning
Caller picks up; it is a new customer asking for a quote.
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
Pew Research Center (2020). Most Americans don't answer cellphone calls from unknown numbers (opens in a new tab) ↑
O*NET OnLine (U.S. Department of Labor, Employment and Training Administration) (2025). 43-4051.00 - Customer Service Representatives (opens in a new tab) ↑
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) ↑
Microsoft Support (2026). Keeping leading zeros and large numbers (opens in a new tab) ↑
Federal Trade Commission (2016). Protecting Personal Information: A Guide for Business (opens in a new tab) ↑
PCI Security Standards Council (2011). Information Supplement: Protecting Telephone-based Payment Card Data (opens in a new tab) ↑
U.S. Bureau of Labor Statistics (2026). American Time Use Survey - 2025 Results (opens in a new tab) ↑