Sort a list of email addresses by domain in Excel
 

Frequently Asked Questions

Whether you’re test driving our products, getting started with your marketing efforts or taking them to the next level, we've got the answers to your questions.

    
Search Tips
    

Email Answer

*Recipient Email

*Your Email

*Your Name

*Denotes a required field.




How do I sort a list of email addresses by domain in Excel?

Article: 000002229    Product: All

Sort a list of email addresses by domain in Excel

To sort an entire list of contact email addresses by domain in Excel: 

  1. Make a copy of the file and open the copy.
  2. Click Data > Text to Columns.
  3. Select Delimited and click Next.
  4. Under Delimiters, uncheck anything that is selected and check Other.
  5. In the box next to Other: enter the @ symbol.
  6. Click Next > Finish.  This will generate two columns. The second column will contain the second half of the email address containing the domain.
  7. Copy the second column and open the original file.
  8. Paste the contents of this column into this file, making sure that the information corresponds correctly.
  9. If the information looks correct, save the file.
  10. Click Data > Sort.
  11. Sort by the column that contains the domain name. This will group all the addresses with the same domain together.

Excel is not a Constant Contact product. For more information, please refer to http://support.microsoft.com

Provide Feedback on this Answer
Please share your feedback below to make this answer more helpful. Note: If you need immediate assistance, please visit our Help & Support page to contact us – we’re here to help.
 
 
Not Helpful Helpful