I have exactly the same problem with French version of Excel. The problem arises from the fact that only an English version of Excel will correctly read a *.cvs file, because of 2 problems: a) the separator used (comma "," for some languages or semi-colon ";" for other languages) and the character set being used.
Try this, it works ok for me in French version of Excel:
1- When you do the CSV export of your questionnaire responses, change the *.csv extension to a *.txt extension before saving the file to disk. For example, save it as responses.txt
2- Open Excel.
3- In Excel, Open File / Filetypes: Text files: *.prn, *.txt,*. csv / open your responses.txt file
4.On the next Excel screen, Excel might or might not automatically detect that your data is "delimited", if not, then check the Delimited radio button
5. On the same screen, File Origin: in the list of character encodings, select 65001: Unicode (UTF-8).
6. Next screen: Separators: check the "comma" check-box
Next...
And you get your correct data!
| RESPONSE | SUBMITTED_DATE | COURSENAME | GROUPNAME | USER_ID | FULLNAME | USERNAME |
| 4 | 11/09/PM 16:09:47 | Análise da Taxa de Juro | Não Grupo | - Unknown - |
