How to Combine Multiple CSV Files into a Single Excel File

In this video, we'll learn how to combine data from multiple CSV files into a single Excel file using Power Query. We’ll tackle common challenges such as dealing with inconsistent headers, junk rows, and varying column structures. You'll learn how to remove unwanted rows, clean up your CSVs, and combine them seamlessly without opening each file manually.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[GoodlyChandeep]

Here are some best practices to follow while combining multiple Excel files -

[ursvenky]

You're always the best in teaching techniques Chandeep.

[shaunrowley]

An Excellent video we receive many CSV files for our Warehouse system from Customers who use various systems with one being Sage where depending on how they have exported their data could have 1 to 4 redundent rows. This video has helped to remove the rows and import the data without failures - Thanks again 👍

[johnhackwood]

Hat's off, great video such a practical problem and classy solution.

[chrism]

Chandeep, you continue to crank out super awesome videos, thanks!

[emilmubarakshin]

a fabulous snippet of the recent PowerQuery Duel - as per always Chandeep you rock!

[krishna]

Thanks Chandeep for the useful content!

[ilhamwicaksono]

Saya pernah melihat di video sebelumnya dimana ada function List.ContainAny(). Tapi sekarang anda memasukkan = {..} setelah Record.ToList. itu sangat simpel..

[gurvindersingharora]

Hi Chandeep
Please upload more videos about virtual tables Summarize and Addcolumns together usage ❤

[vipin]

Hi i am from India & I really want to learn but doesn't have that much amount to pay for the full course,

[clotgene]

Lovely, this i was looking for, Can you also help with dynamic columns in csv format

[RogerStocker]

That's really nice! Looking forward to the upcoming M course lessons. I'm curious if we will lern a flexible way to get a defined list of columns from multiple CSV or XL files which have different number of columns and even in different order.

[SHS-]

Hey Chandeep, Which excel format is good to import into PowerBi. CSV, Xlsx, Binary. Also how to change the source of excel file from xlsx or binary into CSV. Please make a video of this. TIA

[Batman-hvxw]

How about connect to one file, clean it. Then save transformations as a function that you use with a folder connection. Is it not better ?

[PEDRUSCOT]

Hey!!! Great video.

Do you know the way to work with old format excel files .xls?

[AbdulJalil-idgr]

I have a request to you to make a free playlist an power query m language.

[subhach]

Hi chandeep, Thanks for the amazing content.

Is there a way we can select the sheets from a bunch of workbooks which had a common name

Example:

3 workbooks in a folder
Wb1 sheet1, s2, s3
Wb2 sheet1, s2, S4
Wb3 sheet1, s2, s3

Is there a way to select sheet1 from all the workbooks using Power query.

Please reply, This will be a great help

[miragurumoorthy]

A kind feedback! Please reduce your pace!

[mrbartuss]

Any thoughts about this solution to dynamically remove rows?
each Table.Skip(Csv.Document([Content]), List.PositionOf(Csv.Document([Content])[Column1], "Date")))

[anish]

What if I have group of files that are in xlsx format and not CSV?