Use Case
How to Map Competitor and Franchise Locations From Bing Maps Data
Search Bing Maps for your category or a competitor's brand in each area, export to Excel or CSV, and use the Latitude and Longitude columns to plot every location. Google My Maps and QGIS both import a spreadsheet with coordinates, which is enough for a first look at where competitors cluster and where they don't.
Quick Answer: Search Bing Maps for your category or a competitor's brand in each area, export to Excel or CSV, and use the Latitude and Longitude columns to plot every location. Google My Maps and QGIS both import a spreadsheet with coordinates, which is enough for a first look at where competitors cluster and where they don't.
Collect the locations
- Search for the category (for example, coffee shop) or a brand name in each city or ZIP code you care about.
- Export each search to Excel or CSV.
- Merge the files and dedupe on ID.
- Add a Brand column. For chains, the website domain is a quick way to fill it.
The columns that matter here are Name, Address, Latitude, Longitude, Category, Rating and Rating Info.
Plot them on a map
- Google My Maps: create a map, add a layer and import your CSV or XLSX. Choose Latitude and Longitude as the position columns. Google's help page says not to import files with more than 2,000 rows, so split bigger files across layers.
- QGIS (free desktop GIS): add the file as a delimited text layer and pick the coordinate columns. It handles larger files and lets you count points per area.
Color points by Brand so you can see each competitor's footprint at a glance.
Find crowded areas and gaps
- Count locations per ZIP code with a pivot table.
- Look for areas with many competitors and high review counts (saturated) and areas with few or none (possible gaps).
- Treat a gap as a question, not an answer: there may be no demand, or competitors may not be listed.
Distance between two points in Excel
To find the distance in miles between a site at (lat1, lon1) and a competitor at (lat2, lon2), you can use the spherical law of cosines:
=3959*ACOS(COS(RADIANS(lat1))*COS(RADIANS(lat2))*COS(RADIANS(lon2)-RADIANS(lon1))+SIN(RADIANS(lat1))*SIN(RADIANS(lat2)))
Replace lat1, lon1, lat2 and lon2 with cell references. Use 6371 instead of 3959 for kilometers. This is straight-line distance, not drive time.
Limits of this method
A Bing Maps export shows listed locations, not sales, foot traffic or lease data. One search shows only part of the map, so run several smaller searches. Check our guide on getting more results. For research only, the free plan's 10 leads a day may be enough for one brand in one city. Premium has no daily cap. This page uses listing data only, so you don't need the Premium email feature.
Frequently Asked Questions
Can I map more than 2,000 locations in My Maps?
Google's help says not to import files over 2,000 rows, so split the file and import each part into its own layer. QGIS handles larger files.
Is this distance the drive time?
No. The formula gives straight-line distance.
Does the export show competitor sales?
No. It shows listing data such as location, rating and review count.
