If you click Folder… and specify a folder, all workbooks in the specified folder are added into Workbook list at once. See screenshot:Ĭlick Files… under Add button, you can add one workbook or multiple workbooks into Workbook list. All the opened workbooks and corresponding worksheets are listed in the Workbook list and Worksheet list boxes, you can click Add > Files… or Folder… button to add the workbooks that you want to merge.

In the Combine Worksheets wizard, please select Combine multiple worksheets from workbooks into one workbook option, and then click Next button. Click OK in the following popping up Kutools for Excel dialog.Ģ. Please apply the Combine Worksheets utility by clicking Kutools Plus > Combine. Supposing you have Workbook A, Workbook B and Workbook C, and you want to merge or combine all worksheets of those workbooks into one workbook. Merge / combine multiple worksheets or workbooks into one workbookĬlick Kutools Plus > Combine. Kutools for Excel augments Excel this powerful feature – Combine. But if there are lots of worksheets need to be merged by such way, it will waste much time. When it comes to merge or combine multiple worksheets / workbooks or csv files into one workbook, most of us will think about copying and pasting the worksheets into one workbook.

How to combine excel workbooks into 1