extract email address

Remove duplicates emails, URLs, phone numbers

ExtractingEmailAddress removes automatically duplicates.

Email addresses

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 result manually

Phone Numbers

Also that some phone numbers may be the same for a human, but not for your computer:
+374 9 1234567 would be the same than +374 (9) 1234567 for a human, but would not be removed as duplicated from your computer. You could sort this manually.

Eliminate dead email addresses

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

As an example:

• Get all the text from emails with 'Mail Delivery System' title
• Paste their body's text into ( optional ) email addresses to be ignored
• Copy the text that contains all the valid and dead email addresses into the text box 'Paste your text here'.
• Click on the button 'Extract'

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'
• select 'only' in the drop-down list
• then write a '@' with the company name after 'extract items containing this string:'
  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

Extracting email address from only one family name usually means that they have the same string just before the '@' sign.

• click on 'Misc'
• select 'only' in the drop-down list
• then write a '@' with the company name after 'extract items containing this string:'
  For instance: doe@
• paste your text into the 'paste your text here' area
• click the 'Extract' button.

Only extract URL from one website

• click on 'Misc'
• select 'only' in the drop-down list
• write the website in the text field.
• paste your text into the 'paste your text here' area
• click the 'Extract' button.

Extract email addresses or urls or phone numbers
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:

and you want this result:

It is simple, just follow these steps:

• 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
• 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", delete the ';' in the text area
• check the check-box "enter at the end of the line"
  
  
• click on "Extract"
• click on result and copy the content
  
  
• go back on your spreadsheet, select the field you want to paste the result in
• paste the result

Warning: if there is some cells in your original document with no email address, or with more than one email addresses, this method will fail. If this is the case, you have to delete them manually before extracting data

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 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 normally in Word or other softwares.

Group email addresses by chunks of 10, 20, 50

Problem: you need to group email addresses by groups of 20 or 100?

It's easy!

• click on 'Format'.
• in the 'group by', select a number.
• paste your text into the 'paste your text here' area.
• click the 'Extract' button.

Extract E-mail Addresses or Website Addresses (URLs) or Phone Number
from 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 telephone numbers or URLs (website addresses)?
• Copy this text into the text box '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 text boxes (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 text boxes (or below if you have a smaller screen), or a grey text 'No Phone number found'.
• And you are done!

Extract email addresses from a website (or extract URLs or Phone Numbers from a 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 addresses (or URLs, phone numbers) into an Excel file

• Click 'Format '
• Click the 'Excel-friendly' button.
• Copy/paste the result into your Excel Document.

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 your SQL editor
• Insert the table name and the column name at the beginning of the text
• Run the query

Extract email addresses (or URLs, phone numbers) address to Text

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

Extract telephone, mobile numbers

• Paste your text in 'Paste your text here'
• Click 'Extract'
• You will see the phone numbers extracted in one of the box that appears

Extract URL, page address

• Paste your text in 'Paste your text here'
• Click 'Extract'
• You will see the URL extracted in one of the box that appears

Extract email addresses to send emails

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

Extract email addresses (or URLs, phone numbers) from an Excel file (xsl, xslt, CSV)

• 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 email addresses (or URLs, phone numbers)
from a MS Word document / Libre Office / Open Office Document
(doc, docx, dot, dotx, dotm, rtf, odt)

• 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 email addresses (or URLs, phone numbers) 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 addresses from 2 or more emails

Not yet documented

From outlook.com

Not yet documented

Extract email addresses (or URLs, phone numbers) from big files

All the text-processing is done by your browser. This is to ensure your privacy, as not a single email 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 recommend:

• 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 Addresses from from Thunderbird

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 text box '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).

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.