Bootcamp mac for free. Nice tip, helped me exchange tab delimited files containing greek text between Windows & Mac versions of Excel and at the same time such '*.csv' files are imported into Excel for Windows silently with a double click. Regarding Excel for Mac, a VB script can likely save tab delimited unicode files with the extension '.csv' and also bypass any warning messages on save and on exit.
As an amateur in VB, I added such a script along with a custom button to a template named 'Personal.xlsb'. UTF-8 with a BOM isn't a real solution. It just smells like one from a distance. It will give you trouble if you Open the CSV with Excel and then save. The BOM gets stripped, and if you open it with Excel a second time, your characters are now messed up.
How can I get Excel to properly display accented characters in the CSV file saved from Accompa? If you use Microsoft Excel to open the CSV files, everything works fine when the file contains just English characters. Select 'ANSI' from the 'Encoding' field. Then click 'Save'. Open this new CSV file using Excel. How do I use Windows Excel shortcuts on the Mac version of Excel? Update Cancel. A d by GitKraken. What are good Git GUI clients for Mac? GitKraken is cross-platform, has a beautiful UI, is easy to setup/use, has smooth integrations & is free. What are the major disadvantages of Microsoft Excel on Mac? What features does Microsoft Excel for.
UTF-16 supports every character UTF-8 does. It just does it in a totally incompatible way - whereas every character takes two bytes. Making your code read UTF-16 is however less easy, particularly if you're not familiar with working with multiple encodings. Presuming you're not operating natively in UTF-16, at some point in the process you need to convert UTF-16 to something you do operate in like UTF-8.
You could even do something as simple as just converting the uploaded file at the time of upload with a tool like iconv.
Am I missing something here? When you use the Text Import [ Data> Get External Data> Import Text File] method the first page of the Text Import Wizard provides an exhaustive list of formats in the File origin menu. Granted, it defaults to Macintosh, but UTF-8 is included in that list in both Excel 2011 & 2016. Also, I created a UTF-8 CSV using Apple's Numbers & Excel 2016 opened it right up without hesitation using File> Open. Excel 2011 opened it readily as well, but I had to select Enable: All Files in the Open dialog in order for the file to be recognized. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.