Geography Data Type In Office 365

Welcome to Excel Jet Consult. In this blog post, we want to learn how to fetch all the information for African countries using the Geography Data Type. Let’s get started

Note that this feature is only available to Office 365 users and there must be internet to use the new features. Geography data type is in the Data Type group of the Data tab

In the caption below, we can see the Geography Data Type and the list of African countries

Next, select all the countries and click on Geography

In the above caption, we can see an icon left of each country and another icon which is to add column to extract field to a table column

To display the Population, Armed Forces size, Leaders, Official Language of each country, click on the Add Column icon and select Population, Armed Forces size, Leaders, Official Language from the List. See the captions below


We can see that names of President and Vice President was displayed for Nigeria and other counties.

Posted in Blog.

Leave a Reply

Your email address will not be published. Required fields are marked *