Bulk Importing Contacts via CSV in GLM

Need more help? Contact our support team at hello@usekilo.com. We're here for you!

Step 1: Set Up Your CSV and Custom Fields

When adding phone numbers that require a "+" sign, use an apostrophe at the beginning

(e.g., '+191668128779 ).

  • File upload and signature fields are not supported when importing.
  • If importing a Do Not Disturb (DND) column, contacts will be set to DND for all communication channels. To control DND by specific channels, set up a workflow and use tags.

Step 2: Check for Duplicates

Always clean your contact list and check for duplicates before importing. This helps prevent issues, especially for cold traffic campaigns, as duplicate records can lead to email deliverability issues.


To check for duplicates in Excel, follow these steps:

  • Select the Data Range:
    • Highlight the column or range of cells where you want to check for duplicates.
  • Go to the "Data" Tab:
    • Click on the Data tab in the ribbon at the top.
  • Click on "Remove Duplicates":
    • In the "Data Tools" group, click the Remove Duplicates button.
    • This will open a dialog box that allows you to specify the columns to check for duplicates.
  • Choose Columns (if needed):
    • If your data has multiple columns and you only want to check duplicates in specific columns, uncheck the others.
  • Click OK:
    • Once you’ve selected the columns, click OK. Excel will highlight the duplicates, or if you selected "Remove Duplicates," it will delete the duplicate rows and keep only unique entries.
  • Optional - Use Conditional Formatting:
    • If you want to highlight duplicates rather than remove them, select the range, go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values, and choose a formatting option. Excel will visually mark the duplicate cells for you.

To check for duplicates in Google Sheets, follow these steps:

  • Select the Data Range:
    • Highlight the column or range of cells where you want to check for duplicates.
  • Go to the "Format" Menu:
    • Click on the Format menu in the top toolbar.
  • Choose Conditional Formatting:
    • Select Conditional formatting from the dropdown.
  • Set Up a Custom Formula:
    • In the conditional formatting pane that appears on the right, change the Format cells if option to Custom formula is.
  • Enter the Formula:
    • Enter the following formula: =COUNTIF(A:A,A1)>1
    • Adjust the A:A and A1 references according to the column you're working with.
  • Choose Formatting Style:
    • Select the color or style you want the duplicates to be highlighted in.
  • Click "Done":
    • Google Sheets will now highlight any duplicates in the selected range based on your custom formula.
  • Optional - Remove Duplicates:
    • To actually remove duplicates, select your data, go to Data > Data cleanup > Remove duplicates, and then follow the prompts to delete duplicates from your sheet.

Step 3: Import Your Contacts

Before you upload your file below, make sure your file is ready to be imported

Access the Import Contacts Section

  1. Navigate to the Contacts section in GLM.
  2. Click on Import Contacts at the top.
  3. Choose whether you want to import Contacts or Opportunities (or both). For this example, select Contacts.
  4. Click Next in the bottom-right corner.

Upload Your File

  1. Upload your file containing the contacts you want to import.

    Choose your preferred import method:

    • Create Contacts: Adds new contacts.
    • Create and Update Contacts: Updates existing contacts if they already exist while adding new ones.
  2. Select Next in the bottom-right corner.

Map the Fields

  1. Ensure that fields like First Name, Last Name, Email, and Phone Number are correctly mapped to the corresponding columns in your file.
  2. Click Next to proceed.

Configure Additional Settings

  1. Optionally, you can:
    • Create a Smart List: Name and organize the imported contacts.
    • Add to a Workflow: Assign the imported contacts to an existing workflow.
    • Add Tags: Label the imported contacts for easier management.
  2. Adjust these settings as needed.

Start the Bulk Import

  1. Check the confirmation box at the bottom of the screen.
  2. Click Start Bulk Import to begin the process.

Bulk Importing Multiple Emails or Phone Numbers per Contact

  • The system supports importing multiple emails or phone numbers for a single contact, using the Additional Emails and Additional Phone Numbers features.
  • Multiple email addresses/phone numbers should be separated by commas, slashes (/), or semicolons (;) in one column, then mapped to the "Additional Emails" or "Additional Phone Numbers" fields during the import process.
  • You can import up to 10 email IDs or phone numbers per contact.

Conditions for Importing Multiple Emails/Phone Numbers

If the primary email/phone is blank but the additional field has data, the first additional entry will become the primary contact information.

If a contact already exists, new emails or phone numbers will be combined with existing data.

Invalid emails or phone numbers will be discarded during the import.

Steps to Import Contacts with Multiple Emails/Phone Numbers

  • In the Contact Import section, map your additional emails and phone numbers to the corresponding fields.
  • Ensure all extra emails/phone numbers are in one column, separated by commas, slashes, or semicolons.
  • During mapping, match these fields to the system’s Additional Emails or Additional Phone Numbers fields.