A spreadsheet can be a real CRM for one person and a handful of deals. Here is how to set one up, the formulas that make it useful, and the exact moment it stops paying off.
Google Sheets works as a CRM for a solo seller or a tiny team: store contacts in rows, track a pipeline with a status dropdown, and report with formulas like COUNTIF and FILTER. It is free and flexible, but it has no automation, no reminders, and no real multi-user control, so it breaks the moment you add a second person or a few thousand rows.
A Google Sheets CRM is a spreadsheet set up to do the basic job of customer relationship management: one row per contact, columns for status and next action, and a few formulas that turn the list into a pipeline you can read at a glance. It runs inside Google Sheets, so it is free, lives in the cloud, and needs zero setup.
It is a legitimate starting point, and the trap is treating it as permanent. If you are weighing it against a dedicated tool, our CRM vs Excel guide covers the same trade-off, and the Sheets version inherits most of the same limits with the bonus of easy sharing.
You can have a working pipeline in under an hour. Follow these six steps in order:
One row per contact. Columns: Company, Name, Email, Phone, Source, Status, Owner, Last contact, Next action, Next action date, Value, Notes. Freeze the header row so it stays visible as you scroll.
Select the Status column, open Data, then Data validation, and add a dropdown with your stages: New, Contacted, Qualified, Proposal, Won, Lost. Now every row sits in a clear pipeline stage instead of free text.
Apply a conditional formatting rule to the Next action date column with a custom formula like =$J2<=TODAY() so any row due today or overdue turns red. This is your reminder system, since Sheets has none built in.
On a second tab, count deals per stage with =COUNTIF(Contacts!F:F,"Qualified"), total open value with =SUMIF, and list overdue rows with =FILTER. That tab becomes your dashboard.
Share with edit access, then protect the header row and the formula tab so a teammate cannot overwrite them by accident. Keep the Notes column wide, context next to each deal is what makes the sheet usable later.
Decide in advance when you will leave: a second active editor, more than ~500 contacts, or follow-ups slipping. A written trigger keeps the spreadsheet from becoming your system of record by default. For a ready-made version, see our CRM Excel template guide.
Five functions do most of the work. Master these and your spreadsheet behaves like a lightweight pipeline:
| Formula | What it does | Example use |
|---|---|---|
| COUNTIF | Counts rows matching a stage | Deals in "Qualified" right now |
| SUMIF | Totals a value by criteria | Open pipeline value per owner |
| FILTER | Returns rows that meet a test | List of overdue follow-ups |
| XLOOKUP / VLOOKUP | Pulls a field from another tab | Match a deal to its company record |
| TODAY + format | Compares dates and highlights | Flag follow-ups due this week |
If you want the official reference for each one, Google publishes a full Google Sheets function list. The reason this matters: the market for spreadsheet CRMs is enormous because, per U.S. Census Bureau business statistics, over 99% of American employer firms are small businesses, many of whom run their first pipeline in a sheet exactly like this.
| Where Sheets wins | Where Sheets hurts |
|---|---|
| Free, instant, no setup or onboarding | No automation, reminders, or follow-up sequences |
| Fully customizable columns and formulas | No audit trail of who changed what, and when |
| Everyone already knows how to use it | Two people can overwrite the same cell silently |
| Easy to share with a link | Reporting is manual and breaks as the file grows |
| Great for validating a sales process | Slows down and corrupts past a few thousand rows |
The pattern is clear: Sheets wins on cost and flexibility, and loses on everything that scales with a team. Salesforce's State of Sales research finds reps spend roughly 70% of their week on non-selling work, and a manual spreadsheet adds to that number rather than cutting it.
| A Sheets CRM is fine if... | It is time to migrate when... |
|---|---|
| You are one person with a simple pipeline | A second person needs to edit the same data |
| You manage under ~500 active contacts | The file gets slow past a few thousand rows |
| Follow-ups fit in a single dated column | Deals slip because nothing reminds you |
| A summary tab answers your questions | You copy and paste between tabs to report |
| You are validating whether you need a CRM | The sheet has quietly become your system of record |
The adoption point matters most. Harvard Business Review's sales research has documented for years that CRM efforts fail when the tool creates busywork, and a shared spreadsheet with manual upkeep is one of the fastest routes to that. For very small teams choosing their first real tool, read simple CRM for small teams and our broader guide to CRM for SMBs.
One editor is fine. Two or more, and silent overwrites become inevitable. That is the clearest single signal to migrate.
Conditional formatting helps, but only if you open the file. A CRM sends reminders; a cell color cannot.
Lag past a few thousand rows means the spreadsheet is out of room, and performance only gets worse from there.
If your weekly numbers need manual copy and paste, you are paying in time what a CRM would automate for a few euros.
Field teams need maps and routes a sheet cannot give. See mapped CRM vs traditional CRM.
A sheet is empty without prospects. Tools that bundle data with the CRM, like a sales route planner with built-in business data, remove the manual entry entirely.
Search Google Maps and press Start. Vonsel gathers the business results as you explore the map, going beyond the pins you can see at a glance. Pause, continue and save your search when you are ready. Google Maps does not provide business emails. Vonsel visits the available business websites to find published emails, additional phone numbers and links to up to 118 supported social networks and other platforms. What it finds depends on what each website publishes. Keep businesses on a map, organise them by stage, edit their details and use a Kanban board, calendar, notes, actions, tags and custom fields. Basic holds 400, Pro 2,000 and Scale 10,000.
In summary:
If you would rather start from real prospects than a blank tab, watch the tutorial video to see a Google Maps search turn into a list of businesses with phones, websites and published emails. The pricing page lays out the free tier and what each paid plan adds, so you can compare it with the time your spreadsheet costs you.
