title: How to write Unicode output to .csv to be used in Excel?
body: <p>I have a data set containing Chinese characters that I worked on using UTF-8 is processed. Part of the data looks like this:</p>
  
  <pre><code>encod   cKeyword
  UTF-8   &lt;U+5169&gt;&lt;U+7528&gt; &lt;U+5305&gt; 27 bloide herme
  UTF-8   &lt;U+593E&gt; &lt;U+62C9&gt;&lt;U+934A&gt; &lt;U+9577&gt; loewe
  UTF-8   &lt;U+5169&gt;&lt;U+7528&gt; &lt;U+5305&gt; &lt;U+8FF7&gt;&lt;U+4F60&gt; 31 lim pashli phillip
  UTF-8   &lt;U+5305&gt; &lt;U+624B&gt;&lt;U+62FF&gt; givenchy pandora
  </code></pre>
  
  <p>When I use <code>write.csv(data, "file.csv", fileEncoding = "UTF-8")</code> , I get a .csv file that when opened displays the exact same thing in Excel. But I need the Unicode to be displayed as its Chinese character.</p>
  
  <p>How can I get it to write Chinese characters instead?</p>