Skip to main content

How to update contacts with a CSV import

This article contains a step-by-step guide for updating an already existing contact in your CRM.

Lubov Mineeva avatar
Written by Lubov Mineeva
Updated this week

If you need to update multiple contacts at once, you can use a CSV import instead of doing it manually one by one.

You can find the “Update contacts” option by clicking the “CSV” button on the “Imports” page:

A screenshot of the CSV menu with the following options: Import contacts, Import accounts, Update contacts, Update accounts, Contacts stoplist, Accounts stoplist.

The Update Contacts option allows you to replace data for matched contacts during a CSV import. When this feature is used, all changes made in the CSV file (e.g., changes to first names or last names) will overwrite the existing data in GetSales. Review key fields (e.g., names) to ensure data integrity.

Note: Ensure your CSV file contains accurate information before importing to avoid undesirable overwrites.

Step-by-step guide on creating a CSV import

  1. Create Custom Fields First

    Before importing, create the custom fields you need at Settings > Custom Fields
    This allows you to map additional fields during the CSV import setup.

  2. Prepare Your CSV File

    Include your custom field data in the CSV file
    Ensure the file contains at least one unique identifier (LinkedIn ID, GetSales ID or email) to match existing contacts.

  3. Import with “Update Contacts”

    Go to Imports → CSV from the main menu, choose the “Update Contacts” option and upload your file:

    A screenshot of the pop-up window "Update from CSV: contacts". Notice that maximum file size is 15 Mb containing not more than 15,000 lines.

  4. Choose ID field

    The second step is “Choose ID field”.

    A screenshot of the pop-up window "Update from CSV: contacts". Shows the System field and CSV file column.


    In the “System field” you can choose one of three options:

    GetSales ID, LinkedIn ID, Email


    You can choose any of these three based on which is present in your CSV. In the “CSV file column” choose a corresponding field.

  5. Match update fields

    The third step is “Match update fields:


    You don’t need to match all fields, just the ones you want to update. For example, if you want to update the Company name, match it with the CSV column containing that information.

    This will perform a bulk update, adding the custom field data to matched contacts.

    The Update Contacts feature will overwrite existing data for matched contacts. Test with a smaller batch first to ensure results align with your expectations.

Note: Always backup your existing data before performing bulk updates.

FAQ:

Q: I have an “Error” message, what do I do?

A: If you see an error, you need to click on the number of failed contacts in the CSV update:

CSV people Update Completed (0 saved, 1 errors)

The “Result” column will show the reason it failed:

Import results: CSV People Update. Import status: completed. There are four columns: Data, Result, Status and Last Update.

Contact not found” indicates that the unique ID (GetSales ID, LinkedIn ID or email) was matched incorrectly to a CSV column or the CSV contains incorrect data. Double-check the CSV file to see what info you have as a unique ID for this contact.

It can also happen if the coding of the file is messed up. You can open the file in Google Sheets and save it as a CSV again. After that, try using it for CSV update again.

Did this answer your question?