If you've ever thought "I really need a CRM" but couldn't decide which platform to go with because the options were either too expensive, too complicated, or built for a large sales team, I get it.
Most small business owners don't have a CRM problem. They have a "my leads and clients live in six different places and I can't see the whole picture" problem. A $50-a-month platform doesn't fix that. A little bit of structure does.
Here's how to build a simple pipeline in a tool you probably already have open right now: a spreadsheet.
Why a spreadsheet actually works here
A spreadsheet gets a bad reputation because messy spreadsheets are everywhere. But the mess usually isn't the spreadsheet's fault. It's a structure problem. People type notes into the wrong cell, mix a phone number and a follow-up date into one field, or free-type a status like "sent it," "Sent It!," and "proposal sent" until filtering becomes useless.
Fix the structure, and a spreadsheet holds up just as well as software that costs you monthly.
Three rules make the difference:
- One row, one record. Every lead, donor, or client gets exactly one row. Never stack two people in a single row to save space.
- One idea, one column. Don't combine a name and a note in the same cell. Split things out — first name, last name, date, status — so you can sort and filter on any of them.
- Dropdowns instead of free text. If status is typed by hand, you'll eventually get three versions of the same status. A dropdown keeps it clean.
Build this: about 10 minutes
Step 1: Set up your headers
Open a fresh sheet, rename the tab something like "Pipeline," and set up these columns across row 1:
- Date Added
- First Name
- Last Name
- Organization
- Phone
- Status
- Estimated Value
- Next Step
- Follow-Up Date
- Notes
Bold the header row and freeze it (View > Freeze > 1 row) so it stays visible as you scroll.
Step 2: Turn Status into a dropdown
Click the Status column header, then Data > Data validation > Add rule, and choose Dropdown. Add options that match how work actually moves through your world, something like:
- New Inquiry
- Contacted
- Proposal Sent
- Active
- Complete
- Not a Fit
Give each one a light background color if you want a quick visual read at a glance.
Step 3: Make new entries impossible to miss
Select your full data range, then Format > Conditional formatting, and add a custom formula rule: =$G2="New Inquiry" (adjust the column letter to match your Status column). Set it to a soft highlight color. Now anything brand-new stands out the moment you open the sheet, no scanning required.
That's it. No integrations, no monthly fee, no onboarding call with a sales rep.
When a spreadsheet stops being enough
This setup will get you pretty far, but here are a few clues that it's time to scale:
- You want automatic reminders instead of remembering to check a Follow-Up Date column
- You're manually re-typing the same info from an intake form into the sheet
- The sheet has turned into five tabs and nobody remembers what half of them are for
None of those mean you need expensive software. Often they mean the structure needs to grow up a little. That usually still happens inside tools you already have.
If you're at that point and want a second set of eyes on it, that's exactly what an Untangle It Session is for. We'll look at what you've actually got and figure out what it needs next, whether that's a small fix or something more.