How to Combine Multiple CSV Files into a Single Excel File

Подписаться 96 тыс.

Просмотров 7 тыс.

50% 1

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.
If you're interested in learning more advanced techniques with Power Query and the M language, you can enroll in my course: goodly.co.in/l...
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/C...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== 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!

Опубликовано:

18 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 37

@GoodlyChandeep 7 дней назад

Download File ⬇ - goodly.co.in/Combine-Multiple-CSV-Files-into-Single-Excel-File Here are some best practices to follow while combining multiple Excel files - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-PWp5Aes9ZJc.htmlsi=4FfG8D65Wb8nOToX You can learn more about the M course here: goodly.co.in/learn-m-powerquery/

@ursvenky6394 7 дней назад

You're always the best in teaching techniques Chandeep.

@jerrydellasala7643 6 дней назад

Really good lesson!

@krishna6296 6 дней назад

Thanks Chandeep for the useful content!

@shaunrowley7230 7 дней назад

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 👍

@altafhussainbakhwani3847 4 дня назад

Brilliant video.. Chandeep

@mnowako 7 дней назад

Awesome as always! Thank you!

@emilmubarakshin49 7 дней назад

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

@chrism9037 7 дней назад

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

$@frachiar4444$

@frachiar4444 6 дней назад

Grazie. Chiarissimo e utilissimo!!

@GoodlyChandeep 5 дней назад

Thank you so much!

@gurvindersingharora5301 3 дня назад

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

@dirkstaszak4838 7 дней назад

Great thx a lot

@JonathanExcels 7 дней назад

Very informative

@ilhamwicaksono1986 6 дней назад

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

@RogerStocker 7 дней назад

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.

@GoodlyChandeep 5 дней назад

Yes you'll learn that too!

@clotgene9090 7 дней назад

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

@Tuhin380 7 дней назад

Great!❤❤

@240vipin 7 дней назад

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

@Makelifeeasz 7 дней назад

Yeah

@bittujha2890 7 дней назад

I agree with you. Can goodly do something for potential learners with some discounts..

@SHS-8 7 дней назад

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-hv9xw 6 дней назад

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 ?

@subhach9487 7 дней назад

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

@GoodlyChandeep 6 дней назад

that's a straight contains or starts with filter on the Name column

@miragurumoorthy95 4 дня назад

A kind feedback! Please reduce your pace!

@PEDRUSCOT 6 дней назад

Hey!!! Great video. Do you know the way to work with old format excel files .xls?

@GoodlyChandeep 5 дней назад

I think there is a way but i havent tried it!

@PEDRUSCOT 5 дней назад

@@GoodlyChandeep I haven't found it. I think this kind of data is not readable in qp

@PEDRUSCOT 5 дней назад

I've to open first the xls file and save as xlsx

@mrbartuss1 7 дней назад

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

@GoodlyChandeep 6 дней назад

Aweome when the first column is a "Date"