ArcGIS for Excel user interface

Note:

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

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.
• 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. For more information, see Layers.
  • Basemap —View the basemap gallery. For more information, see Basemap layer.
  • Selection tool —Select features on the map. For more information, see Selection tools.
  • Search —Search for a location on the map. For more information, see Find an address or place.
  • Analysis —Choose an analysis tool. For more information, see Measure tool, Buffer/Drive time analysis, Spatial analysis, and Information cards.
  • Navigation tools —Set or lock your map extent and set bookmarks. For more information, see Navigate a map.
  • Share | Export —Share the entire map. For more information, see Content sharing.
  • 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. For more information, see View your profile and account settings.
• Zoom in and Zoom out buttons—Zoom in and out on the map. For more information, see Navigate a 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 —Duplicate, remove, show layer details, or zoom to the full extent of the layer.
• 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. For more information about the Symbology tab options, see Symbol types.

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. For more information about style options, see Change the style settings.

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. See Sync with ArcGIS to learn more about syncing ArcGIS data in Excel.

Share layer

Share the layer to your ArcGIS organization. The Share layer button is only active for layers added from Excel. For more information about sharing, see Content sharing.