HOW TO

Join an Excel spreadsheet to a feature class in ArcGIS Pro

Last Published: July 27, 2023

Summary

The Add Join tool in ArcGIS Pro provides the capability to join an Excel spreadsheet (.xls) to a feature class. A join associates data from one table to another based on a common field known as a key. For example, when joining an Excel spreadsheet with the Size field and a feature class, the OBJECTID field is used as the key.

Excel table to be joined
Attribute table of feature layer to be joined.
Note:
Before joining an Excel spreadsheet to a feature class, the spreadsheet must be formatted. For more information, refer to ArcMap: Formatting a table in Microsoft Excel for use in ArcGIS. 

Procedure

To join an Excel spreadsheet file to a feature class in ArcGIS Pro, follow the steps below.

  1. Open the Add Join tool.
Note:
Alternatively, right-click the layer on the Contents pane and navigate to Joins and Relates. Click Add Join.
  1. Navigate to the Analysis ribbon tab, and click Tools in the Geoprocessing group to open the Geoprocessing pane.
  2. On the Toolboxes tab, navigate to Data Management Tools > Joins and Relates, and click Add Join.
  1. Fill in the join details on the Parameters tab.
    1. For Layer Name or Table View, select the desired feature class to join from the drop-down list.
    2. For Input Join Field layer, select the field to be used as the key in the input feature class from the drop-down list.
    3. For Join Table, select or browse for the Excel spreadsheet to join to the input layer.
    4. For Output Join Field, select the field to be used as the key in the Excel spreadsheet from the drop-down list.
    5. Optionally, check the Keep All Target Features check box.
Note:
Checking the Keep All Target Features check box retains all records from the input layer in the output layer. Unchecking the check box only keeps the records from the input layer that match a row in the join table. Records that do not have a match in the join table are not included in the output layer. 
Add Join pane
  1. Click Run. The image below shows the output attribute table of the joined feature layer.
Joined table
Note:
Joining an Excel spreadsheet to a feature class using the Add Join tool outputs a temporary join. To make the join permanent, export the joined feature class to a new feature class or save the joined table view to a new table. Alternatively, use the Join Field tool to output a permanent join. For more information, refer to ArcGIS Pro: Join Field.

Article ID:000021757

Software:
  • ArcGIS Pro

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options