Skip to main content
Question

Exporting Special Characters to Excel

  • July 1, 2015
  • 4 replies
  • 83 views

sara_hoeffler
Forum|alt.badge.img
When exporting scorecards, we've found that special characters like ü and ø don't show up correctly in Excel.

For example, the account name "A.P. Møller - Mærsk A/S" exports to Excel as "A.P. Mà ̧ller - Mærsk A/S" . Is there a fix for this? This is frustrating for our EMEA teams as they have to do tedeous manual cleanup when exporting scorecards.

4 replies

sumesh
  • Helper ⭐️⭐️
  • July 8, 2015
Hi Sara,

Are you using Office 2011 in Mac? If not, you can set the character set to utf-8 in excel and the characters should be displayed properly.  

Thanks,
Sumesh

gabriel_hobbs
  • Contributor ⭐️⭐️⭐️
  • November 2, 2015
I am using Office 2013 and am seeing this on all Excel exports from Gainsight. I was provided with the following work around from Gainsight support, but find this a (bad) short term solution to a problem which other vendors do not seem to have (i.e. Salesforce - when i export a report from SFDC, I do not get this issue...).

I sincerely hope that Gainsight will look into resolving this issue, as most businesses do not run Google Sheets as their main spreadsheet tool, and following on from comments made at Pulse London, there are a lot of countries in Europe and most of them have special characters in their alphabet.

Work around instructions from Gainsight support:

Option 1

Open the file in Google Sheets

Option 2

On a Windows computer, click "File > New" in Excel.
Click "Data" tab.
Then click "From Text" option. Select the CSV you file you saved from Accompa.
Excel will display "Text Import Wizard".
In step-1 of this wizard:
Select "Delimited" radiobutton.
In "File origin" field - select "65001 : Unicode (UTF-8)".
Click "Next >" button.
In step-2 of this wizard:
Select "Comma" checkbox.
Click "Finish" button.
In the dialog window that appears - click "OK" button.
Excel will display your CSV file - including non-English characters - properly.

lila_meyer
Forum|alt.badge.img+5
  • Gainsight Employee ⭐️⭐️⭐️
  • July 22, 2016
I'm re-opening this 'problem' post because I understand it hasn't been solved to our customer's satisfaction, and assigning it to our reporting product manager for further comment.

sudarshan_vig
  • Contributor ⭐️⭐️⭐️⭐️⭐️
  • July 25, 2016
Hello, I understand the situation wherein there is an encoding issue when it comes to European characters like umlauts, accents etc. Thanks for bringing this up. I will add it to the near term roadmap and will update the thread once we pick it up.
Thanks!