Strange characters in CSV after exporting

If your data looks strange with unusual characters like &#*, it is highly likely that your file has been inaccurately encoded. 

CSV exporting works with utf8 encoding.

To understand how to set character encoding, please refer to this article, or any other available articles online.