Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Strange characters in results export

  • tuesday
  • tuesday's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 7 months ago - 6 years 7 months ago #157825 by tuesday
Strange characters in results export was created by tuesday
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: 6 years 7 months ago by tuesday.
The topic has been locked.
More
6 years 7 months ago #157829 by jelo
Replied by jelo on topic Strange characters in results export
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
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose