In order to get the import option enabled on your account, you will need to speak with a member of our account management team to discuss compliance so we are ensuring that all the contacts that you are importing are TCPA compliant.
How to Import Contacts
Click on the Contacts Tab.
Then click Imports / View Imports. Within the drop down, choose Import Contacts.
Within the pop-up you will need to:
Choose a CSV (comma delimited) (*.csv) file from your computer
Make sure it in in the correct format/column order
Column order: 10-digit mobile #, email, first name, last name, gender, birth date. No header is required. Any data you don't have, leave the column blank.
Make sure the country code is added to the beginning of your 10-digit numbers.
Choose the group you would like the contacts added to.
Choose to update or just skip existing contacts
If you never imported email addresses, and you now want to update existing contacts with emails, choose to update. If you do not choose to update, existing contacts will be skipped.
Note: at the bottom of the window before importing. This will indicate if your account is set up to send an opt-in confirmation, import confirmation, or if the contacts will be imported as active. An opt-in confirmation will require them to reply to opt-in and become an active contact.
Click Import Contacts.
How To Format CSV to Import Contacts
There cannot be a header and there needs to be a country code in front of all the numbers.
To import, the order of columns must be in this order:
Column A: Phone number
Column B: Email
Column C: First name
Column D: Last name
Column E: Gender
Column F: Birthday
Column G: (any custom fields you may have)*
If there is data you don’t have, just leave the column blank. The only data that is required to have a contact saved in your group is the cellphone number.
This tutorial is assuming all of the data possible is on the sheet, but usually people do not have to have all of this data.
This is how your file should start off looking like:
This is how your file will end up looking like to import:
First remove the header:
Then add the country code to the numbers. The easiest way is to have the numbers in column A, and then move everything over to leave column B empty to use it.
Type this into the first cell of column B. =”1”&A1
and press Enter.
Now, you can see that the first number is replicated with a country code in front. From here, if there are gaps in your list of numbers, we need to remove them.
Highlight the number column
Press F5 on your keyboard and select Blanks, and click OK.
Now that the blanks are selected, right click one of the blanks and delete by the entire row.
Now that there are no gaps, double click the lower right corner of the B1 cell. This will complete the whole list to the bottom and add the country code to all of them.
Copy the whole column B that’s already highlighted. Then paste with values into column A. To paste with values, you need to right click and select paste with values.
Once you’ve pasted the new numbers with their country code, delete the column Band it will be set and ready to import.
Save as a CSV file, and import into a group on Mobiniti.