Skip to content
honestcrm

Google Sheets CRM

A Google Sheets CRM template, and when to outgrow it

A Google Sheet works as a CRM when one or two people keep a short list of contacts. Download the free template below and add your contacts. When the sheet starts to lose follow-ups, import the same file into honestcrm, which has a free plan with unlimited users.

Sales pipeline board in honestcrm for teams outgrowing a Google Sheets CRM

What is in the template

Fourteen columns and two example rows. In Google Sheets choose File, Import, Upload, and pick the CSV. The first 11 columns match fields in the honestcrm import, so nothing needs renaming later.

First name, Last name
One person per row. Never put two people in one cell.
Email, Phone
The email address is how the CRM later finds duplicates, so keep one address per cell.
Job title, Company, Company website
Type the company the same way every time. The website lets the CRM link people to one company.
Owner
The teammate who owns the relationship. Use their work email.
Lead source
Referral, website form, event, cold outreach. Pick from a list, not free text.
Tags
Short labels split by commas, such as customer or partner.
Notes
What was said, in one or two lines.
Status
New, Contacted, Proposal sent, Won, Lost. Use a dropdown.
Last contacted, Next follow-up
Real dates, not words. The follow-up date is the one column that keeps a sheet CRM alive.

Five settings that keep a sheet usable

  1. Freeze row 1, so the headers stay in view.
  2. Add a dropdown to Status, with Data, then Data validation.
  3. Highlight overdue follow-ups. Apply to the range, choose Format, Conditional formatting, a custom formula, and enter =AND($N2<>"",$N2<TODAY()).
  4. Count them anywhere with =COUNTIF(N2:N,"<"&TODAY()).
  5. Use Data, then Filter views, so each person sorts without rearranging the sheet for everyone else.

Where a Google Sheets CRM stops

Sheets handles lists well and follow-up poorly. Five things go wrong, in the order most teams meet them.

Sorting

Someone sorts one column and not the rest, and phone numbers sit beside the wrong names. Version history can undo it, if anyone notices.

Reminders

A sheet shows a date and does nothing about it. An Apps Script can email you, but it runs as the person who authorized it. If they leave or the permissions change, the reminders stop without a warning.

Email history

Nothing records the emails you send or receive. People paste them in for a week, then stop.

Duplicates

The same person is added in two rows with two statuses. Nothing flags it.

Access

Anyone who can edit can see and change every row. There are no roles for who sees which contacts.

Import the same sheet

Upload the sheet to honestcrm and check the column mapping. Each row becomes a contact or a deal with its owner, stage, and due date.

Move your sheet into a CRM in five steps

You keep the sheet. The import copies it, so you can run both for a while. After it, the team works on a board of deals with tasks, reminders, and logged email. Everyone gets a login, with no per-user charge. Connect a mailbox and email with your contacts is logged on their timeline. See how email logging works.

  1. Pick the sheet

    Keep contacts on one tab with the header in row 1. If you have a second tab for deals, it becomes a second import.

  2. Import it directly or as a CSV

    honestcrm imports from Google Sheets, CSV, and Excel. To use a file instead, choose File, Download, Comma-separated values in Sheets.

  3. Map the columns

    Open Import after you start free. Suggest mapping proposes a target for each column, and you can change any of them. It sees only column names and three sample rows with the values masked.

  4. Send leftovers somewhere useful

    Status and Next follow-up have no built-in contact field. Map them to custom fields you create first, add them as notes, or skip them.

  5. Pick the duplicate rule and review

    Contacts match by email address and companies by website. Choose skip, update, or create anyway. The import shows counts of errors and duplicates before it saves. Imported people get the lead source Import unless your sheet has one.

Import a Google Sheets CRM into honestcrm with column mapping

What it costs

Free covers unlimited users, unlimited pipelines, import, and export. Pro is $39 a month or $299 a year for the company. See the pricing page for details. Also coming from Notion or Airtable? We have guides for those too.

Google Sheets CRM questions

Can Google Sheets be used as a CRM?

Yes, for a short list and one or two people. Keep one row per person, use dropdowns for status, and add a Next follow-up date column. It struggles when the team grows, when reminders matter, or when you want the email history in one place.

How do I make a CRM in Google Sheets?

Download our free CSV template, open a new sheet, and choose File, Import, Upload. Then freeze row 1, add a dropdown on Status, and add a conditional-format rule on Next follow-up. The steps are above.

Where can I get a free CRM template for Google Sheets?

Here. The template has 14 columns and two example rows. Delete the examples and start typing, or paste in your own contacts. Because the columns match the honestcrm import, the same file moves into a real CRM later.

Is a Google Sheets CRM free?

A Google account is free, so a sheet costs nothing to start. Its cost is the time to keep it tidy and the follow-ups it misses. honestcrm's Free plan is also $0, with unlimited users.

Can I import a Google Sheet into honestcrm?

Yes. Import accepts Google Sheets, CSV, and Excel files. It suggests how your columns map, flags duplicates, and shows the counts before it saves anything.

Does honestcrm log my email?

Yes. Connect your Gmail, Google Workspace, or Microsoft 365 (Outlook) mailbox to log emails to and from your contacts and send from the CRM. You can also BCC or forward messages to your logging address. Logging starts when you connect.

My sheet tracks deals as well. Can I import those?

Yes, as a second file. A deals import maps the deal title, value, expected close date, pipeline, stage, status, company, and contact. See the sales tracker page for a deal-level template.

Import your sheet and keep your columns

Upload your sheet and check the column mapping. Free for every user. No card required.

Start for free