title: Convert Text file to Excel
body: <p>I have text files that I convert into Excel by copy/pasting them into Excel then go to DATA -> Text to Columns.</p>
  
  <ol>
  <li>Then I choose Delimited.</li>
  <li>Then select Delimiters Tab and Semicolon.</li>
  <li>In the last step I choose Text for all fields.</li>
  </ol>
  
  <p>Now I want to automate this by making a program in C#.</p>
  
  <p>I will do some editing on the data in the Excel file. That could make a new Excel file if a specific column which would have a specific name and so on. So from one text file I could end up with three or four Excel files.</p>
  
  <p>What are the relative merits of:</p>
  
  <p>read the text file into a string/list then check the data then write the data to different Excel files?</p>
  
  <p>or  </p>
  
  <p>use a TextToColumn() method in C# then start the editing then write it to a new Excel file?</p>
  
  <p>If there are any other, better ways to accomplish such thing then please suggest.</p>
  
  <p>EDIT: I see a lot of 3rd party suggestions, but I would like to do it myself so I can learn.</p>