Import CSV with UTF-8 into Excel for Mac
Excel for Mac 2011 does not support UTF-8 in CSV files. On Windows you can simply add Byte Order Mark (BOM) to the file and it will open correctly in Excel. This does not work on Mac. You can try importing the file with different encoding and some people declare success with UTF-16 Little Endian, but for me this simply does not work.
The best solution that I have found is a script made by Konrad Foerstner, which I have improved little bit, to support different colum delimiters.
Download the script from Github https://github.com/brablc/clit/blob/master/csv2xlsx.py, install library for writing Excel format sudo easy_install openpyxl.
Now you can covert the file from CSV to XLSX.
Categories: MacOSX, Missing Answers
The prefered way of installing python libraries is: pip install openpyxl.
Reasons: http://stackoverflow.com/questions/3220404/why-use-pip-over-easy-install
But pip does not seem to be on my Mac while easy_install was. How to get pip? It seems it comes with “brew install python”, but is not that overkill?
Well, there’s one way to do it: easy_install pip:)
http://docs.python-guide.org/en/latest/starting/install/osx.html