I have downloaded the hourly solar radiation data from NREL which is in CSV format but the problem is that the file does not have an exclusive column called latitude and longitude. There are 100s of CSV files like this and each file represents a latitude/longitude (we can say, point location). I have attached a screenshot of the file along with this post. I am not able to figure out how to import it in ArcGIS/QGIS.
The screenshot is for Bangalore city, India. The highlighted portion in red shows the latitude and longitude for the city. Can somebody please help me import this in ArcGIS/QGIS?
Screenshot of the sample file (click to magnify):
Please find the same file attached here: http://www.sendspace.com/file/m9t19n
This file represents hourly solar radiation data for a particular latitude longitude (in this case, Bangalore).
Clarification: Essentially I would like to perform a site suitability analysis for solar for the state of Karnataka, India. My understanding is that, I will have point locations of the station representing the excel file in question, as the attribute. Then I will extract those locations with a certain DNI value, then intersect it with the land use to determine suitability.
I want to have the location of the station as well as all the attributes mapped to the location in the excel. So one location will have the entire excel as the attribute table (.dbf for the shapefile) and so on.