SharePoint data preparation

ArcGIS for SharePoint allows you to add content to the ArcGIS for SharePoint web part from several sources, including SharePoint lists in your site collection and ArcGIS. Before you can add data to the map, the list items must be spatially enabled (geocoded) using the ArcGIS Maps Locate workflow. Geocoding is the process of taking data, such as an address, and converting it to a coordinate that corresponds to a location in a coordinate system.

The following table provides information about how to geocode various types of data.

Data sourceProcess to add to a map

Run the ArcGIS Maps Locate workflow. See Geocode lists containing address or place-name data.

This process consumes ArcGIS credits.

SharePoint list with place-names such as U.S. city, U.S. state, and World country

Run the ArcGIS Maps Locate workflow. See Geocode lists containing address or place-name data.

SharePoint list with coordinate data

These lists are considered already geocoded and can be added to a map. See Geocode lists containing coordinate data.


No geocoding necessary. See Add data from ArcGIS.

ArcGIS Maps Locate workflow


The ArcGIS Maps Locate workflow can only be accessed in the classic experience of SharePoint.

The ArcGIS Maps Locate workflow can geocode SharePoint lists that contain the following location types:

  • Address—In the United States, address data is comprised of street name, city, state, ZIP Code, and country. There are similar address elements in other countries. The more address elements your data contains, the more accurate your results will be. You can find a complete list of countries for which there is address coverage in the supported countries link on the ArcGIS World Geocoding Service overview page.
  • US city, State, ZIP code, World city, and Country—Cities (US city and World city) are added to the map as points. States, ZIP Codes, and countries are added to the map as polygons, which represent both the shape and the location of the place. When entering World countries, you can use the Geonames country codes as a reference for accepted spelling variations.
  • Custom location types—This feature allows you to use a hosted service from ArcGIS to specify a location type. For example, if your organization has its own boundaries (water districts, sales districts, zoning boundaries) shared on ArcGIS, you can map your spreadsheet data using those locations instead of the default location types.

The ArcGIS Maps Locate workflow requires a connection to ArcGIS to access the ArcGIS World Geocoding Service for geocoding addresses. By default, the ArcGIS Maps Locate workflow connects to


If you're connecting to ArcGIS Enterprise and do not see the fields populate on the Choose the columns with location information page of the ArcGIS Maps Locate workflow, set the geocoding service to be available to Everyone.

When the ArcGIS Maps Locate workflow executes on a list, it adds new columns to the list. For point items, ArcGIS Maps Location, ShapeX, and ShapeY columns are added; for line and polygon items, an ArcGIS Maps Location and single Shape column are added. The ShapeX and ShapeY (or Shape) fields store the geographic coordinate data for the list item. The ArcGIS Maps Location field stores the geometry for the list item in JSON format; this can be a point, line, or polygon, and embeds an interactive map in each item's form, which allows you to view and manipulate an item's location. To remove these columns, use the List Settings page for the list.

For point features, ArcGIS Maps Location, ShapeX, and ShapeY columns added to the list.

Import Excel spreadsheet data

In SharePoint, you can create a list from a spreadsheet. There are several best practices for importing Excel spreadsheets that will be used with ArcGIS for SharePoint:

  • Your spreadsheet must be formatted as an Excel table.
  • Ensure your spreadsheet contains no blank columns or rows.
  • Ensure each column has a header (title).
  • When you use a list that was created by importing an Excel spreadsheet, be aware that SharePoint takes the first text column in your spreadsheet and sets that as the title field with a hyperlink to the original spreadsheet. The ArcGIS for SharePoint web part does not include hyperlinked fields when adding data to the map (that is, content in the title field will not appear in pop-ups). This means that you may need to modify your default list view in SharePoint to include the appropriate fields for displaying information in pop-ups
  • Use any browser to import data from Excel into a SharePoint list.

If you are new to creating and working with lists in SharePoint, see the following guides for more information:

Use specific latitude and longitude values

Latitude and longitude values represent an x,y coordinate location on the map. You can map x,y coordinate data using the World Geodetic System 1984 (WGS84) coordinate system. In this system, latitude (y) values range from -90 to 90, and longitude (x) values range from -180 to 180. You can also use DMS (Degrees, Minutes, Seconds) notation to map your data.

Learn more about what notation formats are supported

Use time formats

ArcGIS for SharePoint supports several date and time formats as listed in the table below. If you use a format that is not listed, ArcGIS for SharePoint tries to match the format to an equivalent one; for example, 30‑Dec‑1997 will display as 30 Dec 1997. If there is no equivalent format, ArcGIS for SharePoint uses the default MM/DD/YYYY HH:MM: AM/PM (12/30/1997 6:00 PM).

For best results, use the SharePoint modeling tools to set your date and time formats before you add data to a map.

ArcGIS for SharePoint supports the following date-time formats:

Date-time formatExample



Month DD, YYYY

December 30, 1997

Day Month (short) YYYY

Tuesday, Dec 30, 1997

Day, Month DD, YYYY

Tuesday, December 30, 1997


12/30/1997 6:00 PM


12/30/1997 18:00


12/30/1997 5:50:50 PM


12/30/1997 17:59:59

Month YYYY

December 1997

Month (short) YYYY

Dec 1997





HH:MM:SS (24hr)



5:50 PM

HH:MM (24hr)