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.