R — Data Export

CSV files

# Base R
write.csv(data, "output.csv", row.names = FALSE)

# readr
library(readr)
write_csv(data, "output.csv")
write_tsv(data, "output.tsv")

Excel files

library(writexl)

# Write Excel
write_xlsx(data, "output.xlsx")

# Multiple sheets
write_xlsx(
  list(sheet1 = data1, sheet2 = data2),
  "output.xlsx"
)

JSON files

library(jsonlite)

# Write JSON
json_data <- toJSON(data, pretty = TRUE, auto_unbox = TRUE)
write(json_data, "output.json")

Database

library(DBI)
library(RSQLite)

con <- dbConnect(SQLite(), "database.db")

# Write table
dbWriteTable(con, "users", data, overwrite = TRUE)

# Append to table
dbWriteTable(con, "users", new_data, append = TRUE)

dbDisconnect(con)

Mini Practice

Write R code that:

1. Writes a data frame to CSV
2. Writes multiple sheets to Excel
3. Exports data as JSON
4. Writes to a SQLite database

Up Next

In the next lesson, you'll learn about Statistics — basic statistical analysis in R.