To insert geographic data into Excel, you first convert text into the Geography data type. Then you can use another column to extract certain details relative to that data type, like Total population, or Time zone.
Note: The Stocks data type is only available to Microsoft 365 accounts or those with a free Microsoft Account. You must also have the English, French, German, Italian, Spanish, or Portuguese editing language added to Office Language Preferences.
Use the Geography data type
-
Type some text in cells. For example, type a country, state, province, territory, or city name into each cell.
-
Then select the cells.
-
Although it's not required, we recommend creating an Excel table. Later on, this will make extracting online information easier. To create a table, go to Insert > Table.
-
With the cells still selected, go to the Data tab, and then click Geography.
-
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. You'll know they're converted if they have this icon:
-
Select one or more cells with the data type, and the Insert Data button
-
Click the Insert Data button again to add more fields. If you're using a table, type a field name in the header row. For example, type Area in the header row and the Area column will appear with data.
Tips:
-
To see all of the fields available, click the geography icon (
-
If you see
-
You can also write formulas that reference data types.
