AnsweredAssumed Answered

Adding lots of excel files with X,Y data + attributes

Question asked by ALEEBCIT on Sep 14, 2014
Latest reply on Sep 15, 2014 by riyasdeen_b

I think my problem is quite simple and I might have just overlooked the solution but here it goes. I will try to explain the situation to the best of my ability.

 

I have 300 Excel Workbooks with 3 worksheets in them, each containing different types of data. Of the 3 sheets only Sheet 1 matters and it contains X, Y data in the first 2 columns followed by 2 attributes (name, and description). All of the workbooks follow the same format.

 

Now I'm trying to add in these X,Y coordinates into ArcMap and then convert them into a single shapefile.

I'm looking for a way to automate this or do it quicker.

 

I could always add in X,Y data but as you can imagine it would take forever with so many Workbooks

Outcomes