Sales Tracking Spreadsheets: Free Templates for Google Sheets

Last Modified: November 7, 2023 - 7 min read

Hannah Recker

Even with access to robust CRM systems such as Salesforce and HubSpot, many SalesOps users still prefer spreadsheets for forecasting, dashboarding, and analysis.

Spreadsheets are more flexible, and less cumbersome, than many of the built-in visualization and analytics capabilities of CRMs. However, it’s often difficult to build and maintain sales tracking spreadsheets with so many other competing priorities.

But no worries – we’ve created templates for all of your essential sales tracking spreadsheets in the following blog. Try our free Google Sheets templates for your Salesforce and HubSpot CRM data below.

Win Loss Analysis Template

Win loss analysis is critical to understanding why sales deals were won or lost. This helps sales teams adjust tactics and optimize the sales cycle.

SalesOps managers typically build win loss analysis reports in CRMs that can track these metrics across orgs, teams, and sales reps. But these CRMs often make win loss analysis reporting quite difficult. Salesforce, for instance, restrains users to basic inputs such as pick-lists or open-text fields.

Google Sheets offers more flexibility in terms of building dashboards, but it cannot access real-time CRM data natively. And then, regardless of what platform you use, you must build out the dashboards from scratch.

But slow down there — our Win Loss Analysis Template takes care of all of these dashboarding issues in a single click.

Our Win Loss Analysis Template contains all the metrics and visualizations needed to perform an incisive win/loss analysis, presented in pretty dashboards that capture the core KPIs your team needs:

opportunity won lost template

Dashboards within the template can be customized with a toggle menu at the top of the Sheet — this allows you to view the dashboard for individual sales reps or team. You can also toggle your visualizations based on Time Period, Time Units, Team/Manager, Sales Rep, and Opportunity Type.

quarterly win loss analysis

This allows your team to slice-and-dice the CRM data however they want. The filtered data is then fed into the pre-built win loss analysis dashboards:

salesforce win loss analysis template

Keep track of key metrics such as won/lost by revenue and volume, win rate, and wins by customer stage with high-level charts. View juxtaposed dashboards of opp amounts/counts won and lost.

won lost google sheets template

You can also view win rates by reps, teams, opp size, opp age, lead source, and more.

win rate by sales rep google sheets
win rate by lead source google sheets

Get a full list of lost opportunities, including opp owners, age, amount, and reason lost.

lost opps report google sheets

And these dashboards are always up-to-date and shareable — the template automatically updates your CRM data. Give it a try now: launch our free win loss template in Google Sheets for your Salesforce or HubSpot CRM.

Launch Win Loss Analysis Template for Salesforce

Launch Win Loss Analysis Template for HubSpot

Sales to Target Template

Setting and tracking sales targets is a key initiative for most sales teams. These goals allow teams to measure performance, adjust tactics, and project sales within a given month, quarter, or year.

However, dashboards that track sales targets often require SalesOps managers to corral data from multiple business systems. It’s a messy, time-consuming process to blend sales data in CRMs with sales targets in spreadsheets.

That’s why we created our Sales to Target Template. Our template offers pre-built sales to target dashboards, so SalesOps Managers can avoid building, maintaining, and updating complicated reports involving multiple data systems.

Our Sales to Target Template combines Salesforce or HubSpot data with sales targets, calculates revenue projections, and visualizes progress for teams and opportunity types, by month, quarter, or year. Track yearly or quarterly company revenue side-by-side with open pipeline and target achieved.

sales pipeline template google sheets

Harness the pre-built Gap Analysis visualization to find out how you can close missing revenue. View revenue and opportunities side-by-side, based on existing business and new business. Track your sub-targets and discover where your pipeline needs additional opportunities. You can also utilize these high-level dashboards to measure sales targets by team.

sales targets by team google sheets

Check out the closed-won opportunities vs. targets dashboards to analyze performance over time and see where the gap needs to be made up.

closed won template google sheets

Get a full overview of open pipe by stage to understand where the opportunities are that will allow you to meet sales targets.

sales pipeline dashboard

Our Sales to Target Template allows you to bypass all that tedious dashboard building and focus on analysis. With the template, your team will gain access to a comprehensive view of how sales targets are progressing, and where they can make up the gaps.

And you don’t have to worry about updating the sales data in Google Sheets — that’s done automatically by the template. Launch the Sales to Target Template now with your Salesforce or HubSpot CRM data.

Launch Sales to Target Template for Salesforce

Launch Sales to Target Template for HubSpot

