Toolify Toolify logo
open
Home AI News Plotting Coordinates on a Map Using Microsoft Excel

Plotting Coordinates on a Map Using Microsoft Excel

Updated on Sep 30,2025

Table of Contents

Discover how to visualize geographical data directly within Microsoft Excel by plotting latitude and longitude coordinates on a map. This comprehensive guide avoids the need for external GIS software, offering a streamlined approach to geospatial data visualization.

Key Points

Plotting coordinates on a map within Microsoft Excel.

Utilizing the 3D Maps feature in Excel for geospatial visualization.

Converting a dataset into an Excel table for easier management.

Customizing map styles and labels for effective data representation.

Exploring layer options to enhance map visualization and information display.

Introduction to Mapping with Microsoft Excel

Why Use Excel for Mapping?

Microsoft Excel, often associated with spreadsheets and data analysis, offers powerful mapping capabilities through its 3D Maps feature.

This allows users to plot XY coordinates or, more specifically, latitude and longitude values directly onto a map without relying on external GIS software like QGIS, ArcGIS, or Google Earth Pro. For professionals and enthusiasts who routinely work with geospatial data, mastering Excel's mapping tools can significantly streamline workflows. Excel provides a user-friendly environment for data preparation, manipulation, and visualization, making it an accessible tool for a wide range of mapping applications. For tasks that don't require advanced GIS functionalities, Excel offers a convenient and efficient alternative. The example used in this Tutorial utilizes airport data, but the principles can be applied to any dataset containing location coordinates. Working within Excel allows for seamless integration with existing data workflows, eliminating the need to import and export data between different platforms. This approach is particularly beneficial for projects that require quick data analysis and visualization without the complexity of full-fledged GIS software.

Data Preparation for Mapping

Before diving into the mapping process, it's crucial to prepare your data correctly.

The example dataset, downloaded from Kaggle, includes information about airports in the United States, with columns for IATA code, airport name, city, state, country, latitude, and longitude. To ensure optimal compatibility with Excel's mapping tools, it’s recommended to convert your data range into a formal Excel table. Here's how:

  1. Select the Entire Dataset: Click and drag your mouse to highlight all the data you wish to map.
  2. Format as Table: On the 'Home' tab, locate the 'Format as Table' button in the styles group and select a table style that you like. Choose a light style to have increased readability.
  3. Confirm Table Creation: Excel will ask you to confirm the data range for your table. Verify the range is correct and ensure the 'My table has headers' box is checked if your data includes column headers. Click 'OK'.

Converting the data into a table format allows Excel to recognize and manage the data more effectively. This step ensures that when you use the 3D Maps feature, Excel can accurately identify and plot the location data.

Once you created a table, you can delete filter buttons that excel creates by default.

Ensuring that your dataset includes consistent and accurate latitude and longitude data is essential for successful map plotting. Incorrect or missing coordinate values can lead to inaccurate or incomplete map visualizations.

Step-by-Step Guide: Plotting Coordinates on a Map

Accessing the 3D Maps Feature

Excel's 3D maps is the key to our process. After organizing the data into an Excel table, follow these steps to plot the coordinates:

  1. Select the Table: Click on any cell within the table to activate the table, then select the whole table by using Ctrl + A.
  2. Insert 3D Map: Go to the 'Insert' tab on the Excel ribbon. In the 'Charts' group, you'll find the '3D Maps' option. Expand the dropdown menu and select 'Open 3D Maps'.

This action will launch a separate 3D Maps window, displaying a global view of the world. You can use the controls on the right of the screen for location, heights, categories, time etc. The secondary window allows you to work with a set of data for data analysis.

Configuring the Layer Panel

The Layer Panel is crucial for controlling how your data is displayed on the map.

Here's how to configure it:

  1. Setting the Location: In the 'Layer Panel' on the right-hand side, you'll see options for 'Location'. Click add field on the location.
  2. Specify Latitude and Longitude: Select the 'Latitude' field from your data for the latitude coordinate and the 'Longitude' field for the longitude coordinate. Map excel column that contains Latitude to latitude in Location filed. Map excel column that contains Longitude to Longitude in Location filed. This action tells Excel which columns in your data contain the geographical coordinates.
  3. Choose a Visualization Style: Excel often defaults to visualizing the plotted data as clustered columns. By clicking change the visualization to bubble option.

