Last month Microsoft annouced two new data types in Microsoft Excel.

Today, we are announcing new, cloud-connected data types in Excel, starting with Stocks and Geography. With added AI capabilities, Excel can now recognize rich data types beyond numbers and text strings. For example, Excel recognizes that “France” is a country and automatically associates it with additional attributes such as population and gross domestic product, using the same technology that powers Bing answers. These attributes can then be populated into different cells or used directly in formulas and stay updated with the latest data. Based on machine learning, these new data types will simplify the process of working with real-world data. In the future, we’ll add organizational data types backed by the Microsoft Graph to Excel—intelligently enhancing your spreadsheets with even richer content.

Here's a link to a preview on the new Microsoft Excel data types, Stocks and Geography, where they discuss the features and how to use the new data types. For example, you can use a dot “.” operator to get the population of a city. If cell B3 was 'France', in another cell you could type the formula =B3.Population to get the population of France. Other fields include; Area, Country/region, Latitude, Longitude.