title: Java - Open CSV - .csv to .xls extension
body: <p>We have generated a .csv file using Open CSV library in java. Our requirement is to change the extension from .csv to .xls . </p>
  
  <p>When we changed the extension blindly(in java code) by renaming the file name to .xls in java, the data is not aligned or formatted properly. </p>
  
  <p>In .csv file when we open it with excel values inside table are aligned properly. But when we change to .xls and open it, everything is comma separated values and populated inside one column i.e., the values in table are not populated under respective column. Please find below the screenshot.</p>
  
  <p><a href="https://i.stack.imgur.com/3LJcZ.png" rel="nofollow noreferrer">enter image description here</a></p>