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

Eva Vogel

Iron Contributor

Jan 27, 2019

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.