Sometime copy required data into clipboard and read it from clipboard is convenient way.
Try select some data in spreadsheet by 'Ctrl-c' then using the following program load it into R object.
********************************************
a<- read.table("clipboard", header=T, strip.white=TRUE)
a