read_excel in Hadley’s readxl package should handle your encoding problems. Writing Excel files on a Mac, however, still is somewhat messy.
And you probably should post this kind of question on r-sig-mac On 02 Sep 2016, at 13:03, Kai Mx <govo...@gmail.com> wrote: > > Hi all, > > I am hoping for some advice on how to handle UTF-8 spreadsheet files in a > Mac environment - sort of off-topic, but still relevant for hopefully a > bunch of people. > > I am using R on Mac OS 10.10. Sometimes I have the urge to actually look at > a large spreadsheet on the big screen or make some changes to the tables. > Since most of my colleagues live in the M$ Excel - world I tend to use > Excel 2011 as well. However, Excel does not handle UTF-8 (which I like > because of different system locales). > So I actually do a write.csv with file-encoding in macroman, but even then > Excel won't just open it and I will have to work my way through the > import-dialogue. > > The other way around, it's even worse. I save the spreadsheet as macroman, > iconv it to utf-8 and then read.csv it to R. > > It works, but it's just really messy. Is there a (preferably light-weight) > csv-spreadsheet Editor for Mac OS that you use? Open-Office? I would like > NOT to actually buy another Excel version. However, for collaboration, a > xls-export would be phenomenal. > > Thanks! > > Kai > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code.
signature.asc
Description: Message signed with OpenPGP using GPGMail
______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.