title: Export-Csv .csv file is not properly formatted
body: <p>I have this line of code that gets me all the AD users from my Active Directory server but when I look the CSV file it generates (open with Excel) then the file is not formatted properly.</p>
  
  <pre><code>Get-ADUser -Filter * -SearchBase "DC=mydomainname, dc=local" |
      Select-Object name, samaccountname |
      Export-Csv -path "\\mypcname\c$\ADusers.csv" -NoTypeInformation -Encoding UTF8
  </code></pre>
  
  <p>I expected the output to be like:</p>
  
  <pre>
  Column1 Column2
  Jon Doe JDoe  
  </pre>
  
  <p>And it is:</p>
  
  <pre>
  name,"samaccountname"
  Guest,"Guest"
  </pre>
  
  <p>all in one column.</p>
  
  <p><strong>Edit:</strong></p>
  
  <p>Requested screenshot:</p>
  
  <p><a href="https://i.imgur.com/07qYHw3.jpg" rel="nofollow noreferrer"><img src="https://i.imgur.com/07qYHw3.jpg" alt="Excel screenshot"></a></p>