MestraMestra
All posts

CRM in an Excel or Google Sheets Spreadsheet: How to Build One, a Free Template and When to Switch to a System

Guides5 min read

How to build a CRM in Excel or Google Sheets: the column structure, 5 useful settings, a free template, pros and cons, and when it's time to switch to a CRM.

M
Mestra Team
CRM in a spreadsheet: a client tracking template and switching to Mestra

A CRM in a spreadsheet is an Excel or Google Sheets file where each row is a client or deal, and the columns are contacts, messenger, source, stage, owner, next step and amount. That's enough to start with: free, familiar, and you can give the team access.

But when enquiries pile up and there are several channels, the file can't keep up with the work: it's filled in late, tasks get forgotten, requests get lost. That's when it's time to switch to a CRM system where the base updates itself.

Mistakes when tracking clients in a spreadsheet

  1. Every manager keeps their own copy. A month later, the company has three versions of the base and none of them is up to date.
  2. There's no "next step" field. The spreadsheet stores contacts but doesn't tell you whom to write to and when.
  3. Conversations stay on phones. The spreadsheet shows the client's name but not what was agreed.
  4. Everyone has access to the whole base. Any employee can copy all the clients.

How to build a CRM in Google Sheets or Excel

Column What to enter
Enquiry date When the person first wrote or called
Name and phone Contacts
Messenger MAX, Telegram, WhatsApp*, VKontakte
Source Avito, website, referral, advertising
Interest What they want to buy
Stage New enquiry, meeting, proposal, paid, lost
Owner Who handles the deal
Next step What to do
Next step date When to do it
Deal amount For calculating revenue by stage
Reason for loss Why the deal fell through
Comment Important agreements

5 settings that make work easier

  1. A drop-down list for the stage — so everyone writes the same thing.
  2. A frozen header row.
  3. Conditional formatting: an overdue next-step date is highlighted in red.
  4. Filters by owner and stage.
  5. A separate summary sheet: how many deals are at each stage and for what amount — using COUNTIF and SUMIF formulas.

A free template

A ready template: a Clients sheet with drop-down lists for stages and messengers, and a Summary sheet that calculates the number of deals, the amount by stage and conversion to payment by itself. The template opens in Excel or can be uploaded to Google Sheets.

Download the client tracking template (Excel)

Pros and cons

Pros Cons
Free Doesn't remind you about tasks
Familiar and flexible Doesn't collect messages from messengers
Quick to start Filled in by hand and goes out of date fast
You can give the team access Easy to delete or damage data by accident
— No conversation history or communication quality control
— No access control for clients

When to switch from a spreadsheet to a CRM

  • Enquiries come from several messengers and classified sites.
  • More than one person works with clients.
  • The file gets filled in "later" and lags behind reality.
  • Promises to call back get forgotten.
  • You need to see how managers talk to customers.
  • You need permissions so an employee can't copy the whole base.

More in our article client tracking: how to keep a base.

How to move your data into a CRM

  1. Remove duplicates and bring phone numbers into one format.
  2. Keep only the columns you actually use.
  3. Upload the file to the CRM — most systems accept Excel.
  4. Set up the stages the same way as in the spreadsheet — the team will find it easier to adjust.
  5. Connect messengers so new enquiries enter the system by themselves.

How it works in Mestra

Mestra is our product. If the spreadsheet can no longer cope, you can move the base in one go, and from then on it updates itself:

  • Import from Excel or an old CRM at launch.
  • Enquiries from messengers and classified sites — MAX, Telegram, WhatsApp*, VKontakte, Instagram*, Avito, CIAN — go straight into cards.
  • Tasks and reminders instead of a "next step" column.
  • Roles and permissions for the base.
  • Export to Excel at any time — the data stays yours.
  • Analytics without formulas: conversion, sources, reasons for refusal.

CRM in a spreadsheet and switching to Mestra: client cards and tasks

FAQ

Can you build a free CRM in Google Sheets?

Yes. Create columns for contacts, source, stage and next step, or use a ready template.

How is a CRM different from a spreadsheet?

A spreadsheet is filled in by hand, while in a CRM enquiries from messengers arrive by themselves, tasks remind you about themselves, and the head sees the pipeline and the conversations.

How do you move clients from Excel to a CRM?

Clean the file of duplicates and upload it via import. In Mestra, the move is part of the launch.

Up to what business size is Excel enough?

Usually while you work alone and don't have many enquiries.

Bottom line

Excel is a good first step, especially with a ready template.

But as soon as requests start getting lost and filling in gets postponed, it's time to move to a system where the base updates itself. Try Mestra free for 15 days: move your base and connect messengers in 10 minutes.

*WhatsApp and Instagram are owned by Meta, which is recognised as extremist and banned in Russia.

Keep reading

Sign up for a demo and see it in action

Niche analysis with ready scenarios and fields

Sign up for a demonstration

Leave your contacts and we will schedule a short demo.

We use cookies

Cookies keep Mestra running, remember your preferences and help us understand how the site is used. See our Privacy Policy, Terms of Service and Consent Form.