Sales spreadsheet alternative: what to use when Excel stops working

Spreadsheets are a fair place to start selling. Here is where they stop working, what you can use instead, and how to choose something your whole team will actually use.

If your sales are tracked in Excel or Google Sheets and it is starting to creak, the usual alternative is a CRM: software built to hold your leads, their history, your deals and your follow-ups in one place. But not every team needs the biggest or most expensive one, and moving to the wrong tool can leave you worse off than the spreadsheet you started with.

We build a CRM, so we have an interest here. We will be straight about that, and about when a spreadsheet is still the right answer.

Why spreadsheets work, at first

A spreadsheet is a sensible way to start selling. It costs nothing extra, everyone already knows how to use it, and you can set it up in an afternoon exactly the way you think. For one person with a short list of leads, it can work for a long time.

The trouble is not the spreadsheet. It is what happens when the business grows around it.

Where a sales spreadsheet stops working

Follow-ups get lost. A spreadsheet can store a date, but it cannot remind anyone to act on it. Whether a callback happens depends on someone remembering to open the file and look. When things get busy, they do not.

There is no real history. A row shows where a lead stands today. It does not show the calls, emails and notes that got it there, so every conversation starts with “where did we get to?”. Those details end up in inboxes, notebooks and people’s heads.

One person holds it together. Most sales spreadsheets have an owner: the person who built it, knows what the columns mean and fixes it when it breaks. When they are away, nobody else is quite sure how it works.

Copies multiply. The moment two people need it at once, there are two versions, or one person waiting for the other to finish. Which one is current?

Everyone sees everything. There is no sensible way to let a rep see their own leads without showing the whole file, or to see who changed what and when.

Quotes and reporting live elsewhere. Proposals get written in a document, sent as attachments and tracked by hand. Reports mean building charts from a sheet you hope is up to date.

If three or more of those sound familiar, the spreadsheet is costing you time and, probably, sales.

Your alternatives

You have more choices than “stay on Excel” or “buy the biggest CRM”. Here is the range, with an honest view of each.

OptionGood forWatch out for
A better-organised spreadsheetOne or two people, a short list of leadsIt still cannot remind you, keep history or control who sees what
A simple lead or pipeline boardTeams that mainly need to see deals moving through stagesFollow-ups, proposals and reporting are often thin
A large, full-featured CRMBig teams with someone to run itOften so complex that only one person can drive it, and you pay for features you never use
A CRM set up around how you sellSmall and medium-sized sales teams that follow up leads and send proposalsMake sure someone sets it up properly, or you will recreate the spreadsheet inside it

The last two are where most small sales teams end up. The difference between them is usually how many people can actually use the thing.

How to choose

A tool is only worth having if your whole team uses it. These are the questions we would ask before choosing.

  1. Can everyone use it, not just one person? If only the person who set it up understands it, you have rebuilt the spreadsheet problem.
  2. Does it fit how you already sell? Look for your own fields, your own pipeline stages and your own deal types, rather than a process you must bend to.
  3. Does it remind people to follow up? Tasks, callback dates and reminders are the first thing a spreadsheet cannot do.
  4. Does every lead keep its full history? Calls, emails, notes and documents in one place, so anyone can pick a lead up.
  5. Can it do your quotes? If proposals and signatures sit outside the system, you will still be chasing by hand.
  6. How does your data come across? Ask who moves your spreadsheet in, and whether you can get your data back out.
  7. Where is your data held, and who can see it? Ask for it in writing: where it is hosted, how it is separated from other customers and who in your team can see what.
  8. How is it priced? Ask the supplier how they charge, per user or a fixed rate, and what is included. Do not accept a price that depends on features you will not use.

How to switch without losing anything

You do not need a big project. The steps are the same whichever tool you choose.

  1. Tidy the sheet first. Remove duplicates and decide what each column means. A clean import is far easier than a messy one.
  2. List the fields you actually use. Do not recreate every column. Keep the ones that help you sell.
  3. Import it. Most tools take a CSV file. Some suppliers will do it for you.
  4. Check a sample. Open a handful of leads and compare them with the sheet before you trust it.
  5. Pick a switch-over day. Stop updating the sheet that day, so there is only ever one version.
  6. Keep the sheet for reference for a short while, then archive it.

If you want a fuller walkthrough, our comparison of Henkan CRM and spreadsheets goes job by job.

What it looked like for one business

Fuelwise, a fuel card supplier in Coleraine, was managing leads, callbacks, quotes and customer data across spreadsheets, emails and manual notes. As the business grew, it became harder to stay organised, track follow-ups and give management a clear view.

Since moving to Henkan CRM, Fuelwise has recorded a 23% increase in sales, with the team reporting around 5 hours saved per week per staff member and no missed leads. Those figures were supplied by Fuelwise. You can read the full Fuelwise story.

How we approach it at Henkan CRM

We built Henkan CRM for exactly this move. It is meant to be simple enough for the whole team, and set up around how you already sell, with your own fields, stages and deal types.

Everything a spreadsheet cannot do is in the same place. Every lead has one page with its full history. Tasks and callbacks remind people to follow up. Deals move through your own sales pipeline, and proposals are signed online. Our team imports your spreadsheet for you (see capture), so you do not start from nothing.

There is no sign-up form. We set you up after a demo, so we can show you the system with your own sales process in mind.

Questions people ask

Is a CRM always better than a spreadsheet? No. For one person with a short list, a spreadsheet can be enough. A CRM earns its place when follow-ups slip, history matters or more than one person needs the same information.

Will a CRM be too complicated for my team? It can be, if you choose one built for large organisations. Look for something your whole team could use on day one, and ask to see it with your own process.

Can I keep using the spreadsheet alongside? For a short time while you check your data, yes. After that, keep one source of truth. Two versions are how the original problem starts.

What if I only have a handful of leads? Then there is no rush. Come back to this list when follow-ups start slipping.

Keep reading

If you would like to see how your own spreadsheet would look in Henkan CRM, book a demo and bring it with you.

See Henkan CRM set up around how you sell.

Book a demo and we will show you the product with your own sales process in mind.

Book a demo
  1. 01 Book a demo Tell us a little about your business.
  2. 02 See it around how you sell We show you the product with your sales process in mind.
  3. 03 We set it up for you Our team configures your account, from fields and stages to automations.