Occasionally you may notice that characters that appear to be correct in BuzzStream will not be represented accurately after you open your CSV file in Excel. This is due to a Microsoft Excel issue where are all CSV files are opened in Excel with the assumption that text is formatted as ASCII Text.
This issue can be corrected in MicroSoft Excel 2007 and 2010 for PC. MicroSoft Excel 2011 for Mac does not resolve this issue.
To correct this issue you must import the BuzzStream CSv file into Excel and set the Character encoding.
Export the CSV file and Save it. DO Not open it.
Go to Excel 2007 or 2010. Open a new worksheet. Click on the Cell A1. This is the where the data will be imported.
Find the Data tab, in the Get External Data group, click From Text.
Locate and double-click the BuzzStream Export file that you want to import.
Set the file Type as Delimited and the Character format from options as Unicode UTF8. Click Next.
Select the Delimiter of the file to Comma using the checkboxes. By Default the export format from BuzzStream is comma separated. (Some accounts may be customized to use Semi Colon's or Tabs. Choose the delimiter set in your BuzzStream if your exports are not comma delimited. If you are unsure check with the owner of your BuzzStream account.)
Click Import to finish.