Home > Mailvio > Subscriber Management > Add subscribers by importing a spreadsheet

Add subscribers by importing a spreadsheet

Add Subscribers by Importing a Spreadsheet


The easiest way to import subscribers, along with their details (First Name, Last Name, etc) is via a spreadsheet import. You simply upload your spreadsheet, choose what happens to the columns of data, and your subscribers are imported in a flash. If you only need to add one or two subscribers, you can save time by Adding Subscribers one at a time.

Here's how to import Subscribers from a Spreadsheet...

Step 1: Before you begin, you must make sure you are logged in to the MAILVIO control panel.

Step 2: Click the Subscribers tab at the top of the MAILVIO Control Panel.


Step 3: Make sure you have added at least one group. Now click on the group name towards the left of the page. This will take you into the group view where you can do a lot of things, one of which is adding new subscribers.


Step 4: From the "View Group" page you are now on, click the "Add Subscribers" sub-menu item towards the right side of the page.


Step 5: Select the "From a Spreadsheet" option.


Step 6: On the next screen, you get to upload your spreadsheet and tell us a little bit about the file and what you would like to happen to the subscribers that are imported.

First, click the "Browse" button and select the spreadsheet file on your local computer. At the moment we only support "CSV" files. If you are using Excel you can easily save any spreadsheet as a CSV file.


Step 7: The other options on the page are optional. Here's what they do:

Does your Spreadsheet contain a header?

Tick this if your spreadsheet has a row at the top containing column titles. If you tick yes we will simply ignore the first row of the file.

What is the current status of these subscribers?

Here you can specify a flag for the subscribers when they are imported. This is what each status means:

  • Active - The subscribers are opted in and can be mailed to.
  • In-Active - The subscribers remain on your list but will not be mailed to.
  • Unsubscribed - The subscribers will be flagged as unsubscribed and not mailed to.
  • Bounced - The subscribers will be flagged as bounced and not mailed to.
  • Blacklisted - The subscribers will be added to your global blacklist and will NEVER be emailed to as long as they stay on the blacklist.

Sometimes CSV files do not use commas to delimit fields. If you know your CSV file uses another delimiter, you can specify it here.


Step 8:

Click the "Upload and Continue" button at the bottom of the page. Your file will be uploaded, and the following page will appear. This page allows you to define what happens to each column of your spreadsheet.

You can select from your Custom Fields using the drop-down at the top of each column, or you can Add a New Field if you don't already have an appropriate field for the column. 
You can also choose to ignore columns.
Most importantly, make sure the column containing the email addresses of your subscribers is selected.
Once done, click the "IMPORT" button at the bottom of the page.


Step 9:

Any valid email addresses will now be imported. You can watch as the data is processed.
If any duplicates exist, they will not be imported. If any invalid emails exist, they will not be imported but you will have the chance to amend them if for example, there is a spelling mistake. And if any email addresses have previously unsubscribed, are on your blacklist, or are a "role-based email" they will not be imported.

You've added your subscribers!

Congratulations, you have added some subscribers to your group. You can now go ahead and send campaigns, automation, and much more.

Keep it Clean!

It's really important that you only send emails to people who really want to receive them. Please make sure that when you are adding subscribers, you are only adding the details of people who have permitted you to do so. If you don't you could end up in trouble not only with the subscribers but also with us as we may block your account if we receive complaints.


What happens if I import the same subscriber? Does it get added twice?

No - We check to see if the subscriber email address already exists. If it does we don't import it again.

What happens if I import the same subscriber, but with new details?

We update the details of the original subscriber. For example, if you upload a subscriber with a new First Name, we will leave the subscriber alone but will update their First Name.

What's a CSV file and how do I create one?
CSV stands for Comma Separated Value. It's a way spreadsheet programs can save data and then know how to open them and put your data back into the right columns. You can easily create a CSV file with programs like excel. Simply create or open an Excel Spreadsheet, and then click FILE -> Save As -> CSV