HOW TO
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.
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.
To join an Excel spreadsheet file to a feature class in ArcGIS Pro, follow the steps below.
Note: Alternatively, right-click the layer on the Contents pane and navigate to Joins and Relates. Click Add Join.
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.
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.
Get help from ArcGIS experts
Download the Esri Support App