Free · Excel + Google Sheets · No macros

Free Customer Call Log Template (Excel)

This free call log template records date, customer, reason, duration, resolved status and follow-up due date for up to 200 calls. Follow-up status - OVERDUE, PENDING or N/A - calculates automatically from today's date. A summary rolls up total calls, calls by reason, overdue follow-ups and average duration. Works in Excel and Google Sheets.

Download free template

What's in the customer call log template

One tab, Call Log, holds up to 200 calls: date, customer name, call reason (a dropdown), duration in minutes, resolved status, whether a follow-up is required, and its due date.

Follow-up status calculates automatically: OVERDUE once the due date has passed, PENDING if it hasn't, and N/A whenever follow-up isn't required for that call - so a closed call is never mistaken for one still open.

The summary below the table rolls up total calls logged, calls by reason, overdue follow-ups, and average call duration.

An automatic overdue flag, not just a flat log

Generic call-log templates from Template.net, Smartsheet and similar sources record the same fields but leave follow-up tracking to memory or a separate to-do list.

Here, follow-up status is calculated, not manually maintained - set Follow-up required to Yes and a due date, and the sheet tells you the moment it's overdue, without a separate reminder system.

Who this template is for

Small sales and support teams logging customer calls by hand who want reason and follow-up tracking without a full CRM subscription.

As call volume grows past what one shared spreadsheet can handle cleanly - multiple reps, deal values, pipeline stages - the CRM & Sales Pipeline template is the natural next step.

How to use it

  1. Log each call's date, customer, reason, duration and resolved status.
  2. If follow-up is required, set it to Yes and enter a due date - status updates automatically.
  3. Check the summary below the table for call volume, reason breakdown, and overdue follow-ups.
Need more? — $14

CRM & Sales Pipeline Tracker

Once call volume grows into a real pipeline, the paid CRM & Sales Pipeline Tracker ($14) adds deal value, stage-by-stage conversion and a 3-scenario forecast.

See the full version

Frequently asked questions

Does the follow-up status update automatically?

Yes. It compares your due date to today's date and reads OVERDUE, PENDING or N/A depending on whether follow-up is required and whether the date has passed.

How many calls can it hold?

Up to 200 rows on the Call Log sheet.

Can I roll up calls by reason?

Yes, Call reason is a dropdown list, and the summary below the table counts calls per reason automatically.

Can I use this in Google Sheets?

Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets.

What's the usage license?

Personal use or use within one business. It's not meant to be resold or redistributed as a template product.

Related free templates