Special chars in excel after export csv

ma martinmarcos 03 Jul, 2018
I managed to successfully export to a csv, but i have a problem with some special chars. I have reviewed all possible encodings and formats, and everything is in UTF-8. I'm pretty sure the problem is that the file is encoded in UTF-8 without BOM. If i open it with notepad and save the file without make any change it works perfectly in excel, but i want to know if there's something i can do to avoid this step
​
Thank You
Gr GreyHead 03 Jul, 2018
1 Likes
Hi martinmarcos,
​
The simplest solution is probably to import it into Excel using the Data > From Text setting. That should give you control over the import settings.
​
Or you can use a PHP action to custom code your own export settings.
​
Bob
da darkarturo 30 Aug, 2019
Hi bob, i need u help please.
​
I am currently using the CSV Export [GH], but I don't know if I have to do a custom code and what code to use and where and how to put it please I would appreciate your support.
Gr GreyHead 31 Aug, 2019
Hi darkarturo ,
​
Please check the Help tab in the action. They should answer most of your questions.
​
Bob
This topic is locked and no more replies can be posted.