title: Import data from multiple CSV files to an Excel sheet
body: <p>I need to import data from 50 similar csv files to a single excel sheet.
  Is there any way to get only selected columns from each file and put them together in one sheet.</p>
  
  <p>Structure of my csv files: A few columns exactly same in all the files. (I want them to be in excel) then one column with same column name but different data which I want to place next to each other with different names in the excel sheet. I do not not want all other remaining columns from csv files.</p>
  
  <p>In short, </p>
  
  <ol>
  <li>read all csv files, </li>
  <li>get all the columns which are common to all csv &amp; put in excel sheet.</li>
  <li>Now, take one column from each file which has the same header but different data and put one after the other in excel sheet with named from the csv file name.</li>
  <li>Leave remaining rest of the columns.</li>
  <li>Write excel sheet to a excel file.</li>
  </ol>
  
  <p>Initially I thought it can be easily done, but considering my programming skill in learning stage it is way difficult for me. Please help.</p>