Geocode SharePoint lists and document libraries

Note:

You need the following account and license types to use this workflow:

• Microsoft license—You need a Microsoft 365 license, Contributor role or higher, to geocode Microsoft SharePoint lists.
• ArcGIS account type—You must sign in to your ArcGIS account to use ArcGIS geocoding services to geocode Microsoft SharePoint lists.

To map SharePoint lists or document libraries in ArcGIS for SharePoint, the rows in the list or library must contain x,y coordinates or EsriJSON geometry. If the SharePoint list contains addresses without coordinates or shape data, the data must be geocoded or spatially enabled. You can use the Geocode button when selecting rows from a SharePoint list or library to run ArcGIS geocoding services directly in SharePoint.

Tip:

To geocode a SharePoint list using a Microsoft Power Automate template, see Geocode in SharePoint using Microsoft Power Automate.

See Data and geocoding for more information about geocoding processes and services.

To geocode a SharePoint list or document library, complete the following steps:

1. Open the SharePoint document library or list that contains address information.
2. Select the row or rows you want to geocode.

   Alternatively, you can select the whole list.

3. Click Geocode.

   The Geocode pane appears.

4. Under Rows to geocode, select either Entire list or Selected rows.
   
5. Under Choose a geolocator, sign in to your ArcGIS organizational account to choose a geolocator, such as the ArcGIS World Geocoding Service.
   
6. Once signed in, choose a locator from the Geolocator drop-down menu.
7. Optionally, choose the country in which your addresses are located from the Country drop-down menu.

   If the addresses in your list or library are located in different countries, select World from the drop-down menu.

8. Select if your address data is in a single column or multiple columns.
9. From the drop-down menu or menus, select the corresponding address information columns.
10. Click Geocode.

    The geocoding workflow runs and a progress window appears. In the list or library, a Geocoding status column appears, and the column populates with either a check mark or a warning sign to indicate which rows were successfully geocoded.

    
11. If any rows were not successfully geocoded, repeat steps 1-4.
12. Check the Exclude geocoded rows check box to ensure any rows that were previously geocoded are not repeated.
13. Repeat steps 6-9 to finish geocoding the remaining rows in your list or library.