Click that button, and then click a field name to extract more information. Select one or more cells with the data type, and the Insert Data button will appear. You'll know they're converted if they have this icon: If Excel finds a match between the text in the cells, and our online sources, it will convert your text to the Geography data type. With the cells still selected, go to the Data tab, and then click Geography. Later on, this will make extracting online information easier.

For example, type a country, state, province, territory, or city name into each cell.Īlthough it's not required, we recommend creating an Excel table. Note: The Geography data type is only available to Worldwide Multi-Tenant clients (standard Microsoft 365 accounts).