How to Combine Multiple CSV Files into a Single Excel File

[@GoodlyChandeep]

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 - kzbin.info/www/bejne/hojTZnSbqJ6NgMUsi=4FfG8D65Wb8nOToX You can learn more about the M course here: goodly.co.in/learn-m-powerquery/

[@ursvenky6394]

You're always the best in teaching techniques Chandeep.

[@chrism9037]

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

[@emilmubarakshin49]

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

[@mnowako]

Awesome as always! Thank you!

[@frachiar4444]

Grazie. Chiarissimo e utilissimo!!

[@GoodlyChandeep]

Thank you so much!

[@shaunrowley7230]

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 👍

[@krishna6296]

Thanks Chandeep for the useful content!

[@johnhackwood1568]

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

[@jerrydellasala7643]

Really good lesson!

[@altafhussainbakhwani3847]

Brilliant video.. Chandeep

[@josealvesferreira1683]

very good, congratulations

[@JonathanExcels]

Very informative

[@dirkstaszak4838]

Great thx a lot

[@clotgene9090]

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.

[@GoodlyChandeep]

Yes you'll learn that too!

[@Tuhin380]

Great!❤❤

[@ilhamwicaksono1986]

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

[@gurvindersingharora5301]

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

[@SHS-8]

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

[@240vipin]

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

[@Makelifeeasz]

Yeah

[@bittujha2890]

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

[@PEDRUSCOT]

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

[@GoodlyChandeep]

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

[@PEDRUSCOT]

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

[@PEDRUSCOT]

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

[@Batman-hv9xw]

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]

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]

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

[@sergioladelfa2154]

Hi, I tried all steps but CSV within PQ shows all columns in one single column. Csv.Document[ ] After clicking on Table, all columns are in a single column. How to fix It? Thanks

[@AbdulJalil-id7gr]

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

[@anish890]

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

[@bimanroy3041]

Instead of CSV.Document use Excel.Workbook function

[@mrbartuss1]

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

[@GoodlyChandeep]

Aweome when the first column is a "Date"

[@miragurumoorthy95]

A kind feedback! Please reduce your pace!