Can you put all oy the .csv files is a single folder with no other files?
If so then this should work. "path_to_directory" needs to be changed to your path.
In my case it would be "/home/john/testfolder" .
library(tidyverse)
filenames = list.files("path_to_directory", full.names = TRUE)
myfiles <- lapply(filenames, read.csv)
dat1 <- myfiles %>% map_df(as_tibble)
library(writexl)
write_xlsx(dat1, "myfile.xlsx")
That is why I suggested using dput()
You execute the command **dput(myfile) and paste the output here.