Csv file download on mac chinese characters

Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search.

However if I copy a chinese character from somewhere and paste it into a cell, it is able to show the chinese character. The solution that worked for us was to change the font to "Arial Unicode MS". You can do it for just the cells in question or the entire sheet. What does appear when you open the file instead of chinese -- nothing or latin characters? If the latter, then it is probably an encoding difference. Much simple way of viewing Chinese characters. I have a csv file that I am trying to open to view the characters.

All I have to do is save it is a text file and then open it as a delimited file with the comma being the delimiter. Because there are so many encoding systems out there, we have to understand clearly what kind of encoding system was used to create the CSV, and how the application that you open the file with encodes the file. However, if your file is a mix of Chinese and other languages, you will lost characters other than Chinese, because you are not encoding with Unicode.

An alternative solution would be using the Excel Import function instead of double clicking the CSV to open with Excel. Your email address will not be published. Email Required, but never shown. The Overflow Blog. Who owns this outage? Building intelligent escalation chains for modern SRE. Podcast Who is building clouds for the independent developer?

Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer. Linked Related Thanks, this works perfectly with the current Office version of excel! You should save csv file with: df. The Overflow Blog. Who owns this outage? Building intelligent escalation chains for modern SRE. Podcast Who is building clouds for the independent developer?

Featured on Meta. Now live: A fully responsive profile. Reducing the weight of our footer. Visit chat. Linked Related Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. Accept all cookies Customize settings.