Sort a list of email addresses by domain in Excel

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


Rate This Answer

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.