Issue with Proper Display of Text in 'Export CSV'
Acroxia
Member, PRO Posts: 63
When executing Export CSV from the table, languages other than English do not display correctly. This issue occurs with languages that use UNICODE or UTF-8 encoding.
Comments
Can you give some examples?
Contact me for custom work - Expert GS developer with 15 years of GS experience - Skype: armelline.support
@Armelline Attached is an example. Sorry for the delay. https://drive.google.com/file/d/1pEu0VsTFhkV3K_ufhwyGPT1C_w3ULR92/view?usp=sharing
I'm afraid those export perfectly for me - here's what it looks like in the table and once I export to CSV and open it in Numbers. Perhaps the issue is with the app you're opening the CSV with? Or maybe there's something else going on that I'm missing?
I've had issues in the past with how some exported cells look in the CSV/Numbers, but when imported back into GS they've always been fine.
Could you show how it looks for you when you export?
Contact me for custom work - Expert GS developer with 15 years of GS experience - Skype: armelline.support
@Armelline Sure. Using Mac Creator 1.25.102 and Microsoft Excel. (Mac OS Sequoia, Korean)
Open with Mac Creator and export csv
Open with Microsoft Excel
The exported text (for me at least) is correct, so it seems more likely this is an issue with Excel. Do you see any problems with the actual CSV file if you open it in a text editor? Here's the raw text that gets exported into a CSV for me:
,Text,Text,Text,Text,"EN","KR","JP","CN""","Tuturial","튜토리얼","チュートリアル","教程""","Play","플레이","プレー","表现"Contact me for custom work - Expert GS developer with 15 years of GS experience - Skype: armelline.support
@Armelline It's a problem with Excel. It's solved. Thank you.
So I think (it's been a while). Excel looks for a special bit of text at the beginning of a file to figure out encoding. If you don't have that you need to explicitly tell excel that the file you are importing is UTF-8 or UTF-16 if you're on windows (I think).