How to Add a Map in Excel |

Picture this: you need to present a comprehensive geographical overview of your sales and marketing data to the board.

But representing this data via static spreadsheets becomes challenging, especially when you want to highlight regional trends and patterns. 📊

The solution? Add a map in Excel.

How to add a map in Excel, you ask? We’ll walk you through the process step by step. We’ll also show you how to visualize data from various regions so anybody can grasp the insights at a glance.

Finally, we’ll introduce you to great Microsoft Excel alternatives that make maps more interactive and insightful. Congratulations! Your days of surfing through densely packed spreadsheets to identify geographical trends and patterns are over  🎉. 

Understanding the Basics of the Map Chart Feature

Map charts are an Excel feature that helps you showcase geographical data effectively. They’re a visualization tool, just like flowcharts or graphs in Excel. A map shows specific information about geographical locations, making it easy to identify patterns and gather data insights at a glance. 

Excel’s map is a handy feature for visualizing data by cities, countries, states, counties, or zip codes. You can also add color coding, size variations, and other visual indicators to differentiate data values in various regions. 

How to Add a Map in Excel?

To add an Excel map chart, you need to go to the ‘ribbon’ in Excel’s toolbar, where you’ll find all the features you need.

It provides quick access to various group-related functions while making finding tools like ‘maps’ easier under the ‘insert’ tab. 

Step-by-Step Guide to Creating a Map Chart in Excel

1. Open Excel and enter the geographical data

To add a map in Excel, launch Excel and enter your database, or use spreadsheet templates to plug and play the information. 

You can include location names and the corresponding values you wish to visualize. 

If you want to slice your data by countries or states, you can use the “Data” feature in Excel to enrich your visualization.

• Go to “Data” in Excel’s ribbon. Then, click on “Geography”. You’ll find a “Geography” icon in front of all entries. 

The ‘geography data’ icon means all your entries are now converted to ‘geography data type.’ Now, you can click on the small icon next to your column, and it will automatically show information about your entries.

For example, if you have a list of districts from the US, you’ll see options like Population, Area, Birth rate, Calling code, Currency code, etc. You can choose ‘population’ to enrich your list, and Excel will automatically create a column with that information for you.

2. Select the data range

To compare values, highlight the data range that includes your geographical information and the associated values in the category map. 

3. Navigate to the ‘Insert’ on the ribbon

To create a map chart, go to the ‘Insert’ tab on the Ribbon.

4. Click on ‘Maps’ and select the type of map chart

Select the type of Excel map chart that best fits your data, such as a filled or symbol map.

5. Customize your map 

After building an Excel map chart, you can enhance its clarity and visual appeal by adjusting the colors, labels, and other map formatting options. 

If you double-click the map chart, you get two options: ‘Fill’ and ‘Border’. To change the chart design, you can fill in the colors inside and outside the map and change the border’s color scheme.

If you double-click on the map, you’ll find more chart designs, such as the map projection, map area, and map label options. 

Here, you can change whether you want to show a specific part of the globe or the whole world. You can also add labels of countries to your map. If you click ‘show all’ as the map projection option, you’ll see the names of the chosen countries on the map so anybody can identify the regions.

Try ’s Spreadsheet Template with Map View

Use ’s Spreadsheet Template to track your data based on specific information, including location, age group, and contact details in each row. Use individual views to filter data based on industry, type, and more to sort them further.

This is handy for use cases like storing customer data, where you can organize critical information filtered based on your specific needs. Once the data is in place, use the Map View in the template to visualize your data using geographic terms. 

Useful Features When Working with Maps in Excel

There are many useful features to guide you when creating a map in Microsoft Excel, including: 

How to Embed Maps in an Excel Sheet?

After creating the map, use the following three steps to embed them anywhere in the Excel Sheet. 

• Select the map chart
• Copy and paste it to embed the map wherever you want within the sheet
• Adjust the size and positioning as necessary

Utilizing Analytics with Excel Map Charts

Consider combining maps with Pivot Tables and Slicers to get deeper insights from your geographical data:

1. Connecting map charts with pivot tables

Pivot Table in Microsoft Excel helps you summarize and analyze large data sets. Connecting your map chart to a pivot table lets you quickly summarize sales performance by region, filter for specific periods, and aggregate sales data to see which areas perform best. 

This dynamic analysis helps you pinpoint high-performing regions and areas needing attention. It also lets you identify patterns and trends in the data you may have missed. 

How to connect map charts with pivot tables?

• You can create a pivot table from your Excel data by selecting your data range and choosing the ‘Pivot Table’ option
• Once your pivot table is created, add fields to the rows, columns, and values areas to organize your data
• Insert a map chart by choosing the ‘Maps’ option
• The map chart will now reflect the summarized data from the pivot table. It will update automatically as you adjust it

2. Using slicers with maps

Slicers are visual filters that make filtering data in pivot tables and charts easy. When combined with map charts, slicers allow you to filter and explore your data interactively.

Suppose you have customer data with information on age groups and regions. You can easily filter the map using slicers to show only the data for people aged 18-25. 

You can then view where this age group is located and use this information to create targeted marketing strategies for those regions.

How to use slicers with maps?

• Add a slicer to your pivot table, click on ‘Insert’, and then choose ‘Slicer’
• Select the fields you want to use for filtering, such as regions or categories
• Insert a map chart connected to the pivot table data
• Use the slicers to filter the data and watch the map chart update accordingly

