Add layers from ArcGIS

ArcGIS for Excel works directly with ArcGIS, allowing you to search for content within your organization and, if enabled by your administrator, public content published by the GIS community, including Esri, local governments, and agencies around the world. Adding data from ArcGIS is a quick way to add content to a map to complement existing spreadsheet data. For example, you may have data showing proposed store locations and want to add a household income layer from ArcGIS for those areas to get a better understanding of the potential site neighborhoods.

Add layers from ArcGIS

To add a layer from ArcGIS, do the following:

1. Sign in to ArcGIS.
2. Add a map from ArcGIS to a spreadsheet.
3. Search for a layer to add to the map in any of the following ways:
   • From the drop-down menu, choose the area of your ArcGIS organization to search.

     Note:

     My content appears by default. ArcGIS for Excel filters out unsupported item types, including KML layers. These do not appear in the search results.

   • Type one or more keywords in the search field and press Enter.

     Tip:

     To search using tags, type the keyword tags: followed by the name of the tag you want to find; for example, type tags:myTag. The tags keyword must be lowercase.

   The ArcGIS data pane shows the results of the search.

   

   Note:

   • If your organization's administrator has restricted the ability to search for content outside of your organization, the search returns only results from your organization.
   • To style the layer in ArcGIS for Excel, the item you add must be a feature service or a web map; these contain the data used to create the layer. If you add a map service layer, the Style layer option is not available.
4. To sort the results, click the Sort button .

   You can sort by date modified, title, oldest, or most recent.

5. To filter the search results, click the Filter button and specify the filtering parameters.
   • Turn on the Search within map area toggle button to restrict the search results to the current map extent.
   • Optionally, filter by Item Type or Date Modified. Click Clear filters to remove the filter.
6. Click the List view or Details view buttons to see layer details in those formats.
7. Optionally, from the search results, click a service to view detailed information about it or click the name link to view the author's profile in ArcGIS.

   Tip:

   Click the Show layer details button to view the details in a new window.

8. Find the service you want and click the Add to map button.

   A layer containing the selected data is added to the map and the map view zooms to display the extent of that layer.

   Note:

   • Depending on the data you add, you may consume ArcGIS credits. To help you estimate how many credits the added data will use, see Understand credits.
   • Only operational layers or web maps can be added to the map as data layers; basemaps are not included.

9. When you finish adding layers from ArcGIS, click the back button and click Close to close the pane.

Add data from ArcGIS Living Atlas

When you sign in to your ArcGIS account, you can access content from ArcGIS Living Atlas.

To add a reference layer from ArcGIS Living Atlas, do the following:

1. Optionally, sign in to ArcGIS.
2. From the map tools, select Layers .

   The Layers pane appears.

3. In the Layers pane, click the ArcGIS button.

   Note:

   My content is selected by default in the Add from ArcGIS pane.

4. Select Living Atlas from the drop-down list.

   Note:

   If you are signed in to ArcGIS, choose where to search for layers using the Filter by category drop-down menu. If you are not signed in, this drop-down menu is not available.

5. Search for a layer to add to the map in any of the following ways:
   • From the drop-down menu, choose a category to search in ArcGIS.
   • Type one or more keywords in the Search Living Atlas text box and press Enter.

     Tip:

     To search using tags, type the keyword tags: followed by the name of the tag you want to find; for example, type tags:myTag. The tags keyword must be lowercase.

   • Within the area you selected, scroll to browse available maps and services.
   • Use advanced keyword searches to narrow the search results. For details, see Browse and search content.

   The ArcGIS data pane shows the results of the search.

   If your organization's administrator has restricted the ability to search for content outside of your organization, the search returns only results from your organization.

6. Click the List view and Details view buttons to see layer details in those formats.
7. Click the Sort button to sort the results.
8. Click the Filter button and specify the filtering parameters for the results.
   • Turn on the Search within map area toggle button to restrict the search results to the current map extent.
   • Choose Date modified from the drop-down menu to filter by the date an item was modified. Check the Item type check boxes to filter by item type.
9. Click Clear to remove the filter.
10. Optionally, in the search results, click a service to view detailed information about it or click the name link to view the author's profile in ArcGIS.
11. Click the Add button to add a service.

    A layer containing the selected data is added to the map and the map view zooms to display the extent of that layer. The new layer is added to the layer list.

    Note:

    • Depending on the data you add, you may consume ArcGIS credits. To help you estimate how many credits you will use, see Understand credits.

    • Only operational layers and web maps can be added to the map as data layers; basemaps are not included.

12. Click Back when you finish adding layers from ArcGIS to return to the layer list.