There are two primary functions of our List Import UI:
Importing Users to a New List
In Iterable, you can import user lists through the Import List tab under Users or through the Import List button of the Lists page.
On the Import List page, you will be brought to the Basic Info stage, where you will be prompted to name your list and choose the list type that you would like to create. There are also options to:
- 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
- Or manually type out the data through the textarea input
Note: In order to import users via CSV upload, email is required. You will not be able to import users without email addresses.
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 "city" and "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 Import 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.
WARNING: 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 data field types, click here.
Once everything looks correct, click "Upload Subscribers" to be brought to 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 receive 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.
Note: Iterable shows you the number of rows with invalid fields and which values are incorrect.
Users who do not meet our email validation requirements will also be dropped from the import.
To learn about the best practices for CSV list import, click here.
To learn about migrating subscribers from another email service via CSV uploads, click here.
Adding Users to an Existing List
To add users to an existing list, navigate to the Users > Lists tab in the left navigation bar. Find the list that you want to add to and then hover over it with your mouse cursor. An "+ Add subscribers / Modify list" option should appear.
Click on that text to launch a screen similar to the one for new list imports. Follow the same instructions - starting at step 2 here - to add users to the selected list.
- Column names can't contain special characters, this will result in a list upload of 0 users.