Hello, I’m trying to do a CSV import into NetSuite, and one of the columns in my file contains Chinese characters. When I import the CSV, the text changes into weird symbols or unreadable characters. However, if I manually copy and paste the same text from the spreadsheet into the NetSuite field, it displays correctly.
Is there a way to accommodate Chinese characters properly during the CSV import process? I’m guessing it may be related to the file encoding format. This is how i have it in my spreadsheet 储存过程中可能会形成结晶。如发生结晶,请在不超过140°F(60°C)的条件下缓慢加热至完全熔化,并在使用前充分混合。and this is how it comes up when imported in 储å˜è¿‡ç¨‹ä¸å�¯èƒ½ä¼šå½¢æˆ�结晶。如å�‘生结晶,请在ä¸�超过140°F(60°C)的æ�¡ä»¶ä¸‹ç¼“æ…¢åŠ çƒè‡³å®Œå…¨ç†”化,并在使用å‰�充分混å�ˆã€‚