Whenever I export a csv from any report, if it contains a £ sign, there is always  appears before. How to resolve it please? I am using civicrm 4.6.11, my mysql database characterset is set to "UTF8".

2 Answers 2


My workaround for this is to immediately convert the CSV file in a text editor such as Notepad++ or UltraEdit.

As soon as it's downloaded I open the CSV as UTF8, then immediately save it as ANSI. It's a bit fiddly, but fixes the £ problem, as well as any unusual characters in names/addresses.


When you look at the csv, what software do you use? Are you looking with Excel, and if so is Excel also expecting UTF8?

  • yes, I am using Excel 2013. I didn't understand, what do you mean by " is Excel also expecting UTF8?"
    – Tapash
    Jan 11, 2016 at 9:20
  • Excel also uses encoding to show you the csv file. If Excel is set to a different encoding you will get strange characters. See help.surveygizmo.com/help/article/link/… Jan 11, 2016 at 11:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.