Merge Files and Combine Files – A Quick Way to Combine or Merge CSV Files
Here is a video tutorial on how to mergie CSV files I whipped up for you all. Believe me, if you’ve been merging CSV files by hand, you NEED to learn how to combine CSVs automatically! Best of all? It’s easy, and it’s free.
Let’s go!
Here are the quick steps from that tutorial:
1) Choose Start->Run
2) Enter “cmd”
3) Enter the following:
copy C:\*.csv C:\[filname].csv
…replacing the path and filename with your own information.
4) Hit the enter key.
Enjoy!
*melanie




about 3 years ago
I combined over 2000 csv files into one in a matter of minutes . . . . THANK YOU!!!!
about 3 years ago
Hi Melanie,
That’s great!!
i’ve tested and it’s merge but need some amendmen.
For example i’ve 2 csv files:-
one.csv –
USD1-36864
USD2-47611
USD3-45354
two. csv –
AED1-56
AED2-47
AED3-47
Expected output -
AED1-56
AED2-47
AED3-47
USD1-36864
USD2-47611
USD3-45354
but i got:
AED1-56
AED2-47
AED3-47USD1-36864
USD2-47611
USD3-45354
i dont want any human invention of the file created.
about 3 years ago
Great information! Thanks!
about 3 years ago
Does anyone know how to combine the files such that each file is put into a seperate column? This seems to combine the files in one long column?
about 3 years ago
Guys, I’m so glad this helped you! As soon as I found out how to do this, I knew I needed to share! It’s SUCH a huge timesaver!
about 3 years ago
Hi Melanie,
Thanks for this great video, I cannot tell you how much time you have saved me.
about 3 years ago
That is GREAT… I am sooo glad I found you… I was actually thinking about getting one of those softwares to do this, but now I can do it myself… YES!!!