Combining a ton of Excel files into one Excel file
November 6, 2008 11:41 AM Subscribe
How do I combine a lot of excel files into one file?
posted by cashman to computers & internet (11 answers total) 8 users marked this as a favorite
I have hundreds of excel files that I want to combine into one excel file. I want the data from each file to get piled up into one big file, in one workbook. Just imagine if you had individual sports player stats, and you wanted to just see a big long list of player 1 separately, then player 2 separately, then player 3, on down.
suggests a command line solution, but I don't know if that works, plus I'm using .xls files though I know the csv files referenced at that solution are similar.
How do you suggest I do this?