Forum Discussion

Sayan Ghosh's avatar
Sayan Ghosh
Brass Contributor
Jan 27, 2019

Excel geography data type does not recognise data that Bing maps does

I am extracting data out of a real-estate website into excel. I have noticed that if I denote the data as Geography, excel gets confused and displays a ?. However, when I copy and paste the same address into Bing maps, it resolves just fine. is there a way around this to excel will recognize the address as a valid geographic data?

  • Hi Sayan,

     

    Even if Geography data type, as well as Map Charts, use Bing engine, it's far from Bing maps in places recognitions. That's not the same.

     

    You may help to engine a bit if you place your data in Excel table with proper column names (Country, City, …).  Or click on question mark and add some more information in right pane to find the place.

     

    And Geography data type doesn't work with small geography objects. Do you have information about your ones in Wiki?

  • Eva Vogel's avatar
    Eva Vogel
    Steel Contributor

    hi Sayan Ghosh ! Would you pls. decscribe more details? I would like to know following: Which Excel Version are you working on? In my Excel 365 i have a new object in the "INSERT" Tab, called Cards. There i can relate a geographic chart with my geographic (bing) dates.  If it doesnt, pls. send a screenshot from what is wrong doing in your special workbook. Greets, Eva.

Resources