Need to automatically combine all files in a folder to One Excel workbook? You are going to love this completely automatic way. This simple but insanely time saving trick uses Power Query to combine files in a folder.

In this video ⏱
==============
0:00 Introduction to the combine files problem
0:36 A quick look at the folder & one of the files
1:10 Combining the files with "Get Data → Folder" option in Excel
2:36 Cleaning up the file data with Power Query rules
5:32 Loading the data to Excel
5:55 What happens when you add files to the folder
7:08 How to learn Power Query

Sample files
============
Here is a ZIP file that has individual monthly files & consolidated workbook (with Power Query connection). https://chandoo.org/wp/wpcontent/upl...

For a similar example, but using PDFs, see this video:    • How to Combine PDFs to Excel easily (...  

Watch next
==============

[RECOMMENDED] Detailed Power Query Tutorial (80 minutes)    • Power Query Tutorial  What is it, ho...  
Power Query tips play list    • Power Query Howto & Tips  
Combine sheets in an Excel file    • AWESOME Excel trick to combine data f...  
Combine Data from PDFs    • How to Combine PDFs to Excel easily (...  

Credits:
======
Big bang theory clip from    • The Big Bang Theory: Costumes (Clip) ...  

Music from Epidemic Sound. Get high quality & fresh songs for your videos from here: https://www.epidemicsound.com/referra...

Have an awesome day