Data in contact imports needs to follow our formatting rules and conventions to be added or updated correctly in Superchat. You find common Excel formulas to format data in your CSVs before uploading the CSV to Superchat.
Preparation
1. Open your CSV file in Excel.
Format phone numbers from national format to E164 format (international format)
Superchat requires all phone numbers to be in E164 (international format).
A | B | C | D |
First Name | Last Name | Phone Number (Nat.) | Phone Number (Intl.) |
Maurizio | Superchat | 0156784321001 | +49156784321001 |
Oliver | Superchat | 0156784321002 |
|
Inka | Superchat | 0156784321003 |
|
Assuming your Excel file is set up as above
C2 = Column with the number starting with 0
D2 = Empty column for the correctly formatted number
To format the number, follow these steps:
1. Insert the following formula into D2: =SUBSTITUTE(C2, "0", "+49", 1)
2. Now the telephone number from C2 should appear in the correct format in D2.
Format phone numbers from 0049 to E164 format (international format)
A | B | C | D |
First Name | Last Name | Phone Number ❌ | Phone Number ✅ |
Maurizio | Superchat | 0049156784321001 | +49156784321001 |
Oliver | Superchat | 0049156784321002 |
|
Inka | Superchat | 0049156784321003 |
|
Assuming your Excel file is set up as above:
C2 = Column with the number starting with 0049
D2 = Empty column for the correctly formatted number
To format the number, follow these steps:
Insert the following formula into D2:
=SUBSTITUTE(C2, "0049", "+49", 1)Now the telephone number from C2 should appear in the correct format in D2.
Format phone numbers from 1 to E164 format (international format)
A | B | C | D |
First Name | Last Name | Phone Number ❌ | Phone Number ✅ |
Maurizio | Superchat | 156784321001 | +49156784321001 |
Oliver | Superchat | 156784321002 |
|
Inka | Superchat | 156784321003 |
|
Assuming your Excel file is set up as above:
C2 = Column with the number starting with 1
D2 = Empty column for the correctly formatted number
To format the number, follow these steps:
Insert the following formula into D2:
=LINK("+49", C2)Now the telephone number from C2 should appear in the correct format in D2.
Format phone numbers from 49 to E164 format (international format)
A | B | C | D |
First Name | Last Name | Phone Number ❌ | Phone Number ✅ |
Maurizio | Superchat | 49156784321001 | +49156784321001 |
Oliver | Superchat | 49156784321002 |
|
Inka | Superchat | 49156784321003 |
|
Assuming your Excel file is set up as above:
C2 = Column with the number starting with 49
D2 = Empty column for the correctly formatted number
To format the number, follow these steps:
Insert the following formula into D2:
=LINK("+", C2)Now the telephone number from C2 should appear in the correct format in D2.
Telephone number contains characters
A | B | C | D |
First Name | Last Name | Phone Number ❌ | Phone Number ✅ |
Maurizio | Superchat | +49 15678 4321001 | +49156784321001 |
Oliver | Superchat | +4915678/4321002 | +49156784321002 |
Inka | Superchat | +49AA156784321003 | +49156784321003 |
You don't need to do anything further here; all characters will be ignored during upload. The important thing is that the number starts with +49.
Separating First Name & Last Name
A | B | C |
Name ❌ | First Name ✅ | Last Name ✅ |
Maurizio Blötscher | Maurizio | Blötscher |
Oliver Klötzer | Oliver | Klötzer |
Inka Seidel | Inka | Seidel |
Assuming your Excel file is set up as above:
A2 = Column with the full name
B2 = Empty column for the first name
C2 = Empty column for the last name
To format the first name, follow these steps:
Insert the following formula into B2:
=LEFT(A2, FIND(" ", A2))Now the first name from A2 should appear in the correct format in B2.
To format the last name, follow these steps:
Insert the following formula into C2:
=RIGHT(A2, LEN(A2) - LEN(B2))Now the last name from A2 should appear in the correct format in C2.