title: Automatically convert csv file into Excel table?
body: <p>I generate some csv files using a script. Next I manually convert those csv files into excel tables using the import wizard in excel based on:</p>
  
  <p><a href="https://www.youtube.com/watch?v=z5Pxil4jVO4" rel="nofollow noreferrer">https://www.youtube.com/watch?v=z5Pxil4jVO4</a></p>
  
  <p>Is it possible to do this automatically - e.g. by calling an excel importer from command line - so I don't need to open excel and do all the manual work?</p>
  
  <p>I can open the csv file directly in Excel but its not formatted as a table. E.g. this csv file:</p>
  
  <pre><code>a,b,c
  a,b,c
  </code></pre>
  
  <p>results in this Excel sheet:</p>
  
  <p><a href="https://i.stack.imgur.com/famAt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/famAt.png" alt="enter image description here"></a></p>
  
  <p>I would like each letter to be in a separate column.</p>
  
  <p>I have looked at this:</p>
  
  <p><a href="https://social.technet.microsoft.com/Forums/windowsserver/en-US/370ee470-f2cd-4f30-a167-b106dd51d47a/powershell-convert-csv-to-xlsx?forum=winserverpowershell" rel="nofollow noreferrer">https://social.technet.microsoft.com/Forums/windowsserver/en-US/370ee470-f2cd-4f30-a167-b106dd51d47a/powershell-convert-csv-to-xlsx?forum=winserverpowershell</a></p>
  
  <p>but its an awful lot of boiler plate code from create a simple table.</p>