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.
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.
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.
| Workbook fields | Example entry | What to check next |
|---|---|---|
| Source URL and date checked | blueline.example/products · 5 November 2026 | Reopen the product page and follow the enquiry route. |
| Observation and fit | Machine 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 event | Who owns project enquiries? Product and contact pages reviewed. | Record the responsible role once you can confirm it. |
| Status, next action and due date | Ready for review · Check the enquiry route and update the record · 10 November | This 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.
Add a company and give it a next action
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.
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.
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.
Use the flag to decide what to do
| Company | What the tracker shows | Next action |
|---|---|---|
| Northline Motion | Verify source. The source and check date are blank. | Find the company page and record an observation. |
| Blue Line Machinery | Overdue. The task was due on 10 November. | Check the enquiry route and update the record. |
| Ridge Service | Waiting 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.
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.
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.
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.
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.
Workbook and Excel instructions
The examples come from the downloadable workbook. The filtering steps follow Microsoft’s Excel instructions.
- Microsoft Support · Filter data in Excel
How to filter a range by the values in a column.
