---
title: "Segment a Lead List by Territory: City, County and ZIP"
description: "Split a lead list into sales territories by city, county or ZIP. Worked example: 1,590 Palm Beach County agencies cut into 4 balanced territories."
url: https://leadlists.app/guides/segment-a-lead-list-by-territory
---

# 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

On this page

1. [Pick the unit: city, ZIP, county or radius](#pick-the-unit-city-zip-county-or-radius)
2. [Worked example: four territories in Palm Beach County](#worked-example-four-territories-in-palm-beach-county)
3. [The spreadsheet steps](#the-spreadsheet-steps)
4. [Splitting by ZIP for mail and field routes](#splitting-by-zip-for-mail-and-field-routes)
5. [County territories on a statewide list](#county-territories-on-a-statewide-list)
6. [Keep territories fair after the split](#keep-territories-fair-after-the-split)
[Lists from $29 ](https://leadlists.app/lists/ready-made)

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](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl), and then shows the county-level version on a statewide list.

**1,590**real estate agencies and agents in the Palm Beach County file

**28**cities

**50**ZIP codes

**45.5%**of rows are in the top 3 cities

LeadLists data: [Palm Beach County real estate list](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl), November 2026

## Pick the unit: city, ZIP, county or radius

__Fill rates across 285,744 rows in 323 lists, LeadLists data, November 2026.__
| Unit                | Best for                                                                             | Fill in our files                                          | Watch out for                                                                     |
| ------------------- | ------------------------------------------------------------------------------------ | ---------------------------------------------------------- | --------------------------------------------------------------------------------- |
| City                | Inside sales territories, local campaigns, "we work with agencies in Jupiter" emails | 100%                                                       | Postal city names: one big city can hold several ZIPs and neighbourhoods          |
| ZIP code            | Direct mail, field routes, splitting one big city                                    | 100%                                                       | ZIPs are mail routes, not areas; keep the column as text so leading zeros survive |
| County              | Regional reps, statewide lists, matching to your CRM's regions                       | 35.6% as a column; derive the rest from ZIP or coordinates | Some ZIPs cross a county line                                                     |
| Radius from a point | Field sales from an office, event invites                                            | 100% (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

_**305**_ _**219**_

West Palm Beach

_**250**_ _**157**_

Delray Beach

_**168**_ _**120**_

Boynton Beach

_**159**_ _**85**_

Jupiter

_**135**_ _**100**_

Palm Beach Gardens

_**119**_ _**83**_

Wellington

_**114**_ _**67**_

Palm Beach

_**69**_ _**48**_

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](/guides/shots/segment-a-lead-list-by-territory-1.jpg)

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](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl), 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 Beach**355**

West Palm and western communitiesWest Palm Beach, Palm Beach, Wellington, Royal Palm Beach**483**

Lake Worth to DelrayLake Worth Beach, Greenacres, Lantana, Boynton Beach, Delray Beach**447**

Boca RatonBoca Raton**305**

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.__
| ZIP   | Main city          | Listings | With email |
| ----- | ------------------ | -------- | ---------- |
| 33414 | Wellington         | 86       | 62.8%      |
| 33432 | Boca Raton         | 82       | 80.5%      |
| 33483 | Delray Beach       | 71       | 74.6%      |
| 33480 | Palm Beach         | 68       | 69.1%      |
| 33411 | West Palm Beach    | 68       | 58.8%      |
| 33401 | West Palm Beach    | 66       | 78.8%      |
| 33418 | Palm Beach Gardens | 63       | 68.3%      |
| 33426 | Boynton Beach      | 59       | 61.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](https://leadlists.app/lists/advertising-agencies-new-york) 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](/guides/shots/segment-a-lead-list-by-territory-2.jpg)

City and county tables on the New York advertising agencies list page: 30 counties with at least one listing.[LeadLists list page](https://leadlists.app/lists/advertising-agencies-new-york), 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

Need territories built in?

A [Bespoke plan](https://leadlists.app/pricing) builds lists to a brief like "real estate agencies in North Palm Beach County with an email on their own domain" and pushes each new batch to HubSpot, Instantly or Smartlead. Starter is $99 a month for 2,000 verified leads; Pro is $199 for 5,000.

Once territories are set, import each rep's rows with their owner field filled (see [import a lead list into your CRM](https://leadlists.app/guides/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](https://leadlists.app/guides/cold-calling-small-businesses)). If you're still choosing where to sell, [business email rates by state](https://leadlists.app/guides/business-email-rates-by-state) shows which states publish the most emails, and [buy vs build a lead list](https://leadlists.app/guides/buy-vs-build-a-lead-list) compares the cost of making the file yourself.

Lists with city, ZIP and coordinates on every row

Every ready-made list has full address, city, state, ZIP, latitude and longitude for each business, with a map and city table on the page. $29 once, 12 free rows first.

[Real estate agents and brokerages in Palm Beach County, FL · $29](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl)[Advertising agencies in New York · $29](https://leadlists.app/lists/advertising-agencies-new-york)[Real Estate Agent Email List](https://leadlists.app/lists/real-estate-agents-email-list)

[Browse lists ](https://leadlists.app/lists/ready-made)

## 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

[How to import a lead list into your CRM](https://leadlists.app/guides/import-a-lead-list-into-your-crm)[How to cold call small businesses](https://leadlists.app/guides/cold-calling-small-businesses)[Business email rates by state](https://leadlists.app/guides/business-email-rates-by-state)[How to sell to real estate agents](https://leadlists.app/guides/how-to-sell-to-real-estate-agents)[Buy vs build a lead list: the real cost of 1,000 rows](https://leadlists.app/guides/buy-vs-build-a-lead-list)[LeadLists vs Outscraper](https://leadlists.app/vs/outscraper)[LeadLists vs ZoomInfo](https://leadlists.app/vs/zoominfo)[Real estate agents and brokerages in Palm Beach County, FL · $29](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl)[Advertising agencies in New York · $29](https://leadlists.app/lists/advertising-agencies-new-york)[Real Estate Agent Email List](https://leadlists.app/lists/real-estate-agents-email-list)[All guides](https://leadlists.app/guides)[Insights](https://leadlists.app/insights)[Ready-made lists](https://leadlists.app/lists/ready-made)

## Sources

- [LeadLists data: 285,744 businesses in 323 lists (Nov 2026)](https://leadlists.app/insights)
- [LeadLists: Palm Beach County real estate list](https://leadlists.app/lists/real-estate-agents-palm-beach-county-fl)
- [LeadLists: New York advertising agencies list](https://leadlists.app/lists/advertising-agencies-new-york)
- [HUD USPS ZIP Code Crosswalk Files](https://www.huduser.gov/portal/datasets/usps%5Fcrosswalk.html)
