Forum Discussion
Solved
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 addr...
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
Thanks SergeiBaklan - appreciate that! I can surely do that and see what that gets me. I will also add a comment on the official docs to request more details on the granularity level, it seems at least suburb will be good to have. Again, appreciate all the help!
Sayan, glad to help