Hi !
I can suggest an option to do this with Power Query.
To combine multiple csv files into one Excel workbook, these are the steps you need to follow:
- Put all your CSV files into one folder. Make sure that folder does not contain any other files, as they may cause extra moves later.
- On the Data tab, in the Get & Transform Data group, click Get Data > From File > From Folder.
- Browse for the folder into which you've put the csv files and click Open.
- The next screen shows the details of all the filles in the selected folder.
In the Combine drop-down menu, three options are available to you:- Combine & Transform Data - the most flexible and feature rich one.
The data from all csv files will be loaded to the Power Query Editor, where you can make various adjustments:
choose data types for columns, filter out unwanted rows, remove duplicates, etc. - Combine & Load - the simplest and fastest one. Loads the combined data straight into a new worksheet.
- Combine & Load To… - allows you to choose where to load the data (to an existing or new worksheet)
and in what form (table, PivotTable report or chart, only a connection).
- Combine & Transform Data - the most flexible and feature rich one.
I hope this will help you !