Work with Excel data
In this topic
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:
- Click in the cell that you want to modify and update the value.
- Modify other values as needed.
- 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:
- Insert a new record in the spreadsheet.
- 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 cursor 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 named range or a range of cells in your spreadsheet, 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.
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 spreadsheet, the map refreshes to load the new data. Alternatively, you can fix the errors directly in the Contents pane.
- In the spreadsheet, 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.
- To zoom directly to 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 spreadsheet 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 named range or a range of cells in your spreadsheet, 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 Maps for Office menu commands
ArcGIS Maps for Office includes several context menu commands that allow you to interact with the map directly from your spreadsheet.
From Excel, right-click a cell in the spreadsheet 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. Click 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. Click 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 that are 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.