Receiving data from a determined file for a master excel

New Contributor

Hello everyone,

I have a standard excel workbook and I am gathering information by using this standardized excel workbook. However I have to change name of this workbook when I want to collect information. The renaming parts of workbook is same.

I would like to make a master excel which can read 1000 excel which have different name but same structure from a constant folder. 

Is it possible? Thanks

3 Replies


That could be done by Power Query using From Folder connector.

I could not achieve it From Folder Connector. I only achieved bringing the name of excel workbooks, extensions and so on. Is it allowing to bring data within excel workbooks which are in same folder? And how?


Data -> Get Data -> From File -> From Folder - select folder -> Transform -> filter if necessary - > expand Content column -> follow the wizard