How to update one or more fields, and/or add additional fields with information to your existing contacts  

 

Create a CSV file/spreadsheet. The first column should include the email addresses in your list. You can then add remaining columns to be updated or added. 


Note: Fields that are not being updated do not need to be included.


When uploading, select 'Yes, overwrite existing contact details.'




Here is a more detailed explanation:

 

Assume you have a list called My-List with fields:


Email-address, First-Name, Last-Name and State

 

Perhaps you later decided that you need to add a field called "City" and you might want to also update the values for the field called "State."


Start with a spreadsheet in Excel or a similar spreadsheet program that has your contact email addresses in column #1.  Ensure the first cell has the title 'Email-Address'.


Note: You do not need to include values for the fields First-Name and Last-Name. You can, but it is not required since these fields, in our example, already have data.  


Now add 2 columns: City and State - enter the City and State values for each row / record.

 

Save the file as a CSV (NOT an Excel XLS) file. 

You can now use this spreadsheet to update your Pinpointe list:

 

Go to the Contacts tab -> Import Contacts


On the next page, highlight the contact list you would like to update the contacts in and select the 'Next >>' button.


 On the next screen, select:

  Overwrite Existing Details: Yes, overwrite existing contact details

  Contains Headers: Yes, this file contains headers




Select the spreadsheet you created by dragging it or loading it to the drop box and hit the "Next >>" button.


This will upload values into the fields 'City' and 'State' for all contacts.