- Thank you received: 0
Help me!! incorrect export Thai text to excel
- analizer2010
- Topic Author
- Offline
Less
More
12 years 2 months ago #1912
by analizer2010
Help me!! incorrect export Thai text to excel was created by analizer2010
- bert
- Offline
Less
More
- Thank you received: 749
12 years 2 months ago #1913
by bert
Replied by bert on topic 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
The following user(s) said Thank You: analizer2010