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.

• Map title—Edit the map title, for example ArcGIS for Excel in the screenshot above.
• Close map —Close the map from the worksheet.
• Map tools—Design and work with maps. The map tools are as follows:
  • Collapse/Expand —Collapse or expand the map tools.
  • Layers —Open the layer list. For more information, see Manage layers.
  • Basemap —View the basemap gallery. For more information, see Change the basemap.
  • Search —Search for a location on the map. For more information, see Find address or place.
  • Analysis —Choose an analysis tool. For more information, see Measure, Use buffer/drive time analysis, and Add infographics cards.
  • Share map—Share the entire map. For more information, see Share a map to ArcGIS.
  • Print —Export a printer-friendly page of a map in various formats. For more information, see Printing a map.
  • Settings —Sign in or out of your ArcGIS account and access the ArcGIS for Excel online help. For more information, see Sign in to ArcGIS.
• 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 in the map tools.

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.

Note:

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

Note:

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