One-to-many join Excel to shapefile

12-19-2017 07:17 AM
New Contributor

I am trying to complete a one-to-many join. I have downloaded a zip code shapefile and want to join it with some excel data. There are multiple records per zip code in the excel file. I am using ArcMap 10.5.1.


0 Kudos
1 Reply
Occasional Contributor III

I can give you some tips..although you can do this with a direct join (sometimes), i would highly recommend that you :

1.  Import the excel sheet/table into a database (MS Access would work)

2.  While importing, make sure that the field you are joining on are the same data type ie (Text, Integer, double etc) that is in the shape file.  If you are joining in Zipcode and the shape file dbf has it as a "Long Integer" make sure that the imported excel table in step one is a Long Integer as well.  The datatype for the join field must be the same.

3.  From Arcmap - add the datatable you made in step 1 and perform your join.