With these configurations, Excel will accurately plot each coordinate from your dataset onto the map, providing a visual representation of the geographical distribution.

Customizing Visual Elements

You can customize your map visualization in a number of ways. The goal is to create a compelling and informative visual. Here are some tips.

  • Adjusting Bubble Sizes: In the 'Layer Options' section of the 'Layer Panel', you can change the size of the displayed points to get the best visual outcome. Adjusting the size makes it easier to differentiate points.
  • Changing the Opacity: Adjusting the opacity from here. A low opacity will highlight concentrations on the map. By decreasing the opacity, it creates a unique visual with different highlights.
  • Color Coding by Category: Try using categories to give points their colour. This option is a good idea if the column you categorized for color contains states. Because it provides you with an immediate visual indicator of states.

Customizing these visual elements will enhance the clarity and impact of your map, allowing you to effectively communicate the spatial patterns in your data.

Customize Data Card Options

The default setup in excel 3d maps displays only latitude and longitude value. This customization will help display information you want to display when hovering over a point in map.

  • From Right-hand side panel, choose Data Card. Click on customize, and follow next steps.
  • From left panel choose the data to display when hovered over the point.
  • From right panel set what to display the way you want the display to look.

As long as you provide your data in specific format, excel will recognize and show the correct data that is associated with the co-ordinates.

How to Utilize Your Excel Map

Navigating the 3D Map

Once your data is plotted and styled, you can explore the map using Excel's navigation tools:

  • Zoom In/Out: Use the plus and minus buttons to zoom in on specific areas or zoom out for a broader view.
  • Rotate: Utilize the directional buttons to rotate the globe, allowing you to view different regions.
  • Tilt: Adjust the tilt to change the viewing angle, providing different perspectives on the data.

These controls allow you to interactively explore your data, highlighting patterns and trends in different regions.

Pros and Cons of Using Excel 3D Maps

👍 Pros

Easy to use

Easy to learn

No additional Software Needed

👎 Cons

Can not handle very large amount of data

Does not have dedicated Geographic feature

Requires specific format of the input data

FAQ

What versions of Excel support 3D Maps?
3D Maps (previously Power Map) is available in Microsoft Excel 2016, Excel 2019, Excel for Microsoft 365, and Excel for the web. Earlier versions may not have this feature.
Can I use data from multiple sources in 3D Maps?
Yes, you can combine data from multiple sources as long as they are integrated into a single Excel table. Ensure that the latitude and longitude data are accurately aligned for each entry.
Are there limitations to the number of data points I can plot?
While Excel can handle a significant number of data points, performance may degrade with very large datasets. For optimal performance, consider simplifying or filtering your data.

Related Questions

What types of data can I visualize using Excel’s 3D Maps?
Excel’s 3D Maps can be used to visualize a wide array of data, from simple point locations to more complex datasets that include categories and time-based elements. This flexibility allows you to map not only geographic coordinates but also related information such as sales figures by region, population density, or the distribution of specific events over time. The key is having data that includes a geographic component (latitude and longitude or recognized location names) and any additional fields you want to use for categorization, sizing, or time-based animations. Whether you’re tracking customer locations, environmental data, or retail performance, Excel's mapping capabilities can help bring your data to life in a visually engaging and informative way.
Dell Latitude 7202 Rugged Tablet Review: A Deep Dive
Cities: Skylines II - Building a Megacity and Avoiding a Poop Tsunami

Most people like

Related Articles
Top AI Tools
More Tools
Recommend
Resourse
Browse by Alphabet
Top 1000 AI Tools Directory
Read more
About
Contact Us
toolify
Toolify, The Best AI Websites & AI Tools Directory
English 简体中文 繁體中文 한국어 日本語 Português Español Deutsch Français Tiếng Việt

Copyright ©2026 toolify