Just use a for loop to add the names. There's probably a fancy *apply way, but for is easy to use, remember, and understand. Start by adding names: names(mylist) = paste0("G", seq(from = 100, by = 1, length.out = length(mylist))) Add SITE column as before: for (i in seq_along(mylist)) {...