Data Import & Export

Fix Excel Geography Data Type Not Returning Country for Cities

Maira Mehtab Sep 20, 2026 872 views

Question details

The user needs to resolve an issue where Excel's Geography data type successfully identifies the country for some cities but leaves the country or region column blank for others.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Using the Geography data type to automatically extract and populate location details, such as Country/Region, from a list of city names.
Observed behavior: The linked Geography data card fails to return or display the country information for specific city names, leaving the corresponding fields empty while working correctly for others.

Before you start

Ensure you have an active and stable internet connection, and verify whether you are using a Microsoft 365 Personal, Work, or School account, as data source behavior can occasionally vary by account type.

Solution 1Recommended

Provide More Specific Location Details

Excel's mapping provider may struggle with ambiguous or duplicate city names globally. Adding a state, province, or country to the cell helps accurately match the location.

When you only provide a city name (e.g., 'London' or 'Springfield'), Excel might not know which specific one you mean if there are multiple cities with the same name across different countries or states. Making the text more specific resolves this ambiguity.

Edit the ambiguous cell

Select the cell containing the city name that failed to return a country. Double-click or press F2 to edit the text.

Add state or country context

Append the state, province, or country to the city name, separated by a comma (for example, change 'London' to 'London, Ontario, Canada').

Update the data type

Press Enter. Excel will automatically attempt to re-link the Geography data type using the new, more specific information.

Extract the region data

Click the small 'Insert Data' button that appears next to the cell and select 'Country/Region' to extract the updated information into the adjacent column.

Data Matched: Once the location is correctly identified, a solid map icon will appear next to the city name, indicating the data is fully linked.

Solution 2

Manually Change or Relink the Data Type

If Excel is unable to auto-resolve the location, you can use the Data Selector pane to manually search for and link the correct city.

Solution 3

Refresh Linked Data Connections

Refreshing the data connection can resolve temporary background glitches or fetch updated geographical data from the source servers.

Free Microsoft Office alternative

Need a Reliable and Free Spreadsheet Tool? Try WPS Office

While specialized cloud data types like Geography are tied to Microsoft 365 subscriptions, WPS Office provides a powerful, free, and highly compatible spreadsheet application. If you prefer working with standard datasets, importing external data, or managing large tables without subscription fees, WPS Spreadsheet is an excellent alternative.

1. Download and Install: Visit the official WPS Office website to download and install the free software on your device.
2. Open your Spreadsheet: Launch WPS Spreadsheet and easily open your existing Excel workbooks without losing formatting or standard formulas.
3. Analyze Data: Use built-in data sorting, filtering, and pivot tables to efficiently manage your geographical and numerical data.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Lightweight installation and smooth performance for large datasets and data import tasks.Comprehensive set of standard formulas, pivot tables, and data analysis tools.Completely free to use with a familiar, user-friendly interface for seamless migration.

Frequently Asked Questions

Why does Excel show a question mark next to my geography data?

A question mark indicates that Excel cannot confidently match the text in your cell to a specific geographic location. Clicking the question mark opens a side pane where you can manually search for and select the correct location.

Is the Geography data type available in all versions of Excel?

No, the Geography data type is primarily available to Microsoft 365 subscribers and Excel for the web. It requires an active internet connection to retrieve geographical data from Bing.

Can I extract other information besides the country using this data type?

Yes, once a location is successfully linked, you can extract various details such as population, area, state/province, latitude, and longitude by clicking the Insert Data icon next to the cell and selecting the desired field.

Why is the Geography data type greyed out in my Excel ribbon?

This usually happens if you are not signed into a Microsoft 365 account, your internet connection is offline, or your organization's IT administrator has disabled Connected Experiences in the privacy settings.

Excel & Data Problems