Use weather converter to convert csv to epw

edit

I'm not sure how well this will work for you but one possibility is to use the Elements weather file converter/editor.

Although Elements does not (yet) have a direct CSV import/export, one possible thing you could do is to create a new (blank) weather file in Elements.

You can start by editing the header information to match the target site (it's important to do this first before you try to paste solar data).

Then, column by column, cut and paste your CSV data onto that blank file. You'd have to take care to work with the "Variables to Hold Constant" pull-down within Elements as you cut and paste so as not to mess up previous data you've pasted in already.

See the Elements documentation for more details. You can use the Add/Remove columns button to display fields that aren't shown by default.

There is a tutorial along these lines here.

With regard to solar data, there is another question here on UnmetHours that helped a user deal with cutting and pasting solar data updates into Elements.

It's all still a quite manual and a bit messy but could be faster than trying to figure out the EnergyPlus Weather Converter tool if you're only planning on building a couple of weather files.

In the interest of full disclosure, I helped build Elements, so I may be biased here.

Best of luck!