Free freelance client tracker template
Most freelancers don't lose work to a better competitor. They lose it to a follow-up they forgot to send. This simple spreadsheet keeps every lead, proposal and past client in one place, with the date of the next follow-up front and center.
Download the CSV templateWorks in Google Sheets (File, Import), Excel and Numbers.
What each column is for
| Column | Why it's there |
|---|---|
| Client | Company or person you'd invoice. |
| Contact name and Email | Who you actually talk to, so a follow-up is one click away. |
| Source | Referral, LinkedIn, Upwork, past client. After a month you'll see which source pays. |
| Stage | Lead, Contacted, Proposal sent, Won, Lost. Keep it to five so you actually update it. |
| Project and Value | What they want and roughly what it's worth, so you chase the biggest deals first. |
| Last contact | The date you last heard from them or wrote to them. |
| Next follow-up | The one date that matters. Sort by this column every morning. |
| Next step | A verb: send proposal, follow up, pitch retainer. Vague steps don't get done. |
| Notes | Anything you'd forget: budget hints, decision makers, what they liked. |
How to use it in five minutes a day
- Download the CSV and open it in Google Sheets, Excel or Numbers.
- Delete the three example rows and add every lead, open proposal and past client you can think of.
- Give every row a Next follow-up date. No date means the lead is quietly dying.
- Each morning, sort by Next follow-up and send anything due today or overdue.
- When a deal is won, set a follow-up about 30 days out to pitch a retainer or ask for a referral.
Need the words for those follow-ups? Use the follow-up email templates and the retainer proposal template. Not sure how many leads you need? Try the freelance pipeline calculator.
Outgrowing the spreadsheet?
A spreadsheet can't nudge you. SteadyPipe is the same pipeline with reminders built in: it tells you which follow-ups are due today, schedules a retainer pitch after a won deal, and keeps a weekly follow-up streak. Free for up to 5 open leads.
Start freeFAQ
- What should a freelance client tracker include?
- At minimum: who the client is, how to reach them, where the lead came from, what stage it's at, what it's worth, when you last spoke, and the date of the next follow-up. The next follow-up date is the column that actually brings in work.
- Is a spreadsheet good enough to track freelance clients?
- For a handful of leads, yes. It starts to break when you have more than 10 to 15 open conversations, because nothing reminds you when a follow-up is due. That's when a tracker with reminders saves deals.
- How often should I follow up with a freelance lead?
- A common rhythm is 3 days after a proposal, then 7 days later, then a final note 2 weeks after that. Past clients deserve a light check-in every 60 to 90 days.
- What pipeline stages should freelancers use?
- Lead, Contacted, Proposal sent, Won and Lost cover most freelance work. More stages usually means the tracker stops getting updated.