SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-326198%22%20slang%3D%22en-US%22%3EExcel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326198%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20extracting%20data%20out%20of%20a%20real-estate%20website%20into%20excel.%20I%20have%20noticed%20that%20if%20I%20denote%20the%20data%20as%20Geography%2C%20excel%20gets%20confused%20and%20displays%20a%20%3F.%20However%2C%20when%20I%20copy%20and%20paste%20the%20same%20address%20into%20Bing%20maps%2C%20it%20resolves%20just%20fine.%20is%20there%20a%20way%20around%20this%20to%20excel%20will%20recognize%20the%20address%20as%20a%20valid%20geographic%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-326198%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327543%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327543%22%20slang%3D%22en-US%22%3E%3CP%3ESayan%2C%20glad%20to%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327534%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327534%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B-%20appreciate%20that!%20I%20can%20surely%20do%20that%20and%20see%20what%20that%20gets%20me.%20I%20will%20also%20add%20a%20comment%20on%20the%20official%20docs%20to%20request%20more%20details%20on%20the%20granularity%20level%2C%20it%20seems%20at%20least%20suburb%20will%20be%20good%20to%20have.%20Again%2C%20appreciate%20all%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-327181%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-327181%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sayan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20didn't%20see%20details%20docs%20of%20what%20exactly%20is%20supported.%20In%20this%20blog%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Stocks-and-Geography-New-Data-Types-in-Excel%2Fba-p%2F176185%23comments%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel-Blog%2FPreview-of-Stocks-and-Geography-New-Data-Types-in-Excel%2Fba-p%2F176185%23comments%3C%2FA%3E%20Zip%20and%20Cities%20are%20mentioned%20on%20low%20level%20after%20countries.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20concrete%20addresses%20are%20not%20supported.%20If%20you%20create%20table%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20296px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71303i1F2CF4F87D4D1C8B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20apply%20to%20it%20Geography%20data%20type%20only%20last%20two%20fields%20will%20be%20recognized%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20372px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71304i5AC379EE43DE4EA7%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326953%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326953%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Band%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F153902%22%20target%3D%22_blank%22%3E%40Eva%20Vogel%3C%2FA%3E%26nbsp%3B-%20appreciate%20your%20responses.%20I%20think%20I%20misiterpreted%20the%20capability%20a%20bit%2C%20I%20thought%20it%20would%20auto%20recognize%20any%20geography%20records%20and%20offer%20me%20options%20around%20that.%20It%20seems%20it%20may%20not%20be%20that%2C%20and%20it%20would%20work%20with%20less%20granular%20objects%20such%20as%20city.%20Are%20there%20any%20docs%20that%20speak%20to%20the%20geography%20capability%20a%20bit%20more%20-%20with%20the%20nature%20%2F%20type%26nbsp%3B%20%2F%20granularity%20supported%20-%20I%20have%20looked%20at%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-data-types-stocks-and-geography-61a33056-9935-484f-8ac8-f1a89e210877%3C%2FA%3E%20briefly%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20terms%20of%20version%20I%20am%20on%20Office%20365%20ProPlus%2C%20Version%201812%20(Build%2011126.20266%20CTR)%2C%20Monthly%20Channel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20a%20screenshot%20of%20my%20data%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20359px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F71268iC525A04142474152%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22geo%20data%20excel.png%22%20title%3D%22geo%20data%20excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326220%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326220%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Sayan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEven%20if%20Geography%20data%20type%2C%20as%20well%20as%20Map%20Charts%2C%20use%20Bing%20engine%2C%20it's%20far%20from%20Bing%20maps%20in%20places%20recognitions.%20That's%20not%20the%20same.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20help%20to%20engine%20a%20bit%20if%20you%20place%20your%20data%20in%20Excel%20table%20with%20proper%20column%20names%20(Country%2C%20City%2C%20%E2%80%A6).%26nbsp%3B%20Or%20click%20on%20question%20mark%20and%20add%20some%20more%20information%20in%20right%20pane%20to%20find%20the%20place.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20Geography%20data%20type%20doesn't%20work%20with%20small%20geography%20objects.%20Do%20you%20have%20information%20about%20your%20ones%20in%20Wiki%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-326208%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20geography%20data%20type%20does%20not%20recognise%20data%20that%20Bing%20maps%20does%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-326208%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F40513%22%20target%3D%22_blank%22%3E%40Sayan%20Ghosh%3C%2FA%3E%20!%20Would%20you%20pls.%20decscribe%20more%20details%3F%20I%20would%20like%20to%20know%20following%3A%20Which%20Excel%20Version%20are%20you%20working%20on%3F%20In%20my%20Excel%20365%20i%20have%20a%20new%20object%20in%20the%20%22INSERT%22%20Tab%2C%20called%20Cards.%20There%20i%20can%20relate%20a%20geographic%20chart%20with%20my%20geographic%20(bing)%20dates.%26nbsp%3B%20If%20it%20doesnt%2C%20pls.%20send%20a%20screenshot%20from%20what%20is%20wrong%20doing%20in%20your%20special%20workbook.%20Greets%2C%20Eva.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Sayan Ghosh
Occasional Contributor

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?

6 Replies

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.

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?

Thanks @Sergei Baklan 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-8a... 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:

 

geo data excel.png

 

 

 

 

Solution

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-... Zip and Cities are mentioned on low level after countries.

 

I guess concrete addresses are not supported. If you create table like this

image.png

and apply to it Geography data type only last two fields will be recognized

image.png

Thanks @Sergei Baklan - 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!

Highlighted
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
34 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies