Excel 3D Maps in 2026: Create Animated Geographic Data Visualizations

If you have ever stared at a spreadsheet full of location-based data and wondered how to make sense of it all, Excel 3D Maps is the answer. In 2026, this built-in Excel feature has become one of the most powerful ways to visualize geographic and time-based data without needing a separate mapping tool, business intelligence platform, or coding skills.

Whether you are tracking regional sales figures, analysing customer distribution across countries, or visualizing supply chain flows, 3D Maps turns your raw data into cinematic, animated tours your audience will actually remember.

What Is Excel 3D Maps?

Excel 3D Maps is a data visualization tool built into Microsoft 365 Excel that lets you plot geographic and temporal data onto a three-dimensional globe or flat map. It supports animated time-lapse playback, multiple data layers, and custom tours that can be exported as video files. Unlike a standard Excel chart, 3D Maps is fully interactive — you can rotate the globe, zoom in on specific regions, and play an animation that shows how your data changes over time.

Why Use 3D Maps in 2026?

In 2026, Excel 3D Maps has been enhanced with tighter Microsoft 365 Copilot integration, smarter geocoding for global addresses, and improved video export quality. Here is why it remains a go-to tool:

No add-ins required — 3D Maps is built into all Microsoft 365 Excel versions

Geocodes data automatically — city names, postcodes, country codes, latitude/longitude

Supports time-based animations to show trends across days, months, or years

Exports as MP4 video for presentations, reports, or social media

Handles millions of rows with Power Query integration

Getting Started: What Data Do You Need?

Before launching 3D Maps, your data needs at least one geographic column (such as country, city, state, postcode, or latitude/longitude) and one numeric value column (such as sales, count, or revenue). A date or time column is optional but adds powerful animation capability.

How to Open 3D Maps

Select any cell within your data table.

Go to the Insert tab on the Excel ribbon.

Click 3D Map in the Tours group.

Select Open 3D Maps. Excel opens a new window with your data plotted on a globe.

If your data is in a named Excel table (recommended), 3D Maps will detect all columns automatically.

Configuring Your Map: Layer Settings

Once inside 3D Maps, you will see a Layer Pane on the right side where you configure what gets plotted and how. 3D Maps offers five visualization types: Stacked Column, Clustered Column, Bubble, Heat Map, and Region. In the Layer Pane, drag your columns into the appropriate fields: Location (your city/country column), Height or Size (your numeric value), and Time (your date column for animation).

Using the Time Animation Feature

One of the most impressive capabilities of 3D Maps is the time-lapse animation. When you add a date or time field to the Time box in the Layer Pane, a timeline bar appears at the bottom of the map window. Press the Play button to watch your data animate over time. Click the clock icon next to the time field to set granularity: Days, Months, Quarters, or Years.

Creating a Tour for Video Export

A Tour is a recorded walkthrough of your 3D map that you can export as a video — perfect for executive presentations, website content, or training materials.

In the 3D Maps window, click New Scene in the Home tab.

Position the map view to your desired starting angle.

Set the scene duration and transition type (Fly-through, Straight Line, or Orbit).

Add as many scenes as needed.

Click Create Video in the Home tab and choose your video resolution (up to 4K in 2026).

Customizing Appearance

3D Maps includes several appearance options: Themes (dark globe, satellite imagery, flat map, or monochrome), Data Labels to show values on bars or bubbles, and a 2D Map Flat View option. For professional results, the Dark Globe theme with white bars is particularly striking in video exports.

Tips for Better Results

Clean your location data — misspelled city names may geocode incorrectly. Use ISO country codes where possible.

Use an Excel Table (Ctrl+T) as your source — the map updates automatically when you add new rows.

Layer multiple data series — click Add Layer to overlay different metrics on the same map.

For large datasets, connect through Power Query first to filter and clean data before mapping.

Common Issues and Fixes

Add a Country column alongside your City column to help Excel disambiguate location names.

Use a full address or postcode for precise plotting.

If geocoding fails, add a Latitude and Longitude column for exact positioning.

Conclusion

Excel 3D Maps is one of those features that consistently impresses audiences who have never seen it before. In 2026, with improved geocoding, Copilot-assisted data suggestions, and higher-quality video export, there has never been a better time to start using it. The next time you have regional sales data or time-based geographic trends to present, skip the static bar chart and build a 3D Map tour instead.