French Text appear as ????? | XM Community
Solved

French Text appear as ?????

  • 9 October 2018
  • 5 replies
  • 22 views
christopeter
Rank
Userlevel 3
Badge +1
Hi All,

We are uploading the data from one survey to another using CSV. After the data is imported we noticed that our open end responses which were in French in original survey becomes ???? in new survey. Can someone suggest how to deal it.
icon

Best answer by PeeyushBansal 9 October 2018, 17:37

View original

5 replies

MohammedAli_Rajapkar
Rank
Userlevel 7
Badge +20
Can you try CSV with "unicode utf 8" format?

Please check below link for guidance

https://www.nextofwindows.com/how-to-display-csv-files-with-unicode-utf-8-encoding-in-excel
Regards, Mohammed Ali
christopeter
Rank
Userlevel 3
Badge +1
Hi Mohammedali,

This link is for reading unicode CSV in excel. Qualtrics exported CSV is already utf8 formatted.

Thanks anyway for your search.

Christo
TomG
Rank
Userlevel 7
Badge +27
@christopeter,

You have to save the csv as a Unicode Text file from Excel (which is tab delimited), then upload it.
PeeyushBansal
Rank
Userlevel 7
Badge +33
You can directly pull tsv file from one survey and import in other, doing so your special characters or non English verbatims will appear correct. But this import will happen in table format not in legacy.
Best Regards, Peeyush
christopeter
Rank
Userlevel 3
Badge +1
Tsv export and import worked for us. Those who have similar issue can use this support page also
https://www.qualtrics.com/support/survey-platform/contacts/csv-upload-issues/

Leave a Reply


Terms & Conditions