|
How can I import email addresses from an excel (.xls, .xlsx), CSV (.csv) or a text (.txt) file?
Once you have set up an email list, you can upload / import email addresses to this list. To import email addresses:
- Login » Surveys » Send Survey » Manage Email Lists (Select List)
| Screenshot |
 |
- Click on the CSV/Excel Upload (Additional Fields) link.
- Step 1: On the popup, Choose Upload Format
- Step 2: Choose file
- Step 3: Select check box if you wish to Skip the first line (Header)
- Click on the Upload File button
| Screenshot |
 |
The email addresses will get uploaded to your email list. Now you can send survey(s) to this email list.
To track e-mail addresses / custom variables please use the respondent tracking link when sending emails via QuestionPro Email Management.
What format should the file be in?
Following are the approved file types:
| File Types | Extension |
|---|
| Excel | .xlsx, .xls |
| CSV Raw Data | .csv |
| Text | .txt |
Your data in the file should confirm with any of the format option as below:
License Level: Professional
| Column 1 | Column 2 | Column 3 |
| Email | | |
| Email | First Name | Last Name |
License Level: Corporate / Enterprise
| Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column n |
| Email | Field1 | Field2 | Field3 | Field4 | Field5 | | | | |
| Email | First Name | Last Name | Field1 | Field2 | Field3 | Field4 | Field5 | | |
| Email | First Name | Last Name | Password | Field1 | Field2 | Field3 | Field4 | Field5 | |
| Email | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field7 | Field8 | Field(m). |
| Email | First Name | Last Name | Field1 | Field2 | Field3 | Field4 | Field5 | Field6 | Field(m). |
| Email | First Name | Last Name | Password | Field1 | Field2 | Field3 | Field4 | Field5 | Field(m). |
| Email | First Name | Last Name | Address Line1 | Line2 | City | State | Zip Code | | |
| Email | First Name | Last Name | Address Line1 | Line2 | City | State | Zip Code | Phone | IP Address |
Compliance format for the email address file:
- There should not be any spaces in the email address field
- The email address should be in plain English. The FIRST / LAST NAME variables and Custom Variables support multi-lingual characters.
- There should not be any Commas within the CSV / Excel file
I am trying to upload multilingual variables but they don't get uploaded properly.
When uploading multilingual variables make sure you use an excel file. A .csv file doesn't support multilingual characters.
How can I save an Excel file to a CSV file?
All Spreadsheet Application Softwares have the option for saving files as .csv files. For excel, the 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 |
 |
| 
Print
Feedback