Strange characters in results export

Mehr
1 Jahr 8 Monate her - 1 Jahr 8 Monate her #157825 von tuesday
COM_KUNENA_MESSAGE_CREATED_NEW
When I export results to Excel or CSV format, strange characters appear. For example, quotes are changed to €œ (open quote) and € (end quote). The character  appears in various places. There are others. This has been going on through multiple versions of limesurvey and Excel. I currently have Excel 2013. Is there anyway to remedy this?
Last edit: 1 Jahr 8 Monate her by tuesday.

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

LimeSurvey Partners
Mehr
1 Jahr 8 Monate her #157829 von jelo
COM_KUNENA_MESSAGE_REPLIED_NEW
That looks like a issue with UTF8 Encoding in the workflow. That can be an issue in the database, in the application or in the browser.

This is not directly related to LimeSurvey and can happen everywhere.
E.g. digwp.com/2011/07/clean-up-weird-characters-in-database/

But first try to change some settings during the import into Excel (or use e.g. LibreOffice to import into a excel file)
www.howtogeek.com/howto/microsoft-office...ext-into-excel-2007/

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users

Bitte Anmelden oder Registrieren um an der Konversation teilzunehmen.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha