CRM workflow guide
How to build a freelance lead tracker
A spreadsheet can be a complete lead-management system when every open conversation has a clear stage, next action, and follow-up date.
Published and fact-checked September 6, 2026 · By Seiya Utsumi
The minimum useful tracker
Create one row per prospective client. Include their name, contact details, source, service, stage, next action, follow-up date, estimated value, and notes. Review all open rows once a week.
Download the starter template
Open this CSV in Google Sheets, Excel, Numbers, or another spreadsheet app. Replace the sample row and begin with your current open conversations.
Download the free CSV templateNo email address required.Use these nine columns
| Field | What to record |
|---|---|
| Name | The person and company, if relevant. |
| Contact | The email address or channel used for the conversation. |
| Source | Referral, website, social media, event, or another source. |
| Service | The offer or outcome they are considering. |
| Stage | New, Qualified, Proposal sent, Deciding, Won, or Lost. |
| Next action | The single action required to move the conversation forward. |
| Follow-up date | The date you will take that action. |
| Estimated value | A rough project or contract value for prioritization. |
| Notes | Only the context needed for the next conversation. |
Keep the stages simple
Stages should describe a real change in the buying conversation. Six stages are enough for many independent businesses:
- New: an enquiry has arrived but has not been reviewed.
- Qualified: the project appears relevant and worth discussing.
- Proposal sent: scope, price, or terms have been shared.
- Deciding: the prospect is considering the proposal.
- Won: the work is confirmed.
- Lost: the prospect declined, chose another option, or stopped responding after your defined follow-up process.
Make every open row actionable
“Waiting” is not a useful next action. Write a specific verb and date, such as “Send two project examples on Tuesday” or “Ask whether the proposal needs revisions on September 12.” If no action is required, move the opportunity to Won or Lost.
Run a 15-minute weekly review
- Sort by follow-up date.
- Complete or reschedule every overdue action.
- Check that each active lead has exactly one next action.
- Close stale opportunities using a consistent rule.
- Look at lead sources and note which produced qualified work.
Put the tracker into action
Once every open lead has a next action and date, use the freelance lead follow-up guide to choose your timing and write concise messages.
When to move to a CRM
A spreadsheet becomes fragile when several people update it, conversations happen across many channels, or you repeatedly need reminders, email history, automation, permissions, and reporting. At that point, use your tracker as the requirements list for evaluating a CRM.