title: What is the right CSV encoding for c# to open with Excel?
body: <p>I write a CSV with my C# CSVWriter based on a StreamWriter.
  In my data I have a lot of special characters like "Bávaro".</p>
  
  <p>So when I use UTF-8 or ASCII to encode my CSV I can't get the "á" but I can open it in Excel afterwards perfectly.
  When I use Unicode my CSV has the correct char but in fact when I open this CSV in Excel it doesnt get automaticly sorted like my other CSV, all values are in the first column as string.... </p>
  
  <p>What is the right encoding here?</p>