How to Export Bing Maps Results to Excel or CSV

Bing Maps is built for viewing listings, not downloading them. To get search results into a spreadsheet, use a tool that exports them.

Quick Answer: Bing Maps is built for viewing listings, not downloading them. To get search results into a spreadsheet, use a tool that exports them. Map Lead Finder by Pick Ads exports both Excel (.xlsx) and CSV. Pick Excel if you'll work in Excel.

Pick CSV for CRMs and other tools, and if you open a CSV in Excel, import it through Data > From Text/CSV with UTF-8 encoding so accents and phone formatting survive.

Excel or CSV: which to pick

The extension exports both. Choose Excel (.xlsx) when you'll sort, filter and share the list in Excel. Choose CSV when the next stop is a CRM, an email tool or Google Sheets, since CSV is plain text that almost every tool can read. The catch with CSV is that Excel guesses column types when you double-click a CSV, and it can guess wrong: it may drop leading plus signs, reformat long numbers, or garble non-English characters. Importing instead of double-clicking avoids most of that.

Export steps

  1. Set Bing to English (United States) so categories and hours come back in English.
  2. Search bing.com/maps for one category in one area, for example "dentist Austin TX".
  3. Run Map Lead Finder on the results.
  4. Export the results as Excel (.xlsx) or CSV and save the file.

On the free plan you can export up to 10 leads a day with listing data. Premium adds emails and social profiles.

Column dictionary

These are the columns in a free-plan export:

ColumnWhat it holdsWatch out for
IDBing's listing identifier, such as ypid:YN18FEC2C11DEFC296Best key for deduping
NameBusiness name as listedSome listings use a practitioner's name, which is personal data
AddressFull address in one cellSplit into street, city, state, ZIP
Featured imageLink to the listing photo on bing.comFor reference only; don't republish
Bing Maps URLLink back to the listing on the mapHandy for checking a row
Latitude, LongitudeCoordinatesKeep as numbers; good for mapping
RatingStar rating, such as 4.5Blank if no reviews
Rating InfoReview count in parentheses, such as (74)Strip the parentheses to sort
CategoryBing categoryComes in your Bing language
Open HoursHours text as shownMay be a live status ("Open, closes at 4 PM"), and can be blank
WebsiteWebsite on the listingMay be a location page, not the home page
PhonePhone as shownLocal format; convert for dialers

Premium exports add email and social-profile columns.

Opening a CSV in Excel without breaking it

  1. Open a blank workbook.
  2. Go to Data > From Text/CSV and pick the file.
  3. Set File Origin to 65001: Unicode (UTF-8) and Delimiter to Comma.
  4. Click Transform Data. Set the Phone, ID and Website columns to Text, and Latitude and Longitude to Decimal Number.
  5. Click Close & Load.

If you've already double-clicked the file and the characters look wrong, close it without saving and import it this way instead. If you exported Excel (.xlsx), open it directly and check that phone numbers and accents look right before you edit.

Open it in Google Sheets

Go to File > Import > Upload, pick the CSV, and choose "Replace current sheet" or "Insert new sheet". Sheets reads UTF-8 by default. If phone numbers turn into formulas or numbers, format the column as Plain text and import again.

Five formulas that clean the file

Assume Address is in column C, Rating Info in column I, Website in column L, and Phone in column M.

  • Review count as a number: =VALUE(SUBSTITUTE(SUBSTITUTE(I2,"(",""),")",""))
  • Street: =TRIM(LEFT(C2,FIND(",",C2)-1))
  • ZIP (US addresses): =RIGHT(TRIM(C2),5)
  • Digits-only phone: in Excel 365, =CONCAT(IFERROR(MID(M2,SEQUENCE(LEN(M2)),1)*1,"")); in Sheets, =REGEXREPLACE(M2,"[^0-9]","")
  • Website domain (Sheets): =REGEXEXTRACT(L2,"^(?:https?://)?(?:www[.])?([^/]+)")

Then use Data > Remove Duplicates on the ID column after you merge several exports.

Next steps

Once the file is clean, dedupe it against your existing lists and import it into your CRM. If you plan to email or call these businesses, check the rules first: CAN-SPAM applies to B2B email in the US, and calling or texting mobile numbers can require consent.

Frequently Asked Questions

Can I export Bing Maps results to Excel directly?

Yes. The extension exports Excel (.xlsx) as well as CSV.

Why do accents or Vietnamese characters look broken in Excel?

Excel guessed the wrong encoding. Import through Data > From Text/CSV with UTF-8 instead of double-clicking.

Why is the Open Hours cell empty?

Some listings don't show hours. In our 10-row sample, one row had none.

How many rows can I export?

Up to 10 leads a day on the free plan. Premium has no daily cap (owner-stated).