Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

merge excel files into one workbook


I would like to create a flow, which will automatically add new excel file on onedrive to workbook as a separate sheet.


Is it possible?



Community Support Team
Community Support Team

Re: merge excel files into one workbook

Hi @koreluk,


Could you please show a bit more about WorkBook?

I suppose that you want to add a new excel file from OneDrive to WorkBook which is a Advertising SoftWare Suite automatically in Microsoft Flow. Is it true?

The WorkBook connector is not supported in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:


Best regards,



Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: merge excel files into one workbook

Hi @v-xida-msft,


It sounds a bit more complicated that what I meant:) I am not familiar with WorkBook as a tool.

In other words: my idea was to merge different excel files into one and make it not a one time event with the help of macros, but do it constantly as soon as new file is added to onedrive.

Or you are mentioning same?


Thank you!


Bets regards,


Level: Power Up

Re: merge excel files into one workbook

Koreluk, did you ever figure anything out in this regard? I'm looking to do exactly the same.


Level: Powered On

Re: merge excel files into one workbook

Hello @SA_NYC!


I am doing this via Power Query and I adore this option:-)

This will work only if your file structure are identical.

You can check this option from Data tab --> Get Data --> From File --> From Folder

Here you enter folder path, where your files are stored and then Edit your File template from any file in the folder.

After finalizing transormation process, all your files are in one table.

Whenever you are adding or removing files, all these updates will be reflected in summary table.


Let me know if you need any other assistance.


Best regards,



Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!


Microsoft Learn

Learn how to build the business apps that you need.


Power Platform World Tour

Find out where you can attend!


Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (4,603)