Note:
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).
Note:
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.