title: Non-Unicode CSV Export from SQL Server Report Server
body: <p>I am using the SQL Server Report Server from Microsoft SQL Server 2005.</p>
  
  <p>In the report server report viewer control, there is a CSV download option.  The CSV download option is currently downloading a Unicode CSV file, which does not load into Microsoft Excel with the correct column formatting.</p>
  
  <p>If I save the Unicode CSV file and convert it to a ASCII file it works fine in Excel.</p>
  
  <p>How can I can I set a report or the SSRS Report Viewer to export CSV as ASCII instead of Unicode?</p>
  
  <p>Thanks in advance for any help with this.</p>