You are here:
Import Subscribers from a File
You can import email subscribers to Email Studio in Marketing Cloud Engagement by uploading a CSV file.
- Create a subscriber list.
- Review the recommendations for configuring and correctly formatting the import file.
- Choose Subscribers.
- Open the My Lists folder. If you've created a list subfolder under My Lists in which you want to import the new subscribers, choose that subfolder.
- Double-click the desired list or select the list, then choose Open List.
- Choose Import, which opens the Import Subscriber wizard.
- Choose Next in the wizard's introductory dialog box.
-
Read the content of the Opt-in Certification dialog box that appears next.
- If you’ve verified that every subscriber in your import file has agreed to receive emails from you, choose I agree, then Next.
-
Complete the Identify Source File dialog box:
- Upload Source - The import wizard shows you 2 upload options: Your Computer and FTP. To use a file that you've uploaded to the FTP site, type the file name in the FTP field. See the Enhanced FTP Guide for details on using the FTP option. If the file you want to import is on your hard drive, click the Browse button and locate the import file on your computer. Only files on a locally mapped drive are supported. You can’t upload a file from a UNC path, such as \\ abcfiles\.
- Data Format - Select either CSV, Tab-Delimited, or Other Delimited. With the Other Delimited option, enter a 1-character delimiter in the field.
- File is encrypted- If the advanced feature for encrypted imports is enabled in your account, choose File is encrypted if the import file you're using has been encrypted.
- Updated Options - You can add new subscribers and update existing subscribers, add new subscribers but leave existing subscribers alone, or update existing subscribers without adding new subscribers.
- Choose Next button in the Import Subscriber Wizard dialog box. The application reads the import file and performs a check for malware. The amount of time this check takes depends on the amount of data in the file.
-
Complete the 2 sections of the Map Attributes dialog box:
- Source - The Source section lists the data found in the first row of your import file. Labels that are unavailable have been mapped to attribute fields by default; labels shown in black font haven’t been mapped. If the first row of your import file is a header row, you see the column labels from your import file shown in the Source section. Choose First row is header so that the application doesn’t attempt to import that row as subscriber data. You can view all the data in your import file by the buttons below the Source section. To go to the next row or back to the row that was displayed, choose Next or choose Previous.
- Destination - The Destination section lists the profile and preference attributes currently defined in your account, separated into attributes that have been set up as required and those that haven’t. If the header row in your import file contains labels that exactly match attribute names, the application has mapped those labels to the attributes for you. The Mapped From column in the Destination section shows the label from your import file that's been mapped to the attribute shown in the Attribute column. Use Previous and Next to scroll through the rows of data in your import file. The Destination section updates to show how the data is mapped to the attribute fields.
-
If a field from your import file hasn’t been mapped for you to an attribute, map it as
follows:
- Click the field in the Source section. (Whether you're viewing the header row labels or a row of actual subscriber data in the Source section when you click the source field is unimportant. In either case, you're mapping all data from that column of your import file to the attribute.)
- Click the corresponding attribute in the Destination section.
-
Choose Map.
The column of data is mapped to the attribute. The value is unavailable in the Source section and the Mapped From value in the Destination section.
To remove a single mapping, click the attribute row in the Destination section and then choose Unmap.
To remove all current mappings (that is, all values from the Mapped From column in the Destination section), choose Clear Map.
To undo all changes you've made and return to the original mapping, choose Default Map. The default mappings were in place when you first opened the Map dialog box. Any fields still displayed in black font rather than gray in the Source section represent data that isn't imported.
- When you’re satisfied with your mapping, choose Next. Map any required attributes to fields in your import file before continuing with the wizard. Use the Confirm Mappings dialog box to view your selected mappings and the number of columns, or fields, and records, subscribers, in your file that the Email Studio attempts to import.
- If you want to be notified when the import is complete, choose Email me upon import completion and enter your email address. Your email notification also includes a log of any subscriber records that couldn’t be imported.
-
Choose Begin. The application begins the process of importing your
data. The amount of time that the import takes depends on the size of the import file.
If the import produces a result file that is 5 MB or larger, the system delivers the file to your enhanced FTP account. This action occurs even if you chose to receive an email when the import is complete. If you don’t have an enhanced FTP account, you instead see a message asking you to call Global Support for additional assistance.
If you didn’t choose to be emailed when the import is complete, a dialog box appears when the import is complete. The dialog box includes the results of the import, and it includes a button that lets you download the results. You can also open the list that you imported the subscribers into.
