Combing many CSV & Excel files in a folder using Power Query

Hi all today I am joined by my brother Stefan an economics student who is having trouble combining csv files we'll walk through a real world example how to combine many files at once quickly. Enjoy!!


How to combine many CSV/Excel files into one using Power Query!

In this tutorial, we'll take you step by step through the process of combining multiple CSV and Excel files into a single, consolidated file using Power Query in Microsoft Excel.

📌 What You'll Learn:

Basics of Power Query and its interface.
How to import multiple files from a folder.
Adjusting queries to ensure consistent data structure.
Cleaning and transforming data once combined.
Finalizing and loading the consolidated data back to Excel.

0:00 Intro
0:30 Reviewing the columns & rows
1:00 Combining files from folder
2:00 Cleaning the data in Power Query
5:00 Outro


#excel #exceltutorial #exceltips #powerquery