Add ArcGIS layer data to Excel

Note:

Some workflows may require specific privileges. For more information about user types, roles, and privileges, see the Accounts topic.

You can add and edit an ArcGIS Online or ArcGIS Enterprise layer attribute table in a Microsoft Excel worksheet. Any edits made to the ArcGIS layer attribute data in the Excel worksheet directly update the hosted layer in ArcGIS. See Layers to learn about maps and layers.

See the Esri Community blog article for more information and a video about adding an ArcGIS layer to Excel.

Note:

This functionality is only available for feature layers. Inserting new features to the ArcGIS layer in the Excel worksheet is not supported.

Add a feature layer or group layer to a map and an Excel worksheet

Complete the following steps to add a feature layer or group layer to a map and an Excel worksheet:

Note:

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. See the ArcGIS for Excel Frequently asked questions topic for troubleshooting information.

1. From the map tools, click the Layers button .

   The Layers pane appears.

2. In the Layers pane, click Add .

   The Add layer pane appears.

3. Click the ArcGIS tab.
4. Click to select a remotely hosted ArcGIS Online or ArcGIS Enterprise feature layer from the drop-down menu.

   If necessary, click the Add attribute table to Excel and layer to map button .

   

   If the layer added is a feature layer or a group layer with feature layers, the connected attribute table is shown and reflected in Excel with the features populating the map.

Note:

A few things to remember:

• If you have already added ArcGIS layer data to your Excel worksheet, and the ArcGIS layer has been added to the ArcGIS for Excel map, you cannot create a new layer from the same data.
• Only organization administrators or layer owners can perform delete, rename, or insert column operations to update the fields of the ArcGIS layer.
• When you add Excel data to the map to create a layer, you can share the layer to ArcGIS Online or ArcGIS Enterprise. You cannot however create a new Excel data layer using the same data.

Edit hosted stand-alone or related tables

ArcGIS for Excel supports editing stand-alone, related, and join tables that are associated with a remotely hosted ArcGIS layer in ArcGIS Online or ArcGIS Enterprise. Associated tables in layers brought from a remote source into your worksheet can be edited directly in Microsoft Excel.

You can use the Sync with ArcGIS tool on the Map data tab to refresh and sync the ArcGIS Online or ArcGIS Enterprise attribute table with the connected table in Microsoft Excel.

Note:

If you made edits to the layer's feature attributes using ArcGIS Pro or ArcGIS Online Map Viewer, ArcGIS for Excel detects such changes and a notification indicates that your data may need to be synced back to Excel. This notification is not supported in ArcGIS Enterprise.

Related tables define a relationship between two tables. The associated data isn't appended to the layer's attribute table as it is with a join. For example, you can associate a table containing parcel ownership information with the parcel's layer data because they share a parcel identification field.

ArcGIS Pro

You can create related tables using ArcGIS Pro and publish the table layer to ArcGIS Online or ArcGIS Enterprise. You can bring the table layer into an Excel worksheet using ArcGIS for Excel for editing purposes.

Note:

ArcGIS for Excel does not support creating related tables in Excel.

Learn more about hosted related tables in ArcGIS Pro

Learn more about tables in ArcGIS Pro

Learn more about joins and relates in ArcGIS Pro

ArcGIS Survey123

You can bring data from ArcGIS Survey123 to Excel to review or edit. There are many options for authoring XLSForm-compliant spreadsheets; Excel is the most commonly used. Once the table is imported into Excel, you can start the editing process using ArcGIS for Excel.

Learn more about hosted related tables in Survey123

Learn more about tables in Survey123

Learn more about Survey123 repeats

View and edit single-layer attributes

Complete the following steps to add and edit attributes of a single feature layer:

1. In the Layers list, click More options > Show layer details to view the layer details in ArcGIS Online.
2. On the ArcGIS Online details page, click the Data tab.

   The tab shows the default Table view of the attributes.

3. Click Settings and ensure that the Enable editing check box is checked in the Feature layer (hosted) section.

   Note:

   When editing is enabled, you can edit a remotely hosted feature layer in the Excel table.

