ExcelMergeTool

1.Merge Sheet Recover Same Name Sheet 

Merge Sheets in many different Excel files into destination Excel file, if there is a same name Sheet in destination file that Sheet will be recovered. 

2.Merge Sheet Rename Same Name Sheet 

Merge Sheets in many different Excel files into destination Excel file, if there is a same name Sheet in destination file then give sheet a new name and merge the renamed sheet into destination file.

3.Merge Rows into Specified Sheet 

Merge Rows in many different Excel files into specified Sheet in destination file. 

4.Merge Rows into Same Name Sheet 

Merge Rows in many different Excel files into same name Sheet in destination Excel file. If there is no same name Sheet then rows will ignore. 

5.Merge Rows into Create Same Name Sheet 

Merge Rows in many different Excel files into same name Sheet in destination file. If there is no same name Sheet then create it first and merge rows into it. 

6.Merge Cells with Same Row Column Structure

Merge Cells in many different Excel files which sheet have same row and column structure into destination file according Templet file. 

7. Merge Cells with Same Row Structure 

Merge Cells in many different Excel files which sheet have same column structure into destination file according key column (setting in textbox ?Key column? ) and Templet file. 

8. Merge two Excel files into New by key column 

Merge two Excel files A and B into destination file according key column?s value. (File B?s rows will be merge with File A?s row when their column?s value are equal, Set destination file and File A are same can improve merge speed 5-10 times, but for safety you?d better backup File A before merge) And with this mode you can also fill File A with File B?s value. 

9. New Excel File rows share by A and B 

Merge rows in Excel file A and Excel B into a new destination file that key column?s value appeared both in Excel file A and in Excel B 

10. New Excel File Rows only in File A 

Merge rows in Excel file A and Excel B into a new destination file that appeared only in Excel file A. 

11. Compare Excel File A and B 

Compare cell in Excel file A and B, mark the difference (made font color red and bold) on the destination file and output to Compare Report File. (Set destination file and File A are same can improve compare speed 5-10 times, but for safety you?d better backup file A before compare).

More Detail Please Download User Guide