Select the data type you want to add To use the Geography data feature, fill the sheet with the location names you need data of, and select them. Now, click on Data in the ribbon and select Geography.

Microsoft on Thursday announced some Excel and Power BI enhancements that add 'connected data types' on top of the standard strings and numbers options.