Skip To Content

Frequently asked questions

Why can't I connect to my ArcGIS Enterprise portal instance from ArcGIS for Excel?

If you can't connect to your ArcGIS Enterprise portal instance from ArcGIS for Excel, ensure that the ArcGIS connection specified in the ArcGIS for Excel configuration settings uses the HTTPS protocol (for example, https://sampleportal.xyz.com/portal). ArcGIS for Excel does not support HTTP.

How do I install a Microsoft Office language interface pack?

To install ArcGIS for Excel in the native operating system (OS) language, you must first install the Microsoft Office language pack in the desired language, and set that language as the default display language. To set the default display language in Microsoft Office, complete the following steps:

  1. Open a Microsoft Office program, such as Excel.
  2. Click the File tab and click Options.
  3. In the Excel Options pane, click Language.
  4. Under the Choose Display Languages option, choose the language you want to use, and click Set as Default.
  5. After you change the default display language, restart Microsoft Office.

How do I set up a proxy PAC file to work with ArcGIS for Excel?

ArcGIS for Excel uses the proxy that's defined in the Internet Explorer browser settings. With Microsoft IIS (and other web servers), you can use a proxy PAC file to dynamically switch proxy settings when your connection changes (for example, if you move your laptop from your office network to a home-based VPN).

Proxy settings are specific to your web server. For more information, refer to the Microsoft documentation.

How do I set the language for ArcGIS for Excel?

ArcGIS for Excel uses the language specified in the Excel Options window, not the OS culture setting. To set the language in Excel, click the File menu and click Options. In the Options window, choose Language, and specify a language.

How do I tell which version of ArcGIS for Excel I have installed?

To see the installed version of ArcGIS for Excel, click the File menu and choose ArcGIS. The version number is listed below the Current User entry.

Do I need an ArcGIS subscription to use ArcGIS for Excel?

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 additional content and tools. Learn more about using ArcGIS for Excel with and without a subscription.

Does this app consume ArcGIS credits?

Some ArcGIS for Excel features consume credits. Credits are most often consumed through address geocoding or data enrichment—functions that add new columns of data to a spreadsheet. For more information, see Credits in ArcGIS for Excel.

Does all geocoding consume credits?

Only geocoding using the ArcGIS World Geocoding Service (the default address option in ArcGIS for Excel, U.S. cities, or world cities) consumes geocoding credits. Other options, such as ZIP Codes, states, counties, or countries, are considered standard geographies and do not consume ArcGIS credits. For more information, see Credits in ArcGIS for Excel

Why doesn't my worksheet appear in the Add from Excel wizard?

ArcGIS for Excel recognizes tables and automatically adds them to the Add data from Excel wizard. If there are no tables in your worksheet, you can manually select a cell range by dragging the pointer over the desired group of cells. See Select cell contents in Excel for more information.

If I make a map in Excel, what happens when I send the worksheet to my colleagues? Will they see the map?

What your colleagues see depends on whether they have ArcGIS for Excel installed and whether they are signed in to ArcGIS. Here's what your colleagues will see in various scenarios:

  • The ArcGIS for Excel add-in has been added to your ribbon and your colleagues are signed in to ArcGIS as members of an ArcGIS Online organization or an ArcGIS Enterprise deployment with privileges to create, analyze, and share content—The map is fully interactive and your colleagues can pan and zoom the map, add and remove layers, and work with the tools in the map. They see the layers they have access to and can perform actions that are allowed for the permissions that have been assigned to them. Changes to the spreadsheet are reflected in the map, and new rows are geocoded (locations changed to precise coordinates), provided that your colleagues have geocoding privileges in ArcGIS.
  • You can pan and zoom the map and view pop-up information. Only publicly shared ArcGIS layers and layers created from the Excel worksheet are visible. Map tools are not available. Your colleagues must sign in with a user type that has privileges to create, analyze, and share to view and interact with all map content.

My organization has a geocoder registered with ArcGIS. Can I use it with ArcGIS for Excel?

Yes, you can. When you add data to a map from Excel, click the Location Type drop-down arrow and choose Address from the list. In the Geolocator drop-down menu, you will find your custom geocoder (that has been registered with ArcGIS) in the list.

Can I add a custom basemap to the Basemap Gallery in ArcGIS for Excel?

Custom basemaps can be added to the group established by your ArcGIS administrator as the Basemap Gallery group.

When I add a layer from ArcGIS Online that contains a large number of points, are all the points added to the map at once?

No. When you add a layer to a map from ArcGIS Online, not all points are added to the map at the same time. To maximize performance, ArcGIS for Excel adds feature points in batches, based on the visible map extent. As you zoom or pan across the map, points that are visible in the new extent are added to the map while you scroll.

Why doesn't my clustered layer display in ArcGIS Online?

You can apply clustering while working with maps in ArcGIS for Excel. When sharing a layer to ArcGIS, clustering is turned off. To share the clusters, share the layer as part of a map. See Share a map to ArcGIS for more information.

Why doesn't ArcGIS for Excel recognize my pivot table when adding data?

When adding data, the Add from Excel wizard attempts to recognize tables in the spreadsheet. If possible, it will also recognize existing pivot tables in the spreadsheet. If the pivot table contains an unsupported, nonnative data type, contains a hierarchy, or has more than one row label, the Add from Excel wizard does not recognize it. Nonnative data types are typically generated by third-party Excel plug-ins and do not directly conform to typical data types stored in a relational database management system (RDBMS).

Why isn't cell formatting preserved when sharing to ArcGIS Online?

Cell formatting, such as double or datetime, may not be preserved in pop-ups when sharing a map or layer to ArcGIS Online. In these cases, ArcGIS for Excel publishes the value in the cell, not the formatted string, and additional analysis can be performed on the value.

Can I add a Bing basemap to my map?

ArcGIS for Excel does not provide a user interface to add Bing Maps. Bing Maps basemaps must be configured online by the administrator of your ArcGIS Online organization.

ArcGIS for Excel shows a warning message when Internet Explorer (IE) is not supported.

You need to upgrade Microsoft Excel. Follow the steps in the Esri Community blog article.

While connecting to an ArcGIS Enterprise machine, an Invalid Redirect URL message is displayed in the sign-in window.

Connect to ArcGIS Enterprise, https://<machine_name>:7443/arcgis/portaladmin, and sign-in as an ArcGIS Enterprise administrator. Click Home > Security > OAuth > Update App Info. Paste this text in the text box: {"appId":"mapsForOffice","redirectURIs":[".arcgis.com",".esri.com. Click Update App. Open Excel, access the ArcGIS tab, and connect to ArcGIS Enterprise from ArcGIS for Excel.

I get a message stating You don't have access to this resource when I sign in from Firefox.

Choose Allow from the Open pop-up windows drop-down options to allow pop-ups from esriis-my.sharepoint.com. Then you can sign in from the enabled ArcGIS login page with no error messages.