Dear ODK committee members,
I designed some text-type questions in the xlsform, which are answered by written Chinese. I downloaded the submitted data but the Chinese text couldn't display properly. Any ideas how to fix it?
Welcome to the ODK forum, @Caixia ! We're glad you're here. When you get a chance, please introduce yourself on this forum thread. I'd also encourage you to add a picture as your avatar because it helps build community!
This could be an encoding problem on the spreadsheet tool side. You should try to force the encoding while opening the csv to UTF8. Are you using Microsoft Office? It can be troublesome when dealing with CSV files. I've heard that LibreOffice tends to have fewer issues.You might also try searching the internet for general guidance on opening CSV text files in Excel, for example: