TABLE OF CONTENTS

  1. How to import multiple email addresses?

    To import multiple email addresses from a CSV or XLSX file, include a separate column for the “Primary email”. For the other emails in your file, you can add a separate column called “Other Emails”.
    Here is an example: To import the below email addresses, here is how you can format your file:

    Jamessampleton@gmail.com - Primary email
    Jamessampleton123@yahoo.com - Other email
    Jamessampletonxyz@gmail.com - Other email 
    Once you’re done with formatting, ensure that the fields are mapped as below, while uploading your file:

     

  2. How to import multiple phone numbers?

    When your contacts have multiple phone numbers apart from the “Mobile” and “Work” fields, you will have to list the other phone numbers in separate columns on your sheet and map it to the “Other phone numbers field”.






    The CRM allows you to save up to 10 values in “Other Phone numbers” field.

  3. I want to assign customer data to different sales reps via Import. How do I get this done?

    You can assign different sets of records to sales reps by mapping the “Sales Owner” column during import. In your file, ensure that you enter the sales rep’s exact email address that they have used to log in to their CRM account.
     

  4. What are the different ways to import CSV/XLSX data? And when to use them?

    You can perform the below functions while importing data to your CRM account:
    1. Create new contacts
    2. Create new contacts and update existing ones
    3. Update only existing contacts
              Create new records only: This captures all the data from the CSV/XLSX file as new records and does not look for duplicates.


      Create new records and update existing ones: This not only imports data from the CSV/XLSX file as new records but also updates any matching existing records based on your unique field identifiers.


      Update only your existing records: This strictly updates data in the system by using the CSV/XLSX file information and does not add any new records, ensuring only existing entries are modified.


      For example, if you are trying to update values based on “Emails”, Choose “Email” as highlighted below.
       

  5. What are the acceptable formats for date fields?

    You can choose between one of the following three formats:
    • DD/MM/YYYY
    • MM/DD/YYYY
    • YYYY/MM/DD
      You can also use periods(.) and hyphens(-) to separate date, month, and year in the file.

  6. How to format date information in Excel?

    To customize the date format in Excel, follow the below instructions:
    To successfully import date fields to the CRM, it needs to be in one of the formats specified above on point 5.
    1. First, select an option from the date format list. Once you’ve selected your preferred format, you can customize it and change it.
    2. In the “Category” menu, select “Custom”
    3. The type you chose in Step 1 will be displayed here. 
    4. In the “Type” box, enter the correct code to alter the date
    5. If you are trying to change the date display to DD/MM/YYYY, simply go to Format Cells > Custom
    6. Next, Enter DD/MM/YYYY in the available space given.
      For more information, refer to this article: https://support.microsoft.com/en-us/office/format-a-date-the-way-you-want-8e10019e-d5d8-47a1-ba95-db95123d273e

  7. How to format dates in Sheets?

    To successfully import date fields to the CRM, it needs to be in one of the formats specified above on point 5.
    To customize the format, follow the below instructions.
    1. Select the date column on your spreadsheet.
    2. Next, go to Format >Numbers>Custom Number Format, and fill in the desired format.
      For more information, refer to this article: https://support.google.com/docs/answer/56470?hl=en&co=GENIE.Platform%3DDesktop#zippy=%2Ccustom-date-formatting

  8. Where can I find my past imports?
    You can view Import History from your All Contacts page.


  9. What are the required fields to be mapped before importing?

    You can view all the required fields on the first page of the import screen. You will be able to view an alert box with the list of required fields to be mapped. Please ensure that you have data for all these fields before importing.
    Here is an example: 
     

  10. What is the maximum file size for a CSV/XLSX Import?

    The maximum file size is 5 MB. Ensure that your file size does not exceed 5MB to successfully import all your data

  11. What file formats does the CRM support?

    The CRM supports files in .CSV and .XLSX formats.

  12. How to import social media fields such as Facebook, Twitter, and Linkedin?

    When importing social media fields, make sure that your CSV/XLSX file is populated with the username(only) rather than the URL of the profile.
    For example, when you want to import a Facebook profile https://www.facebook.com/jane.sampleton, ensure that your file has only jane.sampleton, so that the fields are successfully imported.

  13. Why are all my imported Deals in the new stage?

    If your intent is to import deals in different stages of a pipeline and if all the imported deals are marked as “New”, you may not have mapped the field “Deal Stage” while importing, or it could be that you don’t have the exact matches with the deal stage names.
    To find your Deal Stages, navigate to Admin Settings>>CRM Modules and Automation>>Pipelines.


  14. Contacts and accounts can be imported together from the Contacts module.


    1. To Create or import new accounts while importing contacts, choose the below option and follow the same steps as mentioned here:

    2. Verify the mapping of the mandatory account fields. All mandatory account fields need to be mapped to a corresponding CRM field. If you have missed any, you will encounter the below error:
      Note: If there are multiple (account) field values associated with a contact, the CRM updates the contact with the latest value. For example: Contact A with Account Name X already exists on the CRM, and your import file contains Contact A with Account Name Y, then the CRM updates Contact A with Account Name Y


  15. How to import multiple values to a record?

    If you're trying to import a multi-select field (with multiple values) or a bunch of tags, the field values should be separated by a semicolon (;) in the CSV/XLSX file. 

    For example: If you have an existing multi-select field called ‘Interested Products’ with multiple choices/values such as Freshdesk, Freshsales, Freshservice, etc., the ‘Interested Products’ column in the CSV/XLSX should be formatted as represented in the table below:

    EmailInterested Products
    laer.bloomington@acmeglobal.com
    		Freshsales; Freshservice; Freshdesk
    sarah.neruvisk@pigmentcorp.com
    		Freshservice; Freshsales