Filter Massive CSV using PowerQuery in Excel

preview_player
Показать описание
Filter a 1+ million row CSV using a list of criteria in a second CSV -- all in seconds using PowerQuery
  1. Your Excel Solution
Рекомендации по теме
Filter Massive CSV 0:06:03

Filter Massive CSV using PowerQuery in Excel

Working with very 0:17:47

Working with very LARGE Datasets | 4+ Million Rows | Power Query and Power Pivot | Big Data in Excel

10 Million Rows 0:10:57

10 Million Rows of data Analyzed using Excel's Data Model

Use This Trick 0:00:44

Use This Trick to Merge CSV Files Together Instantly

How To Open 0:04:02

How To Open Large CSV File In Excel

Basic Excel Business 0:11:20

Basic Excel Business Analytics #29: Power Query: Import Multiple Large CSV Files Into Data Model

Big data in 0:11:09

Big data in Excel : 100+ millions rows of data consolidation using power query & power pivot

Combine multiple CSV 0:07:06

Combine multiple CSV / Excel files into one file

How to filter 0:05:19

How to filter CSV to another spreadsheet automatically

[Tagalog][Eng Sub]How to 0:05:32

[Tagalog][Eng Sub]How to Filter Data from Large CSV File

Filter large CSV 0:02:02

Filter large CSV using MS powershell (2 Solutions!!)

How to use 0:16:35

How to use Microsoft Power Query

Filter A CSV 0:03:45

Filter A CSV Online: Analyzing 4.2 Million Rows

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

10 Million Rows 0:03:08

10 Million Rows of Data Loaded into Excel ( **see updated version of this - link in description**)

Power Query: How 0:02:51

Power Query: How to Load CSV Data that Grow By Columns

14 - Combine 0:06:11

14 - Combine CSV Files (or Text Files) in a Folder Using Power Query

Opening .CSV Files 0:01:39

Opening .CSV Files with Excel - Quick Tip on Delimited Text Files

Filtering CSV file 0:00:21

Filtering CSV file

Try limiting rows 0:05:01

Try limiting rows when creating reporting for big data in Power BI

13 - Combine 0:10:31

13 - Combine All the Excel Files in a folder Using Power Query

Excel Magic Trick 0:11:35

Excel Magic Trick 1336: Power Query: Import Big Data Text Files: Connection Only or Data Model?

How To Open 0:01:12

How To Open A Big CSV: 90 Million Row Spreadsheet #spreadsheettutorial #howto #csv

05 - Import 0:07:18

05 - Import Data from TEXT Files in Excel using Power Query

Комментарии
Автор

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

krypt
Автор

This was enormously helpful to me. Thanks so much!

nicholashall
Автор

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

r
Автор

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?

SA-ktwt
Автор

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.

Amit_Singh
Автор

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?

srixter
Автор

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

supriyapawar
Автор

its tooo fast, could not understand anything.

manishjargamagar