Weird Character output Field Collection data with Views Data Export (CSV) I am using Field Collections on a content type, in Drupal 7. I am exporting this data as a Views Data Export with these collections. I can get everything to print out, however, I get a weird special character and I cannot seem to get rid of it. Below is the output. I don't like the way it looks but getting rid of the special character is paramount. 

Name of Conference:Â Conference TypeTitle of Abstract:Â Testing each field and its meritsAuthors:Â Tim Snip, Fish Head, Testing Page, Water CupCity:Â AtlantaState:Â GACountry:Â U.S.A.Date:Â June, 2018


I have been clicking every check box and testing everything I can but not luck. Is there a way to get rid of this? or find out why it is even showing up?
You have UTF-8 characters in your data. The Â character in your case is a UTF-8 non-breaking space, but it's being rendered with the wrong encoding.

You might be looking at the output in something that can't render UTF-8 correctly (some old, dumb text editor), or if you're using something that does understand UTF-8, perhaps the wrong encoding (i.e. iso-8859-1) was chosen when you opened the csv.