Display .csv files from UBot Studio in Microsoft Excel UTF-8 to ANSI

Notepad++ utf-8 to ansi

By default UBot Studio saves the file in UTF-8 format.

UTF-8 files cannot be displayed correctly in Microsoft Excel, which can be annoying if you would like to work with tables in excel.

Save your table in UBot Studio to csv:

save to file("{$special folder("Application")}\\details.csv", &details)

Navigate to your saved .csv file and open in Notepad++

In the main toolbar in Notepad++, click on:

Encoding > Convert to ANSI

Save file

In Windows Explorer navigate to your .csv file and double click to open in Excel.

The file should now open and display correctly without any of the strange character encoding that occurs in UTF-8 files.

Be the first to comment

Leave a Reply

Your email address will not be published.