Note:
Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.
Answers to common questions about ArcGIS for Excel are provided.
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). Specifically, confirm that the maps.arcgis.com extension, for example, https://example.maps.arcgis.com does not support HTTP.
To install ArcGIS for Excel in the native operating system (OS) language, you must first install the Microsoft Office language pack in the required language, and set that language as the default display language.
To set the default display language in Microsoft Office, do the following:
- Open a Microsoft Office program, such as Excel.
- Click the File tab and click Options.
- In the Excel Options pane, click Language.
- For the Choose Display Languages option, choose the language, and click Set as Default.
- Restart Microsoft Office.
To find the ArcGIS for Excel version number, click Settings 
in the map tools. The Current version is shown on the Settings tab 
.
No. You can use ArcGIS for Excel as a guest user without an ArcGIS account, 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.
Some ArcGIS for Excel functionality consumes credits. Credits are most often consumed through address geocoding or data enrichment—functions that add new columns of geographic or demographic data from Esri to a spreadsheet. For more information, see Credits.
Only geocoding using the ArcGIS World Geocoding Service (the default address option in ArcGIS for Excel, United States cities, or world cities) consumes geocoding credits. Other options, such as ZIP Codes, states, counties, and countries, are considered guest geographies and do not consume ArcGIS credits. For more information, see Credits.
ArcGIS for Excel recognizes tables and automatically adds them to Add data from the 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 the Microsoft Select cell contents in Excel article for more information.
If I use ArcGIS for Excel to 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 an ArcGIS account. Here's what your colleagues will see in various scenarios:
- 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 they 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 they make to the spreadsheet are reflected in the map, and new rows are geocoded (locations changed to precise coordinates), provided that their accounts have geocoding privileges in ArcGIS.
- Your colleagues do not have an ArcGIS account—They 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.
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 the map, points that are visible in the new extent are added to the map as you move.
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.
- 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.
Yes. The ArcGIS for Excel add-in can be natively added to any MacBook without installing Windows at the same time, as in previously released versions of ArcGIS for Office. For additional support or questions, contact Esri Technical Support.
The preconfigured organization URL is not listed in the ArcGIS Connection drop-down list when accessed through Safari.
A workaround is available for this known Safari issue. See the GitHub documentation for more information. Also see Configure enterprise logins for information about ArcGIS connections.
When signing back in after clicking Cancel in the Select a certificate for authentication pane while attempting to connect to PKI ArcGIS Enterprise, the Select a certificate for authentication pane doesn't display again.
Refer to the following methods according to your operating system:
- Microsoft Excel Online—Clear the cache in your browser by only selecting and clearing the Site settings cache. Close and reopen the browser, and connect to PKI ArcGIS Enterprise from ArcGIS for Excel. The Select a certificate for authentication pane appears.
- Microsoft Excel Windows Desktop—Close all the open Excel workbooks on your
machine. Clear the Excel cache, and open a command prompt as an admin. Run this command: rmdir /s /q
"%LOCALAPPDATA%\Microsoft\Office\16.0\Wef"
.
Open Excel and connect to PKI ArcGIS Enterprisefrom ArcGIS for Excel. The Select a certificate for authentication pane appears.
- Microsoft Excel macOS Desktop—Close all the open Excel workbooks on your
machine. Clear the Excel cache.
Open Excel and connect to PKI ArcGIS Enterprisefrom ArcGIS for Excel. The Select a certificate for authentication pane appears.
To clear the Excel cache on macOS, follow the instructions in the Microsoft Clear the Office cache article.
To clear cache from your Windows or macOS machines, follow the instructions in the Microsoft article clear an add-in cache.
Follow the instructions in the Technical Support article for Windows or macOS machines.
Follow the steps for Microsoft Windows, macOS Desktop, or ArcGIS for Excel Online to make your map full screen.
A Field name collision error occurred, while inserting a new column into the table data of the ArcGIS layer in the Excel worksheet.
You need to re-create the layer. The ArcGIS Enterprise database contains an erroneous column that ArcGIS for Excel is unable to detect. Additionally, in ArcGIS Enterprise, the Data tab on the item details page does not display the column in the list of fields, and the column cannot be deleted from the database.
Running an ArcGIS function within the Excel tables or in the column directly to the right of the Excel table causes the #SPILL! Error message.
Follow the steps in this Knowledge Base article to avoid the error when working with Excel tables.
When styling a layer by color or size, the filter was applied to a layer in Excel, but the classification remained the same.
To update layer styling that is dynamically based on filtered data or a subset of your data, do one of the following:
- Export the filtered data to a new Excel sheet, then create a layer and apply the layer styling to the new layer.
- Use the Create spatial filter tool
in the Analysis pane 
to create a layer. Apply the layer styling to the new layer.
When adding a layer to your map, you consistently get the following error: Layer view requires layer with query capability. When adding new features to an ArcGIS layer, no features are drawn on the map.
For hosted feature layers in ArcGIS, the layer's edit settings only allow the Add option. When the settings are applied, the query capability for the layer is disabled, and you cannot add features to the map. Go to the layer's Settings tab, and in the What features can editors see? section. Select the Editors can see all features option. Re-add the layer to visualize the features on the map in ArcGIS for Excel.