You don't need software to start tracking leads. You need a spreadsheet with the right columns, a daily habit, and five minutes to set it up. This article gives you all three.
Below is a free lead tracking template you can copy into Google Sheets or Excel right now. It's the same structure used by solo contractors, freelancers, and small teams who manage anywhere from 5 to 50 active leads. No formulas to learn, no tabs to configure — just a flat list that answers one question every morning: who needs to hear from me today?
The template: 8 columns that cover everything
Here's the structure. Copy these headings into row 1 of a blank spreadsheet:
| Name | Phone / Email | Source | What They Need | Next Action | Due Date | Status | Notes |
|---|---|---|---|---|---|---|---|
| Dana Martinez | 555-0142 | Kitchen remodel quote | Text revised quote | Apr 2 | Quoted | Prefers weekday installs, budget ~$12K | |
| Mike Chen | 555-0198 | Referral (Jake) | Fence repair | Call to schedule visit | Apr 1 | New | Leaning toward cedar. Neighbor may want one too |
| Raj Patel | raj@email.com | Website form | Logo + brand identity | Send portfolio examples | Apr 3 | New | Startup, tight timeline |
That's a working lead tracker. Three sample rows so you can see the format. Delete them and start entering your own.
What each column does (and why it's there)
Name — The person you're talking to. First and last if you have it, first name only is fine.
Phone / Email — Their preferred contact method. Don't overthink it — just put whatever they gave you.
Source — Where the lead came from: Google, referral, text, Instagram, website, yard sign, etc. This is the column most people skip — and it's the one that tells you where your business actually comes from after a few months.
What They Need — One line describing the project or inquiry. Keep it short: "bathroom tile quote," "weekly office cleaning," "deck stain + seal." Enough to jog your memory, not a full scope document.
Next Action — The specific thing you'll do next. This is the most important column in the entire sheet. Not "follow up" — something concrete: "text quote," "call to confirm scope," "send contract." If this column is empty, the lead is at risk.
Due Date — When you'll do the next action. No due date = no urgency = the lead drifts. Even a rough date is better than blank.
Status — Where the lead stands. Keep it simple:
- New — Just came in, haven't responded yet
- Quoted — Sent a quote, waiting for reply
- Follow-up — Needs your attention
- Won — Hired you, project active
- Lost — Went with someone else or went cold
- Parked — Not active now, check back later
Notes — Anything useful: customer preferences, project details, conversation history. This is where you write "prefers mornings" or "mentioned budget is tight" so you don't have to ask again.
How to use the spreadsheet daily (5-minute routine)
The template is useless if you don't check it. Here's the daily habit:
Morning (2 minutes):
- Sort by Due Date (earliest first)
- Look at anything overdue or due today
- That's your to-do list for the day
End of day (3 minutes):
- Did any new leads come in? Add them with a next action and due date
- Did you complete any follow-ups? Update the next action to the next step
- Is every active lead showing a next action and due date? If any column is blank, fill it now
This routine takes less time than scrolling through your texts looking for messages you forgot to reply to.
According to a 2022 Act! survey, 45% of small businesses still rely on paper records to manage contacts. A simple spreadsheet with these 8 columns puts you ahead of nearly half the market — in about 5 minutes.
Real-world example: Nadia the event photographer
Nadia shoots weddings and corporate events. She gets leads from Instagram, her website, and referrals. Before the spreadsheet, she tracked everything in her DMs and email — which worked fine at 3 inquiries a week but fell apart during engagement season when she was getting 10+.
She set up this exact template in Google Sheets on her phone. Every inquiry gets a row: name, contact, source, what they need, next action, due date. Her morning check takes 90 seconds — sort by due date, see who needs a response.
The biggest change: she stopped losing Instagram leads. Before, a DM would come in, she'd think "I'll reply later," and it would get buried. Now she adds a row immediately (name + "reply with pricing" + tomorrow's date) and the spreadsheet reminds her.
When the spreadsheet stops working (and what to do next)
A spreadsheet is a great starting point. But it has predictable limits:
Signs you've outgrown it:
- You have more than 20 active leads and scrolling takes too long
- You keep forgetting to open it (spreadsheets don't send reminders)
- You need to look back at conversation history but your "Notes" column is a wall of text
- You're sorting and filtering constantly just to find today's priorities
Why it breaks down: Spreadsheets are passive. They hold data, but they don't surface priorities. When you get busy — which is exactly when follow-ups matter most — the spreadsheet sits there silently while leads go cold.
This is the point where a purpose-built tool earns its place. Not a complex CRM with pipelines and automations, but a simple follow-up tracker that shows you what's overdue and due today without you having to sort anything.
Where ActiveLead fits
ActiveLead uses the same structure as this spreadsheet — name, contact, next action, due date — but it does the one thing a spreadsheet can't: surface your priorities automatically. Overdue leads appear at the top of your dashboard every morning. No sorting, no filtering, no discipline required.
If this spreadsheet works for you, use it. When it starts to feel like a chore to maintain, ActiveLead picks up exactly where the spreadsheet left off — same simplicity, less friction.
Try ActiveLead free for 14 days — no credit card required.
The best lead tracking system is the one you actually use. Start with this spreadsheet today — enter your five most active leads, set a next action for each, and check the list tomorrow morning. That's enough to stop losing leads to forgotten follow-ups.
FAQ
Can I use this template in Excel instead of Google Sheets?
Yes — same columns, same structure. The only advantage of Google Sheets is that it syncs across your phone and computer automatically. If you prefer Excel, save the file somewhere you can access from your phone (OneDrive, Dropbox).
Do I need to track every lead or just serious ones?
Track every inquiry. A 30-second row entry is worth it even for long-shot leads. You can't know which ones are serious until you follow up — and the "small" lead you skip might turn into your biggest job of the month.
How many leads can this spreadsheet handle?
Comfortably, 15–25 active leads. Beyond that, sorting and filtering becomes tedious and you'll start missing things. If you consistently have more than 25 active leads, a dedicated tool will save you time.
Should I delete old leads from the sheet?
No — change their status to "Won," "Lost," or "Parked" and leave them. Old leads are useful for quarterly revival outreach and for tracking which sources bring the best work over time. Use the Status column to filter your view.
Examples are illustrative, not based on real customers.