Forum Discussion
Sayan Ghosh
Jan 27, 2019Brass Contributor
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,
I didn't see details docs of what exactly is supported. In this blog https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185#comments Zip and Cities are mentioned on low level after countries.
I guess concrete addresses are not supported. If you create table like this
and apply to it Geography data type only last two fields will be recognized
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?
- Sayan GhoshBrass Contributor
Thanks SergeiBaklan and Eva Vogel - appreciate your responses. I think I misiterpreted the capability a bit, I thought it would auto recognize any geography records and offer me options around that. It seems it may not be that, and it would work with less granular objects such as city. Are there any docs that speak to the geography capability a bit more - with the nature / type / granularity supported - I have looked at https://support.office.com/en-us/article/excel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877 briefly?
In terms of version I am on Office 365 ProPlus, Version 1812 (Build 11126.20266 CTR), Monthly Channel.
Attached is a screenshot of my data:
Hi Sayan,
I didn't see details docs of what exactly is supported. In this blog https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Stocks-and-Geography-New-Data-Types-in-Excel/ba-p/176185#comments Zip and Cities are mentioned on low level after countries.
I guess concrete addresses are not supported. If you create table like this
and apply to it Geography data type only last two fields will be recognized
- Eva VogelSteel 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.