Print     Email Page

How can I import email addresses from an Excel/CSV file?

• Goto:
  • Login »  My Surveys »  Send Survey »  Manage Email Lists (Select List) »  Overview

  
  Screenshot
  
  

  Click on the CSV Upload link
• Choose the Upload File Format type. Browse for the file and click on the Upload CSV File button

  
  Screenshot
  
  

What format should the file be in?

The file should be in CSV (.csv) file format. All Spreadsheet Application Softwares have the option for saving files as .csv files. Your data in the file should confirm with any of the format option as below:

Correct format for the "Notepad" file:

You can also upload from Notepad (.txt) file. The email addresses and custom variables must be in the following format:

 

email_address, first_name, last_name, custom variable 1, custom variable 2, custom variable 3, custom variable 4, custom variable 5

For example:


kevin111@questionpro.com, Kevin, Battey
support@surveyconsole.com, Nick, Smith
tom@gmail.com, Tom, Russell

Please see Personalize emails to your distribution list help file (referenced below) for more information on how to use the custom variables uploaded with the email addresses.

How can I save an Excel file to a CSV file?

• The Excel File should be in the following format:

  
  Screenshot
  
  

• Click on the File menu in Excel and select the Save As option.

  
  Screenshot
  
  

• Select the File Type as CSV(Comma Delimited)and click on the Save Button.

  
  Screenshot
  
  

Compliance format for the email address file:

1. There should not be any Spaces in the email address field
2. The email address and the Custom Variables should be in plain english. Accents or Special Characters are not permitted
3. There should not be any Commas within the CSV file