I don't think you can skip the first row while connecting CSV. Tableau 9.0 has included a feature called data interpreter that automatically detect the data part of a worksheet. Follow the links for more information.
Is there any provision to change the format of your data? If so then remove the first row then connect. You can automate this writing a macro in excel.