How to use Kernel Excel Merge Tool?

Here is the detailed step-by-step procedure to merge multiple Excel sheets into a single worksheet an individual worksheets 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 software will begin merging the Excel files.

Step 10: Upon completion, click OK. process completed

Step 11: Click Open Folder Location to view merged files. Click and Open Folder

Step 12: All Excel file data is saved in a single worksheet.

Step 13: Click on Save Reports. click save reports

Step 14: 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 Browse. select individual worksheet and click merge

Step 7: Provide destination and click OK.

Step 8 Click on Merge. Click Merge

Step 9 Wait till process completes.

Step 10 After the process is completed, click OK.

Step 11: Click on Open Folder Location. process completed click on open file location

Step 12: 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 13: Click on Save Reports. click save reports

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