Skip To Content

ArcGIS for Excel user interface

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

ArcGIS ribbon

The ArcGIS ribbon provides tools to get started using 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.
  • Function Builder—Customized formulas that you can use to geocode, geoenrich, and route operations.
  • Help—View the ArcGIS for Excel online help.
  • Get started—Get started with sign in and using ArcGIS for Excel tools.

Map window

The map window displays the map and tools for working with it. When you click Show Map, it opens next to the Excel worksheet.

ArcGIS for Excel map window

  • Map title—Edit the map title, for example ArcGIS for Excel in the screenshot above.
  • Close map Close—Close the map from the worksheet.
  • Map tools—Design and work with maps. The map tools are as follows:
  • Zoom in and Zoom out buttons—Zoom in and out on the map.

Layer list

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

Layer list

  1. Active layer indicator—Identify the layer you are working on.
  2. Expand layer contents—Expand or collapse the layer legend.
  3. Layer name—View the name of the layer.
  4. Layer options—Open the layer options pane.
  5. Close—Close the layer list.
  6. More options—Duplicate, remove, or zoom to the full extent of the layer.
  7. Show layer—Show or hide the layer on the map.
  8. Add from Excel—Create a map using data in the current Excel workbook.
  9. Add from ArcGIS—Create a map using data from ArcGIS.

Layer options pane

The layer options pane provides a single point of entry for working with map layers. In this pane, you can modify a layer's properties, change styling options, configure map elements, and work with the data, among other features.


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

  • Styling Styling—Change the layer's styling options.
  • Select features Select featuresSelect features on the map for analysis.
  • Clustering Clustering—Enable and configure clustering.
  • Pop-upsPop-ups—Enable and configure pop-ups.
  • Labels Labels—Enable and configure labels.
  • Time Time slider—Configure and run an animation that shows how patterns in the layer's data change over time.
  • Share layer or Update layer Share map—Share the layer to your ArcGIS organization. If you've already shared the layer, this option changes to Update layer.
  • Properties Properties—Set properties for the layer, including transparency, visible range, and refresh interval.
  • Active layer drop-down menu—Choose a layer to work with.


  • Click the back button Back/ Return to return to the layer list.
  • Switch layers using the Active layer drop-down menu in the layer options pane.