Skip To Content

Understanding ArcGIS for Excel

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.

Microsoft Excel with ArcGIS tab visible on the ribbon

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:

CapabilityStandard experienceArcGIS ViewerArcGIS 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:

FunctionUse

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.