Importing Subscribers from a Spreadsheet

The easiest way to import Contact, 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 Contacts are imported in a flash.

If you only need to add one or two Contacts, you can save time by Adding Contacts one at a time.

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

Step 1:

Before you begin, you must make sure you are logged in to the MPZMail control panel. If you don't already have an account you can create a free account.

Step 2:

Click  Contacts at the top of the screen and then select + Add Contacts If you haven't yet set up any Groups you will be prompted to do so before you can start adding Contacts. 

Select the Group you would like to add your Contacts to.

Step 3:

With the Group selected click Start Importing

Upload your CSV or XLSX file and then from the drop down select how MPZMail should handle contacts who exist in other Groups or on your blocklist. You can also define whether to import your contacts as Active, Unsubscribed or Blocklisted. 

  • 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 Contacts?
    Here you can specify a flag for the Contacts when they are imported. This is what each status means:
    • Active - The Contacts are opted in and can be mailed to.
    • In-Active - The Contacts remain on your list but will not be mailed to.
    • Unsubscribed - The Contacts will be flagged as unsubscribed and not mailed to.
    • Bounced - The Contacts will be flagged as bounced and not mailed to.
    • Blacklisted - The Contacts will be added to your global blacklist and will NEVER be emailed to as long as they stay on the blacklist.
  • Delimiter
    Sometimes CSV files do not use comma's to delimit fields. If you know your CSV file uses another delimiter, you can specify it here.

Once you have done this click Upload & Continue -> 

Step 4:

Once your file has been uploaded, you will need to map the column of your spreadsheet with the fields you use in MPZMail. 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 Contacts is selected.

Once you have mapped the fields click 

Step 5:

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 Contacts!

Congratulations, you have added some Contatcs to your Group. You can now go ahead and send campaigns, automations, 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 Contacts, you are only adding the details of people who have given you permission to do so. If you don't you could end up in trouble not only with the contacts, but also with us as we may block your account if we receive complaints.


What happens if i import the same Contact? Does it get added twice?

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

What happens if i import the same Contact, but with new details?

We update the details of the original Contact. For example if you upload a Contact with a new First Name, we will leave the Contact 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

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.