Type some text in cells. For example, type a country, state, province, territory, or city name into each cell. Then select the cells.

Understanding the Context

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. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.

Key Insights

If you want geographic data, type a country, 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.

Final Thoughts

For example, starting at a country/region level, you can expand to a city level which expands both the state/province and city level. This can be a time-saving operation when you work with many levels of detail. This story was originally published by Data-Smart City Solutions. A city’s data is one of its most valuable assets. Urban data is the bedrock of the performance management programs that allow cities ... In our program at the Harvard Kennedy School we explore exemplary data practices in city governments to identify the principles that will take municipal data use to the next level.

In June we examined ... Government Technology: Why Data Sharing Is Key to Building Smart City Success Kaleido Scope: Magic City Data Collective: UAB students helping solve community challenges through data analysis Magic City Data Collective: UAB students helping solve community challenges through data analysis