[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

Erich Neuwirth erich.neuwirth at univie.ac.at
Fri Sep 2 13:10:12 CEST 2016

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 <govokai at 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 at 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.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 670 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20160902/4c6a9ca4/attachment.bin>

More information about the R-help mailing list