French Text appear as ????? | XM Community
Skip to main content
Solved

French Text appear as ?????


christopeter
Level 2 ●●
Forum|alt.badge.img+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.

Best answer by PeeyushBansal

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.
View original

5 replies

MohammedAli_Rajapkar
QPN Level 5 ●●●●●
Forum|alt.badge.img+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

christopeter
Level 2 ●●
Forum|alt.badge.img+1
  • Author
  • Level 2 ●●
  • 57 replies
  • October 9, 2018
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
Level 8 ●●●●●●●●
Forum|alt.badge.img+27
  • Level 8 ●●●●●●●●
  • 5926 replies
  • October 9, 2018
@christopeter, You have to save the csv as a Unicode Text file from Excel (which is tab delimited), then upload it.

PeeyushBansal
Level 6 ●●●●●●
Forum|alt.badge.img+39
  • Level 6 ●●●●●●
  • 1144 replies
  • Answer
  • October 9, 2018
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.

christopeter
Level 2 ●●
Forum|alt.badge.img+1
  • Author
  • Level 2 ●●
  • 57 replies
  • October 10, 2018
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