title: excel cannot recognize newline character in a csv file
body: <p>I wrote the output of a python code to a csv file. The output needs to contain newlines inside, so I wrote '\n' where I needed them. However, when I open this cvs file in Excel, I see no newlines and the character '\n' is printed instead. I tried '\r\n' too but I doesn't work. </p>
  
  <pre><code>"chart_num, weekday, average, std_dev \r\n 214, 0, 2726, 658"
  </code></pre>
  
  <p>The above string is part of the csv file. How can I change the row in excel where '\r\n' exists?</p>