Add XY coordinates
When your data contains addresses that you want to use as your location information, you typically need to pay ArcGIS service credits to geocode the information—that is, to generate spatial coordinates that appear as points on your map. After you've done so, you may want to add columns to your spreadsheet to contain the generated spatial coordinates so that you can reuse the information in other maps or spreadsheets without incurring additional geocoding costs. ArcGIS Maps for Office allows you to easily add new location columns to your spreadsheet, or to replace existing columns with the new location information.
The Add XY coordinates feature applies only to layers that contain point geometries; it is not available for line or polygon layers. Also, this feature is enabled only when a map layer was created using an Excel table; if the layer was created using a named range or a cell range, the feature is not available.
To add new coordinates to your spreadsheet, do the following:
- From the Contents pane, select the layer that contains the generated spatial coordinates.
- Click More to display the layer options menu and choose Add XY coordinates.
The Insert XY coordinates into worksheet pane opens.
- Choose one of the following:
- Create new column—In the X and Y fields, provide names for the new columns that will be added to the spreadsheet, or accept the default names. The specified column names must not already exist in the spreadsheet.
- Use existing column—From the X and Y drop-down menus, choose existing columns in the spreadsheet that contain location information. Note that this process overwrites any information that exists in the specified columns.
- Click Add Coordinates.
The new spatial information is added to your spreadsheet.