{"id":39172,"date":"2025-08-20T07:48:16","date_gmt":"2025-08-20T07:48:16","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=39172"},"modified":"2026-02-26T07:53:15","modified_gmt":"2026-02-26T07:53:15","slug":"merge-sheets-by-name-in-multiple-excel","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/exceldatatransformer\/merge-sheets-by-name-in-multiple-excel.html","title":{"rendered":"Merge Excel Workbooks and Merge worksheets by sheet name"},"content":{"rendered":"<p>Want to merge Excel sheets by sheet name from multiple Excel files?<\/p>\n<p>Using Withdata <a href=\"https:\/\/www.withdata.com\/excel-data-transformer\/\">Excel Data Transformer<\/a>, you can merge Excel sheets by sheet name from multiple Excel files, Easy and Fast.<\/p>\n<ul>\n<li>Can run in GUI mode, <a href=\"#combine\">Step by Step<\/a>, just a few mouse clicks.<\/li>\n<li>Can run in Command line, for <strong>Scheduled Tasks<\/strong> and Streams.<\/li>\n<li>Combine Excel files locally and <strong>privately<\/strong>, avoid uploading large Excel file(s) to online services.<\/li>\n<li>Support Windows, Linux, and macOS.<\/li>\n<li>No Excel Installation Required.<\/li>\n<\/ul>\n<p><a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\">Download Withdata ExcelDataTransformer<\/a>  <a href=\"#download-top\" onclick=\"dtv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/download_3.jpg\" alt=\"Download ExcelDataTransformer\" width=\"80\" height=\"22\" style=\"max-width:100%;height:auto;\" \/><\/a> <span id=\"dtv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<p>If you want to merge multiple Excel files (workbooks) into one Excel file (workbook), see this: <a href=\"\/blog\/exceldatatransformer\/merge-excel-workbooks.html\">Merge Excel Workbooks into one with all worksheets<\/a>.<\/p>\n<p>If you want to merge Excel sheets from multiple Excel files into one sheet, see this: <a href=\"\/blog\/exceldatatransformer\/merge-multiple-files-sheets-into-one-sheet.html\">Merge Excel sheets from multiple Excel files into one sheet<\/a>.<\/p>\n<p>If you want to merge Excel sheets in one Excel file into one sheet, see this: <a href=\"\/blog\/exceldatatransformer\/merge-one-file-sheets-into-one-sheet.html\">Merge Excel sheets in one Excel file into one sheet<\/a>.<\/p>\n<h2 id=\"combine\">Merge Excel sheets by sheet name from multiple Excel files<\/h2>\n<p>For exmaple, there are 2 Excel files.<\/p>\n<p>1.xlsx, has 2 worksheets: countries, departments.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/1_countries.png\" ALT=\"countries 1\" width=\"608\" height=\"166\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/1_departments.png\" ALT=\"departments 1\" width=\"608\" height=\"166\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>2.xlsx, has 2 worksheets: countries, departments.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/2_countries.png\" ALT=\"countries 2\" width=\"614\" height=\"169\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/2_departments.png\" ALT=\"departments 2\" width=\"614\" height=\"169\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>Start ExcelDataTransformer, click &#8220;Merge Workbooks&#8221; to start a new task.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/merge-excel-workbooks-new-task.png\" alt=\"Merge Excel workbooks from multiple Excel files - start\" width=\"281\" height=\"209\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\" \/><\/p>\n<p id=\"merge\">Select Excel file folder, enter output Excel file, and then, merge worksheets by sheet name.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/merge-excel-sheets.png\" ALT=\"Merge Excel sheets\" width=\"722\" height=\"632\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>After merging, you can view the output Excel file. The output Excel has 2 merged sheets.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/exceldatatransformer\/merge-excel-sheets-result.png\" ALT=\"Merge Excel sheets result\" width=\"535\" height=\"169\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<hr style=\"clear: both;\" \/>\n<p>More about <a href=\"\/tools\/merge-file\/merge-excel-files\">Excel Merger<\/a><\/p>\n<div id=\"download-bottom\" style=\"clear: both;\">\n<p>Download Withdata ExcelDataTransformer<a href=\"#download-bottom\" onclick=\"dbv.style.display = 'block';\"><img decoding=\"async\" src=\"https:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download ExcelDataTransformer\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a> <span id=\"dbv\" style=\"display: none;\"><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=win64\">Windows 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=win32\">Windows 32 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=deb\">Linux .deb (For Debian, Ubuntu) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=rpm\">Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit<\/a><br \/>\n<a href=\"\/download.php?app=ExcelDataTransformer&#038;ver=pkg\">MacOS 64 bit<\/a><br \/>\n<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to merge Excel sheets by sheet name from multiple Excel files? Using Withdata Excel Data Transformer, you can merge Excel sheets by sheet name from multiple Excel files, Easy and Fast. Can run in GUI mode, Step by Step, just a few mouse clicks. Can run in Command line, for Scheduled Tasks and Streams. [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5948],"tags":[15,13300],"class_list":["post-39172","post","type-post","status-publish","format-standard","hentry","category-exceldatatransformer","tag-excel","tag-merge"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/39172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=39172"}],"version-history":[{"count":5,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/39172\/revisions"}],"predecessor-version":[{"id":45229,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/39172\/revisions\/45229"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=39172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=39172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=39172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}