In this post I’m going to show you how you can take multiple .csv files and merge them into a single .csv or .txt file. The process is very simple and should take a couple of minutes to complete.
For my example I have created four .csv files which contain 3 rows of the letters A, B, C & D. See below.
| A.csv | B.csv | C.csv | D.csv |
 |
 |
 |
 |
STEPS TO CREATE YOUR MERGED CSV OR TEXT FILE
1.Create a folder to store all of the .csv files you would like to merge e.g ‘All csv files’ on your C drive.
2.Open notepad and add this text ‘copy *.csv Merged.csv’ (If you want to produce a text file this text will be ‘copy *.csv Merged.txt’)
3.Save the text file to the ‘All csv files’ folder and call it ‘Process’ (the name can be whatever your choose) and change it’s extension to .bat
4.Double click the Process.bat file and you will see that a .csv file is created in the C:\All csv files folder called ‘Merged.csv’.
5. Open your Merged .csv file and you will see that all of your data has been successfully merged. In my example the consolidated data is as follows :
Seriously like the fresh appear. I liked this content. Thanks a lot for a quality post.