How to Convert Excel Data to a Mailing List. Capturing and organizing customer or prospect email addresses is the first basic step toward compiling a mailing list.

To get domain from email address in Microsoft Excel, use Excel functions, the Text to Column feature, or the Flash Fill feature.