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
- Set Bing to English (United States) so categories and hours come back in English.
- Search bing.com/maps for one category in one area, for example "dentist Austin TX".
- Run Map Lead Finder on the results.
- 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:
| Column | What it holds | Watch out for |
|---|---|---|
| ID | Bing's listing identifier, such as ypid:YN18FEC2C11DEFC296 | Best key for deduping |
| Name | Business name as listed | Some listings use a practitioner's name, which is personal data |
| Address | Full address in one cell | Split into street, city, state, ZIP |
| Featured image | Link to the listing photo on bing.com | For reference only; don't republish |
| Bing Maps URL | Link back to the listing on the map | Handy for checking a row |
| Latitude, Longitude | Coordinates | Keep as numbers; good for mapping |
| Rating | Star rating, such as 4.5 | Blank if no reviews |
| Rating Info | Review count in parentheses, such as (74) | Strip the parentheses to sort |
| Category | Bing category | Comes in your Bing language |
| Open Hours | Hours text as shown | May be a live status ("Open, closes at 4 PM"), and can be blank |
| Website | Website on the listing | May be a location page, not the home page |
| Phone | Phone as shown | Local format; convert for dialers |
Premium exports add email and social-profile columns.
Opening a CSV in Excel without breaking it
- Open a blank workbook.
- Go to Data > From Text/CSV and pick the file.
- Set File Origin to 65001: Unicode (UTF-8) and Delimiter to Comma.
- Click Transform Data. Set the Phone, ID and Website columns to Text, and Latitude and Longitude to Decimal Number.
- 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).
