Importing a list of recipients from a spreadsheet (.csv or .xlsx/xls )

You can import a list of recipients from an external spreadsheet (.csv) by uploading it to Contacts and mapping existing fields to the list. The

1. To import a .csv or .xlsx/xls, in Lists, find a list you wish to import recipients into and click on it to open the list. Email Address, First Name and Last Name are required fields. Please make sure that your file have these info.
2. In Contacts, select the list/s you wish to import your recipients list. You can use the top import function if you want to mass export or use the import function within the recipients section,
   Top Import Function
   
   
   
   Import within Recipients section
   
   
3. Select the import function and browse and select the file.
   
4. Select the Next button
   
   
   5. Map the columns that corresponds to the column of the csv or xls/xlsx file that you are importing. If you are replacing the list make sure to select the check box "Replace - Overwrites the list"

            

      6. Select the Finish button.

            

Note: If you used the top import function, please make sure that the file you are importing has the column for List Name [ID:List ID].

      Download Summary

      If you want to check the summary of the import process, select Download Summary. 

      

      The summary will show you which recipients failed to import and the reason why it failed.

• Related Articles

• Export recipients to external spreadsheet (.csv)

  You may wish to export an existing list to an external spreadsheet so that you can review it with non-users on your team. You can do this by exporting it. Exporting recipients  In Contacts, locate or select the list/s you wish to export. You can use ...

• Deleting all recipients in a list

  You may wish to clear a list entirely while preserving the list itself (useful for reimporting from an external spreadsheet).  Deleting all recipients In Contacts, located the list you wish to clear On the right side, select the check box on the ...

• Copying all Recipients to a different list

  As a list manager you may want to add recipients from one list into another list.   Copying all recipients In Contacts, locate the list you wish to copy the recipients from. Select the top check box in the first column to select all recipients. ...

• Exporting Reporting results into .csv

  You can export the current results in your Reporting search into a .csv (comma separated value) file that is readable by popular spreadsheet programs.  Exporting to .csv After displaying the desired results in your Reporting page (or in release ...

• Selecting lists of recipients

  To make your release available to anyone in the Play MPE system you need to specify which lists or recipients you want to have access to the release. Do this in an Assignment Schedule. Viewing lists of recipients In Contacts (Step 4) of an existing ...