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.

[@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 👍

[@emilmubarakshin49]

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

[@chrism9037]

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

[@mnowako]

Awesome as always! Thank you!

[@johnhackwood1568]

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

[@krishna6296]

Thanks Chandeep for the useful content!

[@jerrydellasala7643]

Really good lesson!

[@altafhussainbakhwani3847]

Brilliant video.. Chandeep

[@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!

[@clotgene9090]

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

[@ilhamwicaksono1986]

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

[@josealvesferreira1683]

very good, congratulations

[@gurvindersingharora5301]

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

[@dirkstaszak4838]

Great thx a lot

[@JonathanExcels]

Very informative

[@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

[@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

[@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 ?

[@Tuhin380]

Great!❤❤

[@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..

[@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

[@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

[@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

[@AbdulJalil-id7gr]

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

[@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!