write_excel_sheets_to_csv: Export Excel Sheets to CSV Files

In bulkreadr: The Ultimate Tool for Reading Data in Bulk

Export Excel Sheets to CSV Files

Description

This function reads an Excel file, converts each sheet into a data frame, and writes each sheet to a CSV file in the specified output directory.

Usage

write_excel_sheets_to_csv(excel_path, output_dir = "data/")

Arguments

excel_path	A character string specifying the path to the Excel file.
output_dir	A character string specifying the directory where CSV files will be saved. Defaults to "data/".

Value

A list of file paths corresponding to the exported CSV files.

Examples

# Path to the example Excel file shipped with the package
excel_file <- system.file("extdata", "Diamonds.xlsx", package = "bulkreadr")

# Export each sheet to its own CSV in a temporary directory
output_dir <- tempdir()
write_excel_sheets_to_csv(excel_file, output_dir)

bulkreadr documentation built on June 8, 2025, 9:36 p.m.