Work with map data

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

Use the Zoom To or Select tools on the Map Data tab to zoom to or select a specific feature or features on a map from their corresponding row, cell, or cell range in the Excel spreadsheet. See Maps to learn about maps and layers.

Use the Sync with ArcGIS tool to sync the ArcGIS Online or ArcGIS Enterprise attribute table with the connected table in Microsoft Excel. Use the Sync with PivotTable tool to sync your pivot table with the connected mapped data layer.

Note:

For macOS, the icons are visible without the section names, for example, Navigate, Table, and Layer. For internet browsers, you may or may not see the section names depending on whether your ribbon layout is Classic or Single Line.

Select specific features on a map

Use the Select tool on the Map Data tab to select a specific feature or features on a map.

To select a specific feature or features from Excel, do the following:

1. In an Excel spreadsheet, locate the row or rows that contain the features you want to see on the map.
2. Click the Map Data tab.
3. Click Select .

   Note:

   If you selected a single row in Excel, the unselected features on the map fade out, leaving the selected row and feature active.

4. Click Zoom To to zoom in to this active feature.

   Note:

   You can click the selected feature to view its details in a pop-up.

Zoom to a specific feature from an Excel spreadsheet

You can get a closer look at details on the map by zooming to a feature.

To zoom in to a specific feature from Excel, do the following:

1. In an Excel spreadsheet, locate and select the rows that contain the features you want to see closer on the map.
2. Click the Map Data tab.
3. Click Zoom To .

   Note:

   The map zooms in and displays the selected feature in the center of the map. If you selected multiple rows, the map zooms to show the extent of the selected features.

Sync with ArcGIS

You can sync the ArcGIS Online or ArcGIS Enterprise attribute table with the connected table in Microsoft Excel. You can set the refresh to perform automatically at a custom set time interval by enabling the Automatically refresh layer toggle button in the Layers pane, Properties > Layer refresh section.

Learn more about adding ArcGIS layer data to Excel

1. In an Excel spreadsheet, locate and select the rows of the attribute table imported from ArcGIS Online or ArcGIS Enterprise.

   Note:

   You can have changes done to rows or the whole table in Microsoft Excel or in the remotely hosted table in the portal.

2. Click the Map Data tab.
3. Click Sync with ArcGIS .

Sync with PivotTable

A PivotTable is a Microsoft Excel tool that can be used to create a summarized table of aggregated data. Data can be sorted, filtered, and rearranged dynamically to emphasize different aspects of your data. ArcGIS for Excel can now add the data from pivot tables for visualization on the map.

When you select a PivotTable on the spreadsheet whose data was mapped as a data layer, the Sync with PivotTable tool syncs the data between the two.