Resources     Blog  

  1. Home
  2. cPanel Tutorials
  3. How to Import Email Addresses into cPanel

How to Import Email Addresses into cPanel

Creating an email account in cPanel is easy. But what if you have a long list of email addresses to set up? You’re in luck because it’s easy to import email addresses into cPanel.

In this tutorial, I’m going to show you how to import a list of email addresses, as well as a list of email forwarders.

How to Format an Address List for Import

To import your list of email addresses, the list has to be either an .xls (Excel) spreadsheet or a .csv (Comma Separated Value) file.

You don’t necessarily need the Microsoft Excel program to create a .xls file. Some open source spreadsheet programs will save files in the .xls format. Note that cPanel will not import email address lists saved with the newer Excel .xlsx extension.

The .xls file should be formatted with one address per line, followed by the email account, password and the mailbox quota in megabytes:

cPanel email address importer, xls file format

You can create a CSV file with many spreadsheet programs. If you don’t have access to one of these, you can use a text editor.

If you use a text editor, save the file as a .txt (text) file, then change the file extension to .csv before importing into cPanel.

The .csv file should also be formatted with one address per line followed by the email account, password and the mailbox quota in megabytes, all separated by commas:

cPanel email address importer, csv file format

Note that in both examples above I used the first rows as column headers. Column headers are not required for import.

How to Import Email Addresses into cPanel

Log in to cPanel and in the “Email” section, click the “Address Importer” link or icon.

cPanel email address importer, step 1

Click the “Choose File” button.

cPanel email address importer, step 2

If you upload an .xls file, you will see the option, “Treat first row as column headers.” If the first row of your spreadsheet is column headers as in the example above, make sure the option is checked.

Click the “Next” button.

cPanel email address importer, step 3

If you upload a .csv file, in addition to the “Treat first row as column headers” option, you will also have a “Select Delimiter” option.

Since you created a comma-separated list, select “Comma (,).” As you can see, the list could also be separated by tabs, semicolons or other delimiters.

Click the “Next” button.

cPanel email address importer, step 4

The next page will display a list of the addresses that were in your uploaded list. Here you can change the header for each column if necessary.

There is also an option to “Select the domain for the users in the list.” If your cPanel account only has one domain attached, there’s no need to change the setting.

If you have multiple domains in cPanel, make sure the domain in the drop-down matches the addresses you are importing.

Click the “Next” button.

cPanel email address importer, step 5

You will get a final opportunity to verify that all the information is correct. If it is, click the “Finish” button. If it is incorrect, click the “Go Back” link under the list.

cPanel email address importer, step 6

The import will proceed, and you’ll see a readout of successful address imports.

cPanel email address importer, step 7

Importing Email Forwarders into cPanel

Importing a list of email forwarders is the same as the process above, but the address list that you import is formatted slightly differently. It’s still one address per line, but here the forwarder address is followed by the forward-to address:

cPanel email forwarder importer, xls file format

And in the first step, instead of “E-mail Accounts,” select the “Forwarders” option.

cPanel email forwarder importer, step 2

Importing Made Easy

Now that you know how to import lists of email addresses into cPanel, you can save the time and the headaches of creating addresses one by one.

Have you ever had to move a large number of email addresses to a new account? If you have to move a large number of email addresses in the future, do you think you’ll use the cPanel import method?

Author: Michael Phillips

Michael Phillips is a web hosting industry veteran, helping people make the most of their web presence since 1995.

Was this article helpful?

Related Articles

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.