{"id":30744,"date":"2023-09-04T03:10:59","date_gmt":"2023-09-04T01:10:59","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=30744"},"modified":"2024-05-30T21:00:28","modified_gmt":"2024-05-30T19:00:28","slug":"merge-excel-files","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-excel-files\/","title":{"rendered":"Top 3 Methods on How to Merge Excel Files &#8211; A Step-by-Step Guide"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"aligncenter size-large wp-image-30796\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C-1024x576.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/09\/A79B055A-DE61-482B-9DE0-C39FEC82B88C.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>You may have come across a situation where<strong> data is spread across multiple workbooks and switching between these is becoming cumbersome<\/strong>. This can be<strong> time-consuming and can lead to errors<\/strong> as well.<\/p>\n<p>So, what is the<strong> best solution<\/strong> to solve this problem?<\/p>\n<p>The optimal solution is to merge Excel<strong>\u00a0files into a single workbook<\/strong>. Instead of <strong>manually copying and pasting values<\/strong>, you can effortlessly use any of these<strong> 3 quick and easy <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/compare-two-excel-files\/\" target=\"_blank\" rel=\"noopener\">methods to combine Excel files<\/a><\/strong>.<\/p>\n<p>In this article, we will cover the following methods to merge Excel files &#8211;<\/p>\n<div class=\"contents\">\n<h2>Table of Contents<\/h2>\n<ul>\n<li><a href=\"#1\"><strong>Method 1 &#8211; Excel Move or Copy Feature<\/strong><\/a><\/li>\n<li><a href=\"#2\"><strong>Method 2 &#8211; Paste Links<\/strong><\/a><\/li>\n<li><a href=\"#3\"><strong>Method 3 &#8211; Power Query<\/strong><\/a><\/li>\n<\/ul>\n<\/div>\n<p>Let us explore these methods one by one!<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Merge Excel Files &#8211; <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files.zip\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Merge-Excel-Files.zip<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"1\" style=\"color: #ff0000\">Method 1 &#8211; Excel Move or Copy Features<\/span><\/strong><\/h3>\n<p>Suppose you have <strong>bi-annual sales data of a company in 2 different workbooks<\/strong> and you want to<strong> combine them<\/strong> to get annual sales data in a single workbook. Follow the<strong> steps below<\/strong> to use the copy or move feature to merge Excel files &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Open both workbooks.<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Press <strong>Ctrl + left-click<\/strong> to select all the worksheets.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30766\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-1.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"429\" height=\"549\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-1.png 577w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-1-234x300.png 234w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Right-click and Select <strong>Move or Copy<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30767\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-2.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"437\" height=\"529\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-2.png 615w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-2-248x300.png 248w\" sizes=\"(max-width: 437px) 100vw, 437px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> In the Move or Copy dialog box, Select <strong>Jan &#8211; Jul Sales.xlsx<\/strong> in the Move selected sheets dropdown.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30768\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-3.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"382\" height=\"390\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-3.png 382w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-3-294x300.png 294w\" sizes=\"(max-width: 382px) 100vw, 382px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span><\/strong> Select (move to end) to copy the selected worksheets at the end.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30769\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-4.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"381\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-4.png 381w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-4-294x300.png 294w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6: <\/span><\/strong>Check the <strong>Create a copy<\/strong> option if you wish to retain the original worksheets within the source file. Click OK.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30770\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-5.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"381\" height=\"389\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-5.png 381w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-5-294x300.png 294w\" sizes=\"(max-width: 381px) 100vw, 381px\" \/><\/a><\/p>\n<p>All the copied worksheets will be pasted at the end.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30771\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-6.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"574\" height=\"455\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-6.png 943w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-6-300x238.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-6-768x608.png 768w\" sizes=\"(max-width: 574px) 100vw, 574px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"2\" style=\"color: #ff0000\">Method 2 &#8211; Paste Link<\/span><\/strong><\/h3>\n<p>When you copy-paste the worksheets as mentioned in the method above, only the values get pasted. To<strong> establish a connection between the values<\/strong> in the destination file and the source file, you should <strong>opt for pasting the values as links<\/strong>. In this way, when you<strong> make any change in the source file<\/strong>, it gets <strong>reflected in the destination file<\/strong> as well.<\/p>\n<p>Follow the <strong>steps below<\/strong> to paste the value as a link &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Open the destination workbook and <strong>add a new worksheet named &#8220;Jul&#8221;<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30772\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-7.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"380\" height=\"593\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-7.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-7-192x300.png 192w\" sizes=\"(max-width: 380px) 100vw, 380px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Open the source workbook and press <strong>Ctrl + A to select all cells<\/strong> and then press<strong> Ctrl + C to copy<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30773\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-8.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"390\" height=\"552\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-8.png 703w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-8-212x300.png 212w\" sizes=\"(max-width: 390px) 100vw, 390px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Go back to the destination workbook and go to <strong>Home &gt; Paste &gt; Paste Links<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30774\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-9.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"554\" height=\"434\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-9.png 710w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-9-300x235.png 300w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> You can also select <strong>Paste Formatting<\/strong> to match the formatting in both files.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30775\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-10.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"550\" height=\"585\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-10.png 550w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-10-282x300.png 282w\" sizes=\"(max-width: 550px) 100vw, 550px\" \/><\/a><\/p>\n<p>This method tells Excel to paste a link to the source data rather than just the values. Any changes made to the source data in the source workbook will automatically update in the destination workbook as well.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30776\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-11.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"507\" height=\"454\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-11.png 558w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-11-300x269.png 300w\" sizes=\"(max-width: 507px) 100vw, 507px\" \/><\/a><\/p>\n<p>You can see that Excel has pasted the link to the source workbook rather than pasting the values.<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span id=\"3\" style=\"color: #ff0000\">Method 3 &#8211; Power Query<\/span><\/strong><\/h3>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/free-excel-power-query-training-2021\/\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Microsoft Power Query<\/strong><\/a> is a powerful tool that allows you to transform, consolidate, and merge data from various sources. Suppose you have 3 month&#8217;s data in 3 different workbooks and you want to combine them into a single workbook.<\/p>\n<p>This can be achieved by using <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" title=\"Power Query\" data-wpil-keyword-link=\"linked\">Power Query<\/a> in Excel. Follow the steps below to understand how to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-multiple-excel-files\/\" target=\"_blank\" rel=\"noopener\">merge Excel files<\/a> using Power Query &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 1:<\/span><\/strong> Open a new workbook and go to <strong>Data &gt; Get Data &gt; From File &gt; From Folder<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30783\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-18.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"495\" height=\"476\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-18.png 591w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-18-300x288.png 300w\" sizes=\"(max-width: 495px) 100vw, 495px\" \/><\/a><\/p>\n<p><em>Please Note &#8211; For this method to work, you will have to insert all the files inside a single folder and make sure that the worksheet name is the same for all.<\/em><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 2:<\/span><\/strong> Browse and select the folder. Press <strong>Open<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30777\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-12.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"626\" height=\"390\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-12.png 938w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-12-300x187.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-12-768x478.png 768w\" sizes=\"(max-width: 626px) 100vw, 626px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 3:<\/span><\/strong> Double-check the names of the workbooks and press <strong>Combine &amp; Load<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30785\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"682\" height=\"543\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1.png 1097w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1-300x239.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1-1024x815.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-13-1-768x611.png 768w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 4:<\/span><\/strong> Select <strong>Sheet1<\/strong> in the left panel and press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone wp-image-30779\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"768\" height=\"604\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14.png 1105w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14-300x236.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14-1024x805.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-14-768x604.png 768w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/a><\/p>\n<p>The data from the three files will be combined into a single workbook with a new column named Source.Name. This will help you distinguish which data belongs to which workbook.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30780\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-15.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"457\" height=\"679\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-15.png 457w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-15-202x300.png 202w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 5:<\/span><\/strong> Go to <strong>Table Design &gt; Summarize with PivotTable<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30784\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"1139\" height=\"160\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19.png 1139w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19-300x42.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19-1024x144.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-19-768x108.png 768w\" sizes=\"(max-width: 1139px) 100vw, 1139px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000\">STEP 6: <\/span><\/strong>In the PivotTable Fields dialog box, drag and down &#8211;<\/p>\n<ul>\n<li>Source.Name under Columns<\/li>\n<li>Product Names under Rows<\/li>\n<li>Sales under Values<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30781\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-16.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"435\" height=\"673\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-16.png 435w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-16-194x300.png 194w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/a><\/p>\n<p>The summarized <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-pivot-tables\/\" target=\"_blank\" rel=\"noopener\" title=\"Pivot Table\" data-wpil-keyword-link=\"linked\">Pivot Table<\/a> containing the sales data for the three months will be displayed.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" class=\"alignnone size-full wp-image-30782\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-17.png\" alt=\"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide\" width=\"703\" height=\"629\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-17.png 703w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/Merge-Excel-Files-17-300x268.png 300w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><span style=\"color: #ff0000\">Conclusion<\/span><\/strong><\/h3>\n<p>The article discusses methods for <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells\/\" target=\"_blank\" rel=\"noopener\">merging data from multiple Excel<\/a> workbooks into a single one. The proposed methods are using Excel&#8217;s Move or Copy feature to consolidate worksheets, pasting values as links for automatic updates, and utilizing Microsoft Power Query to combine and analyze data from various sources.<\/p>\n<p>Each method has its benefits and applications, allowing you to select the method that best suits your specific needs.<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-merge-cells-in-excel-definitive-guide\/\" target=\"_blank\" rel=\"noopener\">6 Simple Ways to Merge Cells in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/unmerge-all-cells-using-macros-in-excel\/\" target=\"_blank\" rel=\"noopener\">Unmerge All Cells Using Macros In Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/merge-columns-using-power-query\/\" target=\"_blank\" rel=\"noopener\">Merge Columns Using Power Query<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/support.microsoft.com\/en-gb\/office\/combine-data-from-multiple-sheets-dd7c7a2a-4648-4dbe-9a11-eedeba1546b4\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn more about how to combine data from multiple worksheets.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You may have come across a situation where data is spread across multiple workbooks and switching between these is becoming cumbersome. This can be time-consuming and can lead to errors as well. So, what is the best solution to solve this problem? The optimal solution is to merge Excel\u00a0files into a single workbook. Instead of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":30796,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Top 3 Methods on How to Merge Excel Files - A Step-by-Step Guide","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[121,10],"tags":[1347,1345,1346],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30744"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=30744"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30744\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/30796"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=30744"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=30744"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=30744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}