Kai Mx
2016-Sep-02 11:03 UTC
[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)
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]]
Erich Neuwirth
2016-Sep-02 11:10 UTC
[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)
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>
Hadley Wickham
2016-Sep-02 14:02 UTC
[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)
You can use readr::write_excel_csv() which adds a BOM that forces excel to read as UTF-8. Hadley On Friday, September 2, 2016, Erich Neuwirth <erich.neuwirth at univie.ac.at> wrote:> 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 <javascript:;>> 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 <javascript:;> 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. > >-- http://hadley.nz [[alternative HTML version deleted]]
John Kane
2016-Sep-02 14:25 UTC
[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)
An alternative to Erich Neuwirth's solution might be to use Apache OpenOffice or the (roughly) equivalent LibreOffice. I routinely use UTF-8 with these. John Kane Kingston ON Canada> -----Original Message----- > From: govokai at gmail.com > Sent: Fri, 2 Sep 2016 13:03:20 +0200 > To: r-help at r-project.org > Subject: [R] workflow getting UTF-8 csv in and out of R on Mac > (spreadsheet editor) > > 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.____________________________________________________________ Can't remember your password? Do you need a strong and secure password? Use Password manager! It stores your passwords & protects your account.