Advanced Map Options in Excel

1. 3D maps 

With Excel’s 3D Maps or Power Map, you can plot geographic and temporal data on a 3D globe or custom map. 3D maps create exciting animated tours to showcase data changes over time or highlight specific data points. 

For example, this map format is a great choice for presenting the global trend of YoY imports and exports over the last 10 years by city.

2. Geographical heat maps

Once you add geographical heat maps in Excel, it color-codes regions based on data values, visually representing data density and distribution. For instance, you can use a gradient color scale to highlight the variation in sales volume.

This visual representation makes it easy to identify hotspots, such as states with exceptional performance and areas that may need more attention.

3. Data labels and annotations

Adding data labels and annotations to your maps makes your data more informative by providing additional context.

Imagine you’re a sales manager analyzing sales data across different states. By adding data labels and annotations to your map, you can display the exact sales figures directly on each state within the map.

You can also add campaign information on the states with high sales figures so viewers can understand the figures resulting from a specific marketing campaign. This helps you communicate your findings at a glance.

Limitations of Using Excel for Maps

Although you can add a map in an Excel sheet, it has certain limitations. 

• The Excel map feature is only available for users with a Microsoft 365 subscription 

• Excel users can’t create map charts using street addresses and latitude/longitude coordinates datasets. It’s limited to high-level geographic details, nationwide data points (like unemployment rate), and other top-level data
• With complex datasets, you will struggle with using Excel as it slows down performance 

While Excel is a powerful map-creation tool, it doesn’t offer advanced data visualization. To overcome Excel limitations, we tried several Excel alternatives in the market. tops the charts.

As an all-in-one project management platform with robust spreadsheet features, can address these gaps. It provides an integrated and efficient solution for managing your data. 

To start with , import your database from Excel to using this easy-to-use guide on how to create a database in .  

Alternatively, pick a database template to get started.

Map View in

Once you’ve organized your data into the Task hierarchy, you can easily display it in the Map view. 

The Map View transforms location-specific data into interactive, visually appealing maps. 

Step-by-step process for creating maps in Map View

1. Access the ‘Map View’

• Open your Workspace and head to the project or list where you want to add a map 
• Click on the ‘+ View’ button at the top right of your screen 
• Select ‘Map’ from the list of view options

2. Add locations to the map

• Click the ‘+ Add Location’ button in the Map View 
• Enter the address or geographical coordinates for each location you want to add. You can also search for locations using the search bar 
• Click ‘Save’ to add the location to your map

3. Customize map points

• Click on any location point on the map to open its details 
• Add relevant information such as location name, description, and custom fields to your workspace 

You can use color coding or different marker styles to differentiate between data points.

4. Integrate with tasks

Link each map point to tasks by selecting the ‘Link Task’ option within the location details. This integration ensures that geographical data is seamlessly connected with your project management workflows. You can assign these tasks to team members, set due dates, and add task statuses directly from the map.

5. Adjust map settings

Access the map settings to customize the map’s appearance. You can choose different map styles, adjust zoom levels, and set default views.

6. Save and share the map

Once your map is set up, save the view. You can share the map with your team by setting the appropriate permissions and sharing options within . Team members can view, edit, and interact with the map data.

Benefits of using ’s Map View  

1. Add location to your tasks 

Add Location Custom Fields to include geographical addresses in your task items. Based on location data for customers and job sites for employees, categorize and sort the information. 

2. Customizable pins to manage your work 

Customizable pins for status and priority allow you to manage your geographical work on a map. View task locations and share them with anyone using a private link. 

Bonus: Editable Spreadsheet Template with Table View

If you’re a fan of the good old table view, consider using ’s Editable Spreadsheet Template to store, organize, and structure your data. 

Here’s how it helps you get your spreadsheets in order: 

• Eliminate manual data entry with automated data import
• Allow users to create custom formulas to crunch numbers quickly 
• Track progress on projects with interactive visuals 
• Ensure data accuracy and consistency across documents 

Use this template to switch to Table View for a more streamlined project management approach, where you can easily assign tasks, set deadlines, and track progress. 

’s Table View offers many benefits:

1. Flexible data management

Easily add, edit, and manage data rows and columns as you would in spreadsheets, but with improved Excel project management capabilities. This helps you seamlessly transition from Excel to .

2. Customization

Adjust the layout and data fields according to your specific needs. Add, remove, or reorder columns, change column types (like text, numbers, dates, etc.), and apply filters or sorting to manage your data effectively. 

The Table View can be tailored to fit various use cases, from project tracking to data analysis.

3. Integration with tasks

Unlike Excel, ’s Table View integrates directly with its task management features. You can link data entries with tasks, deadlines, and assignees. 

Create tasks directly from the Table View, assign them to team members, set due dates, and track progress. Also, add task statuses, priorities, and custom fields to manage workflows. This ensures that all aspects of your projects are synchronized and easily accessible.

Build Interactive Maps using

Map views showcase geographical data types and the insights contained within them. While Excel maps are great for this, they have limitations. 

You need a robust tool like to create detailed, interactive maps without the manual hassle. For example, ’s Map View allows you to add a location to any task and sort, filter, and customize your maps with the latest information.

Additionally, ’s pre-built templates for Excel project management ensure automated data transfer across documents for data accuracy and consistency.

If you’re looking for an Excel alternative to advanced data visualization capabilities, we recommend signing up for free with .

Explore article topics