Replace Pioneer Home All Examples Free Download

500.Text merge -- How to merge two or more csv files with different columns into one file?

User: editor -- 2010-05-07 << 499 501 >>

Hits: 609

Type: Text merge

Search all Text merge examples

Description:

How to merge two or more csv files with different columns into one file?

I have some csv files that have differenct columns, but all of them have same number of lines, how to merge/join them into one big files?

Input Sample:

file1.csv
a1,a2,a3
b1,b2,b3
c1,c2,c3

file2.csv
A1,A2,A3
B1,B2,B3
C1,C2,C3

Output Sample:

output.csv

a1,a2,a3,A1,A2,A3
b1,b2,b3,B1,B2,B3
c1,c2,c3,C1,C2,C3

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open first csv file
2. open menu "File->Load->Column Append file to page"
* word output delimter: select "other", and input a comma(,) at the following entry.
* click Next, and select the second csv file.
3. repeat step2 and open the other csv files one by one.
4. ctrl-s save to result file.

Similar Examples:

How to merge two or more files which have same file names? (64%)
How to join hundreds of columns in different files into one csv file? (62%)
How to parse all the fields in different segment from a text file? (60%)
How to merge two text file base on the value of first column and do sort? (60%)
How to merge more columns into one column in multiple csv files? (58%)
How to count and sort the occurrence of different numbers in a text file? (58%)
How to replace one content of same files with different contents ? (58%)
How to move a list of files that in different folders to a common folder? (57%)

Check Demo of Text merge

Keywords:

different columns column append repeat merg merge text merge same append file append number of lines how to output into different columns of the same csv file merge csv files with different columns merge csv files into one different columns merge csv files different columns merge csv files number of lines merge csv with different columns merge two csv files different number of columns merge two lines into one