I learned using clipr::write_clip()
can easily copy a table to clipboard and then copy to Excel for better formatting.
For a long time, I have problems copy a simple table from R/Rstudio to clipboard, until today. I saw a post from here.
tt1 <- iris %>% head()
clipr::write_clip(tt1)
# Or
iris %>% head() %>% clipr::write_clip()
Then you can copy it to Excel. The format looks good.
For copying table from Excel to R, I use datapasta.