EXCEL TEMPLATE

Free sales lead tracker Excel template

Keep each B2B prospect’s source, last interaction and next action in one row. Download the Excel file for free, with no sign-up.

INSIDE THE WORKBOOK

Tracker gives you blank rows for your own prospects. Examples shows three fictional companies with a source to check, an overdue task and a reply to wait for.

UPDATED

· 4 min read · By the Anivo team · Türkçe

01

Read an overdue follow-up row

A fictional supplier called Blue Line Machinery fits a web design offer focused on project enquiries. Here is its record from the Examples tab.

Blue Line Machinery on the 13 November example review
Workbook fieldsExample entryWhat to check next
Source URL and date checkedblueline.example/products · 5 November 2026Reopen the product page and follow the enquiry route.
Observation and fitMachine range fits the offer. Product pages lead to general contact.See whether a visitor can find which project details to submit.
Open question and last eventWho owns project enquiries? Product and contact pages reviewed.Record the responsible role once you can confirm it.
Status, next action and due dateReady for review · Check the enquiry route and update the record · 10 NovemberThis is overdue on 13 November. Complete the website check before preparing a message.

The example URL is fictional. In your own tracker, use a source you can reopen and record the day you checked it.

02

Add a company and give it a next action

  1. Save what you checked.

    Open Tracker. Enter the company, the page URL and the date you looked at it. Describe what you saw and why it matters for your offer.

  2. Record where the conversation stands.

    Write the open question and last event. Select a status from the dropdown. If you sent a quote, keep the date and any agreed review timing in Last event.

  3. Write a task you can finish.

    Use Next action and Due date. “Check whether the revised quote was received” is a task you can review again. Enter an Excel date so the workbook can compare it with the review date.

03

Use the flag to decide what to do

Three decisions from the Examples tab
CompanyWhat the tracker showsNext action
Northline MotionVerify source. The source and check date are blank.Find the company page and record an observation.
Blue Line MachineryOverdue. The task was due on 10 November.Check the enquiry route and update the record.
Ridge ServiceWaiting for reply. Review is due on 16 November.Check for a reply on the review date, then update the task.

On Tracker, Needs attention checks the source and date first, then the status, task and due date. A blank flag can mean the action is scheduled for later. Closed records also leave the flag blank.

04

Filter the rows before a follow-up session

In Excel, select the header and the records together and choose Data → Filter. Open the Needs attention filter and select Overdue to see tasks that have passed their due date.

Clear that filter before filtering Status for Waiting for reply. Read the due date beside each result to decide when to check the conversation.

05

Replace the old task when a buyer replies

Suppose Ridge Service replies a day early and asks for a quote by 19 November. Add the date and the request to Last event, change Status to In conversation and set the next action to preparing the quote by 19 November.

If a buyer closes the conversation, log the outcome and set Status to Closed. The row can stay in your record while the follow-up flag stays clear.

06

Keep a spreadsheet while a row holds enough context

Use the file when you can keep each company’s source, latest event and next task in one row. If a company appears on two lists for the same offer, keep the checked source and next action together in a single record.

If your work needs the full reply thread, several tasks and research notes for each firm, review a CRM workflow. The B2B prospecting software guide covers what to check when comparing tools.

FAQ

Questions about the Excel tracker

Start with the blank tab and use the examples to check your first records.

Is the sales lead tracker free to download?

Yes. The editable .xlsx workbook downloads directly from this page without a form or account.

How does the workbook flag an overdue follow-up?

On Tracker, the review date uses today’s date. Once the source, check date, status and next action are filled in, an open record is overdue when its due date is earlier than the review date.

Can I use the workbook to follow up after sending a quote?

Yes. Record the quote and any reply under Last event. Set Next action to the work you agreed to do, with its due date. The sales follow-up guide shows three ways to handle the buyer’s reply.

Why is Needs attention still blank?

The workbook leaves it blank on empty and closed rows. An open row with everything filled in and a future due date also has no flag.

Is there a CSV version?

The customer research guide has a separate CSV for a flat list. Use the Excel file here for the dropdowns, dated checks and Examples tab.

Which URL should I record for a prospect?

Use the page that supports your observation. For example, save the product page that links to general contact. Leave the source field empty until you can check a page.

SOURCES

Workbook and Excel instructions

The examples come from the downloadable workbook. The filtering steps follow Microsoft’s Excel instructions.

YOUR FIRST MARKET IS WAITING

Research your next group of companies with Anivo

Describe the businesses you want to reach. Review the research plan and keep notes and next actions with the company records you choose.