How to paste R output to excel and word

This is a brief solution for copying and pasting R output to excel or word tables.

[gradschoolhelp]

Step 1) Highlight the output in R and paste to excel

Step 2) Go to the "data" tab and choose "Text to Columns"

Step 3) Select "Delimited" and hit "next"

Step 4) Select the delimiter type "space" and deselect "tab"

Step 5) Clean up formatting by highlighting the entire table, right click, choose "Format Cells", select type "Number", and your preferred number of decimals

Step 6) Copy the data in excel that you want to paste to word, make sure you have the same grid dimensions highlighted in your word table, and paste

[GerardFunClub]

Thank you!! This video helps me reduce some tedious tasks for my final year thesis hahaha

[kwayaempire]

You have no idea how much time you saved me. Great job. Thanks man

[drryangagnon]

Why spend 5 minutes doing something in excel, when you can spend 3 hours failing to automate it in R... nice work dude! this saved me after spending a few hours in semTables.

[dgstat]

Yeah! This is an excellent video. As a researcher, I was confronted with the same problem that this small kid has investigated. Thank you not in millions, but in billions. Dr. Abdul Hannan (PhD)

[jessicacalverley]

I never comment on Youtube vids but this has just SAVED ME HOURS of trying to figure out. Amazing, thank you so much for sharing! A happy PhD student again!

[investornaire]

This tutorial is per excellence. You just solved a huge problem in my Postgraduate Data Analysis . A must watch lesson . No BS. Thank you

[danielharold]

Thank you so much for posting this! I can make regression output tables with R, check texreg, but I had a covariance matrix that I wanted to move to excel but couldnt get it to paste into the cells properly. Now each of the elements has their own cell!!!

[trinam]

Thank you so much!! You saved me so much time on my thesis for my MSc in Finance

[Harukox]

I fully agree with the other comments. You saved me HOURS of work. Thank you so much!

[more_riffage_in_my_diet]

It's been said already but thank you you absolute legend - I just wish I'd found this video sooner!!! Absolute legend.

[sakolteeravarunyou]

Great video. I like the text to column function. It saves my time. Thanks Bros.

[dolce]

omg ur a fucking legend for posting this lol. I've been copy pasting my results for an hour now and was about to go insane

[Jwilb]

Holy shit...you are a lifesaver, thank you SO much

[sreeramvishnu]

Thank you so much. I was looking for this

[robertgreen]

It didn't work well for me since there is a space in one of my dependent variable names. I use the tab_model(model) function

[laxmanbisht]

Thanks, it an easy method, but could you tell how to save output automatically in excel or csv of regression models?

[laxmanbisht]

Thanks! I am geting this error, when I am writing csv.
Error in as.data.frame.default(x[[i]], optional = TRUE, stringsAsFactors = stringsAsFactors) : cannot coerce class ‘c("clogit", "coxph")’ to a data.frame

[tuannguoinghe]

From Stata, feeling really upset when doing some simple things that became over-complicated in R