We all know that that making spreadsheets look nice can be tedious. On top of that, it’s difficult to come up with big-picture ideas to figure out how a spreadsheet should function, and what objectives it should abide by. Fortunately, we have templates. There are people who have done some of the grunt work for us and made awesome templates to help us get started, and use spreadsheets to manage data or day to day tasks.
Spreadsheets can be especially helpful in sales. Use spreadsheets to track leads, sales, marketing, and appointments. Above all, you can manage sales funnels from start to finish and create beautiful reports for internal and external use. Use a sales plan template exactly how it comes, or customize it to fit the way you work. Let’s get you started finding the best sales plan template in Google Sheets.
How to use Google Sheets templates:
There are a few different ways to access Google Sheets templates for sales.
1. Open Google Sheets.
2. Click “Template Gallery”
3. Click on any template and automatically open into a new Google Sheet, with instructions on how to use it. Like this:
There are currently only around 25 templates in the Google Sheets gallery, both for professional and personal use. In other words, not all of them are what you are looking for. Keep an eye out for new additions from time to time, but until then, check out some 3rd-party sales templates, or templates that come in the form of add-ons.
Keep in mind, that using the Sheetgo web app or add-on for Google Sheets, because it is possible to import data from an Excel file. The latest version of Sheetgo even preserves formatting. So, if you find the perfect template out there online that is an “Excel” template, you can simply save it as a .xlsx or .csv file, and change it into a Google Sheets file using Sheetgo.
Let’s take a look at the templates:
Sheetgo’s sales plan template
This Sales lead tracker template in Google Sheets consists of a sales lead tracking spreadsheet for each representative and automatically exports that information into the manager’s master spreadsheet, where all sales lead tracking is visualized in a personal dashboard. To start, take a look at the instructions in this blog post or install the template directly by clicking the button below.
CRM Report from Google
This customer relationship management template is free and easily available right from the template gallery. It’s really effective for small teams or solo-
Spreadsheet CRM is another sales and CRM dashboard template that was designed just for Google Sheets Users. Go to their website to sign up or get it here, and directly open the template. It has the share setting “View Only”. You need to click on File → Make a copy to make your own copy and get started. This template is designed for small businesses to use as
Cold Email Sales
This template from SalesHacker is for tracking lead generation and sales via cold email. It can also be modified for cold calling. This a great tool to manage sales performance with individual employees over a period of time. It’s a pretty simple template but it, on the other hand, helps you see the big picture of your cold email process. Tracking percentages and outcomes is a great way to help you manage the efficiency of your sales pipeline. Here is the template. Its share settings are set to View Only. You need to click on File → Make a copy to make your own copy and get started.
Another great template from Salesacker. This template helps you take a birdseye view of your yearly pipeline and analyze and adjust it by quarter. Moreover, set big goals and generate big revenue with the help of this great template. Its share settings are View Only. You need to click on File → Make a copy to make your own copy and get started.
Template Gallery Add-on
You don’t necessarily need to go scouring the web for templates. As an alternative, there is also a great add-on called Template Gallery with many templates available. Simply get and open the add-on, then browse through the templates. When you find one you like, click it, and save a copy to your drive. These templates are by Vertex42. If you go directly to their website, they only have templates for Excel users, but by using this handy add-on, you can access their templates directly in Sheets!