I have an issue which i have been at for two days now. I have read tons of documents online but maybe someone can help me here. So in short for those who dont want to read further is i require to import .csv documents to excel with lots of data which includes some cells with two or more lines in it.

So here is my first .csv file for example using utf16 little endian encoding:

```
Id;Order Date;First Name (Billing);Optional message;
106119;"2016-11-01 \r\n 22:34:00";John;;
94540;"2016-11-01 \n 22:37:33";John;;
94540;"2016-11-01 \r 22:37:33";John;;
94540;"2016-11-01 \n\r 22:37:33";John;;
94540;"2016-11-01
22:37:33";Damien;;

```

From what i read the last line or event the \n lines should be printed in single cell in two lines, but instead excel 15 on OS X recognises \n and goes to next row.

Here is pretty much the same file which also doesnt work:

```
"Id","Order Date","First Name (Billing)","Optional message",
"106119","2016-11-01 \r\n 22:34:00","John","",
"94540","2016-11-01 \n 22:37:33","John","",
"94540,"2016-11-01 \r 22:37:33","John","",
"94540,"2016-11-01 \n\r 22:37:33","John","",
"94540,"2016-11-01
22:37:33","Damien","",

```

I add ,\r\n to end of each line. 

Can someone tell me what am i doing wrong, i am already out of ideas. Again using Office 15 on mac. Ask me an additional questions. I have tried the swift generated .csv file as well as a woocommerce exported file from wordpress which i edited manually to include newlines for cell. Neither work. I dont know what to do. If you do please send me the correct way by editing one of my examples. Thank you in advance.