This is an archive related to a previous version of ArcGIS Maps for Office. If you need the current version go to http://doc.arcgis.com/en/maps-for-office/.

Work with Excel data

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 spreadsheet, 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 spreadsheet, do the following:

  1. Insert a new record in the spreadsheet.
  2. 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.
  3. Right-click the new record to display the context menu, and choose Go to Location.

    The map zooms in to display the new feature.

Use ArcGIS Maps for Office menu commands

From Excel, select a row in the spreadsheet and right-click to display the context menu. The ArcGIS Maps 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 spreadsheet. Select a row or rows in the spreadsheet and right-click to display the context menu. Choose Go to Location. A submenu lists all the available maps and layers based on the current spreadsheet. 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 spreadsheet, 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 spreadsheet. Select a row or rows in the spreadsheet and right-click to display the context menu. Choose Select on Map. A submenu lists all the available maps and layers based on the current spreadsheet. 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 spreadsheet, corresponding features are selected on the map. If you select more rows to select on the map, the new selections are added to features already selected.

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

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

  • Export Layer to CSV—Exports data about all features on a map layer to a comma-separated values (CSV) file.

    You can also use the Selection tool on the map to select and filter features to export to CSV; see Select features.