Filter out email addresses from csv file

[Profit17]

Hi,

I have a 300,000 strong email list in csv format. I need a way to filter out all addresses that aren't gmail. So either delete those, or cut the gmails and save in a new file.

This is obviously too massive to do manually and I can't find a way to achieve this.

Any ideas?

Thanks

 

[davids355]

Some sort of conditional formatting so that a new column in your sheet checks the email column to see if it contains gmail.

Then you can filter based on the result and copy the remaining emails accordingly.

Ref - https://exceljet.net/formula/cell-contains-specific-text

 

[Shyam007]

Just filter by contains gmail.

Copy paste somewhere else.

 

[Deleted member 1175125]

You can filter using regex in almost all programming languages.

 

[Profit17]

thanks guys

 

[payal23j]

It will be easy if you use excel and notepad.

 

[Gr33nArrow]

linux command..

grep gmail.com email_list.csv > gmail_only.csv

 

[tanglewood]

Data->sort by that field. Delete whatever you don’t want. 300k is not huge...

 

[lawrencelau]

Just filter by contains gmail.

Copy paste somewhere else.

+1

using excel is very easy to filter