Import Excel data into ArcGIS for SharePoint


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

  • Microsoft license—You need a Microsoft 365 license, role Contributor or higher, to import an Excel spreadsheet to use with ArcGIS for SharePoint.
  • ArcGIS account type—Standard users can perform the basic functions of this workflow; you do not need to sign in.

You can import Excel data into ArcGIS for SharePoint.

See Data and geocoding to learn more about geocoding.

In SharePoint, you can create a list from a spreadsheet. Keep the following in mind when importing Excel spreadsheets into ArcGIS for SharePoint:

  • Your spreadsheet must be formatted as an Excel table.
  • Ensure that the spreadsheet contains no blank columns or rows.
  • Ensure that each column has a header (title).

    When you use a list that was created by importing an Excel spreadsheet, SharePoint sets the first text column in the spreadsheet as the title field with a hyperlink to the original spreadsheet. The ArcGIS for SharePoint web part excludes hyperlinked fields from pop-ups when adding data to the map (hyperlinked content does not appear in the map's pop-ups). You may need to modify the default list view in SharePoint to include the appropriate fields in pop-ups.

  • You can 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 Microsoft documentation for more information: