How to Import Bing Maps Leads Into Your CRM
Clean and dedupe the export, import it as companies (organizations), map each column to a CRM field, store the Bing listing ID in a custom field, and test with 10 rows before importing everything. Most CRMs accept CSV, and many also accept Excel files.
Quick Answer: Clean and dedupe the export, import it as companies (organizations), map each column to a CRM field, store the Bing listing ID in a custom field, and test with 10 rows before importing everything. Most CRMs accept CSV, and many also accept Excel files.
Prepare the file
- Dedupe on ID, then phone.
- Split the address into street, city, state and ZIP.
- Standardize phones, for example to +15126074268.
- Remove the Featured image column; you don't need Bing's photos in your CRM.
- Save as CSV (UTF-8) or Excel, whichever your CRM accepts.
Companies, not contacts
A Bing Maps listing is a business, not a person. Import rows as companies or organizations. If you have Premium emails, decide whether a generic address like info@ belongs on the company record or a contact record. Emails from Premium aren't verified, so verify them before any campaign.
Column mapping
| Export column | CRM field |
|---|---|
| Name | Company or organization name |
| Street, City, State, ZIP (after splitting) | Address fields |
| Phone | Company phone |
| Website | Website or domain |
| Category | Industry or a custom Category field |
| Rating, Rating Info | Custom number fields |
| Latitude, Longitude | Custom fields, if you map territories |
| Bing Maps URL | Custom URL field |
| ID | Custom unique field, such as Bing listing ID |
| Emails, social profiles (Premium) | Email and social fields |
Many CRMs dedupe companies by domain automatically. Check your CRM's import settings so it doesn't merge separate locations of the same business.
Keep the ID for re-imports
Store the ID in a unique custom field. When you export the same area again later, you can match on it to update existing records instead of creating duplicates.
Record the source and consent basis
Add a Lead source value such as Bing Maps, plus the import date. For UK and EU contacts, note your lawful basis. Keep opt-outs in the CRM so nobody emails a business that has unsubscribed.
Test with 10 rows
Import 10 rows, check every field, fix the mapping, then import the rest. It's much easier than cleaning up 2,000 broken records.
Frequently Asked Questions
Can I import the Excel file directly?
Many CRMs accept Excel as well as CSV. Check your CRM's import help.
Should I import Bing listing photos?
No. Keep the Bing Maps URL instead.
