I have a load of excel files (consistent format, but with different content) that I would like to pull data from into one master file. All source files are saved on Sharepoint in one folder, and the destination file is also to be saved on Sharepoint.

I would like the master file to pull given fields from all files saved in the folder, without having to specify all of the file names.

I managed to get this working with Power Query for files just saved on my hard drive, but not sure the best way to achieve this same end on Sharepoint (using this method, for reference). Really nice solution but doesn't seem to be so simple via the cloud.



Try mapping your SharePoint folder in file manager. This should allow you to use the Power Query process.


UPDATE: Found a solution here that has done the trick

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.