ArcGIS for Excel user interface

ArcGIS for Excel includes tools for creating, designing, and working with maps.

ArcGIS for Excel ribbon

Use the tools on the ribbon to get started with ArcGIS for Excel.

• ArcGIS tab—Display the ArcGIS ribbon.
• Show Map—Create a map in the current worksheet.
• Reset Map—Reset a map in the current worksheet.

  Note:

  This removes all data from your map. Optionally, you can either keep your ArcGIS account connection, or switch to another.

• Function Builder—Use customized formulas to geocode, enrich data, and route operations. For more information, see Use the Function Builder tool.
• Help—View the ArcGIS for Excel online help.
• Getting Started—Sign in and start using ArcGIS for Excel tools.

Map Data

Use the Map Data tools on the ribbon to zoom to and select specific features.

• Zoom To—Zoom to the extent of a selected feature or features.
• Select—Select features on the map based on the cell or cell range chosen on the Excel worksheet.
• Sync with ArcGIS—Sync updated rows between your spreadsheet and the portal attribute table hosted in ArcGIS Online or ArcGIS Enterprise.
• Show Related Records—Show related records in the Excel worksheet for features on the map, and clear filters.
• Configure location—Configure location type and fields for a layer.
• Edit Geometry—Modifies the location types, such as address and coordinates, and their associated fields.
• Sync with PivotTable—Sync updates between your spreadsheet PivotTable and the mapped data layer.

Map window

The map window displays the map and its tools. When you click Show Map, the map opens next to the Excel worksheet.

The UI items in the map window are described as follows:

• Close button—Close the map from the worksheet.
• Map tools—Design and work with the maps. The following are the map tool buttons:
  • Collapse/Expand —Collapse or expand the tools.
  • Layers —Open the Layers list.
  • Basemap —View the basemap gallery.
  • Selection tool —Select features on the map.
  • Search —Search for a location on the map.
  • Analysis —Choose an analysis tool. Measure tool, Buffer/Drive time analysis, Spatial analysis, and Information cards.
  • Navigation tools —Set or lock your map extent and set bookmarks.
  • Share | Export —Share the entire map.
  • Settings —Sign in or out of your ArcGIS account, view the component version, link to the Esri Community page, manage Esri User Experience Improvement (EUEI) program permissions, clear your cache, and access the ArcGIS for Excel online help.
• Zoom in and Zoom out buttons—Zoom in and out on the map.
• Click the Default map view button to zoom the map to its initial extent.
• Click the Enter fullscreen button to adjust the full-screen control.
• Click the New bookmark button to add a bookmark and save the current map view.

Note:

The zoom buttons appear when you are actively interacting within your map frame. Move your pointer over the map to view the zoom buttons if they disappear.

Note:

This topic primarily describes navigating a map and creating bookmarks in ArcGIS for Excel in a Microsoft web environment. These processes differ when using ArcGIS for Excel in Microsoft Windows and macOS Desktop; see the Navigate a map and Create, update, and delete bookmarks topics for more information.

Layers list

Each layer in a map is represented in the Layers list. To display the Layers list, click the Layers button in the map tools.

The UI items in the Layers list are described as follows:

• Expand layer contents—Expand or collapse the layer legend.
• Active layer indicator—Identify the layer you are working on.
• Layer name—View the title of the layer.
• Symbology —Open the symbology options.
• Style options —Access symbol styling, clustering, and attribute styling.
• Layer properties —Enable pop-ups, the visible range, labels, transparency, and auto-refresh.
• Add —Add data from the current Microsoft Excel workbook or add content from ArcGIS Online and your organizational account.
• Close —Close the Layers list.
• Share layer —Share the layer to your ArcGIS organization. If you've already shared the layer, this button changes to Update layer.
• More options—More layer options, such as zoom to the layer, duplicate the layer, view the layer in ArcGIS, or delete the layer appear. If you have permissions to save changes made to the properties of the layer, the Save to ArcGIS button appears.
• Hidden | Visible—Show or hide the layer on the map.

Symbology tab

The Symbology button opens the Symbology tab, where you can select the active layer you want to work with and whether there are specific fields, or data attributes, you want to symbolize. Select a symbol type (also known as smart mapping). The available choices in the Symbol type drop-down menu vary based on the active layer and attributes you have selected.

Note:

Depending how you added or created a layer—as the result of an analysis, for example—some functionality may not be available, and buttons related to that functionality are inactive.

Style options

The Style Options button opens the Style Options tab. On this tab, you can configure clustering, adjust the layer's styling options (including any options unique to the symbology, such as classification methods), and adjust transparency and rotation by attribute.

Layer properties

The Layer Properties button opens the Layer Properties tab. On this tab, you can enable and configure pop-ups and labels, as well as set the transparency, visible range, and automatically refresh interval for the layer.

Note:

In ArcGIS for Excel, the automatically refresh interval setting does not refresh your Excel attribute table.

Share layer

Share the layer to your ArcGIS organization. The Share layer button is only active for layers added from Excel.