...
💡Verify your account and unlock the FREE+ plan with 10,000 emails & 2,000 contacts at no cost!
EN
Select your language

How to Import Phone Numbers

If you have your customers' phone numbers, you can upload them to Selzy and use them to personalize content of your emails.

Preparing the file

File format and size

Files in CSV, XLS, XLSX, and TXT formats are suitable for uploading.

XLS and XLSX files may have additional formatting elements, table borders, formulas, merged cells, and other elements that prevent importing the data correctly"(present tense). Therefore, we recommend that that you save your XLS and XLSX files as CSV files.

The file encoding is UTF-8.

The maximum file size is 20 MB.

The maximum number of columns in a file is 50.

Format of phone numbers

Phone numbers must be in international format, starting with the + symbol and the country code, or starting with the country code. For example, +551234567890 or 551234567890 are correct formats.

Country  Incorrect number Correct number
USA 5155550111 +15155550111
Ukraine 0661234567 +380661234567
Spain 917146300 +34917146300
Kazakhstan 87015511222 +77015511222

Importing a file

In your account, go to Contacts — All Contacts and click on the Add Contacts button. The button is also available from the Lists tab and from every email list.

 

Choose Import contacts, if you want to upload a file or Add one contact for adding phone numbers manually.

Choosing between importing contacts from the file or adding each new contact manually

The import page opens.

The import page

There are two ways to import contacts:

From file. Click Upload a file and select the file to be imported, which meets the requirements.

Manually. Go to the Manually tab, add the contacts you want to upload and click Continue.

Next, configure the fields. Set the required field Email. Next to the phone numbers, select Mobile phone number. Click Continue.

Import settings

Select the contact list and click Import.

Selecting a contact list.

Data import is completed.

If errors occured during import, click "Error Report" to download the report.

Import result

In the report, you can see why not all contacts were imported and the reasons for errors. These can be, for example, duplicate contacts, errors in email addresses and phone numbers.

Frequently asked questions

How duplicates are imported

Since the Phone field is optional and the Email field is mandatory, the system will only check email for uniqueness. You can import phone number duplicates to the list if the email addresses are different.

Examples:

1.Uploading two contacts:

Email Phone Name
[email protected] +15555550125 Jim
[email protected] +15555550125 Martha

The phone numbers are the same, but the email addresses are different, so both contacts will be added to the list.

2.Uploading two contacts:

Email Phone Name
[email protected] +15555550125 Martha
[email protected] +15555550125 Martha

The phone numbers are different, but the email address is the same, so only one contact with a phone number which is imported last will be added to the list.

How to replace phone numbers

If the list contains phone numbers with an incorrect or outdated country code, you need to fix them. In Excel, you can do this in bulk.

Let us assume, we have a file with three columns - "Email", "Phone", "Name". In some cells, the phone number starts with "0" (local UK format), while in some with "44" or "+44".

Numbers with an incorrect country code.

To fix the numbers that start with "0", use the formula:

=IF(AND(LEN(B2)=11;LEFT(B2)="0");("+44"&MID(B2;2;10));B2)

Copy it and paste it into an empty cell in an empty column. Then double-click on the plus sign in the lower right corner of the cell to apply the formula to an entire column the formula to the entire column.

Insert a formula into a cell

How this formula works:

  • If the first digit in the phone number is "0", but the number has 11 digits in total, then the first digit changes to "+44".
  • In all other cases, the number remains the same.

Important!

The formula works correctly if the phone numbers are in column B. If your file has a different column positioning, change their positions or insert a letter of the desired column in the formula.

Now let's replace the old column containing phone numbers with a new column.

To do this, enter "Phone" in the upper cell, copy the entire column and paste it instead of the old one. When pasting, it is important to use values from the copied cells. If you just insert text, the copied formulas will not work.

Replacing the old column containing phone numbers with a new column.

The file is ready for import.

How to correct mojibake in a file

Sometimes when importing contacts, you may see unreadable characters, such as:

Mojibake in the file.

The reason is incorrect encoding. In such cases, the file must be converted to UTF-8.

How to Change File Encoding to UTF-8 in Excel

Useful links:

Create a Contact List
Delete a Contact List
Copy or Move Contacts Between Lists
See Contact Information & Campaign History
Rename a Contact List
How to Update Your Contact List
How to Segment Your Contacts

In this article
Did we answer your question?
1
0

To get more help, contact our Support Team. They are available for all Selzy users 24/7.