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

Подписаться 38 тыс.

Просмотров 189 тыс.

50% 1

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.
Learn Excel the FAST way, find out how here 👉 www.excel-university.com/yt
Check out 7 Excel Time Hacks Everyone Should Know here • 7 Excel Time Hacks Eve...
Subscribe here 👉 / exceluniver. . and turn on all notifications 🔔 for MS Excel time hacks that will make you more productive!
Watch VLOOKUP Hacks Playlist here ru-vid.com?list...
Watch VLOOKUP vs SUMIFS Playlist here ru-vid.com?list...
Watch Dynamic Arrays playlist here ru-vid.com?list...
Watch Treasure Maps playlist here ru-vid.com?list...
Watch Slow to Fast playlist here ru-vid.com?list...
00:00 - Introduction
00:51 - Move Copy Sheet
02:19 - Paste Values
04:25 - Power Query From Folder
06:01 - Power Query From Workbook

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 103

@rpatel8978 3 месяца назад

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!

@KateAFury 5 месяцев назад

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!

@gldnkey7 11 месяцев назад

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!

@ExcelU 10 месяцев назад

Thank you, glad it was useful!!

@stefifigueira598 Год назад

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

@PaulEBrownbill 3 месяца назад

Excellent again. thanks Paul

@kellystclair1 10 месяцев назад

THANK YOU!!!! Amazing!

@darienwashington510 Год назад

Thank You. Life Saver

@ankitbishnoi4067 Год назад

Save a lot of time great job 👍

@ursulabrady5024 7 месяцев назад

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

@OnnYari 2 месяца назад

i love it. thanks for your sharing

@killmenothing 3 месяца назад

Made my work easier! Thanks!

@jelespuru 3 месяца назад

Great video. Thank you!

@sofeaathirah2741 4 месяца назад

THANKS SIR ITS WORKED ON ME! 😊

@vanipolishetty2667 9 месяцев назад

thank you, it helps a lot...

@patriciapetri4792 Год назад

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

@ExcelU 10 месяцев назад

Thank you for your kind note :)

@supersql8406 8 месяцев назад

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!

@ExcelU 8 месяцев назад

Thank you so much ... and welcome :)

@manishshhete1094 11 месяцев назад

thanks it helped. so easy.

@maryl1993 10 месяцев назад

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

@ExcelU 8 месяцев назад

Glad to hear it!

@Iano51 4 месяца назад

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.

@ExcelU 3 месяца назад

Glad it was helpful!

@riajulhaque Год назад

Thanks for the useful tutorial. Can i store the merged file in the same data folder in MS teams/ Sharepoint?

@suhaskurse 3 месяца назад

Thank you very much Sir

@Goldpoint3295 Год назад

Your explanations are so simple and easy to understand

@ExcelU Год назад

Thank you :)

@laibaahmad2361 2 месяца назад

really appreciateeee thisss thankyouu

@wayneedmondson1065 Год назад

Great! Thanks Jeff!!

@ExcelU Год назад

Thanks Wayne!

@INDERJEETSINGH-pq7st 4 месяца назад

Very nice and well explained

@deedeewatkins9478 4 месяца назад

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.

@patanirfan6146 9 месяцев назад

Thank you

@ZohraNur Год назад

Love it! Clear and concise. Thank you.

@ExcelU Год назад

Thank you :)

@ddarbela 8 месяцев назад

Excellent video great instruction saved awe loads of time.

@ExcelU 7 месяцев назад

Great to hear!

@samuelsen3656 Год назад

Very nice. Thank you for the video.

@ExcelU Год назад

Thank you :)

@rahulr6236 6 месяцев назад

Super helpful

@iakovospapaioannou7202 8 месяцев назад

Best video on this subject :) thanks!

@ExcelU 8 месяцев назад

Glad it was helpful!

@liakat26 Год назад

Your explanations are so simple and easy .thanks sir

@ExcelU Год назад

Thank you :)

@realebogapetlele6908 Год назад

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

@ExcelU 10 месяцев назад

You are very welcome ... glad it helped!

@abararahmed9402 3 месяца назад

THNX

@cadubidu Год назад

Genius. Love'ya

@aira170 Год назад

Very useful and easy to understand

@ExcelU Год назад

Excellent … thanks!

@noscream6 5 месяцев назад

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

@AustinBrook5 Год назад

Is it possible to use power query to consolidate all the tabs into one workbook while keeping all of the tabs separate? I have all of my files into one folder, but would like to bring all of their sheets into one workbook but in separate tabs still.

@brandthelmholdt4362 4 месяца назад

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?

@George-lp3qb Год назад

Underrated Channel, Thanks

@ExcelU Год назад

Thanks for your compliment George!

@ulrichknop9281 Год назад

Is it possible to link excel from another computer? For example computer 1 is where you input the data and computer 2 is where the output is?

@subhank42 Год назад

usefull video

@user-ty1eg4vq9q 5 месяцев назад

Thank you!!!

@ExcelU 4 месяца назад

Welcome!

@khadijakh8130 5 месяцев назад

Thank u so much ❤

@ExcelU 4 месяца назад

Always welcome

@AdilZaman-yf1ky 9 дней назад

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

@ExcelU 12 часов назад

Glad I could help

@sivareddy3745 9 месяцев назад

It is good Brow.

@goonie79 Год назад

Are there instructions for the online version of this?

@minetoobin9762 13 дней назад

from folder isn't an option for power query on mac. Choose data source and excel workbook etc/ no "folder" option.

