Why not work with the CSV file and encoding together
The answer is simple - Microsoft excel not support it. Came to do simple experiments (next exercise does not need to know Development). Open notepad- Copy the following text (it is in Hebrew because of the example of the encoding) עמודה 1, עמודה 2, עמודה 3 טקסט 1, טקסט 2, טקסט 3 טקסט 11, טקסט 22, טקסט 33 Now save it with encoding - Unicode. The result you receive a Hebrew - but only one column. Now save it with encoding of UTF-8 Now the columns fine but where the Hebrew? If you try to open the same file in other programs such as One-Note it will work well. My recommendation to work less with CSV (with ms. excel). Yours, Roi