Forum Discussion
Solved
Using Query and Connections
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.
Hello,
don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.
I am using Office 365 ProPlus. There is a Get Data tab under Data but no option for Folder, only File, Database, etc.
Hello,
don't give up so fast. Click Data ribbon > Get Data > From File > From Folder, then navigate to the desired folder.
Thank you Ingeborg and Tanya. You were both very helpful. This is going to save me a ton of time in my analyses.
- 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.
