Please help me to save CSV as UTF-8 with BOM

Discuss
, ,
1

I have a variable containing the following data (in Arabic):

1, أحمد, علي
5, فهد, سعد

I successfully saved it as a CSV file. However, when I open it in Google Sheets or Excel, the text appears as unreadable symbols. I can view it correctly in Excel only if I manually change the encoding.

I want the data to display correctly in Excel without requiring the user to adjust the encoding settings. I believe saving the CSV file using UTF-8 with BOM might solve the issue. However, after two days of searching and trying different solutions, I still haven’t found a way to make it work.

Any help would be greatly appreciated. Thanks!

2

try the UriEncode method from the web component
Taifun

3

I appreciate your help.
This is my first project, and I don’t have the level of experience you might expect.
Could you kindly provide me with a simple example?

222
222559×202 31.6 KB

0001111
0001111723×315 58.8 KB

It did not work

4

any help please

5

Show us some Do it results

use the companion app together with Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps

see also Live Development, Testing and Debugging

Taifun

6

CSV_K.aia (222.3 KB)

FAILD

7

hi…any help?

8

Instead of creating a csv file you could upload the data directly using this method

See also

Taifun

9

Thanks I’ll try it