How to Merge Excel Files (Without Using VBA) - 4 Easy Ways

You might be surprised how much time is lost flipping between Excel workbooks trying to find information – especially if you have a lot to sort through. Learning how to merge Excel files will make finding information easier, faster, and more user-friendly (especially if you’re sharing workbooks).

While you can use VBA to combine files, not everyone is familiar with the programming language or creating Microsoft Excel macros. In this video learn four easy ways to merge files without having to use VBA.

00:00 - Introduction
00:51 - Move Copy Sheet
02:19 - Paste Values
04:25 - Power Query From Folder
06:01 - Power Query From Workbook

[rpatel]

I absolutely had to take few min to type a thank you comment here. This video saved me hours worth of good old copy and paste. Have thousand or so downloaded restaurant vendor receipts that I was trying to consolidate to analyze cost increases. This video is awesome....short & simple, but could you slow your speed just a bit. I watched it four times before executing successfully. No big deal, four times time well worth spent. Thank you and keep making!

[Iano]

Best and most comprehensive review of how to do this so thank you. A bit fast but it's a video so I can just pause.

[KateAFury]

You should add on the "Power Query from Workbook"-part that you can actually combine worksheets with different number of columns (as long as the coloumn names for the data you want to combine together are the same), by adding the worksheet with the most/all the coloumns first, and then the worksheets with the fewer coloumns. But your video really helped, thank you so much!

[Goldpoint]

Your explanations are so simple and easy to understand

[gldnkey]

So appreciate this. Very simple, easy and optional. We don't have to search for other possible options as you include them all in. So thank you!

[supersql]

With clear cut explanation like this; and straight to the point with differents possibilities what we want the end result to be... nothing else to do but to "subscribe". and Thanks!

[patriciapetri]

Thank you. I love the way you explain. you made it so simple and step by step!!.

[liakat]

Your explanations are so simple and easy .thanks sir

[ursulabrady]

Thank you, we pull data for ad hoc reports constantly and this is a timesaver.

[maryl]

This is what I really need. Thank you so much! Take care and God bless!

[deedeewatkins]

This is very helpful. Is there a way to use the Power Query where it copies the formals found in the workbooks as well? It's only copying the values.

[stefifigueira]

Thank you very much. U helped me to prepare my report easily 😊

[brandthelmholdt]

This is great! I have created a new table that links multiple files but now I want to add data to the table but when I hit the Refresh Data button it overwrites the data I have entered. How do I stop it from doing that?

[noscream]

Thanks for the video. For the 1st step. How can I use PQ if I have more than 100 files. Is it posible? They do not have the same structure

[AdilZaman-yfky]

Really appreciate this brother. you saved many hours for me.

[brianbaheramouzegarletsbui]

Great work. All is crystal! As advertised! Thank you.

[realebogapetlele]

thank you much, i was able to avoid mistakes and confusion...

[ZohraNur]

Love it! Clear and concise. Thank you.

[ramanamurthy]

I have only MS office 2013 version. Can you help me, to merge multiple workbooks data into one workbook when format of all the workbooks is the same.

[TransformChantel]

Thank you. Is there a video on how to merge instead of appending?