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.