Alternative solution for displaying accented characters in excel ? UTF-8

[reader6886]

Is there an alternative more easier/convienent solution for excel to dispaly the accented chatacters correctly other than by DATA-GET DATA-FROM TEXT/CSV-IMPORT-FILE ORIGIN-DELIMTER route.
I have CSV files that don't get displayed correctly in excel. I have been told its excel encoding problem ( UTF -8). Any different fix than clicking through above process?

 

[reader6886]

That is the CSV file . The scraper does not produce CSV file with notepad icon( if you were expecting that, which i was to be honest!) The icon of the file is changed( to excel) because the csv file is set to open with excel.Hence the excel icon for the file. Deep down and in its true form it is a CSV file.You can right click the file property and find out. When the scraper outputs the file that is what is get. as CSV file.
Cheers.


T

 

[sandy666]

sure, I know but I can download this csv as Excel file, there is no possibility download it as csv. If I download this as Excel file and it can be converted by Excel-online to any other character encoding than UTF-8 (if csv is with UTF-8) so result can be different than you want to

btw. why Power Query is not easy? Imho it is just for these things like this

 

[sandy666]

You can use Notepad++, UltraEdit or even Notepd and some more software to convert this csv to UTF-8 but you want display it in Excel so PQ will be simplest way I suppose

 

[sandy666]

or like this

 

[reader6886]

You can use Notepad++, UltraEdit or even Notepd and some more software to convert this csv to UTF-8 but you want display it in Excel so PQ will be simplest way I suppose

I have notepad++ , could you tell me how I can do that . Thank you.

 

[sandy666]

open csv in Notepad++ then check what kind of encoding is there

if it's different than UTF-8 simply change it to UTF-8 (convert to) and save as

do all on copy not on your original file

but I'm not sure what Excel will do with csv after Notepad++ , maybe change encoding to Excel own encoding, you will need to test it (this is Microsoft only )

 

[reader6886]

open csv in Notepad++ then check what kind of encoding is there

View attachment 22374
if it's different than UTF-8 simply change it to UTF-8 (convert to) and save as

do all on copy not on your original file

but I'm not sure what Excel will do with csv after Notepad++ , maybe change encoding to Excel own encoding, you will need to test it (this is Microsoft only )

Thank you for engaging in this thread. You mentioned notepad++ so I searched around and found a script that does bulk encode in npp. Even though not an excel solution , That was what I needed.
Thanks again.

 

[sandy666]

You are welcome