Filter Massive CSV using PowerQuery in Excel

Filter a 1+ million row CSV using a list of criteria in a second CSV -- all in seconds using PowerQuery

[@krypt777]

2 year old video and still gave me the best method, Thanks alot

[@nicholashall3479]

This was enormously helpful to me. Thanks so much!

[@srinivaspavali3550]

Thank you so much

[@sharifskijr.1257]

You're simply awesome!

[@SA-kt3wt]

Thanks - this is slower but simpler for those of us who dont have SQL experience (the go to for this stuff!). Can you match two columns? E.g. let's say county and sales date April in your example?

[@ThisGuyOnYouTube1]

Yep!

[@nknaru007]

can we import multiple csv files?

[@r0260064]

Thanks for the help! Important note: Do not changetype for any of the columns before doing the merge action, this gives errors.

[@Jizzus-l7w]

Hello, I have two similar lists, but in my case i want to remove the countries that are in europe from the 1.6m rows CSV. any ideas on how to do it?

[@Amit_Singh777]

Hi , I have two files(say excel) from two two different sources..I want to compare these two files for any difference (if any)... After comparison I want to do the same comparison(basically automate) for other years in power query . Can you help me in this.

[@wilfredo2752]

Great! Thanks for your video.

[@supriyapawar8417]

Hi, can you please show how we can convert csv file with millions of data into excel . Like i want to export all those millions data into excel. Thank you

[@AidonakS]

Thanks 😄

[@manishjargamagar5925]

its tooo fast, could not understand anything.