Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

MS Flow get column data from multiple excel sheet and extract

I want to achive following :


I have 3 excel files and all of them have multiple sheets with same column names.

1) Get  1st  excel , get "UPN" column from each sheet  and append /write to new excel file (into single sheet)

2)repeat same for other 2 excel files.


These excel files i can out it into Sharepoint / Onedrive. and every week new excel file will be added and this files data needs to get extracted into a combined excel sheet

so in short extracting and merging columns data from multiple excel files.


help / pointers are aprreciated.


Community Support
Community Support

Hi @maheshkhisteLiv,


Please save your excel files in your onedrive.


I have made a test on my side to create excel a,excel b,excel c with UPN column as below:



The rows in the excel a,excel b,excel c would be created in the excel new.

The excel new as below:



Please refer to screenshot below to create the flow:



The flow would run successfully as below:




The rows would be created in the excel new as below:




Best regards,


Is there an easier way to do this if I have 250 spreadsheets?

with desktop PA you can set each sheet as active (by index) looping through sheets, and then read data from that active sheet into a datatable and append it to master Excel. desktop app doesn't require to have data formatted as Tables

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Users online (2,284)