# Exporting Data

There are numerous methods for exporting R objects into other formats . For SPSS, SAS and Stata, you will need to load the foreign packages. For Excel, you will need the xlsReadWrite package.

## To A Tab Delimited Text File

```
write.table(mydata, "c:/mydata.txt", sep="\t")
```

## To an Excel Spreadsheet

```
library(xlsx)
write.xlsx(mydata, "c:/mydata.xlsx")
```

(To work with R and Excel, try this interactive course on importing data in R.)

## To SPSS

```
# write out text datafile and
# an SPSS program to read it
library(foreign)
write.foreign(mydata, "c:/mydata.txt", "c:/mydata.sps", package="SPSS")
```

(Alternatively, to practice importing SPSS data with the **foreign** package, try this exercise.)

## To SAS

```
# write out text datafile and
# an SAS program to read it
library(foreign)
write.foreign(mydata, "c:/mydata.txt", "c:/mydata.sas", package="SAS")
```

## To Stata

```
# export data frame to Stata binary format
library(foreign)
write.dta(mydata, "c:/mydata.dta")
```

(Alternatively, to practice importing Stata data with the **foreign** package, try this exercise.)