Use Case

How to Build a Prospect List by City, ZIP Code or Territory

List the ZIP codes or towns in your territory, run one Bing Maps search per area and category, export to Excel or CSV, merge and dedupe on ID, then use the Latitude and Longitude columns to map the list and split it between reps.

Quick Answer: List the ZIP codes or towns in your territory, run one Bing Maps search per area and category, export to Excel or CSV, merge and dedupe on ID, then use the Latitude and Longitude columns to map the list and split it between reps.

Define the territory

Write down the ZIP codes, towns or neighborhoods you cover, plus the categories you sell to. A simple sheet with Area and Category columns becomes your search plan.

Collect by area

  1. Set Bing to English (United States).
  2. For each row in your plan, search category plus ZIP or town in Bing Maps.
  3. Run the extension and export.
  4. Name each file after the search, then merge them and remove duplicates on ID.

The free plan covers 10 leads a day, enough to test one area. Premium has no daily cap for full territories.

Split the address

The Address column holds the whole address, such as 1000 E 5th St Ste 110, Austin, TX 78702. For territory work you need the ZIP on its own:

  • ZIP (US addresses): =RIGHT(TRIM(C2),5)
  • City: split on commas with Data > Text to Columns, then take the second part.

Then check that each ZIP really is in your territory. Searches near a border pull in neighbors.

Map it

The export has Latitude and Longitude for every row. To see your list on a map, import the file into a mapping tool that reads coordinates, for example Google My Maps (create a map, then Import, and choose the Latitude and Longitude columns). Color the pins by category or rep.

Assign reps

  • By ZIP: add a Rep column and fill it from a ZIP-to-rep lookup with XLOOKUP.
  • By distance: sort by latitude and longitude to group nearby businesses for route planning.

Hand off to the CRM

Keep the ID column as an external ID so re-imports update rows instead of duplicating them. Map Name to company, the split address to address fields, and Phone and Website to their fields. Keep the Bing Maps URL so reps can check the listing.

Frequently Asked Questions

Can I filter by ZIP code?

Search by ZIP in Bing Maps, then split the ZIP out of the Address column to check and filter it.

How do I plot leads on a map?

Import the export into a mapping tool that reads latitude and longitude columns, such as Google My Maps.

How do I avoid duplicates across areas?

Remove duplicates on the ID column after merging.