- Mensajes: 10845
- Gracias recibidas: 3997
Help me!! incorrect export Thai text to excel
- analizer2010
- Autor del tema
- Invitado
12 años 1 mes antes #1912
por analizer2010
Help me!! incorrect export Thai text to excel Publicado por analizer2010
El tema ha sido cerrado.
- bert
- Administrador
Menos
Más
12 años 1 mes antes #1913
por bert
Respuesta de bert sobre el tema Help me!! incorrect export Thai text to excel
Hi analizer2010,
You should focus on CSV export (probably CSV3) as the XLS generated file format will not work with non ASCII characters.
Excel has some trouble recognizing UTF-8 encoding automatically, I'm not sure if there is an 'Open as UTF-8' option.
I suggest you to use LibreOffice ( www.libreoffice.org ) to open those CSV files first , it has an excellent CSV file parser and it will work right away. Then ,if you need to move to Excel or any other format you'll have plenty of options too.
Regards
You should focus on CSV export (probably CSV3) as the XLS generated file format will not work with non ASCII characters.
Excel has some trouble recognizing UTF-8 encoding automatically, I'm not sure if there is an 'Open as UTF-8' option.
I suggest you to use LibreOffice ( www.libreoffice.org ) to open those CSV files first , it has an excellent CSV file parser and it will work right away. Then ,if you need to move to Excel or any other format you'll have plenty of options too.
Regards
El tema ha sido cerrado.