1. In this example, I have a folder with 47 text files and all the files have the same columns but with different data and a different number of rows. I will combine them all together using excel.
2. In Excel go to Data > Get Data > From File > From Folder
3. Select your folder
4. In the window that pops up select Combine > Combine & Load
5. The next window shows a preview of the first file. Click OK.
6. This will combine all the text files together in one big excel table.
