Forum Discussion

Brass Contributor

Jan 27, 2019

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...

excel

SergeiBaklan
Jan 29, 2019
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

SergeiBaklan

Diamond Contributor

Jan 29, 2019

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

Sayan Ghosh

Brass Contributor

Jan 29, 2019

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!

SergeiBaklan
Diamond Contributor
Jan 29, 2019
Sayan, glad to help