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.

- 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 Bundle30% 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
- Open the file in Excel, or upload it to Google Drive and open it with Google Sheets.
- On Settings, type your business name and check the lead sources and activity types.
- On Stages, set your sales stages and the chance of winning at each one, for example Lead 10%, Proposal 50%, Won 100%.
- On Contacts, add each person with the next date you plan to follow up.
- On Deals, pick the contact and stage from the dropdowns and type the value. Win chance and weighted value fill in.
- 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?
| Feature | Free | Full Small Business CRM |
|---|---|---|
| Contacts, deals and activity log | Yes | Yes |
| Automatic follow-up list | Yes | Yes |
| Editable stages with win chance | Yes | Yes |
| Pipeline dashboard with charts | No | Yes |
| Monthly report of leads, deals and revenue won | No | Yes |
Sales stages and win chances to start with
| Stage | What it means | Starting win chance |
|---|---|---|
| Lead | Someone showed interest but you haven't talked yet | 10% |
| Qualified | They have the need, the budget and a reason to act soon | 25% |
| Proposal | You sent a quote or proposal | 50% |
| Negotiation | You're agreeing on the details | 75% |
| Won or lost | They said yes, or the deal is closed without a sale | 100% 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 CRM | Paid CRM software | |
|---|---|---|
| Cost | Free, yours to keep | A monthly fee per user |
| Setup | Minutes | Hours to days |
| Best for | One person or a small team, up to a few hundred contacts | Larger teams, many contacts |
| Email tracking and automation | No | Usually 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.

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