ArcGIS for Excel is an add-in for Microsoft Office that brings mapping capabilities from ArcGIS into Microsoft Excel. With ArcGIS for Excel, you can create an interactive map that includes data from Excel and ArcGIS services without leaving the Excel environment. You can share Excel data to ArcGIS and add web maps you've created.
After you install the ArcGIS for Excel add-in, the ArcGIS tab becomes available in Excel. Use this tab to create and manage maps.
You can use ArcGIS for Excel in the standard experience (without signing in to ArcGIS), or you can sign in to connect with your ArcGIS organization and access premium content and analysis tools.
Use ArcGIS for Excel without an ArcGIS subscription
If you do not have an ArcGIS account, you can use a map-enabled worksheet in the standard experience.
The standard experience allows you to view and work with public ArcGIS content and a curated set of layers from ArcGIS Living Atlas. Standard users can also add x,y points from Excel, pan and zoom the map, and view pop-ups. Private layers and some map tools, including Analysis, are not available to standard users.
Tip:
To access all map tools and ArcGIS content, you must sign in to an ArcGIS account.
The following table compares capabilities in the standard experience to the ArcGIS experience, depending on user type:
| Capability | Standard experience | ArcGIS Viewer | ArcGIS Creator |
|---|---|---|---|
Basemap view | Set of four basic basemaps | Yes | Yes |
Public ArcGIS content | Yes | Yes | Yes |
x,y points | Yes | Yes | Yes |
ArcGIS Living Atlas content | Curated subset of content | Yes | Yes |
Boundary matching | No | Yes | Yes |
Geocoding | No | Yes | Yes |
Buffer/Drive time analysis | No | No | Yes |
Infographic cards | No | No | Yes |
Publish to ArcGIS | No | No | Yes |
Use ArcGIS for Excel with an ArcGIS subscription
ArcGIS for Excel works directly with your ArcGIS subscription to allow you to access geographic content that enhances your business data.
To access all map tools and content in ArcGIS for Excel, your ArcGIS user type must include privileges to create, analyze, and share content in an ArcGIS Online organization or an on-premises ArcGIS Enterprise deployment. You can sign up for a free trial ArcGIS Online subscription. The authentication method you use to access ArcGIS must be properly configured by your ArcGIS administrator. Public ArcGIS Online accounts are not supported.
Credits in ArcGIS for Excel
Credits are the currency of ArcGIS. You can use credits to access tools and premium content provided by Esri. Your organization's ArcGIS subscription includes some credits. The number of credits available to you depends on your user type and your organization's credit budget. The number of credits you need depends on the processes you use, each of which has associated costs.
Credit-consuming processes
Credit-consuming processes in ArcGIS for Excel are listed below:
| Function | Use |
|---|---|
Geocoding | Add layers from Excel (Address). |
Demographics | Zoom and pan all ArcGIS Living Atlas public premium layers in the map. Zoom and pan with the infographics card on the map. |
GeoEnrichment | Zoom and pan layers that use ArcGIS GeoEnrichment Service (for example, U.S. states layers and U.S. ZIP Codes layers). |
Storage | Share a map. |
Analysis | Create buffer/drive times. |
Credit use
In ArcGIS for Excel, you use credits primarily for geocoding (transforming a place to a coordinate) and data enrichment (adding context to existing data). ArcGIS World Geocoding Service turns an address or a place-name into x,y coordinates that can be mapped. ArcGIS GeoEnrichment Service provides localized information, such as demographic data, that you can include on a map using standard administrative boundaries including ZIP Codes, states, and counties.
ArcGIS World Geocoding Service and ArcGIS GeoEnrichment Service charge your organization credits based on the number of attributes you add to a dataset. For more information on how ArcGIS uses credits, see Understand credits.