How to Split a Real Estate Farm Between Agents Fairly

To split a real estate farm between agents fairly, list the addresses in Google Sheets, geocode them, and apply the =TERRITORY(B2:B201, 5) formula. This divides your list into five balanced geographic zones. You can then use =INSTAMAP() to generate a shareable map that automatically colour-codes each agent's area.

This guide is for team leaders and brokerages managing multiple agents. By the end, you will have a reproducible system that eliminates territory disputes, ensuring every agent gets an equal portion of the farm without spending hours drawing lines on a whiteboard. You can use this exact process for door-knocking routes, just-listed just-sold routes, and geographic targeting.

What you need to split a farm

You need a Google Sheet containing your farm addresses and the free InstaMaps add-on. Install InstaMaps from the Google Workspace Marketplace to access custom location formulas. Spreadsheets are already the backbone of real estate tracking, so keeping this process inside Google Sheets helps you avoid learning a new interface.

You can insert formulas without typing by using the sidebar under Extensions > InstaMaps > Formulas. The add-on provides 100 free lookups per day, which increases to 1,000 per day with a free email unlock. If you do not want to start from scratch, you can download templates directly from get-instamaps.com/templates. These templates are pre-formatted to handle real estate data out of the box.

Step 1: Geocode your farm addresses

Before dividing territories, assign latitude and longitude coordinates to your properties. A simple street address is not enough for geographic splitting, because the system needs to know precisely where the house sits on the earth. Geocoding translates human-readable text into machine-readable coordinates. Without this step, mapping software relies on rough postal code estimates, which can place homes at the wrong end of the street.

If your addresses are in column A, use the =GEOCODE() formula to return coordinates. Select the adjacent column and apply the formula to your entire dataset. This process pulls the exact spatial data for each home, which is necessary for the territory algorithm to calculate distances accurately.

1. Cell example: =GEOCODE(A2:A201)

2. What appears in the sheet: Accurate latitude and longitude pairs for all 200 properties in your farm, appearing as decimal numbers.

Step 2: Assign territories with TERRITORY

Now that your data has coordinates, divide the farm among your agents. The =TERRITORY() function groups locations into a specified number of balanced, continuous geographic areas based on driving distances and physical boundaries. You do not need to manually draw polygons, purchase expensive mapping software, or guess where one agent's area ends and another's begins.

The algorithm evaluates the coordinates and creates tightly clustered zones that minimise driving time between properties. It deliberately accounts for natural barriers like rivers and major motorways where possible, ensuring an agent does not receive a territory that requires driving ten minutes out of their way to reach the next house. Whether you are splitting between two agents or five, the math remains the same.

1. Cell example: =TERRITORY(B2:B201, 5) (where column B holds the coordinates).

2. What appears in the sheet: A number from 1 to 5 assigned to each row, designating which of the five agents owns that specific property.

Step 3: Visualise the split with INSTAMAP

Arguments over territory boundaries end when agents can see their assigned properties on a live map. Instead of sending a spreadsheet and asking agents to plot their own addresses, use the =INSTAMAP() formula. This formula reads your assigned territory numbers and generates a live, hosted URL.

It automatically colour-codes the map points based on the territory number, updating instantly whenever you add or remove properties from the sheet. Because the map is hosted live, agents can bookmark the URL on their phones. When they are out in the field, they simply check the link to see their daily route. If a house falls through and you reassign it, the map reflects the change immediately without any manual updates.

1. Cell example: =INSTAMAP(A2:A201, C2:C201) (where column C holds the territory numbers).

2. What appears in the sheet: A clickable URL to a shareable map displaying colour-coded pins for each agent's territory.

Worked example: Dividing a 200-home farm

Imagine a team leader managing five agents and a 200-home farm. The goal is to ensure no agent is assigned houses scattered across town, minimising driving time and maximising door-knocking efficiency. By running the formulas in order, the spreadsheet does the heavy lifting. When splitting between five agents, the algorithm tries to create pie slices or grid sections depending on the shape of the neighbourhood. This prevents one agent from receiving all the homes on a cul-de-sac while another gets the busy main road, ensuring lead quality remains consistent.

For a smaller team, a 2-agent example works the exact same way. You simply change the number in the territory formula to two: =TERRITORY(B2:B201, 2). The system cleanly cuts the farm in half along the most efficient geographic line. Agent A takes the streets north of the main road, and Agent B takes the south, ensuring no overlap.

1. Paste 200 addresses into column A.

2. Run =GEOCODE(A2:A201) in column B to get coordinates.

3. Run =TERRITORY(B2:B201, 5) in column C to assign zones 1 through 5.

4. Run =INSTAMAP(A2:A201, C2:C201) in cell E1.

5. Result: Five tight, contiguous geographic clusters. Each agent receives a single map link showing only their colour.

Limits and honest alternatives

InstaMaps processes up to 1,000 lookups per day with a free email unlock. If your farm exceeds 1,000 addresses and you need the data immediately, you can process the sheet over two days by splitting your list into two batches. For standard real estate teams, this limit is rarely an issue. You can also use the =ROUTE_LINK() formula, which uses Google Maps' official URL scheme (max 11 stops), to create driving directions for each specific agent territory.

While paid territory mapping software like Regrid or Esri exists for large-scale municipal zoning, they are expensive and overly complex for splitting a single neighbourhood farm. They require extensive training and annual contracts that make little sense for a team that just needs to divide 200 doors fairly. If your primary goal is complex demographic filtering rather than just geographic splitting, a dedicated CRM with built-in mapping capabilities might be better suited for your needs. However, for the specific task of cutting up a neighbourhood fairly and keeping everyone accountable, a spreadsheet and a shareable map link are entirely sufficient. If you want to expand your efforts beyond a specific neighbourhood, read our guide on /for/sales-territory-mapping. You can also use these exact formulas to set up targeted campaigns by reviewing our strategies for /for/circle-prospecting.

Common Questions