Whilst there are a suite of libraries for importing/exporting data to/from R (the newest arrival is readit which makes it really easy to read most rectangular data) there are occasions when a quick copy and paste from/to Excel is useful.

Andrew Landgraf’s solution is based on two functions:-

# Copy from Excel to R

read.excel <- function (header=TRUE,...) { read.table ("clipboard",sep="\t",header=header,...) }

# Paste from R to Excel

write.excel <- function (x,row.names=FALSE,col.names=TRUE,...) { write.table (x,"clipboard",sep="\t",row.names=row.names,col.names=col.names,...) }

Just copy and paste the two functions functions into R.

To paste data from Excel to R, copy (ctrl-c) the cells from Excel and then run the following in R

df <- read.excel ()

# to write a data set to Excel, simply run this command in R and then paste (ctrl-p) in Excel

write.excel (df)

## One comment on “R-Tip: Copy and paste data from/to Excel”

## Seb Fox

Hi Andrew – I like your functions. I was recently introduced to the datapasta package addin for RStudio: https://cran.r-project.org/web/packages/datapasta/vignettes/how-to-datapasta.html – it is amazing! You might find it useful too