FlowsBook a callSign inCreate free accountSign up
Sales and prospecting

Prospecting with a map instead of a spreadsheet

A prospect sheet hides where accounts are. Why field sales teams switch to a map, what it shows that rows cannot, and how to keep the sheet for what it still does well.

Part of the guide AI employee for sales prospecting

By the xMap team · · 5 min read

Prospecting on a map works better than a spreadsheet when your reps visit customers in person, because a map shows what rows hide: which prospects sit next to each other, which streets are full of them, which districts nobody covers and where your existing customers already are. A spreadsheet is still the right place for notes, owners and history. The practical answer is both: find and plan on the map, record in the sheet.

This article is for field sales managers and reps who sell to businesses they can walk into: distributors, wholesalers, service companies, equipment and software firms selling to shops, clinics or restaurants. It explains what a spreadsheet gets wrong, what a map adds, a made-up week in Madrid, and how to set up an AI employee that keeps the map and the sheet in step.

What a spreadsheet hides

A prospect sheet sorted by name, score or date looks organised. Put the same rows on a map and problems appear that were invisible in columns:

  • Clusters. Twelve promising prospects on three neighbouring streets read as twelve separate rows. On a map they are one morning's visits.
  • Gaps. A sheet cannot show the district with nobody in it, which might be a district you never searched rather than one with no prospects.
  • Duplicates. The same pharmacy typed twice with a slightly different name sits in two rows, but on a map the two dots land on the same corner.
  • Overlap between reps. Two reps each own half the alphabet, and both drive across the whole city every day.
  • Stale rows. Places that closed six months ago stay in the sheet until someone notices; a fresh map search simply no longer finds them.

What a map adds

A map is not just a picture of the sheet. Built from a live search, it adds things a list of names cannot hold:

  • The whole market. Searching xMap's places database for a kind of business returns every one listed in the area, not just those someone once typed in. In Toronto, for example, the database lists 519 pharmacies within 10 km of the centre (November 2026); of the 438 nearest the centre, 319 are independent. A rep selling to independents can see all of them, not the forty in last year's sheet.
  • Your customers against the market. Customers in one colour, prospects in another, and the empty streets in between.
  • Territories that make sense. Areas drawn so each rep has a compact patch, instead of a list split by letters.
  • A visiting order. Prospects on a rep's patch put into the order that wastes the least driving.
519Pharmacies listed
438Nearest counted
319Independent among them
4.3Average rating
Pharmacies within 10 km of the centre of Toronto, xMap's places database, November 2026. Independents and the rating are of the 438 nearest the centre.

A made-up week in Madrid

An invented example. A distributor of dental supplies in Madrid has three reps and a sheet of 140 dental practices, split by surname of the dentist. Each rep drives across the city most days.

Made-up figuresWith the sheetWith the map
Practices known140410 found in the same area
Already customers5252, marked on the map
Duplicates foundNot seen9 merged
Visits a rep fits in a day69
Districts with no practice in the sheetNot seen4

Illustrative figures only.

A live search finds far more practices than the sheet held. Matching them against the customer list marks the 52 accounts, so reps do not cold-call their own customers. Splitting the city into three compact patches and ordering each day's visits lets each rep fit more calls into the same hours. The four districts that had no practice in the sheet turn out to have plenty; nobody had searched there.

Keep the sheet for what it does well

Switching to a map does not mean throwing the sheet away. It is still the best place for the rep's notes, the account owner, the last visit and the next step. The aim is a sheet that is filled from the map, not typed by hand, so it stays complete and current: new businesses arrive in it as they open, and each row carries its position, rating, phone and website.

Setting up an AI employee that does both

  1. Start with a Schedule every Monday morning, and set the city or districts with Area of interest.
  2. Search the kind of business you sell to with Nearby places, with Only independents or a minimum rating if that is your market.
  3. Add Match with my table against your customer list, keeping only the places not found, so existing accounts drop out.
  4. Add Remove duplicates and Only new, so each week brings only places the reps have not seen.
  5. Share the prospects out with Split by territory, then order each rep's list with Route planner.
  6. Send the results to a shared sheet and draw them with Show on a map, with a short email to each rep's manager.

On Monday each rep opens a map of their patch with the week's new prospects, numbered in visiting order, and finds the same prospects as new rows in the team sheet, each already carrying its address, phone, rating and position. Notes go in the sheet; planning happens on the map.

Questions

Is a map better than a CRM for prospecting?

They do different jobs. A map is better for finding prospects and planning visits; a CRM or sheet is better for notes, owners and history. Use the map to fill the CRM, not to replace it.

How do I stop reps calling existing customers?

Match every prospect against your customer table before it reaches the reps and keep only the places not found.

How many visits can a rep plan from the map?

Route planner orders up to 50 stops in a route. How many fit in a day depends on visit length and travel, which the route's totals show.

Will the map show businesses that just opened?

Yes, once they are listed in xMap's places database. A weekly search with Only new brings each new one to the reps once.

Templates that do this

Read next

More on sales and prospecting · Every article · Templates

Put it to work

An AI employee in xMap Flows does this on live data, on its own timetable. Start from a template or describe it in plain words.