How to Build a Simple CRM Spreadsheet for Freelancers: Pipeline, Follow-Ups and Onboarding
Last updated: 9 October 2026
Most freelancers do not lose work because they are bad at the job. They lose it because a promising enquiry got buried in the inbox, a proposal never got a follow-up, or a new client’s first week felt disorganised. A full CRM system can fix that, but for one person with a handful of leads a month it is often more software than you need. A spreadsheet with the right columns, one rule and a ten-minute daily habit does the same job. This guide shows how to build it.
What a freelancer’s CRM actually needs to do
Strip a CRM (customer relationship management) tool down to its core and it does three things:
- Shows your pipeline: every potential client and how close each one is to saying yes.
- Tells you who to contact next, and when.
- Makes onboarding repeatable, so every new client gets the same smooth start.
Everything else, such as email sync, automations and team permissions, is useful later. Start with these three and a spreadsheet is enough.
Step 1: The columns
One row per lead or deal. If the same client comes back for a new project, give the new project its own row.
| Column | What goes in it |
|---|---|
| Name / company | Who you are talking to. |
| Source | Where they found you: referral, Instagram, website, repeat client. |
| Service | What they want, in a few words. |
| Stage | A dropdown with your pipeline stages (next step). |
| Value | Your estimate or quote, before VAT. |
| Next step | The one thing you will do next, such as “send proposal”. |
| Follow-up date | When you will do it. |
| Flag | Calculated: Overdue, Today or This week. |
| Notes | Budget, deadline, anything you will not remember in three weeks. |
Step 2: Pipeline stages
Keep the stages few and clear. Each one should describe something that has actually happened, not a feeling. A simple set for service work, with a rough chance of winning that you can adjust to your own history:
| Stage | Means | Chance (your guess) |
|---|---|---|
| Lead | They exist and might need you | 10% |
| Contacted | You have talked or emailed | 20% |
| Call booked | A call or meeting is in the calendar | 40% |
| Proposal sent | They have a price and a scope | 60% |
| Won | Quote accepted or contract signed | 100% |
| Lost | They said no, or went quiet after your last follow-up | 0% |
Put the stages and percentages on a small tab called Stages and use them for the dropdown (Data → Data validation in both Excel and Google Sheets). Then the weighted value of a deal is its value × its chance:
=E2*VLOOKUP(D2,Stages!A:B,2,FALSE)
The sum of weighted values is a sober estimate of what your open pipeline is worth, which is far more useful for planning than the optimistic total.
Step 3: The one rule: every open deal has a follow-up date
This is the whole trick. If a deal is not Won or Lost, it must have a next step and a date. No date means it will be forgotten. With the stage in D and the follow-up date in G, the flag column is:
=IF(OR(D2="Won",D2="Lost",G2=""),"",IF(G2<TODAY(),"Overdue",IF(G2=TODAY(),"Today",IF(G2<=TODAY()+7,"This week",""))))
Colour Overdue red, Today amber and This week blue with conditional formatting, then sort by follow-up date. When you open the sheet, the top rows are your to-do list.
Worked example: a fictional freelancer’s pipeline
These leads are invented for the example. Imagine today is Friday 9 October 2026.
| Client | Stage | Value | Weighted | Follow-up | Flag |
|---|---|---|---|---|---|
| Harbour Café | Proposal sent | €2,400 | €1,440 | 7 Oct | Overdue |
| North Yoga | Call booked | €900 | €360 | 9 Oct | Today |
| Fjord Travel | Proposal sent | €3,000 | €1,800 | 12 Oct | This week |
| Lumi Bakery | Contacted | €1,600 | €320 | 14 Oct | This week |
| Pine Studio | Lead | €600 | €60 | 20 Oct | – |
| Kettu Ceramics | Won | €1,200 | – | – | Onboarding |
Open pipeline: €8,500. Weighted: €3,980. That gap is normal; it is exactly why the weighted number is the one to plan with. Today’s actions are obvious: chase Harbour Café’s proposal, prepare for the North Yoga call, and start onboarding Kettu Ceramics.
A 10-minute daily routine
- Add anything new. Every enquiry from email, DMs or calls gets a row, a stage and a follow-up date.
- Work the red and amber rows. Send the follow-up, then update the stage, next step and new date before you move on.
- Close what is dead. After two or three unanswered follow-ups, mark it Lost with a short note. A clean pipeline is an honest one.
Once a week, glance at the totals: number of open deals, weighted value, and win rate. Win rate is simply won ÷ (won + lost):
=COUNTIF(D:D,"Won")/(COUNTIF(D:D,"Won")+COUNTIF(D:D,"Lost"))
Follow-up messages that do not feel pushy
Short, specific and easy to answer works best. Two examples you can adapt:
After a proposal
Hi Emma, I wanted to check whether you had a chance to look at the proposal for the new website. Happy to adjust the scope or timing if something does not fit. Would a 15-minute call next week help?
Last follow-up
Hi Leo, I have not heard back, so I will assume the timing is not right at the moment and close this on my side. If things change, just reply to this email and we can pick it up again.
The second message often gets a reply, and if it does not, you can mark the deal Lost with a clear conscience.
Step 4: An onboarding checklist for every new client
When a deal moves to Won, the same ten steps start. Keep them on their own tab with one column per client and tick them off:
- Quote accepted or contract signed, with scope and revision rounds written down.
- Deposit invoice sent (and logged in your invoice tracker).
- Deposit received.
- Welcome email: timeline, how and when to reach you, what you need from them.
- Kickoff call booked.
- Brief or questionnaire received.
- Files, brand assets and access collected. Share logins through a password manager, not plain email.
- Shared folder set up.
- Milestones and deadlines added to your calendar.
- First check-in date set.
A checklist like this sounds bureaucratic, but clients notice the difference. The first week sets the tone for the whole project, and the routine means you never have to remember it all yourself.
When to move to a real CRM
A spreadsheet works well while one person updates it and you have up to a few dozen open deals. It is time to look at dedicated CRM software when several people need to edit at once, when you find yourself copying data between tools every week, or when you want emails logged automatically. Until then, simple wins.
How it connects
The value column only means something if your prices are right, so see how to calculate your freelance hourly rate before you quote. Won deals become invoices, and the weighted pipeline is a good input for next month’s budget. If many of your leads come from social media, a steady posting plan helps keep the top of the pipeline full; planning a month of Instagram posts is a good place to start.
If you would like this ready to use, the Bolde Client Tracker CRM has the lead pipeline with stage dropdowns, automatic Overdue, Today and This week flags, a 10-step onboarding checklist, a projects tab, a dashboard with weighted pipeline and win rate, and seven short email templates. It works in Excel, Google Sheets and LibreOffice, with no subscription and no macros.
Questions
Can I use a spreadsheet as a CRM?
Yes. For a freelancer or a very small business, one tab with name, stage, value, next step and follow-up date, plus a formula that flags overdue follow-ups, covers what most people use a CRM for.
What columns should a simple CRM spreadsheet have?
Name or company, source, service, stage, value, next step, follow-up date, a calculated flag and notes. Add a weighted value column if you want a realistic view of your pipeline.
How often should I follow up with a lead?
Set a follow-up date for every open deal. A few working days after a proposal is a common first follow-up, then about a week later. After two or three unanswered messages, close the deal politely and move on.
Bolde · hello@bolde.fi