How to Convert Geography Data to Text in Excel
Excel is more than a place to store a list of countries or cities, it’s a dynamic tool that can transform that list into a rich source of information. Using a built-in feature, you can convert simple geographic text like "Japan" or "California" into an interactive data type that lets you pull in dozens of facts, like population, area, and even the name of the current leader, all within your spreadsheet. This guide will show you exactly how to do it, step-by-step.
What is the Geography Data Type in Excel?
Before diving into the "how-to," it helps to understand what you're working with. The Geography data type is one of Excel's "Linked Data Types," a feature available to Microsoft 365 subscribers. When you apply this data type to a piece of text - like the name of a city, state, or country - Excel connects to an online source (Microsoft Bing) to fetch a wealth of related information.
Instead of just being a static string of letters, the text "Germany" in a cell becomes a living link to a data card. This card contains dozens of individual pieces of information, called fields, that you can extract and display in separate columns. It recognizes a wide range of locations, including:
- Countries and Regions
- States, Provinces, and Territories
- Counties
- Cities
- Even some postal codes and airports
This transforms a simple text list into an instantly researchable database, saving you the time of looking up each data point manually online.
How to Convert Geographic Text into a Rich Data Type
The process of converting your text list is straightforward. By following these steps, you'll be able to unlock the data hidden within your location names.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Step 1: Prepare Your List
Start by entering your list of geographic locations into a single column in your Excel sheet. For the best results, consistency and clarity are important.
- Be Specific: If you're listing cities that share names (like Springfield or Franklin), include the state or country to avoid confusion (e.g., "Springfield, Illinois" instead of just "Springfield").
- One Location Per Cell: Each cell in your list should contain only one geographic location.
- Use Headers: It's good practice to create a header for your column, such as "Country," "City," or "State." This helps keep your data organized and makes it easier for Excel to understand the context.
Step 2: Select Your Data
Once your list is ready, click and drag to highlight all the cells containing your geographic text. Make sure you don't include the header row in your selection.
Step 3: Apply the Geography Data Type
With your cells selected, navigate to the Data tab on the Excel ribbon. Look for the "Data Types" section. Here, you will see an icon with a small map marker labeled Geography. Click it.
Excel will now process your list, sending the text from your selected cells to its online service to be identified. For each location it recognizes, a small map icon will appear to the left of the text in the cell. Your plain text has now become a rich data type!
Step 4: Resolve Any Ambiguities
Sometimes, Excel can’t be certain which location you meant. If you entered a vague term like "Lincoln," you'll see a question mark icon instead of a map icon. This indicates that Excel found multiple potential matches and needs your help to choose the right one.
When you click on the cell with the question mark, the Data Selector pane will open on the right side of your screen. It will display a list of possible locations. Simply review the options and click "Select" next to the correct one (e.g., Lincoln, Nebraska vs. Lincoln, UK). Excel will then update the cell with the correct data type.
Extracting Information as Text into Your Spreadsheet
Now for the most powerful part. Once your text has been converted to the Geography data type, you can start pulling in useful information and displaying it as text in new columns. There are two primary ways to do this.
Method 1: Using the "Add Column" Button
This is the quickest and most intuitive method for adding data fields.
- Select one or more cells in your list that have the geography data type.
- A small icon with a plus sign will appear just to the top right of your selection. This is the Add Column button.
- Click this button to see a dropdown list of all available data fields you can extract. This list is extensive and includes everything from Population and Area to more specific data like Gasoline price and Fertility rate.
- Scroll through the list and click on the field you want to add. For example, click on "Population."
Instantly, Excel will create a new column right next to your original list, populated with the population data for every location you converted. You can repeat this process as many times as you like to add more columns of data.
Method 2: Using Formulas for Greater Flexibility
Using formulas gives you more control over where you place the extracted information. It allows you to add data to any cell in your worksheet, not just an adjacent column. The syntax is simple and relies on referencing the cell with the data type, followed by a period and the name of the field.
Let's say your starting location (e.g., "Chicago") is in cell A2. To get its population in cell C2, you would use this formula:
=A2.Population
When you start typing the formula, Excel's AutoComplete will help by showing you a list of available fields as soon as you type the period after the cell reference.
Here are a few more examples:
- To get the capital city for a country in A2:
=A2.[Capital or major city] - To get the full official name for a country in A2:
=A2.[Official name] - To find the governor or leader of a state in A2:
=A2.[Leader(s)]
Note: If a field name contains spaces, like "Official name," you must enclose it in square brackets.
You can drag the fill handle down to apply the formula to the rest of your list, just like with any other Excel formula.
Practical Use Cases for Geographic Data
This feature goes beyond simple trivia. It has powerful applications for business analysis, school projects, and everyday planning.
- For Marketers and Sales Managers: Imagine you have a list of sales territories by state. You can instantly add columns for Population, Median household income, and Number of households to analyze market potential without ever leaving Excel.
- For Logistics and Operations Teams: Planning a shipment schedule across different cities? Pull in the Time zone(s) for each location to avoid miscommunication and coordinate timelines effectively.
- For Students and Researchers: Working on a social studies project? Start with a list of countries and quickly build a rich dataset comparing their GDP per capita, Life expectancy, Largest city, and Population density.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Tips and Troubleshooting
While the Geography data type is powerful, you might run into a few hurdles. Here's how to handle them.
Refreshing Your Data for the Latest Information
Because the data is linked to an online source, it can be updated. Population counts and economic data change over time. To get the most recent information, you can refresh your data. Go to the Data tab and click Refresh All. Alternatively, you can right-click a cell with the data type and select Data Type > Refresh.
How to Convert Geography Data Back to Plain Text
Once you are done analyzing and have all the data you need, you may want to convert the linked data type back to regular text. This can make the file smaller and ensure it's compatible with older versions of Excel. To do this, simply select your cells, right-click, and choose Data Type > Convert to Text. The map icon will disappear, and the cell will now contain only the original text.
Final Thoughts
Excel's Geography data type is an incredibly efficient tool for turning a simple list of places into an insightful report. In just a few clicks, you can enrich your spreadsheet with detailed, accurate text-based facts, saving hours of tedious research and enabling you to make better data-driven decisions right inside the worksheet.
While Excel is fantastic for this kind of data enrichment, often the most powerful analysis comes from connecting data across different platforms entirely - like pairing marketing metrics from Google Analytics with sales results from Shopify. We built Graphed to make that process effortless. You can connect all your tools, then simply ask questions in plain English, like "Compare my ad spend on Facebook with my revenue from Shopify last month," to get a live, automated dashboard in seconds.
Related Articles
How to Create Facebook Ads API for Claude Code
Create a Meta Marketing API access token that never expires, using a system user, so Claude Code can pull Facebook ad reports and manage campaigns.
ClickHouse vs Postgres: When to Switch to Columnar
Comparing ClickHouse vs PostgreSQL means matching storage architecture to workload. Row storage wins for transactions. Columnar wins for scan-heavy analytics.
Google Ads for Orthodontists: Get More Booked Consults
Most orthodontic Google Ads campaigns waste money on low-intent searches. The problem is structure, not the platform.