Another useful feature within cPanel is the Email Address Importer. This article will show you how to use the Email address importer and guide you through the process of setting up the CSV file (.csv) or Excel spreadsheet (.xls) needed to make it work.
But first thing is first. The Email address importer is a feature that allows you to create multiple Email accounts or Email forwarders simply by uploading a file containing all the addresses. This makes the process a lot easier, as opposed to adding each address by hand.
The only thing you need to look out for, is the way you format your Excel or CSV files beforehand. Depending on which option you choose, the Address Importer will read a set of fixed parameters.
How to Use Email Address Importer in cPanel
1. Login to your cPanel account.
2. Navigate to the Email section and select Address Importer.
3. Select whether to import E-mail Accounts or Forwarders.
3.1 Email Addresses
For the purpose of this “how to” article, we have already formatted a simple .txt file with three column headers which correspond to the variables required by the Address Importer. It will require Email, Password, Domain and Quota (MB). Here is how the input file looks like:
- In order to convert a .txt file into .csv or .xls, you can simply rename the file’s extension from .txt to .csv or to .xls. It will automatically convert into that file type.
- If you do not know one of the required variables, you can leave it blank in your input file and the system will select a default value. For example, in our Email Accounts.csv file we only provided the Email Addresses, Password and Domain fields. The Quota (MB) will be automatically assigned to each account.
By selecting the Forwarders option, you will be required to upload a file with only two types of information columns: source and target. If you have already pre-formatted your .csv or .xls file beforehand, that’s great. Otherwise, you will be allowed to select the table headers on the next step.
Here is a file example:
4. Click on Browse and upload the file containing your addresses. You will be prompted by the following step where you need to select the type of separator you have used to separate the information in your file. You can also check the “Treat the first row as column headers” box if you already know which parameters the Address Importer expects. If you uncheck this box, you will be able to assign the table headers manually, so that the address importer knows what type of information it is reading.
5. By clicking Next, you will be redirected to one of two pages, depending on your choice from Step 3.1 and Step 3.2. Click again on Next if everything looks good and then on Finish to add the Email addresses as domain accounts or forwarders.
In order to see the newly created Email accounts, navigate to the Email Accounts section from the cPanel home page. To view the newly created forwarders, simply navigate to the Forwarders section from your cPanel dashboard.
And that’s it. You’ve now learned how to use the Email Address Importer in cPanel. Make sure to always double check your settings and explore with different types of formatting your input files.