Free Sales Territory Template for Google Sheets

To create a balanced sales territory template, list your accounts in Google Sheets, install the free InstaMaps add-on, and use the =TERRITORY() formula to split postcodes into equal patches. You can then visualise these patches using =INSTAMAP() without leaving your spreadsheet.

This walkthrough is for sales operations managers and account executives who need to assign neighbourhoods fairly without buying complex GIS software. By the end of this guide, you will have a functional sales territory template that automatically divides your accounts based on count or revenue, alongside a live map link you can share with your team.

What you need to build your template

Start with a blank Google Sheet or grab the official territory splitter starter file from get-instamaps.com/templates. You need two core columns of data: the account addresses and a specific metric like Annual Recurring Revenue (ARR).

Next, install the InstaMaps add-on from the Google Workspace Marketplace. The core add-on is completely free. The standard free tier includes 100 location lookups per day. If you need to process a larger list of accounts all at once, you can complete a free email unlock inside the add-on to raise this limit to 1,000 lookups per day.

Instead of memorising syntax, you can use the InstaMaps sidebar (Extensions > InstaMaps > Formulas) to insert formulas directly into your cells. This prevents typos when building your sales territory template.

1. A Google Sheet with account addresses

2. The free InstaMaps add-on

3. A metric column (like ARR or account count) for balancing

Step 1: Geocode your account addresses

Before you can divide a map, you need coordinates. Addresses are text, but mapping requires latitude and longitude to calculate distances accurately.

In column A, paste your account addresses (for example, A2:A150). In column B, enter the following formula:

=GEOCODE(A2:A150)

When you press enter, InstaMaps reads the text addresses and returns precise coordinates. If cell A2 contains '1600 Amphitheatre Parkway, Mountain View, CA', the output in B2 will be the exact latitude and longitude. You now have the spatial data required to draw boundaries.

Step 2: Split accounts into balanced territories

Now you need to group these accounts. The goal of a good sales territory template is to balance workload so no single rep is overwhelmed. You can balance this by pure volume (an equal number of accounts per rep) or by value (an equal sum of ARR per rep).

Assuming your coordinates are in column B, and you have 5 sales reps, select column C and enter the formula:

=TERRITORY(B2:B150, 5)

The add-on analyses the physical distances between the coordinates and creates 5 compact, contiguous zones. It outputs a simple number from 1 to 5 in column C for each row. If you want to balance by revenue instead of pure count, you can point the territory formula to weight the output using your ARR column. This ensures Rep 1 does not get stuck with 30 low-value accounts while Rep 5 gets 10 high-value accounts.

Step 3: Generate a live map of your territories

Numbers on a spreadsheet are difficult to interpret during a sales meeting. A visual map helps reps understand exactly where their patch begins and ends.

To generate a map, pick an empty cell and use the map formula:

=INSTAMAP(B2:B150, C2:C150)

In this example, B2:B150 provides the coordinates, and C2:C150 provides the territory numbers (1 through 5). InstaMaps will generate a live, hosted URL. When you click this link, it opens a browser map plotting all your accounts. The map automatically colour-codes the points based on the territory number they belong to. Because the map is live, it updates automatically when you add new accounts to your sheet or change a territory assignment.

Worked example: A 200-account farm with 5 reps

Consider a regional sales manager named Sarah who oversees a 200-home farming community. She has 5 field reps and 47 active product demonstrations scheduled for this quarter. She needs to assign these 47 opportunities fairly so her reps are not overlapping or wasting fuel.

Sarah sets up her sales territory template with three columns: Address, ARR Potential, and Coordinates. Because she only wants to split the 47 active opportunities, she filters her sheet to ignore the dormant leads. She runs =GEOCODE() on the 47 addresses to get their map points.

Instead of splitting strictly by the number of stops, Sarah wants to balance the potential commission. She applies the =TERRITORY() formula to her 47 coordinate rows, using her ARR column as a weight. The add-on assigns each opportunity to Reps 1 through 5. In this case, Rep 3 might receive 9 stops while Rep 5 receives 11 stops, but the total ARR value for both patches sits at roughly £14,000.

Finally, Sarah runs =INSTAMAP(). She sends the resulting URL to her team. On Friday mornings, reps use the InstaMaps sidebar to quickly generate a =ROUTE_LINK() for their specific territory (up to 11 stops per link using Google Maps' official URL scheme) to plan their daily drive routes.

Limits and honest alternatives

InstaMaps operates on a freemium model. The free tier handles 100 lookups per day, which increases to 1,000 lookups per day if you verify your email. If you have a database of 5,000 cold leads, you will need to process them in batches over several days. This template is designed for active account management, not bulk cold-calling list processing.

Furthermore, InstaMaps calculates straight-line groupings for territories. It groups accounts geographically, but it does not factor in natural barriers like rivers or specific motorway access routes.

If you need highly complex routing constraints-such as avoiding left turns, calculating exact drive-time boundaries, or integrating with live traffic data-you should use a dedicated, paid GIS tool like Esri ArcGIS. Those tools cost thousands of dollars annually. For a standard sales team that just needs a fair, balanced visual split of accounts, the Google Sheets method is faster, free, and easier to maintain.

Common Questions