
A CRM in a spreadsheet, and it tells you where the month lands.
Deals as a board by stage, a weighted forecast against your monthly target, a call log with call backs that flag themselves, and contacts that turn red when a live deal goes quiet.
Google Sheets · Excel .xlsx · Blank + filled example
Language
Instant download. Permanent link in your account.
Instant download. Permanent link in your account. Yours forever, no subscription.
You sell. It keeps the pipeline honest.
Everything on the right is a formula you never have to touch, in Google Sheets and in Excel alike.
You type
- Your target and stages, once
- Each deal and its stage
- Every call, email and meeting
It works out
- The board, by stage
- A weighted forecast against target
- Follow-ups that have gone quiet
- Win rate by source
Open any tab. These are the real ones.
Tap a tab, then the picture to read every figure full size.
Board
The Board tab.
The board: a column per stage, biggest deals first as cards.
What If
Where this month lands.
At your own win rate, where this month finishes, and the day you cross target at the pace you are on. Add deals or raise the win rate and the month redraws.
Deals
Every opportunity.
Stage, value, chance of closing, close date and the next step, one row each.
Contacts
Quiet too long turns red.
Each contact with their last contact date and open deals. Thirty days quiet with a deal still open, and it turns red.
Call Log
Call backs that flag themselves.
Every prospecting call with its outcome, and a call back that flags itself when it is due.
The dashboard
The dashboard.
Open pipeline, weighted forecast, won against target, win rate, overdue follow-ups and the funnel.
Activities
Activities.
Every call, email, meeting and demo, logged against its deal.
Start here
Start here.
Every tab in one line, then the order to fill it in. The first tab you open, and the only instructions you need.
A plain spreadsheet, and this one.
On the left, the plain deal list most people keep. On the right, the Board tab. Drag the line.
Google Sheets or Excel. You do not have to choose.
The download carries both: the Sheets copy link and the native .xlsx. Every formula is chosen to work identically in the two, and we test the round trip on every build.
Your first five minutes.
-
1
Buy it once.
$49, no subscription. Your order email and your account both carry the download, permanently.
-
2
Copy it into your Drive.
One click and it is yours, in your own Google account, forever. We keep no access to your copy and nothing in it phones home.
-
3
Start in the example.
The filled copy shows every tab already working. Poke it, break it, then open your blank and type your own.
Add the rest of the set.
All five goes in as the Freelancer & Solopreneur Kit at $129, not five separate items. You keep $66.
Also in the Small Business Operations Kit: all four for $129, you keep $57.
Also in the Real Estate Agent Kit: all four for $129, you keep $47.
№ · Will the month land?
A sales CRM spreadsheet with a pipeline board, follow-up dates and a forecast you can trust
The Sales CRM & Pipeline is for a freelancer, a founder or a small sales team that has outgrown a list of names but does not want a CRM subscription. Put your monthly target on Settings and, if you sell as a team, the owners. Every opportunity is one row on Deals: company, contact, owner, source, stage, value, expected close, next step and a follow-up date.
The follow-up date runs it
Every open deal should carry one, and a deal without it says “No date” until it does. Each morning the Dashboard lists the follow-ups due and overdue, and the Board lays the pipe out as a column per open stage, biggest deals first. Contacts pulls each person’s last contact from the Activities log, and anyone quiet for 30 days with an open deal turns red.
Calls before they are contacts
Calls come before deals, so the Call Log keeps them: date, name, phone, source and what happened (talked, appointment set, voicemail, no answer, not interested, wrong number), with a call back date that flags itself overdue and a column that tells you once the person is in Contacts. The top of the tab counts calls and conversations over the last seven days, appointments set over thirty, and the call backs due.
A forecast weighted by stage
Stages run Lead, Qualified, Proposal and Negotiation, then Won or Lost, each with a chance of closing (10, 25, 50, 75%) you can set to your own history. Weighted value, value times chance, is the steadier forecast. What If says where the month lands at your own win rate, the day you cross the target at this month’s pace, and what a better win rate or a few more deals would be worth.
The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.
Planning on a tablet or on paper instead? Find your planner in 60 seconds.
The questions we actually get
How does it remind me to follow up?
Every deal has a follow-up date. The Dashboard lists the ones due today and those overdue, and Contacts turns anyone red who has an open deal and no contact for 30 days.
What is weighted value?
The deal's value times its stage's chance of closing, 10% for a Lead up to 75% at Negotiation to start. Change the chances on Settings to match your own record.
Why are there two win rates?
The Dashboard counts deals; What If weighs money. A month's target is money, so the forecast uses the money one.
Can a team use it?
Yes. Add each seller as an owner on Settings. The Dashboard shows who is winning, and in Google Sheets everyone can work in the same copy.
Can I rename the stages?
Yes, but keep six, with Won and Lost last. The first four count as open.
Does it work in Excel?
Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable.
Is there a year printed in it?
No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year.
Every deal, in view.
Pipeline, forecast and follow-ups, in Google Sheets and Excel, no subscription, no year baked in.
Get the CRM · $49Still deciding? Open it live, read‑only. Not the sheet you need? See every spreadsheet template or ask at Templacity Hall.
Be the first to say something.
Nobody has written about this one yet. If it is on your device, yours is the first thing the next person reads.
Instant download.
Your file is in your account the moment you check out, yours to re-download any time. A receipt lands in your inbox, too.
One-time purchase.
No subscription, no annual renewal, no upgrade nags. Pay once and the file is yours.
Quiet, secure checkout.
Stripe. Apple Pay. No spam, no “partners,” no reselling your details. Receipt, file, done.

