How to resolve issue with " Â " appears before currency sign?
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.