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 columnCRM field
NameCompany or organization name
Street, City, State, ZIP (after splitting)Address fields
PhoneCompany phone
WebsiteWebsite or domain
CategoryIndustry or a custom Category field
Rating, Rating InfoCustom number fields
Latitude, LongitudeCustom fields, if you map territories
Bing Maps URLCustom URL field
IDCustom 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.