php - How to properly encode the special chars coming in the CSV -

i working on product import magento using advance data flow profiles , facing common special chars issue coming in csv have tried htmlspeicalchars function , utf8_encode encoding values disturbing working of ganon php parser have html pages grabbing data , making csv of products.

this annoying , has been 2 days pulling hair solve this. idea on how solve this.

you correct using these functions, though make sure use decode before using/showing values. e.g.: ut8_decode()