How to Merge Multiple CSV Files into One Excel Workbook

Let’s say you have a team working on a project and each of them created a CSV file. You are left with a considerable number of CSV files that you have to analyze and collect data from. Obviously, opening each CSV file and copying all the data from them onto a new CSV is a tedious task. How about you get it done with a single command though?


ADVERTISEMENT

In this article, we explain in the most simple steps on how you can easily merge multiple CSV files into a single excel workbook. Read on, to learn how!

Step 1: Copy all the CSV files that you want to merge onto a single folder.

In the example below, I need to merge cars.csv and products.csv. So they are copied onto a folder named Geek Page CSV Merge.

 

1 Folder Csv Optimized

 

Step 2: Launch the Run window by pressing the keys Win + R together. Once it launches, type in cmd and hit Enter key.

 


ADVERTISEMENT

7 Run Cmd Optimized

 

Step 3: Once the Command Prompt launches, navigate to the folder where you have copied your CSV files at. You can use the CD command for changing the directory in Command Prompt.

Once you are at the desired folder, type in the following command and hit Enter key.

copy *.csv <name_of_your_merged_file.csv>

Please replace name_of_your_merged_file with a name of your choice. Remember to give the extension as CSV.

 

2 Copy Command Optimized

 

Step 4: Now if you look at your merging folder, you can see that a new CSV file is created, by merging the other CSV files present in the folder.

Double click on the new file to open it in excel.

 

3 Newworkbook Optimized

 

Step 5: When the file opens in excel, click on the File tab at the top.

 

4 File Optimized

 

Step 6: As next, click on the Save As option from the left ribbon. Choose the location where you want to create your new workbook at. I have chosen the same merging folder for this step.

Note: You can use the Browse button and choose any location of your choice.

 

5 Save As Optimized

 

Step 7: In the File name field, give a name to your new workbook. Click on the drop-down menu associated with Save as type. Choose Excel Workbook from the list of options. Hit the Save button once you are done.


ADVERTISEMENT

 

6 Save File Optimized

 

Step 8: That’s it. If you now look at the location that you chose to save your new workbook at, you can see that a new file has been created. This file is a Workbook file created by merging all your required CSV files. Enjoy!

 

7 File Saved Optimized

 

Hope you found the article useful.

ADVERTISEMENT