Map Your Data Quickly with ArcGIS for Excel

4663
0
02-24-2023 08:11 AM
Labels (1)
Jordan_Brasher
Esri Contributor
6 0 4,663

Need to quickly map address or coordinate data, but overwhelmed at the prospect of learning to use new GIS software? You can visualize spreadsheet data on a map directly in Microsoft Excel with the ArcGIS for Excel add-in! 

 jbrasher_EsriEdDelivery_0-1677085272684.png

What is ArcGIS for Excel? 

ArcGIS for Excel, previously known as ArcGIS for Office, is an add-in for Microsoft Excel that allows you to map, analyze, and share geographic data directly in the Excel environment. The add-in was created to streamline the Esri Microsoft apps suite. 

What will happen to ArcGIS for Office? 

Over the last few years, Microsoft 365 has become the flagship of business productivity products for Microsoft. To ensure Esri’s alignment with Microsoft, ArcGIS for Office will be retired on June 1, 2023, and replaced by ArcGIS for Excel, a clearer and more accurate description of the app. 

Why make a map in Excel? 

Get Started: Install the add-in 

  • Open an Excel worksheet and click Office Add-ins on the Insert tab.  
  • Click My Add-ins or Admin Managed to insert the ArcGIS for Excel add-in into the Excel worksheet.

(Hint: Visit the Get ArcGIS for Excel Help documentation to help get started with the add-in.) 

How to Make a Map in Excel: Workflow 

  • Open your spreadsheet and identify its geographic information – you need addresses or coordinate columns to map your data 
  • Select the range of cells to map  

(Hint: Click in A1 cell and then use Ctrl + A shortcut) 

  • Click Insert > Table, and give the table a name that makes sense to you  

(Hint: Leave checked the option “My table has headers”) 

  • Click the ArcGIS tab > Show Map 

 jbrasher_EsriEdDelivery_1-1677085272660.png

  • A map viewer appears on the right side of the screen, sign into your ArcGIS Online account 
  • Click the layers icon, then +Excel to add your data from the table to the map (see example) 

 jbrasher_EsriEdDelivery_2-1677085272663.png

  • Click +ArcGIS to add layers from ArcGIS services, the Living Atlas, or another layer that has been shared with you 
  • Then, your points should appear on the Map Viewer (see below) 

jbrasher_EsriEdDelivery_3-1677085272672.png

  • Next, you could modify visualization settings, perform analysis, or share your map – more on that in a future blog post! 

To practice making your first map using ArcGIS for Excel, get started with your own data or check out Esri’s free Get Started with ArcGIS for Excel tutorial. 

Once finished, share your map to ArcGIS! 

Resource List 

About the Author
Jordan Brasher is a Desktop Support Analyst with Esri based out of the Minneapolis, MN regional office. Originally from Tennessee, they are a connoisseur of all things food, travel, and outdoors, and enjoy solving problems with maps and spatial information.