Generate points from an excel spreadsheet containing Route and County fields.

Discussion created by on Feb 5, 2014
Latest reply on Feb 6, 2014 by rfairhur24
My issue is..... I have an excel table of "projects" that also have fields called route #'s, county, state. I want to create a point shapefile for each project based off those 3 fields. The location does not have to be exact, as long as the project is somewhere on the correct route, in the correct county and state. I have over 1,000 records so I want to either use an ArcGIS tool or python script, or both to do this in a few steps rather than manually digitizing points. Any advice? Example : Project A, Route 83, York County, PA.