How to Free Csv merger for Windows 7

0
1547
0 Flares Facebook 0 Google+ 0 Reddit 0 StumbleUpon 0 Pin It Share 0 0 Flares ×

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.

How-to-join-Multiple-csv-files

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

C:>> D:

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

join-csv-files-in-command-prompt

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

join-text-files-in-command-prompt

 

0 Flares Facebook 0 Google+ 0 Reddit 0 StumbleUpon 0 Pin It Share 0 0 Flares ×