Forums

Special chars in excel after export csv

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
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
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.
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.