This Excel Drag & Drop File Merger Will Save You Hours

Still wasting time copying and pasting from multiple Excel files?
There’s a much easier way—and it starts with a simple drag and drop.

In this training, I will share with you the simplest file merger tool you have ever used. Simple drag and drop any number of excel files, in any order, select a destination workbook, and in just one click, all workbooks are merged.

In This Video, You’ll Learn:
✓ How to design a clean, drag-and-drop interface from scratch
✓ Merge unlimited files in any order
✓ Use new or existing destination workbooks
✓ Automate column formatting and alignment
✓ Track columns even when data varies across files
✓ Build a complete tool with minimal code

👇𝐃𝐎𝐖𝐍𝐋𝐎𝐀𝐃 𝐓𝐇𝐈𝐒 𝐖𝐄𝐄𝐊'𝐒 𝐖𝐎𝐑𝐊𝐁𝐎𝐎𝐊 𝐓𝐄𝐌𝐏𝐋𝐀𝐓𝐄 𝐇𝐄𝐑𝐄:

𝐆𝐄𝐓 𝐀𝐍 𝐔𝐏𝐃𝐀𝐓𝐄𝐃 𝐓𝐑𝐀𝐈𝐍𝐈𝐍𝐆 𝐀𝐍𝐃 𝐓𝐄𝐌𝐏𝐋𝐀𝐓𝐄 𝐖𝐈𝐓𝐇 𝐓𝐇𝐄 𝐅𝐎𝐋𝐋𝐎𝐖𝐈𝐍𝐆 𝐅𝐄𝐀𝐓𝐔𝐑𝐄𝐒:
⭐️ Move Source File Up/Down
⭐️ Remove source from list of source
⭐️ Dynamic Filter Option Added
⭐️ Added sample data files

🛠 𝐍𝐄𝐄𝐃 𝐇𝐄𝐋𝐏?

𝐄𝐗𝐂𝐄𝐋 𝐂𝐎𝐔𝐑𝐒𝐄𝐒:

𝐄𝐗𝐂𝐄𝐋 𝐏𝐑𝐎𝐃𝐔𝐂𝐓𝐒:


𝐓𝐢𝐦𝐞𝐬𝐭𝐚𝐦𝐩𝐬:

0:00 – Introduction
0:45 – Overview
05:18- How to use Drag, Drop , File Merger
13:29- Create and Designing the Main Sheet
14:32 -Headers- Source, Destination, Data Mapping
18:17- Design the Admin
23:23- Design Source Data Mapping
26:53- Add Icons, Buttons, Pictures
30:06- Filling out Destination Columns
33:33- Use of Active X control
40:33- Assigning of Macros
44:31- Add Destination Workbook
50:24 -Select Workbook
53:58- Source Add a Workbook
54:42- Source Initial Mapping
56:36- Merge Data

𝐅𝐨𝐥𝐥𝐨𝐰 𝐌𝐞 𝐎𝐧 𝐌𝐲 𝐒𝐨𝐜𝐢𝐚𝐥 𝐌𝐞𝐝𝐢𝐚 𝐀𝐜𝐜𝐨𝐮𝐧𝐭𝐬:

𝐀𝐛𝐨𝐮𝐭 𝐔𝐬:
I help Excel enthusiasts turn their skills into passive income—no need to trade time for money. If you enjoy these weekly videos, you can support Excel For Freelancers by grabbing one of our powerful tools to boost your Excel skills and chase your dreams.

New Training Video Uploaded Every Tuesday And Saturday!

𝙏𝙝𝙖𝙣𝙠 𝙮𝙤𝙪 𝙫𝙚𝙧𝙮 𝙢𝙪𝙘𝙝 𝙛𝙤𝙧 𝙮𝙤𝙪𝙧 𝙘𝙤𝙣𝙩𝙞𝙣𝙪𝙚𝙙 𝙨𝙪𝙥𝙥𝙤𝙧𝙩,
Randy Austin

#ExcelFileMerger #MergeExcelFiles #DragAndDropExcel #FileMergerTool #ExcelUtility #MergeWorkbooks #CombineWorkbooks #MergeSheetsExcel

[ExcelDataEntrySheets]

Very informative and useful thank you 👏

[alexrosen]

Just fantastic and very useful in real life 👌

[michellegill]

Randy, I enjoy your videos. It is so refreshing to know that one can create a simple app in Excel especially using VBA. My only concern is when you need to save a file in the cloud like to a Teams folder or SharePoint folder for work purposes, VBA does not work in these environments unless you download to a computer. But not many are keen to do that in a work environment so what is the workaround? Looking forward to your response.

[jean-frederickouame]

That's crazy. I don't want to miss it.

[meka]

Fantastic Project, I know you sent the icons and the background, but can you send the workbooks that you use on this project also?

[MGAa]

But … why would I need this when I can use Power Query to … achieve that as well (merge tables/files etc)? Or is the target audience simply “users who do not use advanced possibilities of Excel”?

[DaTestKa]

Good 👍 would be great to have this for merging bank transactions csv files and also categorised it or use a criteria to matching existing data in the destination sheet and ability to add extra helper column..

[gsali]

Thank you randy
But i have a debug when grabbing files in line
.shapes

[rnunez]

Hi Randy, as you know i'm from latin america. CTRL D, Doesn't work in Spanish language, do you Know something about it?

[Rick-juxq]

Getting this when trying to get the .pdf file & the added zip file....This XML file does not appear to have any style information associated with it. The document tree is shown below.
<Error>
<Code>AccessDenied</Code>
<Message>Access Denied</Message>

<HostId>

</HostId>
</Error>