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.

[@gradschoolhelp3796]

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

[@tetianaytko83]

A massive thank you!!! 🙏🙏🙏

[@kwayaempire1548]

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

[@GerardFunClub]

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

[@dgstat3750]

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)

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

[@docharisht]

Exactly. Spent hours trying to automate in R, and Rcmdr and got stuck with many errors. This simple method is so helpful.

[@jessicacalverley1315]

I never comment on RUclips 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!

[@investornaire6838]

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

[@Harukox33]

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

[@trinam4306]

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

[@danielharold2329]

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

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

[@sakolteeravarunyou6083]

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

[@Jwilb]

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

[@dolce9959]

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

[@sreeramvishnu4154]

Thank you so much. I was looking for this

[@raizo7347]

Rare gem thank you heaps

[@gavinslemp9160]

This is brilliant, thank you so much

[@OmarFaruk-uo1ub]

Very Helpful.....Thank You Very much

[@azharulislam4975]

Thanks man, it was helpful

[@danreb1527]

god bless you!

[@sintayehugedifew1431]

Thank you Dear!

[@tiafitzpatrick569]

I love you..

[@pychiu1218]

thank you sir

[@smnparajuli]

Thanks a lot;

[@raphael4038]

Thanks a lot man!

[@robertgreen8195]

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

[@laxmanbisht2638]

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

[@zahid1609]

Thank You

[@madeeasy7691]

thanks dear

[@laxmanbisht2638]

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

[@mmadcrhi473]

exactly, I have tried multiple codes to export the results tables but could not. I do not know why I feel that R is not friendly in some tasks.

[@tuannguoinghe]

@@mmadcrhi473 That is really sad