How do I import my list if it's "dirty"?

If you have an existing customer list (in CSV or Excel Format) of email addresses and those addresses are combined with other information (such as names or phone numbers) in a single cell, you can use Microsoft Excel to separate out the email addresses into its own column so you can just import those.

Do this:

  1. Open the file containing your list in Excel.
  2. Select the entire column (it's column A in this case).
  3. Select DATA from the top level Menu and then select Text to Columns.
  4. Click on each unnecessary column and select "Do not import".
  5. Click Finish.

When this little pop-up finishes and closes, you should see a single clean column of just email addresses.