How to segment a lead list by territory

Step-by-step formulas for Excel and Google Sheets to split a list by city, county or ZIP, with a real county list cut into four territories.

Updated November 20, 2026 · 8 min read · Data from LeadLists' own lists

The short answer

Group whole cities into territories of similar size, using ZIP codes for big cities and county for regional splits. Our Palm Beach County file of 1,590 real estate agencies splits into four territories of 305 to 483 rows each. Count rows per city with COUNTIF or a pivot table, assign each city with XLOOKUP, then filter each territory into its own tab.

A territory split answers one question: which rep, mailing or route owns this row? Get it wrong and two reps call the same office in the same week, or a field rep drives past forty prospects to reach four. Every row in our files carries a full address, city, state, ZIP and coordinates, so the split is a spreadsheet job, not a data-buying job. This guide works through one real file, the Palm Beach County real estate list, and then shows the county-level version on a statewide list.

1,590real estate agencies and agents in the Palm Beach County file
28cities
50ZIP codes
45.5%of rows are in the top 3 cities
LeadLists data: Palm Beach County real estate list, November 2026

Pick the unit: city, ZIP, county or radius

Fill rates across 285,744 rows in 323 lists, LeadLists data, November 2026.
UnitBest forFill in our filesWatch out for
CityInside sales territories, local campaigns, "we work with agencies in Jupiter" emails100%Postal city names: one big city can hold several ZIPs and neighbourhoods
ZIP codeDirect mail, field routes, splitting one big city100%ZIPs are mail routes, not areas; keep the column as text so leading zeros survive
CountyRegional reps, statewide lists, matching to your CRM's regions35.6% as a column; derive the rest from ZIP or coordinatesSome ZIPs cross a county line
Radius from a pointField sales from an office, event invites100% (latitude, longitude)Needs a distance formula; rivers and highways don't show up in miles

For most teams the answer is cities, grouped. A city is what a rep and a prospect both understand, and it's on every row. Use ZIPs only to break up a city too big for one person, and county when the list covers a whole state.

Worked example: four territories in Palm Beach County

The county has 28 cities in the file, but they're far from equal. Boca Raton alone has 305 agencies and West Palm Beach 250, while Hypoluxo and Atlantis have one each. The top five cities hold 64.0% of the rows. That shape is typical of a metro list and it's why you group cities instead of giving each rep "some cities".

Top cities in the Palm Beach County file: listings and listings with an email

ListingsWith an email

Boca Raton
305219
West Palm Beach
250157
Delray Beach
168120
Boynton Beach
15985
Jupiter
135100
Palm Beach Gardens
11983
Wellington
11467
Palm Beach
6948
LeadLists data: Palm Beach County real estate list, November 2026
Top cities table and dot map of real estate agencies in Palm Beach County, FL, concentrated along the coast
The city table and map on the Palm Beach County list page. Almost every agency sits in the coastal strip, which is what makes a north-to-south split work.LeadLists list page, November 2026

The map shows the geography: nearly everything is on the coast, about 40 miles from Tequesta down to Boca Raton. So we sorted the 28 cities by latitude and cut them into four contiguous groups, keeping every city whole. Boca Raton is big enough to be a territory on its own. The result is four territories of 305 to 483 rows.

Four city territories, rows per territory

North countyTequesta, Jupiter, Palm Beach Gardens, North Palm Beach, Riviera Beach355
West Palm and western communitiesWest Palm Beach, Palm Beach, Wellington, Royal Palm Beach483
Lake Worth to DelrayLake Worth Beach, Greenacres, Lantana, Boynton Beach, Delray Beach447
Boca RatonBoca Raton305
LeadLists data: Palm Beach County real estate list, November 2026

Balance by the channel you'll use, not only by row count. If the team works by email, compare rows with an email: North county has 258 (72.7% of its rows) and Boca Raton 219 (71.8%), against 271 in Lake Worth to Delray (60.6%). Those three are close. If they call, nearly every row has a phone (between 98% and 99% in each territory), so row count is the right measure.

The spreadsheet steps

  1. 01

    Count rows per city

    A pivot table with city as rows and a count of business, or the COUNTIF formula below. Sort it largest first.

  2. 02

    Draw the territories on paper first

    Use the list page map or the latitude column to put cities in geographic order, then group neighbours until each group is near your target size.

  3. 03

    Build a lookup tab

    Two columns: City and Territory. One row per city, including the one-listing towns.

  4. 04

    Assign every row

    Add a Territory column with XLOOKUP or VLOOKUP. Anything returning "Unassigned" is a city you forgot.

  5. 05

    Split into tabs or files

    FILTER each territory into its own tab, or filter and export one CSV per rep for import.

  6. 06

    Check the totals

    The territories should add up to the file's row count. Ours: 355 + 483 + 447 + 305 = 1,590.

Count rows per city (city in column P; check your header row)
  Excel / Sheets:  =COUNTIF(P:P, "Boca Raton")
  Sheets, all cities at once:
    =QUERY(A:AP, "select P, count(A) where A is not null group by P order by count(A) desc", 1)
Column letters are from the Palm Beach file: city is P, ZIP is S. Check your own header row.
Assign a territory (lookup tab named Territories: City in A, Territory in B)
  Excel 365:  =XLOOKUP(P2, Territories!A:A, Territories!B:B, "Unassigned")
  Sheets:     =IFERROR(VLOOKUP(P2, Territories!A:B, 2, FALSE), "Unassigned")
Fill down the new Territory column.
Pull one territory into its own tab (Territory in the first empty column, AQ)
  Excel 365 / Sheets:  =FILTER(A2:AQ1591, AQ2:AQ1591 = "North county")
