Applies ToExcel for Microsoft 365 Excel 2024 Excel 2021 Excel 2019 Excel 2016

3D Maps supports several geographic formats and levels including:

  • Latitude/Longitude (formatted as decimal)

Lattitude and Longitude data

  • Street Address

  • City

  • County

  • State / Province

  • Zip Code / Postal Code

  • Country/Region

To plot your data, pick the columns that make up your geography from the Location Add Field list, and specify the geographic level they represent. 3D Maps takes it from there and plots your data.

After you verify that the fields correspond to their geography levels in the Geography section and click Next, 3D Maps automatically starts plotting your data by using Bing. You’ll see the progress on the status bar, and you can make changes to the field list and the globe while 3D Maps resolves your geographic data.

Power Map status on the Bing Bar

If there are multiple geographic levels, you can quickly view your data at a different level on your map. Using our example, picking the Street level visualizes the data by street, like this:

Power Map showing data by street

Picking the State level visualizes the same data by state, like this:

Power Map showing data by state

Change geography fields

To change the geography fields that are shown on the map by default, you can pick different fields in the Location list for any layer in the Layer Pane. They’ll automatically appear in the Geography and Map Level box, where you can verify and change their map level.

Common geocoding errors

Geocoding conflicts can occur during the geocoding process. For example, 3D Maps may show an error message to let you know it couldn’t map some geography fields. This might happen when there are several cities in different states that have the same name, such as Springfield.

3D Maps and Bing will try to find a solution by looking at surrounding data to determine where the city in each row of your data might be located, checking for state, country/region, province, and other geographic fields. If additional data is available, the city appears on the map, but in some cases, rows will be skipped. To avoid such conflicts, you can try adding columns that provide additional data (such as Zip Code or Country/Region) so 3D Maps can use that information to resolve the location with better accuracy.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.