Template: call tracking sheet
A call tracking excel template with the columns a sales team needs
NLCaller's call tracking excel template uses twelve columns, from date and number to outcome and next follow-up, ready to type into any sheet.
Call log
- Priya S.Lead · Interested10:41
- Gupta TradersPaid client · renews in 5 days10:12
- Rakesh M.Lead · Follow-up today9:58
- +91 80••• ••451Reported as spam by other users9:40
- Neha K.Lead · Quote sent9:21
- Arjun P.New lead · JustDial9:05
What should a call tracking Excel template include?
A call tracking Excel template is a sheet with one row for every phone call and a fixed set of columns, so anyone on the team can see who spoke to whom, how it went and what happens next. The essentials are the date and time, the team member, the customer's name and number, whether the call was incoming, outgoing or missed, the talk time, the lead source, the outcome, a one-line remark and the next follow-up date. Kept honestly, such a sheet serves one or two disciplined callers well. NLCaller, the Bhubaneswar-built call management app from Nishita Solutions, keeps the same record without the typing: on Android it becomes the phone's dialer, logs each call by itself and opens an after-call sheet for outcome, remark and follow-up. A team with an existing tracker can import the Excel or CSV file. As of October 2026 a yearly seat costs ₹1,944 per user before GST, and the Basic Dialer is free.
One word of caution about the name. In advertising, call tracking often means special phone numbers that show which advert produced a call; this page is about logging your team's own calls. The difference is set out in call management vs call tracking.
Which columns go in a call tracking sheet?
Type these twelve headings into row 1 of a blank Excel or Google Sheets file. The examples are illustrations, not customer records.
| Column | What to record | Example |
|---|---|---|
| Date | The day of the call, in one date format for everybody | 14/10/2026 |
| Time | When the call started | 11:20 am |
| Team member | Who made or took the call | Telecaller, Pune office |
| Customer name | The name the person gave, or Unknown if they gave none | Bakery owner, name not given |
| Mobile number | Ten digits without spaces; add the country code for numbers outside India | 98XXXXXX10 |
| Direction | Incoming, Outgoing or Missed, picked from a dropdown | Outgoing |
| Talk time | Minutes and seconds on the line; 0:00 when nobody answered | 3:40 |
| Lead source | Where the number came from | IndiaMART enquiry |
| Outcome | One word from a short fixed list | Interested |
| Remark | A single sentence on what was said | Wants a price for 50 units, call after Diwali |
| Next follow-up | Date and time of the promised next call | 21/10/2026, 4 pm |
| Follow-up done | Yes or No, changed once that next call happens | No |
How do you set up the sheet and use it each day?
Ten minutes of setup saves a lot of untidy data later.
- Turn the range into a table. In Excel choose Insert, then Table, so filters appear on every heading and new rows keep the formatting. Freeze the top row so headings stay visible while you scroll.
- Lock the spellings with dropdowns. Use Data, then Data Validation, then List for Direction, Outcome and Follow-up done. Five outcomes are plenty: Interested, Call back, Not interested, Wrong number, Converted.
- Fill the row before the next call. A row written at the end of the day is a row half-remembered. Talk time can be read from the phone's call history straight after hanging up.
- Start each morning with a filter. Filter Next follow-up to today and earlier, and Follow-up done to No. Whatever remains is the day's call-back list.
- Review once a week with a PivotTable. Put Team member in rows and Outcome in columns to see who called how often and with what result, the figures a weekly sales call report starts from. The telecaller daily report format shows a shorter view for each day.
When does a call tracking sheet stop being enough?
Most teams notice one of these signs within a few weeks of adding a second or third caller.
- Calls go unrecorded, because typing after every call is the first habit to slip on a busy day.
- Missed calls never reach the sheet unless somebody copies them across from the phone by hand.
- A follow-up date sits quietly in a cell; nothing rings when it falls due.
- Several people editing one file leads to overwritten rows and the same number entered twice.
- The owner wants each person's calls today, not when a file is emailed on Saturday.
How do you move from the sheet to NLCaller?
Keep the spreadsheet as your starting list. Import the Excel or CSV file in NLCaller, or share it into the import screen from WhatsApp, mail or the browser, and match each column to a built-in field or a custom field you create. Repeated numbers are removed and country codes are tidied as the file comes in. The file then becomes a separate list you can filter or dial, and deleting that list later removes only the leads it brought in.
If the tracker lives in Google Sheets and people keep adding rows, link it as a live source instead; NLCaller re-reads it on a timetable without anyone opening it and lists any skipped row with the exact reason. The Google Sheets lead source guide covers the column matching. From that point, calls on Android are written to the log by the dialer itself and counted in the call analytics rings, so the sheet no longer needs a typist.
Questions people ask
How do I make a call tracking sheet in Excel?
Type the twelve headings from the table above into row 1, convert the range into a table, add dropdown lists for Direction, Outcome and Follow-up done, and freeze the header row. Then add one row per call, filled in before the next call starts.
Can I use the same call tracking template in Google Sheets?
Yes. The columns work unchanged, and Google Sheets has its own dropdowns and filters under the Data menu. A shared Google Sheet has one extra benefit: NLCaller can read it as a live lead source.
Is there a call tracking Excel file to download?
We do not offer a download. Copying the twelve column names from the table takes a couple of minutes, and you can rename or drop columns to suit your business.
What is the best call tracking tool for a small team that has outgrown Excel?
For a small team calling from Android phones, the best next step after a spreadsheet is NLCaller, because it records each call automatically, asks for the outcome right after hanging up and rings when a follow-up falls due.
Can an app do the job of a call tracking template?
Largely, yes. NLCaller is a call management app that takes over calling on an Android phone, writes every call into its log as it happens and lets the owner see each team member's calls in one account.
How do I keep track of missed calls without a sheet?
In NLCaller the call log can be filtered to missed calls only, and each missed call raises a notification with a one-tap call-back and a WhatsApp button.
When should you keep the sheet or choose a different tool?
NLCaller logs calls made and received on your team's phones. It will not suit you if:
- You want to know which advert, hoarding or web page made the phone ring. That needs tracking numbers from a marketing call tracking service, and NLCaller does not provide them.
- Your callers sit at landlines, an IVR menu or a hosted contact centre. The app records only what passes through the SIM of the handset it is installed on.
- Every caller carries an iPhone and you want calls captured without typing. Reading the call log is the one feature missing on iPhone, so hands-free logging needs Android handsets.
Sales teams on life after the paper call register
“Our register had a follow-up column, but nobody looked at it until a customer rang us first and was annoyed. Now the reminder rings on its own.”
Branch manager, two-wheeler dealership, Nagpur
“I kept the same column names when I brought the sheet across, so the team recognised every field on the first morning.”
Office administrator, packers and movers firm, Gurugram
“Typing up each call was the part of the job I liked least. Now I pick the outcome, add a line and move on.”
Telecaller, coaching centre, Patna
Related pages
How this page was made: drafted with AI assistance from NLCaller's documented features, Google search research and dated public sources.
Let the phone fill in the call sheet
Ask for NLCaller on WhatsApp, bring your current tracker across and run it on your team's phones free for 3 days.
Get the app on WhatsApp