How do I merge an Excel table to a shapefile in Arcgis pro?

How do I merge an Excel table to a shapefile in Arcgis pro?

How To: Join an Excel spreadsheet (. xls) to a feature class in ArcMap

1. In ArcToolbox, navigate to Data Management Tools > Joins > Add Join.
2. In the Add Join dialog box, select the layer to join in the Layer Name or Table View.
3. Select the Input Join Field in the drop-down menu.
4. Select or browse for the Join Table.

How do I import an Excel spreadsheet into Arcgis?

Adding a Microsoft Excel table to ArcMap

1. Click the Add Data button .
2. Click the Look in arrow and navigate to the Excel workbook file (. xls).
3. Double-click the Excel workbook file.
4. Click the table you want to add to ArcMap.
5. Click Add.

Where to find the join field in ArcGIS Pro?

A button to validate the join is available on this tool’s dialog box for ease of use. The table or feature class to which the join table will be joined. The field in the input table on which the join will be based.

How are fields kept in the join table?

The Input Table can be a feature class (including shapefile) or a table. All fields in the Input Table will be kept during the join. Optionally, you can select specific fields from the Join Table to be added to the output.

How are records matched in the join table?

The records in the Input Table are matched to the records in the Join Table based on the values of Input Join Field and the Join Table Field parameters. Optionally, you can select specific fields from the Join Table to be appended to the Input Table during the join.

How to join a table to a feature in Excel?

The Join Data dialog box is accessed by right-clicking a layer in ArcMap and selecting the Join option. Refer to the following document for steps to join an Excel spreadsheet to a feature class using the Join Data dialog box: Joining attributes in one table to another.