How to Combine Multiple Excel Files with Power Automate

Need help with your project?

Todays tutorial features our most requested question 😲

How to combine multiple Excel files using Power Automate? If you have watched our recent videos we have focussed on how we can source information using Power Automate but in todays video we demonstrate how you can combine all files within a folder into a single Excel file.

In this power automate tutorial we demonstrate how with just a few simple steps you can combine all files within a folder into a single Excel file. This has been one of our most common questions and we are excited to finally bring you a solution.

WHAT IS POWER AUTOMATE?
Power Automate (previously known as Microsoft Flow) is a cloud-based automation platform that allows users to create and automate workflows across a variety of applications and services. It enables users to automate repetitive tasks and processes, such as data transfer and synchronization, email notifications, and approval requests. Power Automate includes a range of connectors that allow users to connect to a wide range of applications and services, including Office 365, Dynamics 365, Azure, and other third-party applications. It is a powerful tool that can help users save time, reduce errors, and improve efficiency in their workflows.

MORE TUTORIALS

#powerautomate #excel #tutorial #combinefiles #append

[EssentialExcel]

I hope you enjoyed this tutorial 😃 If you did please give it a LIKE... and don’t forget to SUBSCRIBE for even more content!

[cswann]

Liked and subbed. This happened to be exactly what I need for a project my boss has me doing. Power Automate is a legit Superpower.

[QuynhNguyen-optx]

This video is great! Is there a video for combining Excel files in OneDrive with an Instant Cloud?

[MaryAnn-yipw]

Awesome video. I was able to accomplish my objective. Thanks.

[karlahillam]

Hi There, Your Power automate screen looks completely different to mine. How do I get to the ACTIONS side bar? Would some help getting to the start screen. Please and thankyou

[imamuddin]

It also works for copying/merging csv files into an excel file.

[mohabassam]

Hi, Thank you man it was very helpful
I tried it on my files which have two sheets in each workbook each sheet have diffirent table and the template file have the same structure as the separated files
when running the flow it only gets the second sheet data and combined them in the result output file
first sheet was skipped.

is there a fast solution for this? to go through all sheets one by one moving all rows to the right output sheet in the template file.

[FrancesLaw-jxbd]

Thank you for your detailed tutorial. Does this steps work for Power Automate web version as well?

[LearnLearn-ov]

can we do it from Power automate online version ?

[rogeriopenna]

Some of the Excel files I want to merge have empty rows in them (they are generated elsewhere, which is exactly why I need to merge them)

Will that result in `the GET FIRST FREE ROW ON COLUMN instruction finding rows in the middle middle of the filled rows?

Example:

1 - finds first free row (row 2), copy contents of file A and pastes on Output file.
2 - file A however, 5th row was empty and then had 100 filled rows.
3 - iterates to 2nd file
4 - finds first free row on Output file. It should be row 106 (file A's 4 filled rows, 1 empty row, 100 filled rows),
5 - pastes content of 2nd file starting at 6th row instead of 106th row!

??

[anandraichura]

Dear, Thanks a lot for amazing tutorial video. I have used Power Automate for first time and was able to create merge file following steps mentioned here. However, even though last step is save as but template file is getting saved with data of merging.

[TwiztidWicked]

Great tutorial! I have a question and maybe its not possible as I cannot find this without using software, but is there any way to have each of the files you are combining to become their own worksheet in the workbook? I have logs that get created daily as separate CSV's and I don't want them all one on worksheet when combine, I need them to be tabulated at the bottom. Any help would be greatly appreciated.

[cathylammertijn]

Hi, thanks for the video, works perfectly except ... my Excel file contains several time fields, while running the flow fields are converted to a decimal number. Can you prevent this? Can you also dynamically determine the filename you are creating? With for example the current date in the name?

[dzxe]

Hi, this is amazing stuff, however my question is what if one of the files you are trying to combine is dynamic; so in my case, I have two files I would like to combine. They have same properties etc etc. One of the files is generated via an API using power automate, however it only creates 2 months worth of data when the flow runs once every month. My second file is a master file that contains historical data. at the moment, I do this manually once every month where the new data generated from the API flow to the master file. Is there a way to automate the process of appending the API generated file to the master file, master file should only have new API generated data added to it. Any help would be appreciated, thanks.

[siriuspotter]

Hi, this flow is working fine, but I am not able to open the excel which I have consolidated all the files to, once the flow is done. Any idea why this is happening ? Thanks!

[jasoncox]

If the files explored in initial step have multiple sheets does it only take data from the first sheet? If so, How do you make it retrieve from more than one sheet?

[mdnelson]

I am wanting to merge files where the first 6 rows have headings, is there a way to compensate for that? I saw where at the end where you were able to toggle that the first row has headings, but can it go more advanced?

[hindmusallam]

Can I do the same task with word file to excel sheet instead of excel to excel?

[shubhabratadey]

The only issue is in Power Query, you don't need the Columns in the same order but here we would need them to be in a specific order

[OMAKEM]

Interesting but power query is much more easy to get the same result