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.
1. Type data, create a table
Type some geographic data into individual cells, such as country name, county, city, etc. Then select those cells and create an Excel table by clicking Insert > Table. If your data has column headers, select the My table has headers checkbox.
2. Select cells
Now select the cells that contain the geographic data you entered.
3. Click Data > Geography
On the Data tab, click Geography.
4. Icons appear
If Excel finds a match between the text in the cells and our online sources, it will convert the text to the Geography data type. You'll know they're converted if they have this icon: .
5. Add a column
Click the Add Column button , and then click Population. If you don't see this button, make sure to follow step 1 and create an Excel table first.
6. Population appears
Excel will extract the Population field from the cells with the Geography data type. Click the Add Column button again to add other helpful fields like Time Zone, Unemployment Rate, Currency Code and so on.
To see all of the fields available for a selected geography, click the geography icon ( ) or select the cell and press Ctrl+Shift+F2.
You can also write formulas that reference data types.
If you see instead of an icon, then Excel's having a hard time matching your text with data in our online sources. Correct any spelling mistakes and when you press Enter, Excel will do its best to find a match. Or, click and a Record selector pane will appear. Search for the data you need using a keyword or two, and then click Select.