Link to home
Start Free TrialLog in
Avatar of Eduardo Fuerte
Eduardo FuerteFlag for Brazil

asked on

Could you point how to export an Excel sheet to CSV with UTF-8 codepage ?

Hi Experts

Could you point how to export an Excel sheet to CSV with UTF-8 codepage ?

Accordingly to:
User generated image
Saved as CSV it doesn't correctly convert character.
User generated image
Any workaround?

Thanks in advance.
Avatar of leflon
leflon
Flag of Germany image

Hello Eduardo,

do you have the option "CSV UTF-8 (Comma delimited)" in your Save dialog? Or just the regular "CSV Comma Separated Values" entry?

leflon
By the way. You are using which Excel Version?

You might like to give this link a look: https://help.surveygizmo.com/help/encode-an-excel-file-to-utf-8-or-utf-16

hth
leflon
Avatar of Eduardo Fuerte

ASKER

Hi

I'm using  Excel 2016 and found the equivalent...

User generated image
Unfortunatelly when it's opened at Notepad++ it still shows deconfigurated characters.
What I had found is, by using Notepad++

Encoding > Convert to UTF-8 (option without BOM)
ASKER CERTIFIED SOLUTION
Avatar of Eduardo Fuerte
Eduardo Fuerte
Flag of Brazil image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial