Chart & Visualization Issues

How to Fix Excel Map Not Recognizing Municipalities

Maira Mehtab Sep 22, 2026 868 views

Question details

The user is attempting to create a choropleth map in Excel, but certain municipalities (such as those in Meta, Colombia) are not being recognized or displayed on the map, even when department and country information is provided.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a geographic choropleth Map chart to visualize regional data.
Observed behavior: The Map chart fails to plot specific municipalities, leaving blank areas on the visualization because the mapping engine does not recognize the location names.

Before you start

Ensure you have an active and stable internet connection, as Excel relies on the online Bing Maps service to process and plot geographic data.

Solution 1Recommended

Separate Geographic Data into Multiple Columns

Splitting your location data into distinct hierarchical columns provides Bing Maps with clearer context to accurately pinpoint the municipality.

When municipality, department, and country are combined in a single cell, the mapping service often struggles to parse the text correctly. Separating them helps the Geography data type correctly identify the specific region.

Create separate columns

Insert new columns in your spreadsheet and label them individually as 'Municipality', 'Department', and 'Country'.

Input the divided data

Move the respective geographic names into their corresponding columns (e.g., 'Villavicencio' in Municipality, 'Meta' in Department, 'Colombia' in Country).

Apply Geography data type

Select the cells containing the municipality names, navigate to the 'Data' tab on the ribbon, and click 'Geography' in the Data Types group to verify recognition.

Re-insert the Map chart

Highlight your newly structured data range, go to the 'Insert' tab, select 'Maps', and click 'Filled Map' to generate the updated visualization.

Verification Tip: If the Geography data type is applied successfully, a small map icon will appear next to the municipality name in the cell.

Solution 2

Use Official Geographic Identifiers or Codes

If text names remain unrecognized, using official geographic codes or postal codes can force the map to identify the correct location.

Free Microsoft Office alternative

Visualize and Manage Complex Datasets with WPS Office

If you consistently encounter issues with Microsoft Excel's data recognition or map limitations, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for all your spreadsheet and data visualization needs.

1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
2. Install WPS Office: Run the downloaded setup file and follow the on-screen prompts to complete the installation.
3. Open your spreadsheet: Launch WPS Spreadsheet and open your existing Excel workbook to continue working without losing any data.

Seamless compatibility with Microsoft Excel formats (.xlsx, .xls, .csv)Rich built-in charting tools for diverse data visualization scenariosLightweight application that runs smoothly on standard and older devicesFamiliar user interface requiring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel map show 'Some locations could not be mapped'?

This error occurs when the Bing Maps service cannot uniquely identify the geographic location based on the provided text. This can happen due to typos, missing regional context (like states or countries), or limitations within Microsoft's backend mapping database.

Can I manually fix unrecognized locations in Excel?

Yes. If a location is marked with a question mark icon after applying the Geography data type, you can click the icon to open the Data Selector pane. From there, you can manually search for and select the correct geographic location.

Does the language of my data affect Excel map recognition?

Yes, using the official localized names or native language for municipalities and departments often yields better recognition results than using translated or anglicized names.

Excel & Data Problems