There are two primary functions of Iterable's list import user interface:
Importing users to a new List
Import user lists by navigating to Audience > Lists and clicking Import List.
You will prompted to name your list, choose the type of list to create, and set some options:
- Create a Blank List With No Users - One use case for this would be if you wanted to include it in an Add to List action node of a workflow, where users would be added to the list after completing a certain path.
- Update Existing Users Only - Any new users that are entered into the import list will be ignored.
- Trigger Workflows from This List
Clicking Next will take you to a screen that allows you to:
- Drag and drop a CSV file into the window.
- Select a CSV file from your computer.
- Manually enter the list data.
- In order to import users via CSV upload, email is required. You will not be able to import users without email addresses.
- It is a best practice avoid leaving spaces between field names/values in the header and rows of your CSV and when manually typing in the data—especially for fields that are of type long.
Once you click Next, you will be brought to the Review page and prompted to verify that all details of your list are correct.
The Review page also shows you the new user fields that will be added to your Iterable project because of your CSV upload. You'll notice that this is the case for
birthMonth, above (green text to the right of New User Fields to be Added).
Unless set in a specific format, new users fields are set as strings by default. You can set three data types within the Create List page: string, boolean, and date. Dates should be in one of the following formats if setting via the UI: YYYY-MM-DD HH:MM:SS or YYYY-MM-DD.
You will not be able to change the name or data type of user fields once they have been created. Once a user field is set as a certain type, it is permanently that type. You also can't delete user fields once they have been created.
For more information on field data types, read Field Data Types.
Once everything looks correct, click Upload Subscribers, and view the Results page, where you can choose to view the list, check out the details of your list, or choose to upload another list. If you uploaded your list successfully, you will see a page like this:
If you try to upload a CSV with values that don't match the data types of existing user fields, your list will be created, but users with incorrect values will not be added to the list or created within your project. Only users with correct values will be added to the list and created if they don't already exist.
Iterable shows you the number of rows with invalid fields and which values are incorrect.
Users who do not meet Iterable's email validation requirements will also be dropped from the import.
- To learn about the best practices for CSV list import, read CSV list import best practices.
- To learn about migrating subscribers from another email service via CSV uploads, read Migrating subscribers from another email service via CSV uploads.
Adding users to an existing list
To add users to an existing list, navigate to Audience > Lists. Find the list that you want to add to and then hover over it with your mouse cursor. An Add Subscribers / Modify List option will appear.
Click on that text to launch a screen similar to the one for new list imports. Follow the same instructions as above to add users to the selected list.
Column names may not contain special characters. Using special characters in a column name will prevent users from being uploaded.