How to Use readxl Package in R to Read Excel Files

Use the readxl package in R to read Excel files by calling read_excel() with the file path as the main argument. This function supports both .xls and .xlsx formats and allows you to specify sheets and ranges easily.

Syntax

The main function to read Excel files is read_excel(). You provide the file path as the first argument. You can also specify the sheet name or number with sheet, and limit the data read with range.

• path: The file path to your Excel file.
• sheet: (Optional) Sheet name or number to read.
• range: (Optional) Cell range to read, e.g., "A1:D10".

r

read_excel(path, sheet = NULL, range = NULL)

Example

This example shows how to load the readxl package, read an Excel file named data.xlsx, and print the first few rows. It reads the default first sheet.

r

library(readxl)
data <- read_excel("data.xlsx")
print(head(data))

Output

[[1]]  # Example output depends on the actual file content
# A tibble: 6 × 3
#   Name    Age Score
#   <chr> <dbl> <dbl>
# 1 Alice    25    88
# 2 Bob      30    92
# 3 Carol    22    79
# 4 Dave     28    85
# 5 Eve      24    90
# 6 Frank    27    87

Common Pitfalls

Common mistakes include:

• Not installing or loading the readxl package before use.
• Using incorrect file paths or forgetting to set the working directory.
• Trying to read password-protected or corrupted Excel files.
• Confusing sheet names and numbers.

Always check your file path and sheet names carefully.

r

## Wrong: Not loading package
# data <- read_excel("data.xlsx")  # Error: could not find function "read_excel"

## Right: Load package first
library(readxl)
data <- read_excel("data.xlsx")

Quick Reference

Function / Argument	Description
read_excel(path, sheet = NULL, range = NULL)	Reads Excel file; specify sheet or range optionally
sheet	Sheet name (string) or number (integer) to read
range	Cell range like "A1:C10" to limit data read
col_names	TRUE/FALSE to use first row as column names (default TRUE)
skip	Number of rows to skip before reading data

Key Takeaways

Install and load the readxl package before using read_excel().

Use read_excel() with the file path to read Excel files easily.

Specify sheet and range to control which part of the Excel file to read.

Check your file path and sheet names to avoid common errors.

readxl supports both .xls and .xlsx formats without extra dependencies.