[R] Export R output in Excel

Bryan Mac bryanmac.24 at gmail.com
Thu Dec 29 04:58:24 CET 2016

Hi Jim,

Your assumption is correct. When running the analyses in R and want to export the output that appears in the console window to Excel(.csv) file.
I believe it is easier to do if the export it done to an Excel (.CSV) file.

So is there a way to export the analyses in the console window to a .CSV file with the good formatting ?
I am looking to export the whole output if possible. 

I found this code, but it doesn’t cover the whole output of the console. 

write.csv(coef(summary(test)), file=“test.csv”)

My whole output consists of descriptives and regressions. 


Bryan Mac
bryanmac.24 at gmail.com

> On Dec 28, 2016, at 6:33 PM, Jim Lemon <drjimlemon at gmail.com> wrote:
> Hi Bryan,
> When I have to do something like this, I usually go through HTML
> output and import it into MS Word. I am not suggesting that this is
> the best thing to do, but it might get you out of trouble. I'm not
> sure whether importing HTML into Excel will work as well. I assume
> that you are running analyses in R and want to export the output that
> appears in the console window. If so, try producing HTML output with
> the prettyR or R2HTML packages and importing it. There are other ways
> to do this, but the learning curve is steep and you might not want to
> climb it right now.
> Jim
> On Thu, Dec 29, 2016 at 8:45 AM, Bryan Mac <bryanmac.24 at gmail.com> 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.
>> Thanks.
>> Bryan Mac
>> bryanmac.24 at gmail.com
>> ______________________________________________
>> 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.

More information about the R-help mailing list