Knowledge Base

How to import e-mail accounts and forwarders

This article describes how to use cPanel to import lists of e-mail addresses and forwarders. Importing can save you a lot of time instead of manually creating each account or forwarder.

Supported file formats

Before you can import e-mail addresses or forwarders, you must make sure that the information is in a format that cPanel supports. You can use comma-separated values files (commonly referred to as CSV files) or Microsoft Excel spreadsheet (XLS) files to import your data.

CSV files

If you use CSV files, cPanel supports the following data fields:

  • E-mail address or username
  • Password
  • Domain
  • Mailbox quota (in megabytes)

For example, you might have a line in a CSV file that looks like the following:

joesmith,FhW$^A1{g,example.com,10

In this line, joesmith is the username, FhW$^A1{g is the password, example.com is the domain, and 10 is the mailbox quota size in megabytes.

You do not have to use all of these fields. The only required field is the e-mail address (username). If you do not specify passwords, cPanel automatically generates random, strong passwords for you.
Microsoft Excel files

You can also use Microsoft Excel (XLS) files to import e-mail addresses and forwarders.

Importing e-mail addresses

When you have a file in the supported format, you are ready to begin the import process.

To import a list of e-mail addresses, follow these steps:

  1. In the Mail section of the cPanel home screen, click Import Addresses/Forwarders.
  2. Under Step 1, click E-mail Accounts.
  3. Under Step 2, click Browse, and then select the file that you want to use for the import process.
  4. If you are importing a CSV file, click the delimiter that your file uses under Step 3. The delimiter is often, but not always, a comma.
  5. Under Step 3, select the Treat first row as column headers check box if you want cPanel to ignore the first row of data in your file.
  6. Click Next.
  7. Under Step 1, select the correct headers for your data:
    • Ignore: cPanel ignores the entire column of data.
    • Email: cPanel interprets the column as e-mail addresses or usernames.
    • Password: cPanel interprets the column as passwords for e-mail accounts.
    • Domain: cPanel intreprets the column as the domain.
    • Quota (MB): cPanel interprets the column as the mailbox quota size, in megabytes.
  8. Under Step 2, select the domain for the e-mail accounts.
  9. Click Next.
  10. Review the information to make sure that it is correct, and then click Finish to import the data.

    The import process may take some time if you are importing a lot of data.

Importing e-mail forwarders

When you have a file in the supported format, you are ready to begin the import process.

To import a list of e-mail forwarders, follow these steps:

  1. In the Mail section of the cPanel home screen, click Import Addresses/Forwarders.
  2. Under Step 1, click Forwarders.
  3. Under Step 2, click Browse, and then select the file that you want to use for the import process.
  4. If you are importing a CSV file, click the delimiter that your file uses under Step 3. The delimiter is often, but not always, a comma.
  5. Under Step 3, select the Treat first row as column headers check box if you want cPanel to ignore the first row of data in your file.
  6. Click Next.
  7. Under Step 1, select the correct headers for your data:
    • Ignore: cPanel ignores the entire column of data.
    • Source: cPanel interprets the column as the source e-mail address.
    • Target: cPanel interprets the column as the destination e-mail address.
  8. Click Next.
  9. Review the information to make sure that it is correct, and then click Finish to import the data.

    The import process may take some time if you are importing a lot of data.

More Information

For more information about comma-separated values, please visit http://en.wikipedia.org/wiki/Comma-separated_values.