Working with 1000+ excel files to create a shape file
I have downloaded data (wind speed) for india for a state using NSRDB viewer which gave me 1000+ excel files .
Each files has daily wind data for a year for a point location.
Need help on creating a single excel file using 1000+ files which should have point coordinates(Lat & Lon) and average wind speed/year for that point location . I will use that file to import into arcmap to create wind map.
I am assuming that using macros we can achieve this , not sure if that is the right way ?