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

Merging excel files


Hi all,


I have faced a tricky question and it would be wondeful to find a soloution here.

I am trying to creat a Query to merge numbe of excel files. The problem is the worksheets from the files in each column has a different name. I am sensing there should be a way to merge them but couldn't find any advice so far.

If you have any idea, please share!


Key point is I do not want to edit them on excel and import to PBI. I'd like them to be edited on PBI!


Thank you in advacne!

Community Support Team
Community Support Team

Re: Merging excel files

Hi @tubemap,


If these excel files has similar table structure, you can try to use folder connector to get multiple files at same time and merge them at same time.

Combine files in a folder with Combine Binaries (Power Query)


If these files has different structure and you only want to extract part of columns from files, please share some sample data with a pbix file and expect result snapshot to help us test and clarify your requirement.



Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

For learning resources/Release notes, please visit: | |