CSV Import Prep in Google Sheets

☝️Please note that in this article we use +49, Germany's country code, as placeholder. Any other country code can be treated exactly the same way.

Phone number starts with = / 0049 / 1 / 49

	A	B	C	D
1	First name	Last name	Phone number ❌	Phone number ✅
2	Maurizio	Superchat	0156784321001	+49156784321001
3	Oliver	Superchat	0049156784321002	+49156784321002
4	Inka	Superchat	156784321003	+49156784321003
5	Juri	Superchat	49156784321004	+49156784321004

To ensure that your contacts are imported into Superchat with the correctly formatted phone numbers, you need to format them in Excel/Google Sheets.

If the phone numbers are formatted in one of the formats from column C, you can change them to the correct format using the following formula: In this case, we are changing the format of cell C6, which you will need to adjust depending on the row.

=IFS(LEFT(C6,4)="0049",SUBSTITUTE(C6,"0049","+49",1),LEFT(C6,2)="01",SUBSTITUTE(C6,"0","+49",1),
LEFT(C6,1)="1","+49"&C6,LEFT(C6,2)="49","+"&C6)

Phone number contains characters

	A	B	C	D
1	First Name	Last Name	Phone Number ❌	Phone Number ✅
2	Maurizio	Superchat	+49 15678 4321001	+49156784321001
3	Oliver	Superchat	+4915678/4321002	+49156784321002
4	Inka	Superchat	+49AA156784321003	+49156784321003

In this case, you don't need to do anything further, all characters will be ignored during upload. The important thing is that the number starts with +49.

First name & last name separation

	Name ❌	First Name ✅	Last Name ✅
1	Maurizio Blötscher	Maurizio	Blötscher
2	Oliver Klötzer	Oliver	Klötzer
3	Inka Seidel	Inka	Seidel

Assuming your Google Sheets 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,SEARCH(" ",A2))
Now the first name from A2 should be displayed in the correct format in B2

If you then want 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 be displayed in the correct format in C2

CSV Import Prep in Google Sheets

To get phone numbers, first name, and last name into the correct format, simply follow our instructions below.