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.

Happy New Year !! And Happy Extraction !

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 ? Why not 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

Hallowwwwweeeen is here !!!

[¬º-°]¬    [¬º-°]¬    (∩`-´)⊃━☆゚.*・。゚ @ @ @

Do you like this powerful tool ? Has it saved you some time and effort ?

Say thanks ! Donate ! tip me

It is Christmas Time !!! It is happy time !!

*<:-) 3:*) 3:*) ʕ•͡ᴥ•ʔ

Christmas fundraising donate

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.

A text (usual use) . How does this work ? How can I get all the email addresses (or URL or Phone numbers) ?

  • You have a text with a lot of email addresses or telephon numbers or URLs (website addresses) ?
  • Copy this text into the textbox 'Paste your text here'.
  • Click on the button 'Extract'
  • As a result :

    You will have all the email addresses contained in the text appearing on the right side of the boxes (or below if you have a smaller screen), or the grey text 'No email found'.

    You will have all the URL (web addresses) contained in the text appearing on the right side of the textboxes (or below if you have a smaller screen), or a grey text 'No URL found'.

    You will have all the Phone numbers contained in the text appearing on the right side of the textboxes (or below if you have a smaller screen), or a grey text 'No Phone number found'.
  • And you are done!

Extract email address from website

  • 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"
  • 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 document / 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 a PDF document

  • If you haven't got an software to open PDF files, Download and install the latest version of Adobe Reader.
  • Open the PDF in Adobe Reader.
  • Right-click on the open PDF and choose "Select tool."
  • Try to select the content you want to copy.
    This is the trickiest part, because your ability to select text depends on how the PDF was created:
    • If the PDF was created by scanning a document, you will not be able to select any text. This is because the PDF file is encoded as an image instead of a text document. You can click and drag to create a selection box, but this will copy as an image instead of as text. See the next section for tips on converting the file so that you can select the text.
    • If the PDF was created directly from a word processor, such as saved as a PDF in Word, you should be able to highlight text. Selecting large portions of text can be finicky, so try to make your copies in small chunks of text.
    • If you want to copy an image, you'll need to drag a selection box around the entire image.
  • Copy your selected content (select "Copy" from the Edit menu)
  • On this page extractemailaddress.com :
    • 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 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 : "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 ?
That is why I have created this email address extractor, http://extractemailaddress.com
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

Why use it ?

  • It's safe : NO email address are sent to any server- all the magic happens on your device only !!
    I have no interest at all to gather random e-mail address.
  • It's powerful
  • It's easy to use
  • It's free
  • It has powerful sort functionalities
  • From several file formats (text, csv, pdf, excel, doc,...) - as long as you can open them and copy their content
  • To different formats
  • Great for e-mail marketing : you can easily create a mailing list

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

Looking to extract a BUNCH of emails for a mailing list? Check this amazing tool out [http://extractemailaddress.com]
- Digital Domination

...

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 !