How can we help you today?

Stray characters are appearing in comments when downloading reports in CSV format

This occurs as a result of character encoding. We try to ensure that encoding is maintained from what a user has entered, into The Happiness Index and then out again.

However, we have seen encoding can sometimes change when using CSV, particularly if you don’t open the file as UTF-8 (which I think is the format it is in).

There are two options to resolve this:

  • open the file as UTF-8
  • You can easily find / replace in Excel - as the characters will probably all be ' or “