11/12/2023 0 Comments Select excel as default for csv on mac![]() I was initially convinced that there had to be an option somewhere, but there isn’t. It just won’t write the proper UTF-8 encoding into the file. ![]() To make matters worse, if you put UTF-8 characters into an excel file and try to save it as CSV, it will generate garbage. The file will open, but any non-ascii characters will have been totally butchered. At least in version 2011, Microsoft Excel for Mac cannot open a CSV file with UTF-8 characters. As it turns out, you can’t even get off the ground this way. ![]() I naively assumed I would be able to do the same on Microsoft Excel for Mac. I assumed this would be easy, since back in the Windows world I had edited lots of CSV files using Windows Excel. Someone sent me a CSV file, and I needed to make some edits to one of the columns that included adding a bunch of characters with diacritics (ä or ú). Much to my surprise, Mac’s are horribly deficient at editing a CSV file that has UTF-8 characters in it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |