- Why can't I connect to my ArcGIS Enterprise portal instance from ArcGIS for Excel?
- How do I install a Microsoft Office language interface pack?
- How do I set up a proxy PAC file to work with ArcGIS for Excel?
- How do I set the language for ArcGIS for Excel?
- How do I tell which version of ArcGIS for Excel I have installed?
- Do I need an ArcGIS subscription to use ArcGIS for Excel?
- Does this app consume ArcGIS credits?
- Does all geocoding consume credits?
- Why doesn't my worksheet appear in the Add from Excel wizard?
- If I make a map in Excel, what happens when I send the worksheet to my colleagues? Will they see the map?
- My organization has a geocoder registered with ArcGIS. Can I use it with ArcGIS for Excel?
- Can I add a custom basemap to the Basemap Gallery in ArcGIS for Excel?
- 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?
- Why doesn't my clustered layer display in ArcGIS Online?
- Why doesn't ArcGIS for Excel recognize my pivot table when adding data?
- Why isn't cell formatting preserved when sharing to ArcGIS Online?
- Can I add a Bing basemap to my map?
- ArcGIS for Excel shows a warning message when Internet Explorer (IE) is not supported.
- While connecting to an ArcGIS Enterprise machine, an Invalid Redirect URL message is displayed in the sign-in window.
- I get a message stating You don't have access to this resource when I sign in from Firefox.
- Can I use ArcGIS for Excel on a macOS?
- The pre-configured organization URL is not listed in the ArcGIS Connection drop-down list, when accessed through Safari.
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, complete the following steps:
- Open a Microsoft Office program, such as Excel.
- Click the File tab and click Options.
- In the Excel Options pane, click Language.
- Under the Choose Display Languages option, choose the language you want to use, and click Set as Default.
- After you change the default display language, restart Microsoft Office.
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.
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.
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.
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
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.
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.
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.
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).
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.
Yes. The ArcGIS for Excel add-in can be natively added on any MacBook without needing to install windows parallelly, as in previously released versions of ArcGIS for Office. For additional support or questions, contact Esri Support.
The pre-configured organization URL is not listed in the ArcGIS Connection drop-down list, when accessed through Safari.
A work around is available for this known Safari issue. See the GitHub documentation for more information. See ArcGIS for Excel documentation for details on ArcGIS connections.