"text" type does work with the input of multiple languages?

[Tun_Lin_gpt]

Can we use "text" type with the input of other languages? I have used this "text" type to input using other languages. Then after converting(output) the files into *csv file, I see as below. I cannot solve this problem. Please anyone explain or solve this problem? I use ODK briefcase to export the data collected.

[Grzesiek2010]

Hi @Tun_Lin_gpt

is it after sending a form to Google Sheet?

[Joseph_E_Flack_IV]

My organization collects data in written languages that use scripts other than the roman alphabet, such as Amharic. We don't use Google Sheets, personally. When exporting the data from Aggregate or using briefcase, we are able to see non-roman alphabet text. As Grzegorz suggested, I would try that.

[Tun_Lin_gpt]

It happens after exporting from Aggregate.

[Tun_Lin_gpt]

How do you export the data collected? We got only csv file when we export the data from Aggregate or briefcase?

[LN]

Are you trying to open a CSV in Excel? If so, please see

Arabic language in ODK

Excel is terrible at importing CSVs with Unicode characters. Try the following... Open Excel Import the data using Data-->Import External Data --> Import Data Select the file type of "csv" and browse to your file In the import wizard change the File_Origin to "65001 UTF" (or choose correct language character identifier) Change the Delimiter to comma More at http://stackoverflow.com/a/6488070 and http://office.microsoft.com/en-us/outlook-help/choose-text-encoding-when-you-open-and-save-file…

[Tun_Lin_gpt]

Hi LN Thanks a lot. Now I have tried and that works well.

Thanksssssssssssssssssssssss