Format phone numbers for bulk import

Genesys Cloud follows the E.164 specification for phone numbers used within the system. When you bulk import external contacts and external organizations through a .csv file, the input phone numbers in your .csv file must follow the E.164 standard. This article describes how to format the phone numbers before you import them into Genesys Cloud.

Note: The bulk import feature accepts valid formats of phone numbers and converts them into a consistent format. The invalid phone number formats are not converted and are not imported into the system. While processing those numbers, any relevant errors appear during the data validation step.

Acceptable phone number formats

The bulk import feature and enrich APIs recognizes the following phone number formats and processes them internally to suit the identity resolution algorithm for contact matching:

  • +441213315xxx
  • +1 232xxx4316
  • +29234xxx32432
  • +1 xxx 555 5554
  • +591 743392xxx3
  • +1 321 yyy 9872 x 123
  • (+44)121.xxx.5251
  • +1 415-xxx-2629

Acceptable country code formats

The bulk import feature and enrich APIs recognizes and processes the following country code formats supplied in the Phone Number column in the .csv template:

Phone number that starts with a + sign

  • US: +1
  • GB: +44
  • HU: +36

Phone number that starts with 00

  • US: 001
  • GB: 0044
  • HU: 0036

Other phone number formats

  • To use this format, you must provide the country code in the Country Code column (for example, US, GB) in the .csv template:
    • US: 1
    • GB: 44
    • HU: 36
  • Any other country-specific format, you must provide the country code in the Country Code column (for example, US, GB) in the .csv template: 
    • HU: 06

Non-E.164 format examples

Generally, the bulk import feature does not process non-compliant E.164 phone numbers and displays appropriate warnings and error messages.

Non-E.164 formats may have: 

  • Less than the expected digits
  • More than the expected digits
  • Non-numeric characters

Errors and warnings

These example scenarios describe phone number-related errors and warning messages. 

Example scenario 1

In this scenario, the phone number follows E.164 formatting but does not match the North American format. The bulk import feature applies the North American formatting by inserting required dashes.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message
+13216549870 +1 321-654-9870
+1 3216549871 +1 321-654-9871

Example scenario 2

In this scenario, the phone number follows E.164 formatting but does not match the UK format. The bulk import feature adjusts formatting by removing dashes, and adding required spaces.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message
+44 1213315014 +44 121 331 5014
+44 121-231-5416 +44 121 231 5416

Example scenario 3

In this scenario, the phone number is not E.164 compliant due to extra digits or characters in the input, and no normalization country code is specified. If you proceed with the import, the bulk import feature stores the number as-is in the system and a warning message appears at the end of the import process.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message
(+44)121 231 54023 (+44)121 231 54023

contact.cellPhone[(+44)121 231 54023]{Your phone number is not compatible with E164 standard};

contact.cellPhone.normalizationCountryCode[null]{You have to provide a normalization country code}

(44)1213315082 (44)1213315082

contact.cellPhone[(44)1213315082]{Your phone number is not compatible with E164 standard};

contact.cellPhone.normalizationCountryCode[null]{You have to provide a normalization country code}

(44) 121.331.5290 (44) 121.331.5290

contact.cellPhone[(44) 121.331.5290]{Your phone number is not compatible with E164 standard};

contact.cellPhone.normalizationCountryCode[null]{You have to provide a normalization country code}

  • The phone number (+44)121 231 54023 has extra digits in the input. 
  • The phone numbers (44)1213315082 and (44) 121.331.5290, have an invalid country code specified in brackets (44). For more information, see the Valid country code format section.

Example scenario 4

In this scenario, the phone number is not E.164 compliant due to a missing country code in the input or normalization field. If you proceed with the import, the bulk import feature adds the US country code by default.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message
321.654.9881 +1 321-654-9881

contact.cellPhone[321.654.9881]{Your phone number is not compatible with E164 standard};

contact.cellPhone.normalizationCountryCode[null]{You have to provide a normalization country code}

321 654 9879

+1 321-654-9879

contact.cellPhone[321 654 9879]{Your phone number is not compatible with E164 standard};

contact.cellPhone.normalizationCountryCode[null]{You have to provide a normalization country code}

Example scenario 5

In this scenario, the phone number is in E.164 format and the input phone number does not have a country code, however, the import file has the normalization country code in the normalization field. No warnings are generated, and the bulk import feature applies additional regional formatting as needed.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message

3216549891

US

+1 321-654-9891

US

(44)1213315095

GB

+44 121 331 5095

GB

Example scenario 6

In this scenario, the phone number is in E.164 format and the normalization country code is correctly specified in both the input number and the normalization field. No warnings are generated, and the bulk import feature applies additional regional formatting as needed.

Input phone number in .csv Normalization country code in the .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message

(+1)321.654.9838

US

+1 321-654-9838

US

+441213315039

GB

+44 121 331 5039

GB

Example scenario 7

In this scenario, the phone number is in E.164 format, but the input number and the normalization field have two different normalization country codes. A warning message indicates that the bulk import feature uses only the country code from the input phone number and ignores the normalization field value.

Input phone number in .csv Normalization country code in .csv Phone number stored in Genesys Cloud Phone normalization country code stored in Genesys Cloud Warning message

+13216549852

GB

+1 321-654-9852

GB

contact.cellPhone.normalizationCountryCode[GB]{Your phone number is from the US, but your country code is from GB. We are resolving your phone number with a US country code.}

(+44)1213315074

US

+44 121 331 5074

US

contact.cellPhone.normalizationCountryCode[US]{Your phone number is from the GB, but your country code is from US. We are resolving your phone number with a GB country code.}