To use Power Query for this purpose, follow these steps: Go to the Data tab in the Excel ribbon Click on the Get Data button Choose From File > From Folder Select the desired folder and click OK ...