Select features

Selecting features on a map provides a way to identify, locate, and visually analyze a set or subset of data on the map. For example, you can select records in your spreadsheet that correspond to the features selected on the map, or you can filter the spreadsheet to show only the selected features. You can export data from features selected on the map to a CSV file or to a new workbook.

There are several selection tools to help you select features on the map.

Tip:

If you need to adjust the map view while selecting features, click Pan Pan to deactivate the selection tool and pan the map. Then, click the appropriate tool to resume feature selection.

Note:

In some cases, moving from a system with multiple monitors to a system with only one monitor can cause one or more maps to appear hidden. To view all maps, browse to the ArcGIS tab in the Excel ribbon and click Arrange Maps. The maps will be stacked beside the worksheet on the monitor.

Select features

To select features on a map, do the following:

  1. At the top of the layer list, select Layer options Layer options.

    The layer options appear.

  2. If necessary, select the layer you want to modify using the Active layer drop-down menu.
  3. From the layer options, choose Select features Select features.

    The Select features pane appears.

  4. Use one of the following selection tools:

    Note:
    For point features, only features that are completely within the selection area are included in the selection.

    Pan
    • Drag the map view to a different location while making selections.
    • Click a feature using the Pan tool to open the feature's pop-up, if pop-ups are enabled.
    Select by rectangle
    • Drag a rectangle on the map to select features within the shape.
    • Press Ctrl and drag to add or remove multiple features from the current selection.
    • Press Esc to cancel drawing.
    • Click anywhere on the map to clear all selections.
    Select by circle
    • Drag a circle on the map to select features within the shape.
    • Press Ctrl and drag to add or remove multiple features from the current selection.
    • Press Esc to cancel drawing.
    Select by polygon
    • Click to draw points on the map. Double-click to stop drawing and complete the polygon, selecting all features inside the area of the shape.
      Note:

      A minimum of three vertices are required to draw a polygon.

    • Optionally, press Ctrl while drawing to enable snapping.
    • Press Esc to cancel drawing.
    Select by freehand polygon
    • Drag a shape on the map to select features within the shape.
    • Press Ctrl and drag to add or remove multiple features from the current selection.
    • Press Esc to cancel drawing.
    • Click anywhere on the map to clear all selections.
    Clear selection
    • Clear all selections.

Analyze selected features

You can access more detailed information about the selected features in several ways. Use selected features to interact with infographics cards.

Note:

You can view the selection results pane at any time by clicking the Select features button Select features in the layer options.

Work with the spreadsheet

View detailed information about the selected features by viewing the corresponding records in the Excel spreadsheet.

In the Select features pane, click one of the following:

  • Show selected rows—Filters the spreadsheet to display only the rows that correspond with features selected on the map.
  • Show all rows—All rows appear in Excel, regardless of the features selected on the map.
  • Export selected rows—Exports information about the selected features to a separate file or to a new worksheet in the current workbook. For details, see Export data.

Note:

Filtered rows are marked as hidden in Excel; data is not removed from the spreadsheet. If you inadvertently click Clear selection while the spreadsheet is filtered, click in the row number column to select the entire span of rows, and right-click and choose Unhide from the context menu to display all the rows.

Export data

You can export information about the selected features to a CSV file or to new workbook. When exporting selected rows, you can choose to save the file as an Excel workbook (.xlsx) or as a comma-separated values file (.csv). Exporting to an XLSX file creates an Excel table in a new workbook that includes data for each feature selected on the map. If the selection contains point features, the table will include the coordinates for each feature. Polyline and polygon geometries are not exported.

When you export a selection of point features to a file or to a new worksheet, you can choose to use the spatial reference defined by the map's current basemap (default), or specify a different spatial reference. You can also specify the selected spatial reference as the default for all future point layer export functions; you can change this setting at any time by modifying the ArcGIS configuration settings.

Considerations

Keep the following in mind when selecting features:

  • If the active layer is styled using clustering or a heat map, the selection tools are not enabled. Turn off clustering or choose a different style for the layer to enable selection on the layer.
  • When working with a time-aware layer, remember that selection tools only select features that are currently visible on the map. Features that appear earlier or later in the time animation must be added to your selection separately.