Buy Now
Sign in

Special chars in excel after export csv

martinmarcos , July 03 at 11:59
M
martinmarcos
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
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
M
martinmarcos
Thanks