• R-Tip: Copy and paste data from/to Excel

    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)