[R] [FORGED] Export R output in Excel

[Bryan Mac]

Hi Rolf,

I wanted to export the output/results of R to an Excel file for easier comparisons/reporting. When I tried to copy and paste my output to an excel file the formatting was off.
I want to export my descriptive stats and the linear regression.

I googled “Export R output to excel” but did not find most of the hints “useful”. if anything, it got me more confused. 

Thanks.

Bryan Mac
bryanmac.24 at gmail.com



> On Dec 28, 2016, at 3:15 PM, Rolf Turner <r.turner at auckland.ac.nz> wrote:
> 
> On 29/12/16 10:45, Bryan Mac wrote:
>> Hi,
>> 
>> How do I export results from R to Excel in a format-friendly way? For
>> example, when I copy and paste my results into excel, the formatting
>> is messed up.
> 
> 
> Short answer:  *Don't*.  ("Friends don't let friends use excel for statistics.")
> 
> Longer answer:  Googling on "export R data to excel" yields lots of "useful" hits --- "useful" given the (false) assertion that it is useful to export things to excel.
> 
> cheers,
> 
> Rolf Turner
> 
> -- 
> Technical Editor ANZJS
> Department of Statistics
> University of Auckland
> Phone: +64-9-373-7599 ext. 88276