Import multiple .xls files with Lat, Longs in to arcmap

[Arvindzte]

Hi,

I have around 100 .xls files with Lat,Longs that I want to batch import in to ARCMap.

Is there a tool in Arcmap that can do this or a code to execute? please advise.

[DavidPike]

How are you with python? i.e. if I gave you some code samples could you string it together?

also:

these are points I guess? are they all in the same folder? what do you want the output names to look like and what are the current name formats? what coordinate system? you say import but do you want to go to shapefile, feature class etc? are the x, y field names all the same?

[Arvindzte]

Thanks for your response David.

I am not familiar with Python codes but willing to start learning.

Yes these are points and are in the same folder in the .xlsx format. All the worksheets have same count of columns and FIELDS  with Lat, Longs. I think it is NC,SC coordinate system which is I assume UTM zone 17North (NAD83). The import can be in a .shp file or .kml file or all the Lat,Longs in one .csv file so I can plug and play.

[DavidPike]

Cool, i think merging into one file is the best then.  I have a ready-to-go script but it's using pandas, i guess thats not in your library? 😞

[Arvindzte]

No it does not.