Many times for a Webmaster, it is required to working with CSV files regularly and Microsoft excel. Sometimes it is required to merge one or two CSV files in to one or it is required bulk CSV merging, I mean combine many csv files in to Single Csv file.
There are many free tools and Many premium softwares are available to merge multiple CSV files in to one Csv file. In this tutorial I am going to explain about how to merge multiple CSV files without using any third party softwares or without taking too much time.
There are two ways to Combine multiple Csv files are to bulk merge the CSV file . The same process also used to merge multiple more than one Excel sheets in to one .
How to join the Multiple Csv files without using any software
Method 1 : This method is simple , open each CSV file with notepad files and copy all the CSV files data in to one Notepad file and save as the file as CSV File format.
To save the notepad file in to the CSV format you should enter the file name as like this “filename.csv” . Don’t forget to place your file name in the quotes along with the .csv extension.
Method 2: This method is “very easiest Process to join more Csv” files in to one . The above process is difficult when ever if your csv files contains 1000s of records . This process is very easy and takes very less time to join more CSV files using MS DOS.
Keep all files in a folder and place the folder in Drive like D:, E:, (not on desktop )
Now open and Run the Windows Command Prompt
Enter in to the Csv files folder Command Prompt , Suppose if I placed the Csv files in a folder named “Merge Csv” in the “D: drive”
Then see the Below commands how i accessed the folder with the commands
to Enter in to the D drive type the Following Command
To enter in to the folder “Merge Csv”
D:>> Cd Merge Csv
Now type the below command to copy all the Csv file data in to the file name “”join.csv”
D:>> Cd Merge Csv>> copy *.csv join.csv
thats it ! you merged all the Csv files data in to the “Join.csv”file
see the above process in action
so you don’t need any excel Vb code or any other software to join the Csv files , you can do the same process for joining the excel files too by converting or saving the excel files in to the Csv files format.
How to join multiple Notepad files or text files (.txt) in to single file
Note : You can also join the Text files (notepad files) in same folder with the same above process
bu the type commands as below