extract email addresslogo

Extract and sort e-mail addresses, URLs and phone numbers easily !

Hi, I am Nicolas, the guy who made this website. One question :

What new functionnalities, services, or app would help you ? (not necessary related to this website)


Thanks for your input.
Do you find this website useful ? If yes, say thanks to me : donate
Has this website saved you time ? Now is the time to relax, and take one minute to tip me
Wow, this powerful tool will just save you hours of hard work. That is great, isn't it ? You can then thank me for providing such a great tool !

A powerful, easy to use tool, with many convenient features - made with love for you.

Say thanks and tip me

Extract

$32 $19 $12 $9
First step :
Paste your text
here
( optional ) paste here the email
addresses to ignore

Has this powerful tool saved you a lot of time, today ?

Say a great thanks, donate now (bitcoin)


Ask a question?

Concerned about privacy?



How to :

explanation multiple-emails
explanation add-to-address-book

remove duplicates

Extracting email address removes automatically duplicates. However, some people may have two different form of email address. john.bloggs@supercompany.com and j.bloggs@supercompany.com for example.
In that case, you can sort out by company (priority 1.), then by family name (priority 2.). It will be easier for you to strip out manually this kind of duplicates.

To do that,

  • click > sort by > and drag 'company' in the top position, then drag 'family name' just below
  • click 'extract'
  • go through the email list manually

eliminate dead email address

Add in the ( optional ) email address to be ignored a text containing all the email address that should be ignored.

As an example, you can insert the text contained in the 'Mail Delivery System' emails that you have received, denoting wrong or obsolete email addresses

only extract email address from one company

Extracting email address from only one company means that they have the same string after the '@' sign.

  • click on 'Misc'
  • then write a '@' then the company name. For instance : @supercorp. You don't have to put the extension ('.com' for instance), as some companies may have several ones (.co.uk and .com for instance).

  • paste your text into the 'paste your text here' area
  • click the 'Extract' button.

only extract emails from one family name

  • click on 'Misc'
  • then write the family name and a '@'. For instance : doh@. You don't have to put the extension ('.com' for instance), as some companies may have several ones (.co.uk and .com for instance).

  • paste your text into the 'paste your text here' area
  • click the 'Extract' button.

only extract URL from one website

  • click on 'Misc'
  • then write the website in the text field.
  • paste your text into the 'paste your text here' area
  • click the 'Extract' button.

extract from one column only, and paste the result in the same column, keeping the original order

Is there a way to extract out the emails listed in a spreadsheet row by row in one complete column?

Do you have some data like that :

ABC
John AJohn A data stuff 98y7986 john.a@agmail.com
John A2John A dgyu788 john.a@gmail.com
John ASylvie BB syl@sylcorp.com
Jack DohJack d 987 jack.d@gmail.com

and you want this result :

ABC
John Ajohn.a@agmail.com
John A2john.a@gmail.com
John Asyl@sylcorp.com
Jack Dohjack.d@gmail.com

  • in your spreadsheet,select the content of the column only - to do that, click on the letter of the column (example 'C').
  • copy the content, and paste it in the "Paste your text here" text area
  • click in the "sort by" option (just above the text area) - and drag and drop the "original text order" in the first position
  • click in the "format", select the "custom separator", empty out the associat field
  • check the checkbox "enter at the end of the line"
  • click on "Extract"
  • click on result and copy the content
  • go back on your spreadsheet, select all the fields you want to paste the result in
  • paste

Remove extra character at the end of the email addresses

Problem : after saving into csv format, there is a character added at the end of each email address. How can you remove it ?

For example: a.f@gagole.atÊ .

  • Copy all the resulting email address
  • Open a basic text editor such as notepad, but not a word processor where you can add some style like Microsoft Word
  • Past your text in this editor
  • Select all this text from this editor, copy it
  • Past the text wherever you want. The extra characters should be now removed

Explanation:

These basic text editors remove the formatting and transform "the end of line" character to "end of line" character used normalhy in Word or other softwares.

eliminate dead email address

Add in the ( optional ) email address to be ignored a text containing all the email address that should be ignored.

As an example, you can insert the text contained in the 'Mail Delivery System' emails that you have received, denoting wrong or obsolete email addresses

extract email address from web-pages

  • Go on the web-page whose email addresses you want to extract
  • Press on your keyboard Ctrl+U (you will then see the source of the page)
  • Press Ctrl+A to select all the code, then Ctrl+C to copy it
  • Go on extractemailaddress.com , then paste the code with Ctrl+V in the text box "Paste your text here"
  • Click on "Extract"

    1. And you are done!

extract email address (or URL, phone numbers) into an Excel file

  • Click 'Format '
  • Click the 'Excel-friendly' button.
  • In 'What to Extract', select the appropriate type of item to extract

extract email addresses, URL, phone numbers to a database

  • Click 'Format'
  • Click 'database friendly'
  • Paste your text in 'Paste your text here'
  • Click 'Extract'
  • Copy and paste the result in a SQL editor
  • Insert the table name and the column name at the beginning of the text

