txt or xlsm) as well, by following this approach.
Firstly, put all the CSV files into a single folder with no other files (if you put it on the Desktop put it in a new folder). With its powerful Combine utility, you can quickly combine multiple xml files or csv files into one workbook or one Excel sheet. If you are not familiar with VBA, do worry, here I introduce a handy tool – Kutools for Excel for you. Import or combine multiple xml/csv files into a sheet or a workbook with Kutools for Excel.