Visit the Panelist Library page for other topics that may be of interest to you.

1. Exporting current panelist information
   
2. Updating panelist information in the exported file
   
3. Importing updated panelist information
   

Export Panelist Information

1. From the black ribbon at the top of the screen, select Libraries > Panelists.
   
   
2. Click on a panel you wish to update, or use the Find panelists feature to list the panelists you wish to update.
   
   
3. If you wish to update all listed panelists, click in the checkbox in front of the Username.
   
   
   Alternatively, if you do not wish to update all the listed panelists, either refine your search, or manually click the individual panelists' checkboxes until you select those that you intend to update.
   
   
4. Select Import/export > Export panelists and specify the fields you wish to include in your export (Password cannot be exported or viewed).
   
   
5. Click Export panelists. The Import/export history page will open for you with the option to download the file you just exported.
   
   
6. Click on the down arrow or the file name and save the file to a location on your local or network drive. Open the file.
   

Update Panelist Information in the File

1. Unique Panelist Id - A system generated numeric code at the time the panelist record was originally created.
   
2. Panelist Name -  System generated information representing a combination of panelist First name and Last name.
   
3. Date Created - The date when the panelist record was originally created.
   
4. Last Product Test - The date of the last product test in which the panelist completed a sample set.
   
5. Last Screener Test - The date of the last screener test in which the panelist completed a sample set.
   

If you try to import data for fields that cannot be updated, the data in your file for these fields will be ignored, but the rest of panelist information included in the file will be updated if the import is successful.

Going back to our example scenario, as a reminder, we are only interested in updating the email address field for all panelists. For this reason, we will keep the Email column in the file and two other columns outlined below the screenshot.

When deleting unwanted columns:

1. To select and delete one column at a time, click on the column letter, right-click on the selected area and select Delete.
   
   
2. To select and delete multiple columns at a time, use the combination of Ctrl key and mouse click. Right-click on the selected area and select Delete.
   

The three columns that should remain in your file are:

1. Username - Required field that enables the software to know which email belongs to which panelist.
   
   If your import fails indicating an issue with the Username column, rename the column into Code and try importing again. Subscriptions that existed before we moved away from Citrix version of our software are using the Code field.
   
   
2. Panelist Name - Although this field cannot be updated in the Panelists library, it will not give you errors if you do try to import it. The information in this column might be useful to you when populating the email addresses if the Username is not descriptive enough for this purpose. When done updating your file with the email addresses, this column can be removed, if you prefer that.
   
   
3. Email - Required in our example scenario because this is the information we wish to update for all the panelists in our file.
   

The importing information must start in the cell A1 and continue into the column C without any blank columns between. Please see the screenshot above. If your columns are separated by blank columns, please remove the blank columns (select entire blank column at a time, right-click and select Delete).

Update the email addresses for your panelists. When done and certain that each email address corresponds to the right panelists, save the file making sure that you maintain the .csv file format.