Net Atlantic Inc. Professional Email Marketing and Email Deliverability Experts

Professional Email Marketing

Adding List Members (Subscribers) Guide


Creating a .CSV File of Your Subscribers

There are many different ways to add your subscribers to your list. One method is described below. Probably the easiest way to add your subscribers is to simply log in to your control panel and paste in your subscribers under Add Many Members.

If you have many subscribers to add to your list or you also desire to include various demographic information with field values such as Client, Prospect, ZipCode, State, AreaCode, ItemBought, AmountPurchased, Paid, FreeTrial, ExpireDate, Gender, MaritalStatus, Birthday, etc. the best way to do this is by creating and importing the data from a .CSV file (comma separated value). One reason to do this is so that you can subsequently query on this information to create different segments that you can send mail to. Another reason is so that you can perform a mail merge with this information in order to automatically insert these values into your email messages.

  1. Create a .csv file
    Note:To create a .csv file it is best to use Microsoft Excel or a similar program. When saving an Excel file, your file must be saved as a .csv. To do this click File and Save As. Choose CSV (comma delimited) *csv. from the Save As Type drop down menu located at the bottom of the window, then click Save
  2. In row 1 enter the custom fields you would like to use, see How to Create a Segment for a list of available fields
  3. In the columns available, add any information that you would like to segment by

Download these example Excel files to help you create your own.

Professional Level Sample CSV File(includes 6 extra fields)
Enterprise Level Sample CSV File (includes 35 extra fields)

Note: Remember to follow instructions above to convert file to .csv format. Do not change the values in Row 1, these values are necessary to import your subscriber information.
sample CSV file

Adding Subscribers to Your List by .CSV Import

Once your .csv file is ready, you can import your subscriber information to the mail server. While logged into the Net Atlantic control panel:

  1. Click on Members
  2. Mouse over Add Members to open the dropdown menu
  3. Choose Import from CSV File
    Control Panel - Import from CSV file
  4. Select Use types setting in CSV file, in the Action section if import contains MemberType_.
  5. The Update existing members?: section only needs to be checked if you are updating information for members already in your list. If these are new email addresses you can select "no".
  6. Terminate Import, You can select "Do not terminate import due to malformed addresses".
  7. Click on Browse and locate the .csv file you created
  8. Click Next where you will be brought to the Mapping Fields section

  9. Here you can click in the Column Name section where you will select the corresponding field for each column on the imported file.
  10. If you know the Column name you would like to map to, you can start typing the name and are displayed a list of matching fields for you to select from.

    Completed Field Mapping shown below:

  11. Once you have completed your field mapping as shown above you will then click on import to complete the process.

Ready to take the next step?

Fill out this form and one of our email specialists will contact you about how we can help you achieve even greater engagement by switching to Net Atlantic for email marketing services.
RESOURCES

Our Other Services Include

Inbox Experts

An expert service designed for the modern marketer looking to improve their inbox delivery, increase engagement, and increase the rate of return on their marketing spend. Pricing starts at $297.
Learn More >

WeSendIt

Outsource your outbound email campaigns to the email experts at WeSendIt. Relax while we prepare and send your next email marketing campaign for you. Great for both small and large email marketing campaigns.
Learn More >

ListBuddy

Put ListBuddy on your side to clean and validate your list. When your list is properly maintained, your email marketing campaigns will reach more inboxes, achieve better engagement, and deliver higher returns.
Learn More >