ArcGIS plugin for Excel - mapping / geospatial / geographic data display

Microsoft Excel ArcGIS plugin for displaying geographic data 

Mapping geographic coordinates on a world map can now be done right in Excel with our licensed add-in ArcGIS for Excel.  Launch Microsoft Excel through a browser.  There are several ways to do this, one is to log in to https://bwa.dartmouth.edu and then click the upper left grid and click Excel.  Another is to navigate to https://www.microsoft365.com/launch/excel?auth=2

Once in the browser-based Excel, open a blank workbook. Click File > Get Add-ins > More Add-ins and navigate to ArcGIS for Excel 

Uploaded Image (Thumbnail)

"ArcGIS" will show up to the far right of the menus

Uploaded Image (Thumbnail)

Uploaded Image (Thumbnail)

Uploaded Image (Thumbnail)

Uploaded Image (Thumbnail)

Uploaded Image (Thumbnail)

When opening for the first time, Excel and the ArcGIS Add-in may ask for you to sign in to our ArcGIS portal, https://dartmouth.maps.arcgis.com  

Uploaded Image (Thumbnail)

Uploaded Image (Thumbnail)

Excel's ArcGIS Addin can display coordinates in a map in a side panel: 

Uploaded Image (Thumbnail)

sample points: 

Description Latitude Longitude
Dartmouth 43.7023979 -72.2933584
Dartmouth Health 43.6759449 -72.2753397

 

 

 

 

Details

Article ID: 157253
Created
Mon 2/19/24 4:05 PM
Modified
Tue 4/2/24 9:41 AM