How to use Kernel Excel Merge Tool?

Here is the detailed step-by-step procedure to merge multiple Excel sheets into a single worksheet or an individual worksheet within a single workbook using our feature-rich Excel merge tool:

Step 1: The home screen of the Kernel Excel Merge Tool. Excel marge tool home

Step 2: Click on the Merge button under the Merge Excel Files option. Click Marge

Step 3: Click on the Add File button to upload Excel files.

Step 4: Select multiple Excel files and click Open. Select files and click open

Step 5: Tick the checkbox of required Excel sheets or tick the checkbox against the Selected path option to select all Excel sheets. Click Next. Tick required files and click next

Select Merge Options

Here you’ll get two options to merge Excel files:

Merge Excel Sheets in Single Worksheet

With this option, all your Excel sheets data will get merged within a single sheet.

Step 6: Select Single Worksheet and click on Browse to select the destination path select single worksheet and click browse

Step 7: Select the required folder and then click OK. provide location and click ok

NOTE: You can even create a new folder if you want.

Step 8: Click on Merge to begin the process. click merge

Step 9: The Excel merge process is completed. Click Open Folder Location to view merged files. process completed click open file location

Step 10: All Excel file data is saved in a single worksheet.. process completed click open file location

Step 11: Click on Save Reports. click save reports

Step 12: Provide the File name and click Save. provide file name and click save

Merge Excel Sheets in Individual Worksheet

With this option, all your Excel sheets data will get merged into individual sheets within single Excel workbook.

Step 6: Click on Individual Worksheets, then click Merge. select individual worksheet and click merge

Step 7: After the process is completed, click on Open Folder Location. process completed click on open file location

Step 8: All Excel files are merged into individual worksheets within one workbook. preview excel data in individual worksheet

NOTE: After merging excel files with any of the given option, you can keep the merge log report in CSV file. Here's how to do it:

Step 9: Click on Save Reports. click save reports

Step 10: Provide the File name and click Save. Provide file name and click save