How to Import Email Addresses in cPanel Print

Introduction: Setting up a new company or moving from another hosting provider? Creating email accounts one by one (like sales@, info@, john@) can be tedious and time-consuming.

Fortunately, cPanel has a built-in tool that allows you to upload a list of emails and create them all at once. Here is how to use the Address Importer.

Step 1: Prepare Your List (Excel or CSV)

Before you log in to cPanel, you need to create a simple spreadsheet with the email accounts you want to create.

1. Open Microsoft Excel or Google Sheets.

2. You need two (or optionally three) columns. Do not add headers (like "Name" or "Password") in the first row; just start directly with the data.

   • Column A: The email address (e.g., john@yourdomain.com)

   • Column B: The password for that email.

   • Column C (Optional): The storage quota (in Megabytes). If you leave this blank, it will use the default setting.

3. Save the file:

   • If using Excel, save it as an .xls file.

   • If using Google Sheets or another tool, save/export it as a .csv (Comma Separated Values) file.

Important Note on Passwords: Make sure the passwords in your file are strong! If they are too simple (like "123456"), cPanel might reject the import for security reasons.

Step 2: Go to the Address Importer

1. Log in to your cPanel account.

2. Scroll down to the Email section.

3. Click on the icon labeled Address Importer.

Step 3: Upload and Configure

1. Select Source: You will see a box asking what you want to import. Select "E-mail Accounts".

2. Upload File: Click the "Choose File" button and select the spreadsheet (.xls or .csv) you created in Step 1.

3. Improper Headers: If your file did have headers (like "Email" written in the first row), check the box that says "Treat first row as column headers" so cPanel ignores it.

4. Click Next.

Step 4: Match the Columns

cPanel needs to know which column is which. It will show you a preview of your file.

1. Look at the first column (your email addresses) and select "Email" from the dropdown menu above it.

2. Look at the second column (your passwords) and select "Password" from the dropdown menu.

3. Look at the third column (if you added quotas) and select "Quota".

4. Select Domain: If your file only contained usernames (like "john" instead of "john@yourdomain.com"), use the domain dropdown box to select which domain these emails belong to.

Step 5: Finish

1. Click the Finish button.

2. cPanel will process the list.

3. You will see a confirmation screen listing all the emails that were successfully created.

That's it! All your staff members can now log in to their new email accounts immediately.

Common Errors (Troubleshooting)

• "File type not supported": Ensure you saved your file as .xls or .csv. The newer Excel format .xlsx sometimes causes issues on older cPanel versions.

• "Password too weak": If an account fails to import, check the password you assigned to it. Try making it more complex (use symbols, numbers, and capital letters).