Work with Excel data

Note:

When you open a map-enabled worksheet that contains multiple maps or point layers created from Excel data, points on the map may not render immediately because the data is being loaded directly from Excel. Performance depends on your system's capabilities and on the size of the dataset and maps.

Add or modify records in Excel

When you add a new record or modify fields in an existing record, all maps created using the modified layer automatically update to reflect the changes.

Modify a record

To modify an existing record in the worksheet, do the following:

  1. Click in the cell that you want to modify and update the value.
  2. Modify other values as needed.
  3. On the map, view the pop-up for the modified record; the values are automatically updated.

Add a new record

To add a new record to the worksheet, do the following:

  1. Insert a new record in the worksheet.

    • If you created the layer from data formatted as an Excel table, right-click inside the table and click Insert > Table rows above or Table rows below. To add a new row to the bottom of the table, place the pointer in the last cell of the table and press Tab. If necessary, drag the resize handle in the lower right corner of the table to include new rows in the table.
    • If you created the layer from a range of cells in your worksheet, insert a new row so that it falls within the range. To do so, right-click a cell inside the range and click Insert to display the Insert window. Click Entire row and click OK.

    The map layer updates to add the new feature.

    Note:

    Because the location information hasn't yet been provided, a message appears below the layer name indicating that one of the points on the layer failed to load. As you add the information to your worksheet, the map refreshes to load the new data.

  2. In the worksheet, populate the cells with the appropriate values.

    Be sure to include the same type of location information as used in the other records, such as latitude and longitude coordinates.

    The map refreshes with the new feature added to the layer.

  3. To zoom directly to the new feature on the map, right-click the new record to display the context menu, and click Go to Location.

    The map zooms in to display the new feature.

Delete a record

To delete a record from the worksheet and the map, do the following:

  • If you created the layer from data formatted as an Excel table, right-click inside the row to remove and choose Delete > Table Rows.
  • If you created the layer from a range of cells in your worksheet, select the entire row to delete. Right-click to display the context menu and click Delete. Click Shift cells up and click OK.

The feature is removed from the map.

Use ArcGIS for Office menu commands

ArcGIS for Office includes several context menu commands that allow you to interact with the map directly from your worksheet.

From Excel, right-click a cell in the worksheet to display the context menu. The ArcGIS for Office commands appear at the bottom of the menu.

Choose from the following commands:

  • Go to Location—Zooms in on a feature on the map from its corresponding row in the worksheet. Select a row or rows in the worksheet and right-click to display the context menu. Click Go to Location. A submenu lists all the available maps and layers based on the current worksheet. Choose the map or layer on which you want to see the feature. The map zooms in to display the selected feature. If you have more than one row selected in the worksheet, the map zooms to show the extent that encompasses all the selected features.
  • Select on Map—Selects a feature on the map from its corresponding row in the worksheet. Select a row or rows in the worksheet and right-click to display the context menu. Click Select on Map. A submenu lists all the available maps and layers based on the current worksheet. Choose the map or layer on which you want to select the feature. The feature appears selected on the specified map. To view the selection more closely, click Go to Location or zoom in on the map manually.

    If you have more than one row selected in the worksheet, corresponding features are selected on the map. If you select more rows to select on the map, the new selections are added to features that are already selected.

  • Clear Selection—Clears all selected features from all maps and layers based on the current worksheet.

    You can also clear selections from the map; see Select features.