One tab per rep. Re-run after each new list arrives.

Splitting by ZIP for mail and field routes

Use ZIPs when one city is too much for one person, or when you mail. The Palm Beach file has 50 ZIPs and 41 of them have at least 10 agencies, so ZIP-level routes are practical. The busiest ZIPs are not all in the biggest city: Wellington's 33414 tops the list.

Top ZIPs in the Palm Beach County real estate file. LeadLists data, November 2026.
ZIPMain cityListingsWith email
33414Wellington8662.8%
33432Boca Raton8280.5%
33483Delray Beach7174.6%
33480Palm Beach6869.1%
33411West Palm Beach6858.8%
33401West Palm Beach6678.8%
33418Palm Beach Gardens6368.3%
33426Boynton Beach5961.0%
Keep ZIPs as text (leading zeros matter in New England and New Jersey)
  Excel:   =TEXT(S2, "00000")
  Sheets:  Format > Number > Plain text, before pasting

Group by 3-digit ZIP prefix (one regional mail sorting area)
  Excel / Sheets:  =LEFT(TEXT(S2, "00000"), 3)

Distance in miles from your office (latitude in AN, longitude in AO;
office latitude in $AS$1, longitude in $AT$1)
  =3959 * ACOS(COS(RADIANS($AS$1)) * COS(RADIANS(AN2)) * COS(RADIANS(AO2) - RADIANS($AT$1))
          + SIN(RADIANS($AS$1)) * SIN(RADIANS(AN2)))
Sort by the distance column to build a radius list for field visits. AN and AO are where latitude and longitude sit in the full Palm Beach file; check your own header row and swap the letters if yours differ.

County territories on a statewide list

On a state list, counties are the natural unit for regional reps. Our New York advertising agencies list has 907 agencies in 30 counties, and New York County (Manhattan) alone holds 401 of them, 44%. A sensible split is Manhattan; Brooklyn, Queens and the rest of the city; the Hudson Valley and Long Island; and upstate (Monroe, Erie, Onondaga, Albany).

Top cities and top counties tables for advertising agencies in New York State, led by New York County with 401 listings
City and county tables on the New York advertising agencies list page: 30 counties with at least one listing.LeadLists list page, November 2026

Where the county column is blank (it is filled on 35.6% of rows across all our files), derive it from ZIP with the HUD-USPS ZIP crosswalk, a free file that maps each ZIP to the county or counties it covers. Use the county with the largest share of addresses when a ZIP crosses a line. Then run the same lookup-and-filter steps above, with county in place of city.

Keep territories fair after the split

The first split is the easy part. Territories go wrong over the following months, when new rows arrive, a rep leaves, or one area turns out to answer far more often than another. A few rules prevent most of the arguments.

  • Assign by city, never by row. When a new list arrives, every row in Jupiter goes to whoever owns Jupiter. The lookup tab does this for you; a new city that returns "Unassigned" is a decision for the manager, not the first rep to spot it.
  • Balance on reachable rows. Compare territories on rows with the channel you use. In Palm Beach County, Lake Worth to Delray has 447 rows but its email rate (60.6%) is twelve points below North county's (72.7%), so an email team would want more of it.
  • Keep chains in one place. Brokerages and franchises often have offices in several cities. Decide whether the head office's owner works every branch or each rep works their own, and write it down.
  • Review quarterly, not weekly. Move a city only when the numbers say so, and move whole cities. Re-cutting every month resets every rep's pipeline.
  • Use the same territory names everywhere. The value in your Territory column should match the owner or team field in the CRM exactly, so imports route themselves.
  • Mailings follow ZIP, calls follow city. Postal sorting and print vendors work by ZIP; people say they're "in Wellington". Keep both columns, and pick the one that fits the job.

Inside sales territories

  • Grouped cities of similar size
  • Balanced on rows with an email or a phone
  • Time zone matters more than distance
  • Re-cut quarterly at most

Field sales and mail

  • ZIPs or a radius from the office
  • Balanced on drive time and stops per day
  • Coordinates and full address on every row
  • Routes rebuilt as new rows arrive

Once territories are set, import each rep's rows with their owner field filled (see import a lead list into your CRM), and give callers the hours column so they dial each area when it's open (cold calling small businesses). If you're still choosing where to sell, business email rates by state shows which states publish the most emails, and buy vs build a lead list compares the cost of making the file yourself.

How to segment a lead list by territory: questions

How do I split a lead list into sales territories?

Count rows per city, group neighbouring cities into territories of similar size, put the City to Territory pairs in a lookup tab, add a Territory column with XLOOKUP or VLOOKUP, then FILTER each territory into its own tab. Our Palm Beach County file of 1,590 agencies splits into four territories of 305 to 483 rows.

Should territories be based on ZIP codes or cities?

Cities for most sales teams, because reps and prospects both understand them and they're on every row. Use ZIPs to split a city too big for one person, and for direct mail and field routes.

How do I add a county to a list that only has ZIP codes?

Use the HUD-USPS ZIP crosswalk, a free file that maps each ZIP to its county. Where a ZIP crosses a county line, take the county with the largest share of addresses. Our files also have latitude and longitude on every row if you prefer to map points to county boundaries.

How do I keep leading zeros in ZIP codes in Excel?

Format the ZIP column as text before you paste or import, or rebuild it with =TEXT(S2, "00000"). Otherwise ZIPs like 02108 lose their first digit.

What size should a territory be?

Size it by the channel. For calling, count rows with a phone; for email, rows with an email. In the Palm Beach example the territories range from 219 to 297 rows with an email, close enough for a fair split.

Keep reading

Sources