Using Query and Connections

[Marc Juzkow]

Is it possible to pull data from multiple Excel files in a folder using one Query and populate one worksheet with data from each of the Excel files.  Thanks.

[#2]

Have you tried the Get Data from folder (Get & Transform Data tab). Using this you can combine all workbooks in that folder into one data table.

[#3]

I am using Office 365 ProPlus.  There is a Get Data tab under Data but no option for Folder, only File, Database, etc. 

[#4 · Accepted solution]

Hello, 

don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.

[#5]

Thank you Ingeborg and Tanya.  You were both very helpful.  This is going to save me a ton of time in my analyses.