Excel Maps-Is there a Master list of regions?

%3CLINGO-SUB%20id%3D%22lingo-sub-1278431%22%20slang%3D%22en-US%22%3EExcel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278431%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20There%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20a%20teacher%20in%20Ontario%2C%20Canada%20I've%20enjoyed%20using%20the%20maps%20function%20in%20Excel%20with%20my%20geography%20class%2C%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20I've%20seen%20on%20some%20other%20posts%2C%20the%20map%20function%20can%20be%20problematic%20if%20there%20is%20more%20than%20one%20place%20in%20the%20world%20with%20same%20same%20(Durham%2C%20Essex%2C%20etc.)%2C%20and%20there%20are%20also%20challenges%20with%20non-English%20languages.%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20I%20can%20map%20some%20Canadian%20provinces%20based%20on%20the%20regional%20names%20in%20the%20provincial%20directory%20(%20British%20Columbia%2C%20PEI%2C%20Nova%20Scotia%20and%20New%20Brunswick)%26nbsp%3B%20other%20provinces%20aren't%20so%20easy.%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20list%20of%20the%20regions%20that%20Bing%20uses%20to%20identify%20locations.%20%3CU%3ERather%20than%20guessing%20at%20what%20name%20Bing%20uses%20for%20a%20name%2C%20is%20there%20a%20way%20to%20find%20out%20the%20names%20that%20Bing%20already%20has%20for%20a%20region%20for%20each%20location%3F%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1278431%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1278937%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278937%22%20slang%3D%22en-US%22%3EHave%20you%20tried%20using%20the%20Geography%20data%20type%20yet%3F%20(only%20available%20if%20you%20are%20on%20Office%20365%20though)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1278966%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1278966%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3EHI%20Jan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20using%20the%20geography%20data%20set.%20It%20will%20populate%20the%20information%20if%20I%20put%20in%20the%20right%20region%20name%2C%20but%20I%20have%20to%20know%20the%20name%20first.%20I'm%20guessing%20that%20If%20Bing%20Maps%20lists%20Ontario%20as%20a%20province%2C%20is%20there%20any%20way%20for%20them%20to%20have%20a%20drop-down%20box%20that%20lists%20all%20of%20the%20correct%20municipalities%20so%20that%20they%20display%20properly%20on%20the%20map.%20Right%20now%20if%20I%20go%20to%20the%20provincial%20website%20for%20Regions%20and%20Municipalities%20in%20Ontario%20and%20put%20it%20in%20excel%2C%20the%20regions%20don't%20all%20match%20up%20to%20what%20is%20displayed%20on%20the%20map.%3C%2FP%3E%3CP%3ERather%20than%20having%20to%20guess%20at%20the%20regions%20in%20the%20province%2C%20is%20there%20a%20way%20for%20Bing%20or%20Excel%20to%20provide%20these%20lists%20for%20us.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279111%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279111%22%20slang%3D%22en-US%22%3E%3CP%3EI%20agree%20this%20is%20hard.%20If%20you%20use%20the%20table%20I%20created%20in%20the%20attached%20(from%20the%20Ontario%20site)%20and%20convert%20column%20A%20to%20geographic%20data%20type%2C%20a%20number%20of%20municipalities%20are%20not%20recognized.%20I%20don't%20really%20know%20how%20to%20make%20that%20work%20I'm%20afraid.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279266%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279266%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3EHi%20Jan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20passing%20this%20along.%20I've%20run%20into%20the%20problem%20as%20well%20that%20certain%20regions%20aren't%20recognized.%20When%20I%20try%20to%20do%20this%20for%20Quebec%20it%20will%20translate%20some%20of%20the%20names%20on%20its%20own%20(i.e.%20Nord-du-Quebec%20changes%20to%20Katimavik).%3C%2FP%3E%3CP%3EDo%20you%20know%20if%20there%20is%20a%20way%20to%20contact%20Microsoft%20to%20see%20if%20we%20can%20get%20some%20sort%20of%20master%20list%3F%20It%20would%20save%20a%20lot%20of%20digging%20on%20the%20part%20of%20the%20user%2C%20and%20make%20it%20easier%20to%20accurately%20map%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStay%20Safe.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1279563%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Maps-Is%20there%20a%20Master%20list%20of%20regions%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1279563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F607844%22%20target%3D%22_blank%22%3E%40MikePetrychanko%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20will%20be%20very%20surprised%20if%20such%20master%20list%20exists.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi There,

 

I'm a teacher in Ontario, Canada I've enjoyed using the maps function in Excel with my geography class, 

As I've seen on some other posts, the map function can be problematic if there is more than one place in the world with same same (Durham, Essex, etc.), and there are also challenges with non-English languages. 

While I can map some Canadian provinces based on the regional names in the provincial directory ( British Columbia, PEI, Nova Scotia and New Brunswick)  other provinces aren't so easy. 

Is there a list of the regions that Bing uses to identify locations. Rather than guessing at what name Bing uses for a name, is there a way to find out the names that Bing already has for a region for each location?

 

Thanks in advance.

 

 

5 Replies
Highlighted
Have you tried using the Geography data type yet? (only available if you are on Office 365 though)
Highlighted

@Jan Karel PieterseHI Jan,

 

I have tried using the geography data set. It will populate the information if I put in the right region name, but I have to know the name first. I'm guessing that If Bing Maps lists Ontario as a province, is there any way for them to have a drop-down box that lists all of the correct municipalities so that they display properly on the map. Right now if I go to the provincial website for Regions and Municipalities in Ontario and put it in excel, the regions don't all match up to what is displayed on the map.

Rather than having to guess at the regions in the province, is there a way for Bing or Excel to provide these lists for us.

 

Highlighted

I agree this is hard. If you use the table I created in the attached (from the Ontario site) and convert column A to geographic data type, a number of municipalities are not recognized. I don't really know how to make that work I'm afraid.

Highlighted

@Jan Karel PieterseHi Jan,

 

Thanks so much for passing this along. I've run into the problem as well that certain regions aren't recognized. When I try to do this for Quebec it will translate some of the names on its own (i.e. Nord-du-Quebec changes to Katimavik).

Do you know if there is a way to contact Microsoft to see if we can get some sort of master list? It would save a lot of digging on the part of the user, and make it easier to accurately map information.

 

Thanks again.

 

Stay Safe.

 

Highlighted

@MikePetrychanko 

I will be very surprised if such master list exists.