Coefficient Excel Google Sheets Connectors
Try the Free Spreadsheet Extension Over 314,000 Pros Are Raving About

Stop exporting data manually. Sync data from your business systems into Google Sheets or Excel with Coefficient and set it on a refresh schedule.

Get Started

Sales Performance Template

Our Sales Performance Template allows sales leaders to compare year-over-year sales performance by industry, region, and account. Now you can slice-and-dice performance data by sales team, deal type, and more, using a pre-built Google Sheets dashboard that automatically syncs with your Salesforce and HubSpot CRM data.

Here’s a hands-on look at how the Sales Performance Template works.

At the top of the template, you can toggle between year, team, country, and opportunity. This will segment the dashboards in the template to show the specified data.

sales performance template google sheets

See visualizations for yearly historic revenue, and total sales by year, quarter, month, and week at the top of the dashboard. View a high-level overview of monthly sales by country with a geographic gradient map.

monthly sales by deal type dashboard

Manage your top 5 accounts and industries with fresh bar graphs powered by real-time CRM data.

google sheets dashboard CRM data

View the largest deals closed in a pre-designed report, including deal name, account name, amount, close date, and owner.

closed deals template google sheets

Our Sales Performance Template offers all the performance dashboards your team needs to measure yearly, monthly, weekly, and daily growth. Give it a try — it only takes one click to launch the template.

Launch Sales Performance Template for Salesforce

Launch Sales Performance Template for HubSpot

Opportunity History Changes Template

Opportunity History Field Tracking is a powerful Salesforce report that records the change history of opportunity fields. But it is difficult to maximize the potential of the report due to the rigid reporting functionality in Salesforce.

Combining Opportunity History metrics with the flexibility of Google Sheets opens up a new dimension of sales pipeline analysis. In Google Sheets, SalesOps Managers can track historical pipeline conditions and expand sales forecasting with augmented data about past trends in opportunities.

However, getting this Opportunity History data into Google Sheets, and creating dashboards to visualize it, is a challenge in its own right. That’s why we designed our pre-built Salesforce Opportunity History Template for Google Sheets.

Coefficient’s Opportunity History Template shows how new sales pipelines, lost opportunities, changing close dates, and up-sells impact your bottom-line revenue streams. The template unleashes the full potential of Salesforce’s Opportunity History Field Tracking:

  • Track your sales pipeline over any period of time
  • Identify opportunities with value changes or time frame modifications
  • Set custom fiscal year periods and monitor changes by month, quarter, or year
  • Slice and dice opportunity changes by sales team, opportunity type, or account details
  • Identify changes to close dates, opportunity amounts, and other fields that affect sales forecast

The Salesforce Opportunity History Template allows you to apply a more incisive analysis to your opportunities and historical sales pipeline trends. Launch the free template now to get started.

Launch Opportunity History Changes Template for Salesforce

Sales Revenue & Expenses

This free sales template (& sales + expenses template) by Spreadsheet Class will allow you to track your individual sales, and categorize your sales. You can easily view your totals in the template’s charts. Check out the variety of templates created at Spreadsheet Class.

Free Sales Tracking Spreadsheets: Focus on the Tasks that Matter

With our free sales tracking spreadsheets, you can bypass all the grunt work associated with building dashboards and focus instead on insights and analysis. Try these out these free, pre-built Google Sheets dashboards now, and also check out our other sales templates to speed up and optimize your workflows and sales cycles.

Sync Live Data into Your Spreadsheet

Connect Google Sheets or Excel to your business systems, import your data, and set it on a refresh schedule.

Try the Spreadsheet Automation Tool Over 350,000 Professionals are Raving About

Tired of spending endless hours manually pushing and pulling data into Google Sheets? Say goodbye to repetitive tasks and hello to efficiency with Coefficient, the leading spreadsheet automation tool trusted by over 350,000 professionals worldwide.

Sync data from your CRM, database, ads platforms, and more into Google Sheets in just a few clicks. Set it on a refresh schedule. And, use AI to write formulas and SQL, or build charts and pivots.

Hannah Recker Growth Marketer
Hannah Recker was a data-driven growth marketer before partying in the data became a thing. In her 12 years experience, she's become fascinated with the way data enablement amongst teams can truly make or break a business. This fascination drove her to taking a deep dive into the data industry over the past 4 years in her work at StreamSets and Coefficient.
350,000+ happy users
Wait, there's more!
Connect any system to Google Sheets in just seconds.
Get Started Free

Trusted By Over 20,000 Companies