@prashantsingh1892 Год назад

Okay tell me one thing…if i have highlighted few column in the first sheet and when i want to combine two sheets then how to get the same format after combining??!

@lubogeorgiev6922 8 месяцев назад

Tanks a lot :)

@ExcelU 7 месяцев назад

You're welcome!

@fenniemotsi6890 3 месяца назад

Hi, I tried the power query workbook and everything was fine but the file was not accurate. The date was just missed placed. Is they a way, I can do it differently. Thank you !

@TransformChantel Год назад

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

@ExcelU Год назад

I have several videos that show how to use power query to merge, this one is perhaps the most detailed: m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mGYyZ8RWfJc.html Hope it helps! Thanks Jeff

@HaiderKhan-xc8xp 4 месяца назад

While using power query from folder, how to make the first two rows of each sheet disappear.

@nerlynboc156 11 месяцев назад

excellent

@ExcelU 10 месяцев назад

Thanks!

@Rg-ph8mf 2 месяца назад

how to merge the different excel files in one excel but in different columns instead of raw?

@MrShaggy789 5 месяцев назад

How do you consolidate multiple worksheets with different row amounts. I am trying to merge eight worksheets together but each worksheet has a different number of rows. (worksheet 1 has 612 rows, worksheet 2 has 571 rows, worksheet 3 has 377 rows etc...). As each worksheet corresponds to the same item, I wish to have all the data from all the worksheets merge by row 1, row 2, row 3 etc... Having them merged in a stacked formation as you have shown wont produce the result I'm trying to achieve. Any guidance for this would be great. Thanks.

@maryprajutha2657 10 месяцев назад

ok every thing worked but in the of power query from workbook when i load only one workbook is loading nothing else is showing it says null what should i do?????????

@Danielm316 29 дней назад

I appreciate you but it was too fast for me new to these perhaps you . I just want to combine three workbooks containing multiple sheets into one workbook how which method should I ? Thank you

@saravanannataraju7243 11 месяцев назад

How to import group of excel file data which password protected , while importing power query getting cannot import password protected workbook error

@stevendont3928 5 месяцев назад

Question: How do I get multiple worksheets on a single workbook and am able to sift through them via a dropdown list where the information for that specific worksheet appears? This video was very informative, but I have yet to find a way to accomplish merging multiple worksheets on a single worksheet on any given workbook. Thanks

@ExcelU 5 месяцев назад

Interesting idea for a future video! Questions: I think I understand that you have one sheet (eg, the Admin sheet) with a drop down that provides a list of data source choices. And then you want to select a single data source name from the drop down and have the values from the selected data source appear on the Admin sheet. If so, is all of the data combined into a single Table? (So that the data source is identified in one of the data columns, and we just need a formula to return all of the rows from the table where the drop down selection matches the data source column) Or, is data stored in separate worksheets throughout the workbook? (So that the formula will need to use the sheet name from the drop down and then retrieve the data from the selected sheet). Let me know, it sounds interesting :)

@AlphaRules24 Год назад

It says 73 errors detected! What happens to these errors? Are you not included in the new file?

@utsavmaidankar 6 месяцев назад

Hi, Can you please make a video to combine multiple workbook into one workbook. Note: Each workbook contain multiple worksheet

@ExcelU 3 месяца назад

Hi @utsavmaidankar I have created a new video to answer this question: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_8jIwyj1AYw.html I hope it helps :) Thanks Jeff

@Pureyog 3 месяца назад

If I want to merge 3 file and row are 5 millions in total, how to do it

@user-jc2gr4wg6d Год назад

can I refresh the merge files if ever I made an update in raw file?

@ExcelU Год назад

Yes, to do so use the Data > Refresh All button in Excel :)

@rodneysibanda6522 Год назад

is there a video if we have to do this on a recurring basis?

@piyako3586 Год назад

How do we combine worksheets with different set of columns and different data say for example property quarterly annual median all have 5 columns and some have 10 column

@suvendubiswas3978 21 день назад

I am not getting the 'get data' button

@rizwanwaheed3073 Год назад

what if data is more then 1 million rows

@ExcelU Год назад

Power query will process more than a million rows, however excel can’t hold more than a million rows on a given sheet. So, depending on what you are working on, you could aggregate the results in power query by using the Group By command to send a summary to excel (instead of all rows).

@konli 7 месяцев назад

OK !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

@Whosaidsneedfirst Год назад

excel stoner

@feloniousmonk321 Год назад

Too fast. I'm a learner. Slow down. It's also very confusing because you haven't properly explained whether each workbook needs to be open before this can work.

@joukenienhuis6888 11 месяцев назад

You are right that he goes too fast, assuming you know the menus of Excel. He does show before the first step that he has multiple copies open of Excel or as it is called multiple workbooks and only one copy of Excel. On the View ribbon you see an area that is called windows. There is one option to select that has a pulldown option and is called Other Windows. If you select that, like he did, you see the open workbooks in the pulldown.

@francesdobbins2964 4 месяца назад

He speaks too quickly. He's confusing me.@@joukenienhuis6888

@VONALEXANDRIA 11 дней назад

This is too fast! 🤦🏼‍♀️

@ExcelU 12 часов назад

You can slow down the playback speed in RU-vid controls

@hanrealistic 8 месяцев назад

The last one... Instead of adding them as row, can we do that as columns.. Imagine a table with 4 columns pulling data from one sheet, now I'd like to add another column on to that from another sheet.