A freelance enquiry can arrive through a referral, your website, a past client or a networking conversation. The difficult part is remembering what happened next: who you contacted, whether you sent a proposal, what the project might be worth and when you should follow up.
A simple lead-tracking spreadsheet gives you one place to see those details. You do not need a complicated customer relationship management system to get started. What matters is recording the next action and actually reviewing it.
1. Give every enquiry one row
Start with a single row for each potential project or sales opportunity. Avoid creating a separate row every time you email the same person; keep the conversation history or notes with the original lead so you can see the full story.
Useful columns include:
- Date received: when the enquiry first arrived
- Client and contact: the business or person's name and the person you communicate with
- Lead source: referral, website, repeat client, marketplace or another source
- Service or project: what the prospective client is asking for
- Estimated value: your current estimate, clearly marked as an estimate
- Stage: the current position in your sales process
- Last contact: the date you last spoke or emailed
- Next follow-up and next action: when you will act and exactly what you plan to do
- Outcome and notes: the final result or context you may need later
Only collect information you genuinely need to manage the enquiry. Avoid putting passwords, payment-card details or sensitive personal information in a general business tracker.
2. Use a small number of clear pipeline stages
Stages should make it obvious what needs to happen next. Too many options make a tracker harder to maintain. A straightforward starting point is:
- New: enquiry received, not yet reviewed
- Contacted: you have replied or arranged a conversation
- Qualified: the project looks like a possible fit and key requirements are clearer
- Proposal sent: you have sent a quote or proposal and are waiting for a response
- Won: the client has accepted and you are moving into onboarding
- Lost or not proceeding: the opportunity is closed for now
- On hold: the client has asked to pause or revisit later
Keep the definitions consistent. For example, do not mark a project as won just because a client says they like the proposal; record the actual approval or agreed next step.
3. Make the next follow-up impossible to miss
The most useful field in a lead tracker is often the next follow-up date. At the end of every call or email exchange, decide whether there is another action to take. If there is, record the date and use a short action such as “send revised estimate” or “check proposal decision”.
In Excel, format the follow-up column as a date and use conditional formatting to highlight past-due dates. For example, if the next follow-up date is in column J and the status is in column F, a simple overdue rule for row 2 could be:
=AND($J2<TODAY(),$J2<>"",$F2<>"Won",$F2<>"Lost")
Apply the rule to the rows in your lead list, adjusting the column letters to match your own sheet. This highlights overdue follow-ups for open opportunities, rather than completed ones.
4. Estimate the pipeline without counting every lead as a sale
An estimated project value can help you prioritise conversations, but it is not guaranteed income. One way to make a rough pipeline view more realistic is to multiply each opportunity's estimated value by a probability you assign to its current stage.
For example, a hypothetical $2,000 project with a 25% estimated chance of proceeding has a weighted value of $500. This is a planning estimate only, not a forecast or promise of revenue.
If estimated value is in column G and your probability is entered as a percentage in column H, a weighted value formula could be:
=IF(OR(G2="",H2=""),"",G2*H2)
Choose probability assumptions carefully and review them against your own experience. Do not use a high percentage simply to make the dashboard look encouraging.
5. Review your leads in a short weekly routine
A spreadsheet only helps when you keep it current. Once a week, work through this simple review:
- Reply to new enquiries that still need a response
- Check proposals awaiting a decision and follow-ups that are due
- Update stages after meaningful client conversations
- Close opportunities that are no longer proceeding
- Check whether every active lead has a dated next action
- Review lead sources and estimated values without confusing them with actual sales
Keep the routine short enough that you will repeat it. A simple tracker that you update consistently is more useful than a complex system you avoid opening.
When a basic spreadsheet is no longer enough
You can build a useful lead list in a blank spreadsheet, and there are free downloadable tracker options available. A purpose-built workbook becomes useful when you would rather not set up the dropdowns, follow-up views, proposal log and summary dashboard yourself. Compare the features and format with how you actually work before buying any template.
The Solo Studio Lead & Sales Pipeline Tracker is a downloadable Excel workbook with five worksheets: a lead pipeline, follow-up planner, proposal tracker, sales dashboard and getting-started guide. It is designed to bring those parts of the process together in one file.
Once a lead becomes a client, you can use the Client Onboarding Kit to gather project details and agree deliverables, then use the Project & Client Tracker to manage active work. Browse the full Solo Studio Digital Business Templates collection to compare the available workbooks.
Solo Studio templates are administrative planning tools, not legal, accounting, tax or financial advice.
Related freelance guides
Once a new enquiry is in your pipeline, a clear next step helps move it forward. Read How to Follow Up on a Freelance Proposal for practical follow-up timing and email examples.
When a lead becomes a client, use the seven-step freelance client onboarding process to gather details and agree expectations before work begins.
Put follow-ups into a weekly routine
A lead tracker works best when you make time to review the next actions it contains. The free Solo Studio Weekly Reset Planner helps you plan follow-ups alongside client work. For a ready-made lead pipeline, proposal tracker and follow-up planner, see the Solo Studio Lead & Sales Pipeline Tracker.