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