How to Import into an SMS List

Import SMS List

If you would like to upload a list of SMS subscribers, use the Import SMS tool to import this list into an already existing list.  To create a new SMS list, follow the steps in the How to Create a New SMS List Wiki article, then return to the Import SMS List screen.

Make sure that the list is saved in CSV format.  It would look something like this in Excel, saved as a CSV file.

Note: There must be an SMS number for each subscriber, or they will not be imported into the list.  Also, if the file has multiple worksheets then delete the extra sheets. Read How to save an Excel file to CSV format for more information.

Step 1: Import SMS List

1. Click SMS in the left-side menu, then click Import SMS
2. Click Import into Existing List.  (To create a new SMS List, follow the steps in the How to Create a New SMS List Wiki article.)
3. Select the list(s) to import the SMS numbers into. If you select multiple lists, your new data will be imported into each selected list.
4. Choose the Import file delimiter: whether your list values are seperated by commas (.CSV), spaces, or tabs.
5. Subscriber Conflicts: Decide what to do when subscribers are already in the database.
6. To upload your list, select either to upload from a file or to copy and paste the list in the format previously indicated as the Import File Delimiter.

7. Note: The import will automatically clean duplicates from the list. Also, no confirmation messages will be sent to your list, because we trust that you've already received permission.

Step 2: Map Columns of Imported Data to Custom Fields Stored in the System

Match each column of data you would like to import to a custom field.  Ignore all columns you don't want to import into the system.  Note: If you name the custom field the same name as a header row in your data, the field will automatically map to that custom field.  This can save a lot of time if you use many custom fields.

1. To map the imported data column to a custom field in the system, select the correct custom field drop down option.
2. If you want to map a column of data to a custom field that does not appear in the drop down selection, click Add New Custom Field. 
   
   
   1. Name the custom field. 
   2. Optional: give the custom field a default value which will be inserted whenever this custom field is left blank for a subscriber.
   3. Check the Editable on Profile Center box to allow subscribers to update/edit this field on the Profile Center.
   4. Save and Close the window.  Then select the new custom field from the drop down
3. Note: All fields must be mapped and one of the fields must be assigned to "SMS Number."  Click Ignore All Unassigned to ignore all of the columns not assigned to a custom field. 

Step 3: SMS Import List Information

Describe the origin of the imported list.  We have a strict policy against SPAM, so please make sure that you are using the contact information for the purpose for which permission was given to you.

View Imported List

After the list is imported (this may take a while if it is a large list), view the list in the Subscribers & Lists, Lists folder.  Click the list then click View List.