Excel
Reading Excel Files in R With readxl Without Surprises
Read Excel files in R with readxl: list sheets, set ranges and column types, handle dates, blanks and names, and write workbooks with writexl or openxlsx.
7 min read
Tag
r
3 posts
CSV
Reading CSV Files in R With readr and fread Safely
Compare read_csv, fread and base read.csv on the same files: type guessing and ZIP codes, ragged rows, bad quotes, the BOM, and speed on 2,000,000 rows.
10 min read
Editor's pick
CSVGuide
Reading CSV Files in Go Java R Rust and C Sharp Compared
Ten languages read the same awkward CSV files: speed on 2,000,000 rows, BOM, bad quotes, ragged rows, leading zeros and defaults that bite, plus a test list.
18 min read