4. Add the remotely hosted feature layer to Excel.

   Once you edit the table in Excel, it automatically synchronizes with the hosted layer in ArcGIS.

View and edit group layer attributes

Complete the following steps to view and edit group layer attributes:

1. In the Layers list, click More options > Show layer details to view the layer details in ArcGIS Online.
2. On the ArcGIS Online details page, click the Data tab.

   The tab shows the default Table view of the attributes.

3. Click Settings and ensure that the Enable editing check box is checked in the Feature layer (hosted) section.

   Note:

   When editing is enabled, you can edit a group layer in the Excel table.

4. Add the group layer to Excel.

   In Excel, check a check box or boxes from the Select attribute tables widget.

5. Click Add.

   The attribute table for each feature layer in the group layer opens in a new, separate worksheet. All layers are added to the map at once.

6. Optionally, click Cancel to exit the widget and select another feature layer or group layer.
7. Optionally, click the Visualization tab in the remote web map layer to view the layers that were added to the map in Map Viewer. This is identical to your map in Excel.

Edit feature layer fields

In ArcGIS Online and ArcGIS Enterprise, all field management operations remain the same when added to the Excel worksheet. In the ArcGIS Fields view, for example, if you set Unique to Yes in the Settings table and attempt to add a duplicate value in the Excel worksheet, you may receive an error message.

Complete the following steps to edit feature layer fields:

1. In the Layers list, click More options > Show layer details to view the layer details in ArcGIS Online.
2. On the ArcGIS Online details page, click the Data tab.

   The tab shows the default Table view of the attributes.

3. Optionally, click Settings and ensure that the Enable editing check box is checked in the Feature layer (hosted) section.

   Note:

   When editing is enabled, you can edit the feature layer in the Excel table.

4. On the Data tab, click the Fields view next to the Table view.

   In the Fields view, you can edit the ArcGIS feature layer field settings. The feature layer details, such as objectID, Description, Field Value Type, and Settings, appear in a list. You can create lists in the remote hosted layer. Different ArcGIS products have different terminology for this action, for example, Create list in ArcGIS Online and Coded value domain in ArcGIS Pro.

Note:

ArcGIS for Excel supports ArcGIS Pro layers containing a SubType field published to ArcGIS. You can bring that field as a layer to the Excel worksheet for editing. Currently, ArcGIS for Excel does not support editing SubType group layers. You can add SubType group layers to an ArcGIS for Excel map; however, the attribute data is not added to the Excel worksheet.

Add new rows to a feature layer attribute table in an Excel worksheet

To add a new row to a feature layer attribute table in your Excel worksheet, complete the following steps:

1. Sign in to ArcGIS.
2. Add data from ArcGIS.
3. In the feature layer's attribute table in Excel, add a new row.

   The Add features to ArcGIS Layer prompt appears. The selected row and the ArcGIS layer’s Spatial Reference are populated by default.

   Tip:

   Optionally, you can batch copy and add multiple rows. The selected first row is active for editing with the drop-down menu showing all new rows added. Edit the active first row and click Next to keep editing the next rows one at a time. Click Cancel to exit the prompt.

4. Add Longitude(x) and Latitude(y) information.

   Currently, only x,y coordinates are supported.

5. Click Show layer details in the Layers list pane if you cannot add features to your map.
6. Click Save.

   You can zoom to the point feature, and a pop up appears to sync with ArcGIS.

   Note:

   Polygons and polylines are not supported.

Read more in the Esri Community change log blog article

Remove a hosted feature layer

Complete the following steps to remove a hosted feature layer from the Layers list:

1. From the map tools, click the Layers button .

   The Layers pane appears.

2. In the Layers list, click More options > Remove next to the layer you want removed.

   The layer is removed from the map and the Excel worksheet.

Format feature layer pop-ups and labels

You can format pop-ups and labels for hosted feature layers in ArcGIS for Excel. The formatting that is added to Excel is saved in the ArcGIS Online or ArcGIS Enterprise layer automatically in real time.