Free Google Sheets template

The free CRM template for teams that aren't ready for a CRM (yet)

Track leads, manage your pipeline, and close deals — all in Google Sheets. When your team grows past what a spreadsheet can handle, Close is waiting.

Download Free TemplateNo software required — free, forever
Free CRM TemplateGoogle Sheets · auto-savedView only
A2Acme Robotics
B2=SUMIF(Leads!D:D,"<>Won",Leads!E:E)
A
B
C
D
E
F
1
Company
Contact
Email
Stage
Value
Assignee
2
Acme Robotics
Dana Lin
dana@acme.io
Negotiation
$24,000
Maya R.
3
Northwind Co.
Sam Patel
sam@northwind.com
Qualified
$8,500
Jordan T.
4
Bluebird Labs
Riya Shah
riya@bluebird.co
Proposal
$15,200
Maya R.
5
Halcyon Health
Marcus Reed
marcus@halcyon.health
Won
$42,000
Jordan T.
6
Pine & Oak
Lena Brooks
lena@pineoak.com
New
$3,200
Avi K.
7
Cobalt Studios
Theo Nguyen
theo@cobalt.studio
Negotiation
$18,750
Avi K.
8
Marigold Foods
Priya Anand
priya@marigold.co
Qualified
$6,400
Maya R.
9
Tidewater Group
Owen Carter
owen@tidewater.com
Lost
$9,000
Jordan T.
10
Summit Freight
Grace Holt
grace@summitfr.com
Proposal
$27,500
Avi K.
11
Vellum Press
Ian McLeod
ian@vellum.press
Won
$11,800
Maya R.
Potential revenue$103,5507 open opportunities
Won$53,8002 deals closed
Open7in pipeline
Lost1this quarter
Pipeline value by stage
New$3,200
Qualified$14,900
Proposal$42,700
Negotiation$42,750
Won$53,800
Lost$9,000
Deals by status
Open7
Won2
Lost1
Win rate67%

Already feeling the limits of a spreadsheet?

If updates are getting lost and follow-ups are slipping, you're ready for a real CRM. Close takes minutes to get up and running.

Try Close free
What's inside

Everything a small team needs to stay on top of a pipeline

This free Google Sheets template gives you a working CRM — without buying software.

Lead & opportunity tracking

Log every deal with company info, contact details, stage, value, and assignee.

Pipeline dashboard

A live visual summary of open, closed, and won opportunities — plus total potential revenue.

Customizable stages

Edit the status and stage options to match your actual sales process.

Assign to reps

Split the pipeline across your team and see who owns what at a glance.

No setup, no integrations, no cost. Make a copy in Google Sheets and start adding leads today.
Who this is for

A spreadsheet CRM makes sense when…

You're an early-stage founder working your first 20–50 deals
You're standing up a sales process for the first time and want to keep things simple
You're validating a new market or offer before investing in software
You just need something right now and don't have time for a full CRM evaluation

If any of those sound like you, this template is the right starting point.

Spreadsheet vs. Close

Great until you outgrow it

A spreadsheet gets you started. Here's what changes when a real pipeline outgrows a tab.

Spreadsheet
Close
Automated follow-ups
Not built in
Built-in reminders & sequences
Pipeline visibility
After someone re-sorts a tab
Real-time, always current
Calling, SMS & email
Separate tools, copy-paste
All in one place
Onboarding a new rep
Teach them your folder structure
Up and running in a day
Reporting
Build the formulas yourself
Automatic dashboards

Free CRM template for Google Sheets

A simple lead list and pipeline dashboard. Copy it, customize it, start closing.

Download Free Template

When you outgrow it, try Close free.

Close fills the gaps a spreadsheet can't

Automated follow-ups, real-time pipeline, built-in calling and email — without the enterprise setup. Most teams are running in a day.

×

Get the free template

Tell us where to send it and we'll open your copy in Google Sheets.

Name
Work email

Please enter your name and a valid work email.

No spam. Unsubscribe anytime.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

You're all set

Your copy is ready. Open it in Google Sheets and start adding leads.

Open the template

When you outgrow it, try Close free.