Do freelancers need a CRM? Spreadsheet vs CRM, decided by numbers

By SoloWOS teamPublished October 19, 2026

IN SHORT

A freelancer needs a CRM once open conversations no longer fit in memory, usually somewhere around 5 to 10 leads or proposals in play at once, or as soon as follow-ups start slipping. Below that, a spreadsheet with stage, next step and a date works. Above it, reminders and a pipeline view keep deals moving.

Prices and limits as of October 26, 2026.

Key takeaways

The trigger isn't your revenue; it's how many conversations are open at once and whether follow-ups get missed.
Track 8 fields in either tool: name and email, company, source, stage, next step, next-step date, open value and notes.
Work back from your income goal: the goal, your average project, your close rate and your proposal rate give the number of leads you need each month.
Spreadsheets break on reminders, duplicates and history, not on the number of rows.
A freelancer CRM needs a pipeline, reminders and contacts created from your forms and bookings. Lead scoring and sales forecasting can wait.

Plenty of freelancers run for years on a spreadsheet, and plenty lose a project because a follow-up sat in their head for two weeks. The question isn't "CRM or not" but at what point the spreadsheet starts costing you clients. This post is part of the winning clients hub.

Spreadsheet or CRM: the decision table

Signals that decide it (pick the column where most of your answers land)
Signal	A spreadsheet is enough	Either works	Get a CRM
Open conversations at once (leads, calls, proposals)	Fewer than 5	5 to 10	More than 10
New leads per month	Fewer than 4	4 to 10	More than 10
Follow-ups you owe in a typical week	1 or 2	3 to 6	More than 6, or you've missed one this month
Where leads come from	One place (referrals)	Two or three	Forms, bookings, social, referrals and email
Repeat clients	Mostly one-off	Some	Most work is repeat or retainers
Who updates it	You	You, weekly	You plus an assistant or teammate

These thresholds are a rule of thumb from how many items people can keep track of without a system, not a study. The honest test is simpler: if you've found an unanswered lead or a proposal you forgot to chase in the last month, the spreadsheet is already failing.

The 8 fields worth tracking

Name and email: one row per person, matched by email so the same client doesn't appear twice.
Company: for B2B work and for looking them up before a call.
Source: referral, search, a form, social. After six months this tells you where to spend time, and a "How did you hear about me?" question on your inquiry form records it before the first reply.
Stage: Lead, In conversation, Proposal sent, Won or Lost.
Next step: the one action that moves it forward ("send proposal", "call Tuesday").
Next-step date: the field that makes reminders possible. A row without one is a row you'll forget.
Open value: what's in proposals and unpaid invoices for this person.
Notes: what they said, in their words, with the date.

Spreadsheet header row (paste into row 1)

Name,Email,Company,Source,Stage,Next step,Next step date,Open value (USD),Last contact,Notes

Pipeline math: how many leads do you need?

WORKED EXAMPLE

From an income goal to leads per month

Goal: $8,000 a month. Average project: $2,000, so you need 4 won projects. If you win 40% of the proposals you send, you need 10 proposals. If half of your leads get far enough for a proposal, you need 20 leads a month, about 5 a week. Twenty new conversations a month, each with two or three follow-ups, is past what most people track reliably in their head or in a sheet without reminders. The sales pipeline calculator runs the same math with your numbers: deals = goal / average deal, proposals = deals / close rate, leads = proposals / proposal rate, each rounded up.

WORKED EXAMPLE

What a forgotten follow-up costs

A client who books 2 projects a year at $2,000 and stays 3 years is worth $12,000 in revenue. The customer lifetime value calculator adds your margin and shows what you can afford to spend to win one. Next to a number like that, the cost of a CRM is small; the habit of keeping it current is the real price.

Where spreadsheets break

No reminders. A next-step date in a cell doesn't email you when it arrives.
Duplicates. The same person comes in through a form, a booking and an email, and ends up on three rows.
Stale stages. Nobody updates the stage after the proposal goes out, so the sheet stops matching reality.
No history. You can't see when someone moved from Lead to Proposal sent, or why a deal was lost.
Copying. Every form response or booking has to be typed in by hand.

What a freelancer CRM needs, and what it doesn't

CRM features for a one-person business
Feature	Need it?	Why
Pipeline board with stages	Yes	One glance shows what's open and stuck
Contacts created from forms and bookings	Yes	Removes the copying, which is why sheets go stale
Reminders or follow-up emails	Yes	The job a spreadsheet can't do
Open value per client	Useful	Shows where the money is waiting
Email inbox sync	Nice to have	Saves logging, but adds setup and privacy questions
Custom stages, multiple pipelines	Rarely	Five stages cover lead to paid for most freelancers
Lead scoring, forecasting	No	Built for sales teams with hundreds of leads

The CRM in SoloWOS

SoloWOS includes a CRM pipeline for freelancers on every plan. Contacts are created or updated by email from your forms, bookings and proposals, so the same person doesn't show up twice. The board has five fixed stages (Lead, In conversation, Proposal sent, Won, Lost), and with automatic stages on, a booking moves a lead to In conversation, a sent proposal to Proposal sent, and an accepted proposal or paid invoice to Won. Each card shows open proposals and unpaid invoices, and every move is logged. To automate client follow-ups, an automation can email the contact when they reach a stage. It doesn't sync your email inbox and you can't rename stages. Solo costs $15/month.

Questions

Is a spreadsheet enough for a freelancer?

Yes, while you have fewer than about five open conversations and you never miss a follow-up. Add a next-step date column and check it every morning. Once leads come from several places or you find a forgotten lead, the time you spend copying and checking costs more than switching.

What's the minimum a freelancer CRM should do?

Show your open deals by stage, remind you of the next step, and create contacts automatically from the places leads come from. Everything else is optional. If a CRM needs an afternoon of setup before it's useful, it's built for a sales team.

Should I keep leads that went nowhere?

Yes, marked as Lost with a reason. Lost leads tell you which sources and budgets don't convert, and some come back months later. Delete only on request, and follow your privacy obligations for personal data.

How long should I keep client records?

For tax purposes, the IRS says to keep records that support income or deductions until the period of limitations for that return runs out: generally 3 years after you file, 6 years if you leave out income worth more than 25% of what you reported, and 7 years for a bad debt deduction. Keep invoices and contracts with the client record for at least that long.

How often should I update my pipeline?

Every time something changes, which is why automatic updates matter. If you update by hand, block 10 minutes at the start of each day to check next-step dates and 20 minutes once a week to clean up stages.

Sources

Facts checked against these sources on October 18, 2026. Rules and amounts change, so confirm them at the source before you file or sign.

Last reviewed: October 18, 2026

SoloWOS tools mentioned here

Run your client work from one account

14 days free, no card needed · Then Basic for $2/month.

Start your free trial