Skip to content
Home ยป Combine Data from Multiple Workbooks in a Folder Using Microsoft Excel’s Power Query

Combine Data from Multiple Workbooks in a Folder Using Microsoft Excel’s Power Query

    In this Microsoft Excel video tutorial I demonstrate how to combine multiple workbooks (stored in the same folder) in a single workbook. The method shown in this video uses Power Query.

    Click here to download the featured files.

    Video Table of Contents

    00:00 – Introduction

    00:15 – Create a ‘From Folder’ query in Power Query

    00:37 – Exclude non-Excel files

    01:47 – Apply data transformations

    05:47 – Edit the query

    06:18 – Add more workbooks to folder and update data in the combined file