How to Get Bing Maps Data Into Google Sheets

Export your Bing Maps results to CSV or Excel, then in Google Sheets go to File > Import > Upload, pick the file and choose whether to create a new sheet or replace the current one. Sheets handles UTF-8 CSV files well, so accents usually survive.

Quick Answer: Export your Bing Maps results to CSV or Excel, then in Google Sheets go to File > Import > Upload, pick the file and choose whether to create a new sheet or replace the current one. Sheets handles UTF-8 CSV files well, so accents usually survive.

Import the file

  1. Export your Bing Maps results as CSV or Excel (.xlsx).
  2. Open Google Sheets and go to File > Import.
  3. Choose Upload and select the file.
  4. Pick Insert new sheet(s) to keep each export on its own tab.
  5. For CSV, set the separator to comma and decide whether to convert text to numbers, dates and formulas.

You can also upload the .xlsx file to Google Drive and open it with Google Sheets.

Keep phones and IDs as text

If you allow conversion, Sheets may treat some values as numbers. Choose not to convert text, or format the Phone and ID columns as Plain text (Format > Number > Plain text) before pasting data in.

Formulas for cleanup

  • Review count from (24): =VALUE(REGEXREPLACE(I2,"[()]",""))
  • Domain from website: =REGEXEXTRACT(L2,"^(?:https?://)?(?:www.)?([^/]+)")
  • Phone as E.164 (US): ="+1"&REGEXREPLACE(M2,"[^0-9]","")
  • ZIP (US): =RIGHT(TRIM(C2),5)

Share with your team

Share the sheet with editors or commenters, protect the ID column (Data > Protect sheets and ranges), and add Status, Owner and Notes columns so everyone can see who's handling which lead. Keep access tight; the sheet contains business contact data.

Appending new exports

Import each new export into a new tab, then copy the rows into your master tab and remove duplicates on ID (Data > Data cleanup > Remove duplicates).

Frequently Asked Questions

Why did my phone numbers change?

Sheets converted them to numbers. Re-import without converting text, or format the column as plain text.

Can I open the Excel export in Sheets?

Yes. Import it with File > Import, or upload it to Drive and open it with Google Sheets.