Launch offer: 30% off everything until November 30 with code LAUNCH30, applied automatically at checkout.
Free download

Free CRM Spreadsheet Template for Small Business

Contacts, a sales pipeline, an activity log and a follow-up list that tells you who to call today. Excel and Google Sheets, no sign-up and no monthly fee.

Free
Download the free CRM template (68 KB)
  • No sign-up. The download starts straight away.
  • Free for your own business. Please don't resell or re-share the file.

Want the full set? The Small Business Spreadsheet Bundle is $27.30.

Get the Small Business Spreadsheet Bundle

30% off with code LAUNCH30, already applied when you click Buy.

What's in the free download

  • Contacts: company, email, phone, lead source, status, last contact and next follow-up date
  • Deals: value, stage, win chance and weighted value, with expected and actual close dates
  • Activity log for calls, emails and meetings, which counts touches for each contact
  • Follow-ups: a list of who is overdue, due today and due in the next days, sorted for you
  • Stages and Settings you can edit, plus sample rows and a Start here tab

How to set up your spreadsheet CRM

  1. Open the file in Excel, or upload it to Google Drive and open it with Google Sheets.
  2. On Settings, type your business name and check the lead sources and activity types.
  3. On Stages, set your sales stages and the chance of winning at each one, for example Lead 10%, Proposal 50%, Won 100%.
  4. On Contacts, add each person with the next date you plan to follow up.
  5. On Deals, pick the contact and stage from the dropdowns and type the value. Win chance and weighted value fill in.
  6. Each morning, open Follow-ups. Overdue people are at the top, then today, then the coming days.

Why a spreadsheet CRM works for a small business

  • No monthly fee. You own the file.
  • Nothing to learn. If you can use a spreadsheet, you can use it today.
  • Your data stays yours. Export, share or back it up however you like.
  • Easy to change. Add a column for anything your business needs.

A spreadsheet CRM suits one person or a small team with up to a few hundred contacts. If you need email tracking, automations or many people editing at once, a paid CRM may fit better later.

Free template or the full CRM?

FeatureFreeFull Small Business CRM
Contacts, deals and activity logYesYes
Automatic follow-up listYesYes
Editable stages with win chanceYesYes
Pipeline dashboard with chartsNoYes
Monthly report of leads, deals and revenue wonNoYes

Sales stages and win chances to start with

StageWhat it meansStarting win chance
LeadSomeone showed interest but you haven't talked yet10%
QualifiedThey have the need, the budget and a reason to act soon25%
ProposalYou sent a quote or proposal50%
NegotiationYou're agreeing on the details75%
Won or lostThey said yes, or the deal is closed without a sale100% or 0%

Change the stages and percentages on the Stages tab to match how your sales really go. After a few months, compare the chances with your actual results and adjust them. The weighted value of each deal (value times win chance) gives you a realistic forecast instead of a hopeful one.

Follow-up habits that win more deals

  • Always set a next date. Every contact gets a next follow-up date before you close the row.
  • Follow up within a day of a call or meeting while it's still fresh for both of you.
  • Log every touch. A quick note in Activity saves you rereading old emails before the next call.
  • Close the loop. If a deal is lost, mark it lost with a reason. Those reasons show you what to fix.

Spreadsheet CRM or a paid CRM?

Spreadsheet CRMPaid CRM software
CostFree, yours to keepA monthly fee per user
SetupMinutesHours to days
Best forOne person or a small team, up to a few hundred contactsLarger teams, many contacts
Email tracking and automationNoUsually yes

Questions

Is it really free? Yes. No email and no sign-up. The download is a ZIP with the .xlsx file and a short read-me.

Does it work in Google Sheets? Yes. Upload the .xlsx to Google Drive and open it with Google Sheets.

How many contacts can it hold? The formulas cover 500 contacts, 500 deals and 1,000 activity rows.

Small Business Spreadsheet Bundle preview

Want the full set?

The Small Business Spreadsheet Bundle: Eleven spreadsheets for the business side of a small business, with the formulas already done: bookkeeping, a CRM and sales pipeline, inventory and profit, a rental property manager, a business plan with 3-year financials, a social media planner, a pricing calculator, a 13-week cash flow forecast, a year-end tax prep organizer, a mileage log and an employee shift schedule. Type in your numbers and the dashboards and reports update. $27.30, instant download.

Get the Small Business Spreadsheet Bundle

Related guides