Import Email Subscribers From a File
Prepare your file for importing
Steps to import subscribers from the file
You can import subscribers using a number of common file formats, even compressed files for the really large files. Accepted file formats include:
| Excel documents | XLS, XLSX, CSV |
| Comma separated value text files | CSV |
| Tab delimited text files | TXT |
| vCard files | VCF, v card |
| Compressed file formats | ZIP, RAR, 7Z |
By adding people to a subscriber list, you are asserting that you have permission to email them. If you're not sure, read more about what counts as permission to send. Importing subscribers without their permission may result in the immediate termination of your account.
File Preparation
Before importing your file, there are a few important steps you can take to make sure they correct data is imported.
Deleted subscribers
If you're importing to a list of existing subscribers, make sure the file doesn't contain email addresses for anyone previously deleted from the list, because it will change their subscriber status from "Deleted" back to "Active".
To cross-check deleted subscriber addresses against the list you intend to import, first export the existing list of subscribers selecting "Manually Deleted Subscribers" from the Export menu.
Excel files
When importing an Excel file, ensure that all of your subscribers are on one sheet. When a file with multiple sheets is imported, only the data from the first sheet is captured.
Non-English characters
If your list of subscribers contains non-English characters, ensure the file is saved using UTF-8 encoding before you import it. Most text editors, such as Notepad and TextEdit, offer encoding options when you save the file.
Supported formats for importing date data
| YYYY-M-D | D-M-YYYY | D-M-YY |
| YYYY/M/D | D/M/YYYY | D/M/YY |
| YYYY.M.D | D.M.YYYY | D.M.YY |
M and D can represent 1 or 2 integers (eg. M or MM, and D or DD).
Pro Tip: For consistency and best practice, we suggest using the international standard YYYY-MM-DD for importing dates, more details on that can be found here.
Permission to track
Privacy is a growing concern for many users. You can optionally include whether a subscriber has given permission to have their email opens and clicks tracked when importing a file.
Tracking permission is updated across all of your lists. For example, if recipient@example.com is on two different lists, changing their tracking permission on one list will update the other.
To set an email address' permission to track response, create a column in your spreadsheet program or CSV file with the heading permission to track. You can then use yes, no, or unknown as the values for specific email addresses to set whether a subscriber has given their permission or not. A subscriber with an "unknown" permission to track response will be tracked until their setting is explicitly set to no.
Import subscribers from a file
Follow the steps below to import a file to a subscriber list in your account. If you don't already have a list, create one first.
1. Click Lists & subscribers.
2. Click on a list name to open the list details page.
3. Click Add new subscribers in the right sidebar.
4. To import a file, either drag-and-drop it from your desktop or click the option to Select it from your computer.
5. Match the file columns with your subscriber list fields, as shown here:
6. Click Finish adding subscribers.
Related Articles
Understanding Deleted Email Subscribers
When you view your Email List engagement metrics, you may notice some subscribers listed as "Deleted". These subscribers can be found by selecting the Deleted tab when viewing an Email List. Typically, contacts in the Deleted tab have been manually ...Create an Email List
Use email lists to organize separate groups of subscribers like customers or employees. Need to take it a step further? You can also break your lists down into segments. Segments are a useful way to divide a list into groups of people with common ...Triggering Automated Journeys Using Existing Email Lists
When you create a new journey, your triggered automations will only send to new subscribers who join the list through your CRM by default. If you would like to share your new journey with contacts already on an Email List, then you have two options: ...Export an Email List
You can download an email list's subscribers and their details as a CSV (Comma Separated Values) file or a Tab delimited text file. If you have multiple lists, each one has to be downloaded as a separate file. How to export your subscribers To export ...Create Email Campaigns
The Email Campaigns page displays recently drafted and sent campaigns to give you quick insight into the current state of your email marketing. In this guide: What is a campaign? Regular campaign A/B test campaign Create a campaign Step 1: Campaign ...