title: Creating a CSV with c# that doesnt get "corrupted" by excel
body: <p>I'm generating the head of different CSV files so my users can see the format</p>
  
  <pre><code>var output = new MemoryStream()
  var writer = new StreamWriter(output, Encoding.UTF8);
  //this function gets the row depending of the enumerator name in this format a;b;c;d
  var header = ModelosCsv.GetCsvByEnum("HeadRowFileLoad");
  writer.WriteLine(header);
  writer.Flush();
  output.Position = 0;
  return File(output, "application/csv", "format.csv");
  </code></pre>
  
  <p>The code is creating the CSV correctly but if they open the CSV with excel and save it, excel will overwrite all the ";" for triple spaces.
  If I edit the result with notepad++ and put back the ";" excel won't do it again.</p>
  
  <p>I have opened both archives with excel and clicked "save as", the first one (freshly generated by c#) is set as default as "text archive" the second one (edited by notepad++) is set as CSV.</p>
  
  <p>Am I missing something code?
  How could I do to stop excel messing up my archives?</p>