extract email address to text

  • Paste your text in 'Paste your text here'
  • Click 'Extract'

extract email address to send emails

  • Click 'Format'
  • Click 'mail-address-bar friendly' button.

extract from an Excel file

  • Select all the content of your Excel page (right-click anywhere on the page, then click 'select all'). You can also only select one or more columns (click just above the top of the column to do so. Click on the Ctrl button, and select other columns if needed)
  • Copy the text (right-click, 'copy')
  • Paste it in the 'Paste your text here' box
  • Click the button 'Extract'

extract from a Word file / Libre Office / Open Office

  • Select all the content of your Word page (right-click anywhere on the page
  • Click 'select all'
  • Copy the text
  • Paste it in the 'Paste your text here' box
  • Click the button 'Extract'

extract from your gmail account

extract from your outlook account

For outlook.com (your live account), see below

From outlook 2007

  • Click on File, Import and Export and the Wizard tool opens up
  • Select the option to Export to a File and click on Next
  • Select Microsoft Excel 97-2003 (or a CSV file) and click on Next
  • Click on Browse to select a location and then type the file name that you want to export the information to ; click on Next
  • Here is the important bit - click on Map Custom Fields. This will bring up a list of all the available fields that are available in that folder.
  • Since we are only interested in Email address, click on Clear Map and then from the Left side click on From: (address) and drag that to the Right list
  • Click on OK then click on Finish

Extract email address from 2 or more emails

Not yet documented

From outlook.com

Not yet documented

extract from big files

All the text-processing is done by your browser. This is to ensure your privacy, as not a single e-mail address is sent to a server from here !

However, this means that there is a processing limit. If you try would like to extract a text of 800M or more (depending of your computer performance), we recommand :

  • Copy and paste half of the text
  • extract
  • Copy and paste the other half
  • extract
  • Copy and past the first result in the 'Paste your text here' area
  • Copy and past the second result in the 'Paste your text here' area, below the text you have just pasted
  • extract

The last steps are to make remove the potential duplicates, and order all the addresses correctly.

extract email address from from Thunderbird

For your address book, see the 'from emails in folders' help.

from emails in folders

  • find where your data of Thunderbird are : go here and follow the instructions.
  • There, you have different folders. The one containing data about your email could be ImapMail, or PopMail, or a folder with the name of your email account. You will find it easily. Open it, go inside the sub-folder.
    I personally go in ImapMail\imap.aol.com for it.
  • In this folder, you will have files with names similar to your own mail folder. Open the one with the extension .msf with a text editor (notepad, works,.. the lighter the better, so you may avoid big rich-featured text-editor like Word). The operation may take some time, according to your computer and the size of the file to open.
  • Copy the content of the file, paste the content in the textbox 'paste your text here'.
  • Then click the button "extract". This should take some time (If you have an old computer, it might get a unstable for one or two minutes).
Done !

from your address book

  • find where your data of Thunderbird are. Go here and follow the instruction.
  • open the file abook.mab with a text editor (the lighter the better, notepad or works are great for that)
  • copy all the text and start extracting with this website.



Concerned about privacy ?

All the text-processing is done by your browser. This is to ensure your privacy, as not a single e-mail address is sent to a server ! I value privacy at least as much as you do !
This site does not rely on selling email addresses or using email addresses for commercial purposes. But it relies on donations to pay the server needed, and the developement time the developer, myself, has devoted to develop this project for you.

About

One day, a couple of years ago, my Dad asked me : "Cédric, I have a file with a lot of address emails, but it's just a mess inside it. Can you get me all these address emails ?"
Simple idea, but it would have been a real pain to do that by hand : find each email address, copy and paste each one manually. Then I thought, if my Dad needs that, maybe more people need that on the internet ?
Since the initial idea, I have added a lot of features, created a easy to use design, and crafted a look and feel so that you can get what you need quickly and efficiently.

All in all, it is here to help people, like you, in their daily work-life.

I hope it succeeds to do so. If so, say thanks: buy me a beer

 
I am Nicolas, a web developer, from France. I have lived in United Kingdom, Australia and Germany.
I always try to help people, and I also love creating and working on great websites.

That is why I have created, developed and maintained this tool with for you

What people say about this website ?

helpful - I really loved this user friendly option of extracting the mail , thanks a lot for the help i am sure more visibility should be there for your web address
all the best to you
- ramnath

I love you - Just wanted to thank you. Thanks!!!!!
- Matteo M

awesome - Awesome site! Thank you very much!
- Aan

thanks - This page is a very nice help. Does its job beautifully simply.
Thanks
- Jean C.

WOW - What a time saver for me will use this for rest of my list 70 per day for a month.
TY TY TY for this saved in favorites will send you donations in sept.
Will recommend this to 100's of contacts.
Regards
- Bill

...

And you ? Send me your comment here.

Say thanks, donate , how much would you give for all the time and effort this site has saved You ?

Love it ? Hate it ? Say it !