Reports don't display Trademark symbol when opened with Excel

Modified on Thu, 19 Jan, 2017 at 10:39 AM

When attempting to execute a nextINTERACT or myINTERACT report and the data contains unicode such as a copyright/trademark symbol opening the file with Excel does not display correctly when opening the .csv file directly.



To open the file in Excel without the unicode being displayed incorrectly complete the below steps:




1. Save the .csv report but do not open it in Excel 

2. Open a new Microsoft Excel sheet

3. Navigate to the [Data] tab in Excel

4. Under the heading of Get External Data click [Text]

5. Locate your .csv file and click [Get Data]

6. In the Import wizard select the following: 

- Delimited

- Start import at row: 1

- File Origin: 65001 unicode UTF-8/Unicode 6.3 UTF-8

Then click [Next]

7. Check the box for Comma under Delimiters

8. Click [Finish]

9. In the Import Data box select existing sheet and ensure that it begins in cell =$A$1 and click [OK]


This will then display the report correctly

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article