title: Open .csv file containing special characters in Excel
body: <p>I have a system that exports a .csv file and some of the rows contain special box characters such that the data looks like this:</p>
  
  <pre><code>Please specify the primary type of opportunity which you’re proposing:
  └─ Please specify what type of sport:
  └─ What is this person’s vocation?
  └── How long have they been in the industry?
  </code></pre>
  
  <p>However, when I open the file in excel, Excel warps the box characters so that it ends up looking like this:</p>
  
  <pre><code>Please specify the primary type of opportunity which youâ€™re proposing:    
  â””â”€ Please specify what type of sport:   
  â””â”€ What is this personâ€™s vocation?    
  â””â”€â”€ How long have they been in the industry?  
  </code></pre>
  
  <p>The file is being saved as plain-text to the user's hard drive, and I can open it in a text editor and see the characters fine, so I know it's something happening when Excel reads in the data. </p>
  
  <p>Any thoughts? How can I prevent this?</p>