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