Free lead tracking sheet template One row per enquiry.
Source, owner, stage and the next follow-up in one row. Download the blank CSV and open it in Excel or Google Sheets.
Download the blank sheet
15 columns, 20 empty rows, as a CSV. No account needed.
What a lead tracking sheet needs
Enough to make the next conversation useful. Name a person as owner, not a team.
| Field | How to use it |
|---|---|
| Lead ID and enquiry date | Identify the enquiry and when it arrived |
| Name, phone and email | Keep contact details as text, with country codes |
| Source and interest | Record the real source and what was asked for |
| Owner and stage | Name the responsible person and the current step |
| Last contact and next follow-up | Use one date format and sort by what is due |
| Next action and notes | Write the agreed task and the context |
| Contact preference and opt-out | Keep the person’s instructions visible |
Open it in Excel or Google Sheets
Use Excel’s import-from-text flow or Google Sheets File → Import.
- Set phone numbers and lead IDs to text.
- Use one date format, such as YYYY-MM-DD.
- Add filters and stage validation if you like.
- The file has headers and blank rows, no formulas and no reminders.
Use it every day
Sort by next follow-up date and check that every open enquiry has an owner.
- 1Sort by next follow-up date.
- 2After a call, update last contact, outcome and next action.
- 3Back up before sorting or importing a large list.
- 4Share only with the users who need it.
When to move to a CRM
Several sources, users and conversations make a sheet hard to keep honest. Keep IDs, sources, owners and follow-up dates when you move, not just names and numbers.
Read the Excel-to-CRM guide, then start a free trial and import a small cleaned sample.
Yes. Download the CSV without signing up. Excel and Google Sheets can import it.
Let agents run the busywork. Watch your leads move.
Set up Marro for your business in minutes, and watch the first leads get handled.
Start free trial