[R] output my results into Excel

Sarah Goslee sarah.goslee at gmail.com
Wed Mar 2 21:49:08 CET 2016

Hi Michael,

Googling "export R data to Excel" gives LOTS of advice, including
packages that can write your data directly to Excel spreadsheets.

I don't use Excel, so I haven't tried any of those, but using
write.csv() to export your data will create something that my
colleagues who use Excel have no trouble opening.

Printing to the console, as you did by typing the object name, is not
intended to be an export method.


On Wed, Mar 2, 2016 at 3:31 PM, Michael <elopomorph at hotmail.com> wrote:
> I can get R to calculate the distance that I want between my data points.  However, I am stuck trying to get R to output the data so I can paste it into Excel.  Instead, R outputs a matrix mess in the console.
> Below are the steps I am taking to calculate the distance between my data.  Also, I have 42 different data points.
> # Calculate the Euclidean distance between each datapoint using
> # the function dist()
> PRdist = dist(my_data) ;  PRdist
> I would greatly appreciate if someone can tell me how to output my matrix from the dist function into something I can paste into Excel.
> Mike

More information about the R-help mailing list