Assigning location data from a points feature to a different excel file

ThomasHamming

I have an existing points feature containing the locations and names of all addresses in a city. I have another excel file with a list of people who live at each address. For purposes of seeing how many people live in a specific area, I want to assign each of the people in the excel sheet to a point location based on their address. What is the best way to go about doing this with these 2 data sets? Thanks!

ABishop

Hello Thomas,

First, I would export both the feature (class or shapefile?) and the excel file into a file geodatabase.

Then I would geocode the converted excel file table from the file geodatabase.

Lastly, I would do a spatial join using the feature class to geocoded table (1 to many).

You can then use this newly joined data and export it for use in your project.