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

[Hadley Wickham]

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

-- 
http://hadley.nz

[[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.

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

[John Kane]

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: govo...@gmail.com
> Sent: Fri, 2 Sep 2016 13:03:20 +0200
> To: r-help@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@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.

__
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.

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

[Erich Neuwirth]

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

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

[Kai Mx]

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.