Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

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

martinmarcos 04 Jul, 2018

Thanks

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.

2Checkout.com

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com