How to How to Use Geography Data Type in Excel in Excel - Practical Guide

Learn to leverage Excel's Geography data type to automatically enrich location data with maps, coordinates, and demographic information. This advanced feature transforms raw geographic references into interactive, queryable data objects, enabling powerful spatial analysis and visualization without manual data entry or external tools.

Why This Matters

Geography data type streamlines location-based analysis, enabling real estate professionals, logistics managers, and market analysts to extract geographic intelligence directly within Excel, eliminating manual lookups and reducing analysis time significantly.

Prerequisites

•Excel 365 subscription (Geography data type requires cloud-connected Excel)
•Basic familiarity with Excel data types and linked data features
•Understanding of geographic nomenclature (cities, countries, regions)

Step-by-Step Instructions

Enable Geography Data Type

Navigate to Data > Data Types ribbon and verify Geography is available (it appears automatically in Excel 365). If not visible, ensure you have the latest Excel updates via File > Account > Update Options.

Input Geographic References

Enter location names (cities, countries, regions, landmarks) in a column. Use standard formats like 'Paris, France' or 'New York, USA' for best recognition accuracy.

Convert Text to Geography Type

Select the range containing location data, then click Data > Data Types > Geography. Excel automatically recognizes and converts matching entries; unmatched entries appear with an error indicator.

Extract Geographic Properties

Once converted, click any Geography cell and select properties from the popup (Population, Capital, Coordinates, etc.). Use the formula bar to add properties via =[@Geography].Property syntax, or right-click to access the data card.

Visualize and Analyze Geographic Data

Use extracted properties in formulas, charts, and pivot tables. Insert maps via Insert > 3D Maps for spatial visualization, or create conditional formatting based on geographic attributes like population or region.

Alternative Methods

Manual Geographic Lookup Using XLOOKUP

Use XLOOKUP with external geographic databases or reference tables to retrieve properties without Geography data type, though this requires pre-built lookup tables and is less automated.

Power Query for Geographic Data Enrichment

Import geographic datasets via Power Query and merge them with your data using relationship mapping, providing more control but requiring advanced M language knowledge.

Tips & Tricks

✓Use full geographic context (e.g., 'Springfield, Illinois' instead of 'Springfield') to avoid ambiguity and improve conversion accuracy.
✓After conversion, use the data card icon next to cells to quickly preview all available properties without writing formulas.
✓Geography properties update dynamically if underlying data changes, ensuring your analysis stays current.
✓Combine Geography type with conditional formatting to color-code regions by population, climate zone, or other attributes for quick visual insights.

Pro Tips

★Create dynamic maps by extracting latitude/longitude coordinates using =[@Geography].Latitude and =[@Geography].Longitude, then plot them in scatter charts for spatial distribution analysis.
★Use Geography data type within filtered views to automatically segment analyses by region—filter for a continent and formulas referencing Geography properties recalculate instantly.
★Nest Geography properties in IF statements to flag high-population areas or apply regional business rules without helper columns: =IF([@Geography].Population>1000000,"Major City","Other").
★Combine Geography type with UNIQUE and FILTER functions to generate dynamic lists of countries or regions, eliminating manual list maintenance.

Troubleshooting

Geography data type option is grayed out or not visible in Data > Data Types menu

Ensure you have an active Microsoft 365 subscription and are signed in to your Microsoft account within Excel. Check File > Account to confirm your subscription status. Update Excel to the latest version via File > Account > Update Options.

Entries show error indicators after Geography conversion and properties cannot be extracted

Verify location names match standard geographic nomenclature. Try adding country or region context (e.g., change 'London' to 'London, United Kingdom'). Delete and re-enter unrecognized entries with corrected spelling and format.

Extracted property values appear as #VALUE! or are blank

Confirm the property name is spelled correctly and exists for your location type. Some properties may not be available for all geographies (e.g., 'Capital' only applies to countries). Use the data card to verify available properties before writing formulas.

Maps or visualizations created from Geography data do not update when data changes

Ensure you're using dynamic formulas (not static values) to reference Geography properties. Refresh the data connection via Data > Refresh All, and confirm that automatic calculation is enabled in Formulas > Calculation Options > Automatic.

Related Excel Formulas

XLOOKUP FILTER UNIQUE IF INDEX MATCH

Frequently Asked Questions

Is Geography data type available in Excel Online or only desktop Excel?

Geography data type is fully supported in both Excel Online (web version) and Excel desktop, as long as you have an active Microsoft 365 subscription. Cloud synchronization ensures consistency across devices.

What geographic properties are available for extraction?

Available properties vary by geography type. Countries can provide Capital, Population, Area, and Coordinates; cities offer Population, Region, Country, and Coordinates; and smaller regions provide administrative hierarchies. Use the data card to see all available properties for a specific location.

Can I use Geography data type with PivotTables and charts?

Yes. Extract properties from Geography cells using formulas, then use those extracted values in PivotTables and charts. You can also use Geography directly in some visualizations like Power Map (3D Maps), which recognizes geographic context automatically.

What happens if a location name changes or no longer exists?

Excel retains the original entry and marks it with an error indicator if the geographic reference becomes unrecognizable. You can manually correct the entry, and Excel will re-evaluate it during the next conversion refresh.

Can I export or share Geography data type to colleagues without Microsoft 365?

Geography data type features require Excel 365. If you share a workbook with a non-365 user, they can see extracted values but cannot edit or refresh the Geography data type. For collaboration, ensure all users have Microsoft 365 subscriptions.