I recommend you reverse the process:
1) batch convert your excel files to csv (there are multiple tools out there: google for your preferred solution, search for "Batch Excel To CSV Converter" or similar)
2) use some VB script to add the header row to the csv files, instead as to the excel files! CSV are basically text files, so they are much easier to handle.